Altons

Building SCD-2 models using the default incremental materialization

1. Bootstrap the source / snapshot table source_users and the initial state of our scd2 table dim_users by running:

dbt run -m source_users dim_users

2. Copy over contents of dim_users_inc.sql replacing contents in dim_users.sql (or just rename them). Then run:

Altons

from datetime import datetime, timedelta
import networkx as nx

from airflow import DAG
from airflow.operators import BashOperator, SubDagOperator

start_date = datetime(year=2017, month=6, day=13, hour=19, minute=0)
schedule_interval = '0 * * * 1-5'

default_args = {

Altons

-- Based on code here: http://www.sqlservercentral.com/articles/Fuzzy+Match/65702/
-- Modified to be used in SQL Server Database Projects or run on its own, and fixed similarity vs distance confusion

CREATE FUNCTION [dbo].JaroWinklerGetCommonCharacters(@firstWord VARCHAR(MAX), @secondWord VARCHAR(MAX), @matchWindow INT)
RETURNS VARCHAR(MAX) AS
BEGIN
    DECLARE @CommonChars VARCHAR(MAX)
    DECLARE @copy VARCHAR(MAX)
    DECLARE @char CHAR(1)
    DECLARE @foundIT BIT

Altons

 ##############################################################################
 #                        Calendar Heatmap                                    #
 #                                by                                          #
 #                         Paul Bleicher                                      #
 # an R version of a graphic from:                                            #
 # http://stat-computing.org/dataexpo/2009/posters/wicklin-allison.pdf        #
 #  requires lattice, chron, grid packages                                    #
 ############################################################################## 

## calendarHeat: An R function to display time-series data as a calendar heatmap 

Altons

class CreateInvoiceNumbers < ActiveRecord::Migration
  def up
    create_table :invoice_numbers do |t|
      t.integer :year, null: false, unique: true
      t.integer :next_number_within_year, null: false, default: 1
    end

    add_index :invoice_numbers, :year, unique: true

    (2016..2045).each do |year|

Altons

# Usage:
#
# class MyClass < ActiveRecord::Base
#   ...
#   validate :postal_code, spanish_postal_code: true # default message
#   validate :postal_code, spanish_postal_code: { message: '<Your message>' } # custom message
#   ...
# end
#
class SpanishPostalCodeValidator < ActiveModel::EachValidator

Altons

Rails Models

Generating models

$ rails g model User

Associations

belongs_to

has_one

Altons

ActiveRecord cheat sheet / EXAMPLES

INSTALL 
=======  
$ gem install activerecord
in GEMFILE: gem ‘activerecord’

REQUIRE 
=======  
require ‘active_record’

Altons

#!/bin/bash

# --------------------------------------------------------------------------------------------
# Installs Ruby 2.5 using rbenv/ruby-build on the Raspberry Pi (Raspbian)
#
# Run from the web:
#   bash <(curl -s https://gist.githubusercontent.com/blacktm/8302741/raw/install_ruby_rpi.sh)
# --------------------------------------------------------------------------------------------

# Welcome message

Altons

Homebrew

How To

Homebrew is a package management system for OS X. You can read more about it here, or simply run

ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

to install it.