snippets.md

layout	title
page	Snippets 🪡

Collection of "good-to-know" snippets for an analytics engineer.

Deploy dbt docs to App Engine

{% gist 82c5f0cf701735f2a56823e0bfe85a1c %}

BigQuery WAC

{% gist 46ff090b109b5563b9fb3dceb4eccbb9 %}

Production rollback

{% gist 04d6533a84378e017d7d88553a456a2a %}

Flatten external table with Parquet schema inference

{% gist 92c1dc9d09ddde19dbdb109db3ab65bc %}

dbt star macro for CTE

{% gist 4fb12a0750c0cf701909e398e4e825b8 %}

Table limit in Dev

{% gist 06f1642e033fc0bbfdf79c1e2f0c93de %}

Unit testing in dbt

{% gist ebd711fe33ee1c2a5c6addd25ad3f38a %}

Snowflake Blue/green deployment

{% gist 95f0398b8f1aa899d3a52e6ad73874a3 %}

Snowflake External table template

{% gist b6de14aa50cc9470bb00f943bc83af4b %}

dbt Core CI with Snowflake

{% gist f8e0209be966962e734342689108c370 %}