|
How to declare the while loop and then to use that loop in different models, does it used in macro, kindly provide with an example
|
|
1
|
7
|
March 9, 2025
|
|
Ephemeral models, snapshots and new columns
|
|
0
|
27
|
February 26, 2025
|
|
How do I turn 2 years of source data into a snapshot table
|
|
0
|
25
|
February 20, 2025
|
|
Snapshots are built with duplicate rows
|
|
4
|
2352
|
February 4, 2025
|
|
Snapshot fails when new column added to schema
|
|
0
|
53
|
February 4, 2025
|
|
1.9 snapshots fail in Databricks
|
|
2
|
83
|
January 22, 2025
|
|
SCD2 snapshot with multiple source joins
|
|
0
|
33
|
January 17, 2025
|
|
model version of a snapshot
|
|
0
|
50
|
January 9, 2025
|
|
new snapshot meta columns defined in schema don't work
|
|
3
|
96
|
December 23, 2024
|
|
Compilation Error in snapshot invalid syntax for function call expression config(
|
|
1
|
133
|
November 28, 2024
|
|
Setting dbt_valid_from to NULL
|
|
3
|
107
|
November 28, 2024
|
|
dbt snapshots throws compilation error
|
|
2
|
50
|
November 26, 2024
|
|
Mark "first" snapshot?
|
|
3
|
35
|
November 18, 2024
|
|
Snapshots - set dbt_valid_from to created_at instead of updated_at for initial snapshot?
|
|
0
|
91
|
November 11, 2024
|
|
DBT Snapshot has restarted and now has no dbt_valid_to NOT NULL rows.
|
|
0
|
39
|
October 23, 2024
|
|
Creating a custom 'check' strategy
|
|
1
|
984
|
October 2, 2024
|
|
Creating snapshot in a custom location with Trino connector
|
|
0
|
47
|
October 1, 2024
|
|
DBT Snapshot creating duplicate rows even though there's no change in source data
|
|
6
|
3341
|
September 27, 2024
|
|
dbt snapshot fails
|
|
7
|
2849
|
September 18, 2024
|
|
Recreate SCD2 table with snapshots
|
|
3
|
228
|
September 17, 2024
|
|
Snapshots - put into same schema as primary tables?
|
|
0
|
22
|
September 17, 2024
|
|
DBT Snapshots not handling Multiple Updates to the Same Unique Key
|
|
0
|
71
|
September 13, 2024
|
|
Using DBT Snapshots across multiple projects
|
|
1
|
23
|
September 10, 2024
|
|
Building snapshots on an append only table.
|
|
0
|
129
|
August 20, 2024
|
|
dbt cloud +Red-shift not recognizing columns while trying to run snapshot
|
|
0
|
44
|
August 2, 2024
|
|
Dynamically get snapshot strategy using macros
|
|
2
|
71
|
July 8, 2024
|
|
How to configure snapshot in dbt_project.yml file
|
|
1
|
355
|
July 5, 2024
|
|
Generate Snapshots Dynamically via macros
|
|
1
|
572
|
June 11, 2024
|
|
Snapshot: Parsing Error at path []: Snapshots must be configured with a 'strategy', 'unique_key', and 'target_schema'
|
|
2
|
651
|
May 27, 2024
|
|
How would you approach a data Model below?
|
|
0
|
266
|
April 19, 2024
|