Show and Tell

Topic	Replies	Views	Activity
About the Show and Tell category	0	162	September 7, 2022
How to clean orphaned schema (Snowflake specific)	0	5	December 7, 2022
Materialization comparison of view, table, incremental, snapshot in combination with persistent or transient source snapshots , incremental	0	103	November 28, 2022
Clean your warehouse of old and deprecated models	12	9073	November 25, 2022
Spin up a dbt+Postgres environment with a single click in VS Code for demos and interview assignments	3	164	November 25, 2022
Using dynamic schemas for snapshots snapshots , environments	5	7066	November 24, 2022
Subquery containing correlated aggregate function can only appear in having or select clause incremental , snowflake	2	370	November 24, 2022
How to remove comma from a result set in a macro jinja	1	99	November 16, 2022
Setting up VSCode to use with the dbt CLI tools , cli , vs-code	7	12758	November 10, 2022
Modeling changes to daily/weekly/monthly active users date-and-time	2	3037	November 5, 2022
Canceling Slim CI jobs if a new PR is made on the same codebase or if a new commit is made to a PR using Github Actions ci-cd , orchestration-and-deployment , dbt-cloud	2	287	November 4, 2022
Introducing sqlfmt, an auto-formatter for dbt SQL sqlfmt	12	4620	October 21, 2022
Performing a blue/green deploy of your dbt project on Snowflake best-practice	16	16223	October 17, 2022
Orchestrating Fivetran and dbt with Airflow airflow , dbt-cloud	3	5953	December 14, 2021
Creating an ERD for your dbt project documentation , erd	7	8637	October 15, 2022
FAQ: Cleaning up removed models from your production schema	11	18394	October 13, 2022
Using dbt & Snowflake shares jinja , snowflake	0	9514	April 30, 2020
Using Python to update model_schema.yml files and create staging files (BigQuery Specific) yaml , staging , bigquery	0	321	September 21, 2022
Creating Dynamic Queries with Jinja and model.yml files jinja , yaml	0	335	September 20, 2022
Snowflake cluster keys in dbt -- learnings and thoughts snowflake	0	407	September 17, 2022
Using dbt to manage user defined functions udf	17	32309	September 12, 2022
How to prevent (accidental) full refreshes for a model jinja , full-refresh , incremental	2	4443	September 8, 2022
Unioning identically-structured data sources jinja , best-practice	11	13372	August 18, 2022
Running dbt in Composer using a KubernetesPodOperator airflow , orchestration-and-deployment , gcp-cloud-composer	5	6809	May 24, 2022
Build snapshot-based tests to detect regressions in historic data testing , data-quality , snapshots	3	4290	April 27, 2022
Running SQLFluff fix on PRs as a GitHub Action with inline suggestions ci-cd , sqlfluff	3	2388	April 18, 2022
Get dbt up and running from the command line on a MacBook with an M1 chip installation , apple-silicon	5	11448	April 7, 2022
How to add observability to your dbt deployment	1	3859	March 9, 2022
How we sped up our CI runs by 10x using Slim CI testing , ci-cd	11	11164	February 22, 2022
A containerized dbt environment for your team docker , cli , developer-ergonomics	7	8961	December 13, 2021