Skip to main content

snapshot_name

snapshots/<filename>.sql
{% snapshot snapshot_name %}

{% endsnapshot %}

Description

The name of a snapshot, as defined in the {% snapshot %} block header. This name is used when selecting from a snapshot using the ref function

This name must not conflict with any other snapshot names, or any model names.

The name does not need to match the file name. As a result, snapshot filenames do not need to be unique.

Examples

Name a snapshot order_snapshot

snapshots/orders.sql
{% snapshot orders_snapshot %}
...
{% endsnapshot %}

To select from this snapshot in a downstream model:

select * from {{ ref('orders_snapshot') }}
0