17 lines
293 B
SQL
17 lines
293 B
SQL
{% snapshot scd_raw_listings %}
|
|
|
|
{{
|
|
config(
|
|
target_schema = 'dev',
|
|
unique_key = 'id',
|
|
strategy = 'timestamp',
|
|
updated_at = 'updated_at',
|
|
invalidate_hard_deletes = True
|
|
)
|
|
}}
|
|
|
|
SELECT *
|
|
FROM
|
|
{{ source('airbnb', 'listings')}}
|
|
|
|
{% endsnapshot %}
|