Skip to content

Instantly share code, notes, and snippets.

@boxysean
boxysean / dbt build_2023-05-23T20_06_13.598999Z.txt
Created May 23, 2023 20:48
Logs from two successive builds of boxysean/dbt-binary-tree-1024
This file has been truncated, but you can view the full file.
20:06:16 checksum: 0325e47f1211ebbdb24627f81d8289d705fdb573380364d07ab35982cb3d57cd, vars: {}, profile: None, target: None, version: 1.4.6
20:06:16 Unable to do partial parsing because config vars, config profile, or config target have changed
20:06:16 previous checksum: 0049c9ca814b191acba678e7b1a0d7a85eeac3e13700309cfc1ce1a2c78d3886, current checksum: 0325e47f1211ebbdb24627f81d8289d705fdb573380364d07ab35982cb3d57cd
20:06:16 Sending event: {'category': 'dbt', 'action': 'partial_parser', 'label': '739b291c-d23f-48c5-9869-50ee39ebeea5', 'context': [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x7ff65383f8e0>]}
20:06:18 1699: static parser successfully parsed model_396.sql
20:06:18 1699: static parser successfully parsed model_558.sql
20:06:18 1699: static parser successfully parsed model_477.sql
20:06:18 1699: static parser successfully parsed model_639.sql
20:06:18 1699: static parser successfully parsed model_792.sql
20:06:18 1699: static parser successfully parsed model_954.
@boxysean
boxysean / external_email_notifications.sh
Last active March 27, 2023 18:50
dbt Cloud Notification configuration
# Run these commands to create/modify new Notification configurations in dbt Cloud that will alert
# an "external" email address of your choosing of job events: cancels, failures, and successes.
# Note that you MUST manage this Notification configuration via the API -- there is currently
# not UI configuration within dbt Cloud.
# parameters:
### url
# {dbt_url} # the base URL of your dbt account, eg cloud.getdbt.com or emea.dbt.com
# {account_id} # Account ID to setup notifications for
### headers and body
@boxysean
boxysean / README.md
Last active March 27, 2023 14:17
Synthentic binary-tree dbt DAG builder
@boxysean
boxysean / avr-programming.sh
Created June 4, 2014 16:27
"Good looking" run of the make commands for Waterfall Swing
boxysean-mbpr:solenoid-controller boxysean$ avrdude -p m128 -B 50 -P usb -c dragon_isp
avrdude: jtagmkII_getsync(): sign-on command: status -1
avrdude: AVR device initialized and ready to accept instructions
Reading | ################################################## | 100% 0.16s
avrdude: Device signature = 0x1e9702
avrdude: safemode: Fuses OK (E:FD, H:99, L:DE)
@boxysean
boxysean / dbt_cloud_lifecycle_events_payloads.md
Last active May 19, 2021 17:12
dbt Cloud Lifecycle Events payloads

These are lifecycle event payloads sent by dbt Cloud during job execution.

@boxysean
boxysean / slack.py
Last active December 4, 2020 18:47
PythonSlackOperator -- how I've integrated notifications into my PythonOperators
# airflow/plugins/slack.py
import logging
from airflow.operators.python_operator import PythonOperator
from airflow.plugins_manager import AirflowPlugin
from slackclient import SlackClient
from titan.utils import config
@boxysean
boxysean / named.conf.local
Last active June 11, 2020 15:49
bind for outernet
zone "outernet" {
type master;
file "/etc/bind/zones/outernet.db";
};
zone "56.168.192.in-addr.arpa" {
type master;
file "/etc/bind/zones/rev.56.168.192.in-addr.arpa";
};
@boxysean
boxysean / asyncio_example.py
Last active February 16, 2020 19:00
Four approaches to multi-threaded extract-and-load code (including a new one)
import aiohttp
import asyncio
import sqlite3
URLS = [
'http://www.foxnews.com/',
'http://www.cnn.com/',
'http://europe.wsj.com/',
'http://www.bbc.co.uk/',
@boxysean
boxysean / outside-corner.js
Created June 19, 2019 02:15
Outside corner for fixing da cubes
// All units inches
var extrude_ = 0.1;
var nutSize = 0.375;
var threadDiameter = 0.22;
var screwPosition = [0.5, 0.5];
function makeHalf() {
var half = polygon([
[0,0.7],
# dbt_utils/dbt_project.yml
name: 'dbt_utils'
version: '0.1.0'