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') }}