|
Materialization comparison of view, table, incremental, snapshot in combination with persistent or transient source
|
|
0
|
2099
|
November 28, 2022
|
|
Spin up a dbt+Postgres environment with a single click in VS Code for demos and interview assignments
|
|
3
|
2398
|
November 25, 2022
|
|
How to remove comma from a result set in a macro
|
|
1
|
2039
|
November 16, 2022
|
|
Modeling changes to daily/weekly/monthly active users
|
|
2
|
7033
|
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
|
|
2
|
2375
|
November 4, 2022
|
|
Orchestrating Fivetran and dbt with Airflow
|
|
3
|
13919
|
December 14, 2021
|
|
Using dbt & Snowflake shares
|
|
0
|
18936
|
April 30, 2020
|
|
Using Python to update model_schema.yml files and create staging files (BigQuery Specific)
|
|
0
|
5342
|
September 21, 2022
|
|
Snowflake cluster keys in dbt -- learnings and thoughts
|
|
0
|
4665
|
September 17, 2022
|
|
How to prevent (accidental) full refreshes for a model
|
|
2
|
16443
|
September 8, 2022
|
|
Build snapshot-based tests to detect regressions in historic data
|
|
3
|
10910
|
April 27, 2022
|
|
Get dbt up and running from the command line on a MacBook with an M1 chip
|
|
5
|
30515
|
April 7, 2022
|
|
Building models on top of snapshots
|
|
5
|
19220
|
October 23, 2021
|
|
Triggering a dbt Cloud Job in your automated workflow with python
|
|
1
|
16582
|
September 9, 2021
|
|
Dbt model (think unit) tests POC
|
|
2
|
5851
|
August 24, 2021
|
|
The exact privileges we grant to set up Redshift
|
|
0
|
7694
|
August 20, 2021
|
|
Finding active days for a subscription/user/account (date spining)
|
|
5
|
16261
|
August 3, 2021
|
|
Advanced schema tests; thresholds, exclusions and date limits
|
|
1
|
7019
|
July 19, 2021
|
|
How to set up a Google Sheet as a reliable data source
|
|
2
|
12786
|
June 14, 2021
|
|
Testing data transformations
|
|
2
|
7624
|
May 21, 2021
|
|
New Package: dbt-expectations
|
|
6
|
15616
|
May 16, 2021
|
|
Writing models backwards: An unorthodox approach to data transformation
|
|
7
|
9052
|
April 14, 2021
|
|
Writing packages when a source table may or may not exist
|
|
1
|
33163
|
December 28, 2020
|
|
Removing Jinja Comments from Compiled SQL
|
|
2
|
9746
|
August 26, 2018
|
|
How to implement dynamic data masking on Redshift
|
|
3
|
11755
|
January 28, 2021
|
|
Sharing my SQL Style Guide
|
|
9
|
6885
|
December 17, 2020
|
|
Using dbt artifacts to track project performance
|
|
0
|
8924
|
December 8, 2020
|
|
New Package: dbt-meta-testing
|
|
1
|
3152
|
December 7, 2020
|
|
Looker user attributes and `if dev` to auto-switch between dev & prod schemas
|
|
11
|
10023
|
November 8, 2020
|
|
Here is a way to write dbt docs as SQL comment
|
|
1
|
8008
|
September 27, 2020
|