I am working on DBT snapshots versions automated swapping in Snowflake.
In order to swap the snapshot table(s) we need to stop Transformation Jobs till the swapping is over and re-activate them after. All other steps I expect to be executed using DBT and SF Stored procedures. DBT commands to be executed in ADO pipeline.
In Rest Api documentation I don’t see any information related to the Transformation Jobs from REST API perspective.
Could you help us with the Fivetran Rest API call, and the instructions on how to run it in Azure DevOps pipeline?
This way we could have a fully automated pipeline for snapshot swapping.
This feature could be useful in other scenarios when we need to synchronize DBT Transformation activities with some other tasks.