Skip to content

Instantly share code, notes, and snippets.

🕳
[ o o ]

Brian Abelson abelsonlive

View GitHub Profile
@abelsonlive
abelsonlive / dbt_backfill.py
Created Apr 11, 2019
Script for backfilling DBT models which use partitions
View dbt_backfill.py
#!/usr/bin/env python
import json
import copy
import sys
import argparse
from datetime import datetime, timedelta
from subprocess import Popen, PIPE
# dictionary of partiton names to variable generating functions
@abelsonlive
abelsonlive / keybase.md
Created May 28, 2018
keybase verification
View keybase.md

Keybase proof

I hereby claim:

  • I am abelsonlive on github.
  • I am abelsonlive (https://keybase.io/abelsonlive) on keybase.
  • I have a public key ASAQinczA9eMApbqyXq8pZ8Le9PtWFenaQFwkCjHkuIhqAo

To claim this, I am signing this object:

@abelsonlive
abelsonlive / phase-say.py
Created Apr 14, 2018
generative phase music with say
View phase-say.py
import os
import sys
import time
import random
VOICES = [
"Agnes",
"Alex",
"Alice",
"Alva",
@abelsonlive
abelsonlive / config.yml
Last active Feb 28, 2018
Dynamically add partitions to a spectrum table
View config.yml
aws_access_key_id:
aws_secret_access_key:
rs_user:
rs_server:
rs_db:
rs_port:
rs_password:
View base_models.yml
profile_dir: '~/.dbt' # the location of dbt configurations
target: prod # the dbt profile to use for connection
source_schema: fivetran_app # the tables' source schema (where fivetran imports your data to)
materialized: view # how to materialize these views
target_schema: app # the schema to materialize the base models under (where users will access the data from)
table_prefix: app # a prefix to prepend to each base model/view
directory: models/base/ # the directory under which to save the base models
empty_as_null: true # whether or not to apply EMPTYASNULL logic to all text fields
incl_fivetran_deleted: false # whether or not to include records marked as "deleted" by fivetran
excl_fivetran_synced: true # whether or not to include the time fivetran synced each record
@abelsonlive
abelsonlive / thai-spicy.txt
Created Jan 23, 2018
thai spicy instructions
View thai-spicy.txt
thai spicy เผ็ดร้อนไทย, pik nam pla (พริกน้ำปลา) on the side
@abelsonlive
abelsonlive / try_or_die.sh
Created Jan 17, 2017 — forked from dotike/try_or_die.sh
3 finger claw technique for POSIX shell programming. Three one-line functions which greatly enhance shell programming, enabling reliable UNIX-style programming in an extremely concise fashion.
View try_or_die.sh
#!/bin/sh
##############################################################################
# This code known is distributed under the following terms:
#
# Copyright (c) 2013 Isaac (.ike) Levy <ike@blackskyresearch.net>.
# All rights reserved.
#
# Redistribution and use in source and binary forms, with or without
# modification, are permitted provided that the following conditions
View scrape-zillow.py
import requests
import urllib
import json
ZIP_CODES = [
'11211'
]
def get_rect_from_zip(session, zip_code):
"""
View dot-cat.sh
#!/bin/sh
curl http://cat.www.$1.com.meowbify.com/ > index.html
s3cmd put index.html s3://$1.cat/
View input.csv
1 50 Diamond St. Brooklyn NY
2 442 George Road, New York, NY
You can’t perform that action at this time.