Introducing sqlfmt, an auto-formatter for dbt SQL
|
|
22
|
20911
|
April 12, 2023
|
Identifying root nodes using manifest.json
|
|
1
|
2559
|
April 3, 2023
|
dbt example project that shows dimensional modeling, metrics and other techniques
|
|
1
|
3082
|
March 29, 2023
|
How to generate tables and its columns schema yaml reading from snowflake information_schema.columns
|
|
0
|
6336
|
March 6, 2023
|
How to pass target.name or target.project values as an input to macro while calling from model.
|
|
1
|
2746
|
March 4, 2023
|
Creating an ERD for your dbt project
|
|
8
|
26728
|
February 25, 2023
|
How to use incremental models to detect regressions in historic metrics
|
|
1
|
1922
|
February 16, 2023
|
Examples of custom schema tests
|
|
8
|
29042
|
January 19, 2023
|
A containerized dbt environment for your team
|
|
8
|
15405
|
January 17, 2023
|
dbtmock : end to end pipeline testing
|
|
0
|
2172
|
December 23, 2022
|
Materialization comparison of view, table, incremental, snapshot in combination with persistent or transient source
|
|
0
|
2030
|
November 28, 2022
|
Spin up a dbt+Postgres environment with a single click in VS Code for demos and interview assignments
|
|
3
|
2301
|
November 25, 2022
|
How to remove comma from a result set in a macro
|
|
1
|
1958
|
November 16, 2022
|
Modeling changes to daily/weekly/monthly active users
|
|
2
|
6824
|
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
|
2270
|
November 4, 2022
|
Orchestrating Fivetran and dbt with Airflow
|
|
3
|
13420
|
December 14, 2021
|
Using dbt & Snowflake shares
|
|
0
|
17958
|
April 30, 2020
|
Using Python to update model_schema.yml files and create staging files (BigQuery Specific)
|
|
0
|
5077
|
September 21, 2022
|
Snowflake cluster keys in dbt -- learnings and thoughts
|
|
0
|
3946
|
September 17, 2022
|
How to prevent (accidental) full refreshes for a model
|
|
2
|
14860
|
September 8, 2022
|
Build snapshot-based tests to detect regressions in historic data
|
|
3
|
10153
|
April 27, 2022
|
Get dbt up and running from the command line on a MacBook with an M1 chip
|
|
5
|
28899
|
April 7, 2022
|
Building models on top of snapshots
|
|
5
|
18218
|
October 23, 2021
|
Triggering a dbt Cloud Job in your automated workflow with python
|
|
1
|
15582
|
September 9, 2021
|
Dbt model (think unit) tests POC
|
|
2
|
5695
|
August 24, 2021
|
The exact privileges we grant to set up Redshift
|
|
0
|
7514
|
August 20, 2021
|
Finding active days for a subscription/user/account (date spining)
|
|
5
|
15709
|
August 3, 2021
|
Advanced schema tests; thresholds, exclusions and date limits
|
|
1
|
6653
|
July 19, 2021
|
How to set up a Google Sheet as a reliable data source
|
|
2
|
12385
|
June 14, 2021
|
Testing data transformations
|
|
2
|
7500
|
May 21, 2021
|