The Integrated Schedule Option is Unavailable

Issue

The Integrated schedule option is unavailable on the Schedule tab while scheduling a transformation in Fivetran. You can only select Custom schedule.

Environment

Transformations for dbt Core

Resolution

To resolve this issue, ensure you have configured your transformation model correctly by following our Transformations for dbt Core setup guide.

Cause

This issue occurs if your transformation model is not configured correctly.

For example, if you have not yet declared your connectors as sources in the schema.yml file of your dbt project or updated your model to use the source table references instead of hard-coded table names, we can't identify your connectors as being upstream from the models. As a result, we can't use integrated scheduling to coordinate the execution of transformations automatically with the completion of connector syncs.