How Can I Switch My Connection Syncs Back to Fivetran’s Automatic Scheduling?

Question

I schedule my syncs using Apache Airflow. How can I switch back to Fivetran's built-in automatic scheduling functionality?

Environment

REST API

Answer

To re-enable our automatic scheduling, do the following.

1. In Fivetran, go to your connection page.
2. Select the Setup tab.
3. Make a note of the Fivetran Connection ID.
4. Make a note of your API key or create one if you haven't already. See our REST API Authentication documentation for more information.
5. Send the following PATCH request to the Update a Connection endpoint:

   • curl --location --request PATCH "https://api.fivetran.com/v1/connections/{<connection_id>}" \
     --header 'Authorization: Basic <API_key>' \
     --header 'Content-Type: application/json' \
     --data-raw '{
     "schedule_type": "auto"
     }'
     

   • Replace <API_key> with your base64-encoded API key.
   • Replace <connection_id> with the Fivetran Connection ID you found in step 3.

After you switch to automatic scheduling, see Sync start times and offsets to learn when syncs start.