Fivetran Connector Sync

Overview

Paradime provides a convenient way to trigger and orchestrate Fivetran connector syncs, allowing you to keep your data warehouse up to date with the latest data from your sources. By leveraging Paradime’s Fivetran Integration to triggering syncs, you can orchestrate your data pipeline by running dbt™ transformations immediately after your Fivetran sync completes. You can configure this by adding dbt™ commands directly in the same Bolt schedule or by using the on run completion trigger in a separate dbt™ pipeline.

Prerequisites1. Generate API CredentialsYou will need a Fivetran API key and secret to use these commands. You can create them in your Fivetran account settings: API Keys. See our docs here.🔧 Connector Configuration

Ensure connector setup is complete and not in a “broken” state.
Ensure source system credentials are valid.
Verify destination warehouse permissions are correct.
Unpause any paused connectors you want to sync.

2. Set Environment VariablesUse the generated credentials and set as environment variables for Bolt Schedules

FIVETRAN_API_KEY
FIVETRAN_API_SECRET

How to Configure Fivetran Connector Syncs

When setting up Fivetran Connector Sync, you can provide one or more Fivetran Connectors ID when setting up the task. Providing multiple Connector IDs in the same taks will allow the syncs to be run in parallel and continue to the next task only when all syncs completed.

We recommend you set the Fivetran connector sync schedule to manual. This ensures Fivetran runs when you expect, and syncs are orchestrated only via Paradime.

How to Set a Fivetran Sync to Manual

This cURL command updates a Fivetran connection to use manual scheduling instead of automatic syncs.Request Body Fields

schedule_type: "manual" - Sets sync schedule to manual (no automatic syncs)
run_setup_tests: false - Skips connection validation tests during update

Prerequisites

API Key & Secret: Generate from Fivetran account settings
Connector ID: Found in Fivetran dashboard URL for the connector or using the #list-fivetran-connectors CLI command

curl -X PATCH \
  https://api.fivetran.com/v1/connections/<CONNECTOR_ID> \
  -u "<FIVETRAN_API_KEY>:<FIVETRAN_API_SECRET>" \
  -H "Content-Type: application/json" \
  -d '{"schedule_type": "manual", "run_setup_tests": false}'

Expected ResponseSuccess (200 OK)

{
  "code": "Success",
  "data": {
    "id": "abc123",
    "schedule_type": "manual",
    "sync_frequency": 0,
    "paused": false,
    ...
  }
}

Validate in the Fivetran Dashboard UI
After updating your connection to manual schedule, verify the changes in the Fivetran dashboard:

Navigate to your Connector Dashboard
Locate your connector in the list
Check the top right corner of the connector details page

You should see:

“Enabled”
“Sync Scheduleed manually”

This confirms your connection is active and set to manual scheduling mode.

Learn More: For all supported commands and additional configuration flags, refer to the Paradime Fivetran CLI documentation.

Now, let’s learn how to configure the Trigger Types of a Bolt Schedule.

​Overview

​How to Configure Fivetran Connector Syncs

Overview

How to Configure Fivetran Connector Syncs