|
Orchestrating Fivetran and dbt with Airflow
|
|
3
|
12336
|
December 14, 2021
|
|
Using dbt & Snowflake shares
|
|
0
|
15922
|
April 30, 2020
|
|
Using Python to update model_schema.yml files and create staging files (BigQuery Specific)
|
|
0
|
3810
|
September 21, 2022
|
|
Snowflake cluster keys in dbt -- learnings and thoughts
|
|
0
|
3005
|
September 17, 2022
|
|
How to prevent (accidental) full refreshes for a model
|
|
2
|
11627
|
September 8, 2022
|
|
Build snapshot-based tests to detect regressions in historic data
|
|
3
|
8559
|
April 27, 2022
|
|
Get dbt up and running from the command line on a MacBook with an M1 chip
|
|
5
|
24123
|
April 7, 2022
|
|
Building models on top of snapshots
|
|
5
|
15393
|
October 23, 2021
|
|
Triggering a dbt Cloud Job in your automated workflow with python
|
|
1
|
12895
|
September 9, 2021
|
|
Dbt model (think unit) tests POC
|
|
2
|
5089
|
August 24, 2021
|
|
The exact privileges we grant to set up Redshift
|
|
0
|
6620
|
August 20, 2021
|
|
Finding active days for a subscription/user/account (date spining)
|
|
5
|
14069
|
August 3, 2021
|
|
Advanced schema tests; thresholds, exclusions and date limits
|
|
1
|
5600
|
July 19, 2021
|
|
How to set up a Google Sheet as a reliable data source
|
|
2
|
11135
|
June 14, 2021
|
|
Trigger a dbt Cloud job on merging to master branch
|
|
3
|
9883
|
June 3, 2021
|
|
Testing data transformations
|
|
2
|
6919
|
May 21, 2021
|
|
New Package: dbt-expectations
|
|
6
|
14302
|
May 16, 2021
|
|
Writing models backwards: An unorthodox approach to data transformation
|
|
7
|
8034
|
April 14, 2021
|
|
Writing packages when a source table may or may not exist
|
|
1
|
25528
|
December 28, 2020
|
|
Removing Jinja Comments from Compiled SQL
|
|
2
|
7218
|
August 26, 2018
|
|
How to implement dynamic data masking on Redshift
|
|
3
|
10117
|
January 28, 2021
|
|
Sharing my SQL Style Guide
|
|
9
|
5917
|
December 17, 2020
|
|
Using dbt artifacts to track project performance
|
|
0
|
7271
|
December 8, 2020
|
|
New Package: dbt-meta-testing
|
|
1
|
2702
|
December 7, 2020
|
|
Looker user attributes and `if dev` to auto-switch between dev & prod schemas
|
|
11
|
8660
|
November 8, 2020
|
|
Here is a way to write dbt docs as SQL comment
|
|
1
|
6272
|
September 27, 2020
|
|
Auto pivot JSON string using schema.yml in BigQuery
|
|
0
|
5020
|
September 8, 2020
|
|
Custom Versions of generate_schema_name
|
|
0
|
4143
|
September 8, 2020
|
|
An Approach to Building dbt Packages
|
|
2
|
4364
|
July 22, 2020
|
|
A partial workaround for dbt_utils.star not working with CTEs
|
|
0
|
7859
|
July 6, 2020
|