Data transformations

Preview does not change after changing the query

It can occur that the Preview does not change after you changed the query and run the file.

Possible cause

The sql file is identical to the one in dbt, as it has not been updated since the last run. If you run the file again, no changes will be detected and therefore the Preview table won't be updated. For example, if you add a WHERE condition and run the file, the Preview will only show the filtered records. However, if you remove this WHERE condition and run the file again, the Preview will still only display the previously filtered records, when it should actually show all records.

Solution

Add, or change, a comment in the SQL file. This will force a dbt run and the Preview will be updated.

Message: The selection criterion does not match any nodes. Nothing to do.

The following warning messages are displayed in the ingestion log.

When you get the two warning messages The selection criterion "+<file>.state:modified+" does not match any nodes and Nothing to do. Try checking your model configs and model specifications args, it means that no changes were detected compared to the last time the queries were run. The Preview panels are showing the most up-to-date version of the data.

To force a complete re-run of your queries, select Apply to dashboards.