Skip to content

Instantly share code, notes, and snippets.

View ian-whitestone's full-sized avatar
Exit code 143

Ian Whitestone ian-whitestone

Exit code 143
View GitHub Profile
warehouse_periods as (
timestamp as valid_from,
lead(timestamp) over (partition by warehouse_name order by timestamp asc) as valid_to,
event_name = 'RESUME_WAREHOUSE' as is_active
from snowflake.account_usage.warehouse_events_history
-- double check these names, can't remember exact values
ian-whitestone / example_cte_query.sql
Created March 18, 2023 12:29
Example Snowflake CTE query
with sample_data as (
select *
from snowflake_sample_data.tpch_sf1.customer
nation_14_customers as (
select *
from sample_data
where c_nationkey = 14
ian-whitestone / query_tags.sql
Created February 23, 2023 14:11
Query tag with no node refs
{% macro set_query_tag() -%}
{# Start with any model-configured dict #}
{% set tag_dict = config.get('query_tag', default={}) %}
{# Regardless of resource type, we can always access the config via the 'model' variable #}
{%- do tag_dict.update(
ian-whitestone / mode_confettis.js
Created January 17, 2023 16:42
Give the people confetti 🎉
<script src=""></script>
<script src=""></script>
<div id="bottom_of_page">Thanks for scrolling to the bottom 🙌</div>
<div>Enjoy some confetti 🎉</div>
ian-whitestone /
Last active May 3, 2021 12:54
Code for the "Testing SQL" blog post:
import os
from jinja2 import Environment, meta, Template
import pandas as pd
from pandas.testing import assert_frame_equal
import as psql
import psycopg2
# All these constants would likely live in separate files
CONNECTION = psycopg2.connect(
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
ian-whitestone /
Last active February 16, 2021 02:15
Bayesian conversion test A/A simulations
import numpy as np
def bayesian_rate_comparison(
ian-whitestone / simulations.ipynb
Last active December 20, 2023 03:53
Code for the choosing your randomization unit post -
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
ian-whitestone /
Created December 21, 2020 01:51
Code for the Dask cluster on demand blog post
import logging
import time
from dataclasses import dataclass
from typing import Any, Optional, Tuple
import requests
import yaml
from distributed import Client
from import Security
from googleapiclient import discovery
ian-whitestone / Dockerfile
Created September 29, 2020 02:03
Code snippets for single node Dask cluster on GCP blog post
FROM python:3.7.6-buster
# Set the working directory
RUN mkdir /opt/app
WORKDIR /opt/app
# Copy poetry files into docker image
COPY pyproject.toml .
COPY poetry.lock .