dbt: Transformation Is Not Running at Expected Time
Question
The dbt transformation runs at different times during the hour rather than at a set minute of every hour.
Environment
Transformations for dbt Core - Scheduled in Code
Resolution
To make it run every 55th minute, change the setting in the deployment.yml
file to 55 * * * *
. This way, the transformation will run at minute 55 of every hour, rather than at every 55th minute of completion of the previous run.
Cause
If cron is set to */55 * * * *
, the transformation will run in the following timing (i.e., at the start of every hour and at minute 55 of every hour).