Incremental models

For more information about how to use incremental models, please read dbt’s documentation.

​

How to rebuild incremental models?

You can rebuild 1 or more models using the --full-refresh flag (dbt documentation) and graph operators (dbt documentation).

In order to do this in Mage, follow these steps:

1. Create a new trigger.

   You may want to create a scheduled trigger with an interval of @once because running a full refresh of an incremental model is usually done ad hoc and not on a regular basis.

2. On the right side of the edit trigger page, look for the section labeled dbt runtime settings.

3. Under the column labeled Flags, check the box labeled --full-refresh.

4. [Optional] Under the column labeled Prefix, write the graph operators of your choice.

5. [Optional] Under the column labeled Suffix, write the graph operators of your choice.