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

# frozen_string_literal: true

# tap "heroku/brew"
# tap 'homebrew/bundle'
# tap 'homebrew/cask'
# tap 'homebrew/cask-versions'
# tap 'homebrew/core'
# tap "stripe/stripe-cli"
brew 'icu4c'
brew 'gcc'

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

# EditorConfig is awesome: https://EditorConfig.org

# top-most EditorConfig file
root = true

# Unix-style newlines with a newline ending every file
[*]
end_of_line = lf
trim_trailing_whitespace = true
charset = utf-8

Altons

GIT
  remote: https://github.com/spree-contrib/spree_i18n.git
  revision: 5021782dacb25c906b52925cec25494fbdd78dea
  specs:
    spree_i18n (3.3.2)
      i18n_data
      kaminari-i18n
      rails-i18n
      routing-filter
      spree_core (>= 3.1.0, < 4.0)

Altons

Rails Models

Generating models

$ rails g model User

Associations

belongs_to

has_one