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 the name of any other "refable" resource (models, seeds, other snapshots) defined in this project or package.

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