Skip to main content
Trigger Airbyte connector syncs from a Bolt schedule so your warehouse has the latest source data before your dbt™ models run. Add dbt™ commands to the same schedule to transform right after the sync, or run a separate dbt™ pipeline with the On run completion trigger.

​
Prerequisites

  • Airbyte connected to Paradime: Airbyte Cloud or Airbyte Server. You need a Client ID and Client Secret (plus your API base URL for self-hosted).
  • The connection exists and is enabled in Airbyte, with valid source and destination credentials.
  • Set these as Bolt environment variables:
    • AIRBYTE_CLIENT_ID
    • AIRBYTE_CLIENT_SECRET
    • AIRBYTE_BASE_URL (Airbyte Server only)
    • USE_SERVER_AUTH (Airbyte Server only)
Set the Airbyte connection’s Schedule Type to Manual in the Airbyte UI, so syncs run only when Paradime triggers them.
  1. In Airbyte, open Connections and select the connection.
  2. In its settings, set Schedule Type to Manual.
  3. Click Save changes.

​
Usage

Add the Sync Airbyte Connection command to your schedule, then:
  1. Enter one or more Connection IDs (for example, conn_123). Use Add connection to sync several in parallel; the schedule continues to the next command only once all syncs finish.
  2. Choose the Job type: Sync to run the connection, or Reset to clear its data and re-sync.
  3. Click Add command.

​
Learn more

For options beyond the UI, or to run syncs from a pipeline, see the Paradime Airbyte CLI.

Related topics

Orchestrate your whole stackCommandsAirbyte CLIAirbyteAirbyte Cloud