Skip to main content

check_cols

dbt_project.yml
snapshots:
<resource-path>:
+strategy: check
+check_cols: [column_name] | all

Description

A list of columns within the results of your snapshot query to check for changes.

Alternatively, use all columns using the all value (however this may be less performant).

This parameter is required if using the check strategy.

Default

No default is provided.

Examples

Check a list of columns for changes

Check all columns for changes

0