Fivetran - Execute Sync and Check Status
First time using this Blueprint? Make sure you follow our Fivetran authorization guide.
This is considered an "all-in-one" Blueprint that Executes a Sync and checks the status of the sync until it's is finished. By using this Blueprint, you will accumulate runtime as the Vessel continuously waits for the job to be completed. The tradeoff is that results may be quicker and the setup/complexity is less.
If you want to reduce the overall runtime you're billed for, you will need to instead set up a Fleet with Vessels built with these Blueprints in this order:
Execute Sync ->
Check Sync Status
A Vessel built with this Blueprint will sync a connector in Fivetran and check for the status every 30 seconds. Once the status is confirmed to be completed, the script will stop. The final status of this Vessel in Shipyard will reflect the status of the run in Fivetran.
Before using this Blueprint on a connector, we strongly recommend first setting your connector to a manual schedule, using the Update Connector Blueprint. This setting cannot be updated in the Fivetran UI. This will ensure that Fivetran only syncs the connector when Shipyard kicks it off. Without this setting in place, it is possible to have conflicting syncs.
|API Key||FIVETRAN_API_KEY||Password||✅||-||-||Your account's unique API Key for Fivetran.|
|API Secret||FIVETRAN_API_SECRET||Password||✅||-||-||Your account's unique API Secret for Fivetran.|
|Connector ID||FIVETRAN_CONNECTOR_ID||Alphanumeric||✅||-||-||The unique ID associated with a connector. Typically two words separated by an underscore.|
Below is the YAML template for this Blueprint and can be used in the Fleet YAML Editor.
blueprint: Fivetran - Execute Sync and Check Status
FIVETRAN_API_KEY: null ## REQUIRED
FIVETRAN_API_SECRET: null ## REQUIRED
FIVETRAN_CONNECTOR_ID: null ## REQUIRED