Skip to main content

updated_at

dbt_project.yml
snapshots:
  <resource-path>:
    +strategy: timestamp
    +updated_at: column_name

Description​

A column within the results of your snapshot query that represents when the record row was last updated.

This parameter is required if using the timestamp strategy. The updated_at field may support ISO date strings and unix epoch integers, depending on the data platform you use.

Default​

No default is provided.

Examples​

Use a column name updated_at​

Coalesce two columns to create a reliable updated_at column​

Consider a data source that only has an updated_at column filled in when a record is updated (so a null value indicates that the record hasn't been updated after it was created).

Since the updated_at configuration only takes a column name, rather than an expression, you should update your snapshot query to include the coalesced column.

0
Edit this page