ian-whitestone

Baby Boot Camp: Weeks 8–12

Target schedule: 7AM–7PM days, 7PM–7AM nights

---

Prerequisites

Before starting Boot Camp, baby must meet all three:

• Weight: at least 4 kg (9 lbs)
• Food: eating at least ~710 ml/day

ian-whitestone

test

ian-whitestone

with
warehouse_periods as (
select
  warehouse_name,
  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
where
  -- double check these names, can't remember exact values

ian-whitestone

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

{% 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(
        dbt_snowflake_query_tags_version='1.1.3',
        app='dbt',
        dbt_version=dbt_version,
        project_name=project_name,

ian-whitestone

<script src="https://cdn.jsdelivr.net/npm/canvas-confetti@1.4.0/dist/confetti.browser.min.js"></script>
 <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>
 
 
 <div id="bottom_of_page">Thanks for scrolling to the bottom 🙌</div>
 
 <div>Enjoy some confetti 🎉</div>
 
 <script>
 

ian-whitestone

import os

from jinja2 import Environment, meta, Template
import pandas as pd
from pandas.testing import assert_frame_equal
import pandas.io.sql as psql
import psycopg2

# All these constants would likely live in separate files
CONNECTION = psycopg2.connect(

ian-whitestone

ian-whitestone

import numpy as np

def bayesian_rate_comparison(
    control_successes, 
    control_samples, 
    test_successes, 
    test_samples,
    prior_a=0,
    prior_b=0
):

ian-whitestone