1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
{% snapshot snp_my_snapshot %}
{{
config(
target_database='analytics',
target_schema=target.schema+'_snapshots', unique_key='id',
strategy='timestamp',
updated_at='updated_at',
)
}}
select * from {{ ref('stg_my_model') }}{% endsnapshot %}
)))))__SQLFMT_OUTPUT__(((((
{% snapshot snp_my_snapshot %}
{{
config(
target_database="analytics",
target_schema=target.schema + "_snapshots",
unique_key="id",
strategy="timestamp",
updated_at="updated_at",
)
}}
select *
from {{ ref("stg_my_model") }}
{% endsnapshot %}
|
