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 / 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 / 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'
@boxysean
boxysean / datadog-postgres-example.yaml
Created December 28, 2018 16:20
datadog-postgres-example.yaml
init_config: null
instances:
- collect_activity_metrics: true
collect_default_database: true
collect_function_metrics: true
dbname: mydb
host: main-database.example.com
password: mypassword
port: 5432
relations: null
@boxysean
boxysean / dish.js
Created November 25, 2018 19:33
Bedside dish
// All units inches
function form(length, width, height, thickness) {
return union([
cube({size: [length, thickness, height]}),
cube({size: [length, thickness, height]})
.translate([0, width - thickness, 0]),
cube({size: [thickness, width, height]}),
cube({size: [thickness, width, height]})
.translate([length - thickness, 0, 0])
@boxysean
boxysean / a-adam.py
Last active December 22, 2016 16:53
Solutions to Warby Parker Programming Contest (SWE Guild, 12/22/2016)
# Problem A - The 3n + 1 problem
# https://vjudge.net/contest/145712#problem/A
# Author: Adam
import sys
import functools
@functools.lru_cache(maxsize=1000000)
def cycle_len(k):
if k == 1: