|
Introducing sqlfmt, an auto-formatter for dbt SQL
|
|
22
|
23992
|
April 12, 2023
|
|
Identifying root nodes using manifest.json
|
|
1
|
2708
|
April 3, 2023
|
|
dbt example project that shows dimensional modeling, metrics and other techniques
|
|
1
|
3483
|
March 29, 2023
|
|
How to generate tables and its columns schema yaml reading from snowflake information_schema.columns
|
|
0
|
7428
|
March 6, 2023
|
|
How to pass target.name or target.project values as an input to macro while calling from model.
|
|
1
|
3089
|
March 4, 2023
|
|
Creating an ERD for your dbt project
|
|
8
|
30707
|
February 25, 2023
|
|
How to use incremental models to detect regressions in historic metrics
|
|
1
|
2023
|
February 16, 2023
|
|
Examples of custom schema tests
|
|
8
|
31526
|
January 19, 2023
|
|
A containerized dbt environment for your team
|
|
8
|
16066
|
January 17, 2023
|
|
dbtmock : end to end pipeline testing
|
|
0
|
2288
|
December 23, 2022
|
|
Materialization comparison of view, table, incremental, snapshot in combination with persistent or transient source
|
|
0
|
2116
|
November 28, 2022
|
|
Spin up a dbt+Postgres environment with a single click in VS Code for demos and interview assignments
|
|
3
|
2418
|
November 25, 2022
|
|
How to remove comma from a result set in a macro
|
|
1
|
2051
|
November 16, 2022
|
|
Modeling changes to daily/weekly/monthly active users
|
|
2
|
7056
|
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
|
2401
|
November 4, 2022
|
|
Orchestrating Fivetran and dbt with Airflow
|
|
3
|
13998
|
December 14, 2021
|
|
Using dbt & Snowflake shares
|
|
0
|
19069
|
April 30, 2020
|
|
Using Python to update model_schema.yml files and create staging files (BigQuery Specific)
|
|
0
|
5386
|
September 21, 2022
|
|
Snowflake cluster keys in dbt -- learnings and thoughts
|
|
0
|
4798
|
September 17, 2022
|
|
How to prevent (accidental) full refreshes for a model
|
|
2
|
16771
|
September 8, 2022
|
|
Build snapshot-based tests to detect regressions in historic data
|
|
3
|
11031
|
April 27, 2022
|
|
Get dbt up and running from the command line on a MacBook with an M1 chip
|
|
5
|
30691
|
April 7, 2022
|
|
Building models on top of snapshots
|
|
3
|
19365
|
October 23, 2021
|
|
Triggering a dbt Cloud Job in your automated workflow with python
|
|
1
|
16697
|
September 9, 2021
|
|
Dbt model (think unit) tests POC
|
|
2
|
5877
|
August 24, 2021
|
|
The exact privileges we grant to set up Redshift
|
|
0
|
7728
|
August 20, 2021
|
|
Finding active days for a subscription/user/account (date spining)
|
|
5
|
16348
|
August 3, 2021
|
|
Advanced schema tests; thresholds, exclusions and date limits
|
|
1
|
7067
|
July 19, 2021
|
|
Testing data transformations
|
|
2
|
7639
|
May 21, 2021
|
|
New Package: dbt-expectations
|
|
6
|
15687
|
May 16, 2021
|