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.

Prerequisites

1. Generate API Credentials

You 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 Variables

Use 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

1. API Key & Secret: Generate from Fivetran account settings

2. Connector ID: Found in Fivetran dashboard URL for the connector or using the Fivetran Connector Sync 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 Response

Success (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:

1. Navigate to your Connector Dashboard

2. Locate your connector in the list

3. 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.