|
Can I migrate data from Snowflake to On Prim SQL Server using DBT
|
|
1
|
199
|
February 22, 2022
|
|
Formatting SQL in VS Code
|
|
3
|
1637
|
February 22, 2022
|
|
How we structure our dbt projects
|
|
30
|
106019
|
February 21, 2022
|
|
Dbt schema test cases
|
|
0
|
172
|
February 16, 2022
|
|
Managing hundreds of schemas in the dbt_project.yml
|
|
2
|
219
|
February 8, 2022
|
|
How to get the current schema
|
|
1
|
297
|
January 24, 2022
|
|
Variables, functions or macros for audit, metadata fields for each data row
|
|
1
|
251
|
January 21, 2022
|
|
Programmatic Generation of Many Many Models
|
|
1
|
564
|
January 19, 2022
|
|
How to get current model schema
|
|
0
|
180
|
January 13, 2022
|
|
Equivalent of ON CONFLICT DO NOTHING
|
|
1
|
205
|
January 13, 2022
|
|
Using get_column_values with CTEs
|
|
4
|
4204
|
January 6, 2022
|
|
Preventing name conflicts
|
|
4
|
2815
|
February 1, 2019
|
|
How to use variables in config block?
|
|
1
|
374
|
January 1, 2022
|
|
How to configure your dbt repository (one or many)?
|
|
11
|
10275
|
December 31, 2021
|
|
How to use variables in definition.yml
|
|
0
|
278
|
December 31, 2021
|
|
How to let dbt to execute sql command instead of create table object
|
|
17
|
2592
|
December 30, 2021
|
|
Compilation error - No macro names 'get_columns_in_relation_sql' found
|
|
2
|
395
|
December 23, 2021
|
|
Duplicate Records on First run with Incremental Model on BigQuery
|
|
3
|
914
|
November 29, 2021
|
|
How to use "variables" in config block
|
|
1
|
387
|
November 22, 2021
|
|
How do you structure your marts & database schemas?
|
|
1
|
486
|
November 15, 2021
|
|
Want to learn dbt cloud?
|
|
0
|
223
|
October 31, 2021
|
|
Using window functions in incremental tables
|
|
5
|
3324
|
September 11, 2018
|
|
Joining snapshot tables (time range based joins)
|
|
2
|
852
|
October 23, 2021
|
|
Building models on top of snapshots
|
|
5
|
5274
|
October 23, 2021
|
|
Modeling inserts-in-a-loop in dbt
|
|
1
|
356
|
October 14, 2021
|
|
DBT run with 4 threads causing AccessExclusiveLock in Redshift
|
|
0
|
320
|
October 13, 2021
|
|
Postgres partitions
|
|
0
|
216
|
October 11, 2021
|
|
Purpose of dbt being idempotent for when data grows large
|
|
4
|
725
|
October 7, 2021
|
|
Modeling SQL update statements
|
|
7
|
4819
|
October 2, 2021
|
|
How is dbt_scd_id calculated?
|
|
2
|
658
|
October 1, 2021
|