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

Deploy dbt docs to App Engine

BigQuery WAC

Production rollback

Flatten external table with Parquet schema inference

dbt star macro for CTE

Table limit in Dev

Unit testing in dbt

Snowflake Blue/green deployment

Snowflake External table template

dbt Core CI with Snowflake