Fivetran

Fivetran is a managed data movement platform that replicates data from SaaS apps, databases, and logs into warehouses and lakehouses such as Databricks, Snowflake, and BigQuery.

With the Fivetran block, you can:

• Manage connections: List, read, create, update, pause, resume, and delete connections, look up the setup fields a connector type takes (such as Okta), and generate Connect Card links so source owners can authorize a connection themselves.
• Run and repair syncs: Start a sync on demand, re-sync a whole connection or specific tables, run setup tests, reload the schema, and change which schemas and tables a connection syncs and how it handles new ones.
• Monitor pipelines: Read sync history with per-stage data volumes, active warnings, schema configs, and each connection's setup, sync, and update state.
• Work with destinations and transformations: Create and inspect groups and destinations such as Databricks, run destination setup tests, and list, run, or cancel transformations.
• Review the account: Read account details, list users and service accounts, and look up the connector types you can create.
• React to events: Start workflows when syncs start or end, connections succeed, fail, or change, tables are re-synced, or transformations start, succeed, or fail.

To connect, click your username in Fivetran, then API Key > Generate API key. In the block, choose Add API key under Fivetran Account and paste the key and secret. Sim checks them against your Fivetran account, stores them encrypted as a reusable workspace credential, and fills the Connection, Group, and Destination dropdowns from that account. The key acts with your Fivetran permissions.

Triggers take the API key and secret directly, register a webhook in Fivetran when you deploy the workflow (for the whole account or one group), and verify every delivery against a signing secret Sim generates for that webhook. The webhook is removed when you delete the trigger and redeploy.

In Sim, the Fivetran block lets your agents triage failed syncs as they happen, keep security log pipelines into your SIEM from going stale, run dbt transformations after loads finish, and report on pipeline health and account access.

Usage Instructions

Integrate Fivetran into the workflow. List, create, update, pause, resume, and delete connections, trigger syncs and historical re-syncs, read sync history, warnings, and schema configs, enable or disable schemas and tables, run setup tests, generate Connect Card links, look up connector setup fields, create and inspect groups and destinations, run and cancel transformations, review users, and react to sync, connection, and transformation webhooks.

Actions

Fivetran List Connections

List Fivetran connections with their sync state, schedule, and last success or failure, optionally filtered by group or schema name.

Input

Output

Fivetran Get Connection

Get a Fivetran connection, including its setup, sync, and update state, open tasks and warnings, and schedule.

Input

Output

Fivetran Create Connection

Create a Fivetran connection in a group. The config object holds the connector-specific settings and the destination naming: schema for most connectors, schema_prefix for databases, or schema and table for file connectors.

Input

Output

Fivetran Update Connection

Update a Fivetran connection: pause or resume it, change its sync frequency or schedule, or update its configuration.

Input

Output

Fivetran Delete Connection

Delete a Fivetran connection. This cannot be undone.

Input

Output

Fivetran Sync Connection

Start an incremental sync of a Fivetran connection now, without changing its schedule.

Input

Output

Fivetran Re-sync Connection

Run a full historical re-sync of a Fivetran connection, or only of the tables listed in scope. Fivetran returns 409 if a running sync cannot finish first.

Input

Output

Fivetran Re-sync Tables

Run a historical re-sync of specific tables in a Fivetran connection without changing its schedule.

Input

Output

Fivetran Run Connection Setup Tests

Run the setup tests of a Fivetran connection without changing its configuration, and return each test result.

Input

Output

Fivetran Get Sync History

List the recent syncs of a Fivetran connection with their outcome, failure reason, and data volume per stage. The time window is at most 7 days and defaults to the last hour.

Input

Output

Fivetran Get Connection Warnings

List the active warnings on a Fivetran connection, grouped by destination table.

Input

Output

Fivetran Get Connection Schema Config

Get the schemas, tables, and columns a Fivetran connection syncs, and whether each is enabled.

Input

Output

Fivetran Reload Connection Schema

Reload the schema config of a Fivetran connection from its source to pick up new schemas, tables, and columns. Large sources can take a long time.

Input

Output

Fivetran Update Connection Table

Enable or disable syncing of one table in a Fivetran connection, and optionally change its sync mode.

Input

Output

Fivetran Create Connect Card

Generate a Connect Card link that lets someone authorize and finish setting up a Fivetran connection in a Fivetran-hosted form.

Input

Output

Fivetran List Groups

List the groups in the Fivetran account. Each group pairs with one destination, so the group ID is also the destination ID.

Input

Output

Fivetran Get Group

Get a Fivetran group by ID.

Input

Output

Fivetran List Destinations

List the destinations in the Fivetran account, such as Databricks or Snowflake, with their region and setup status.

Input

Output

Fivetran Get Destination

Get a Fivetran destination with its region, time zone, and setup status.

Input

Output

Fivetran Run Destination Setup Tests

Run the setup tests of a Fivetran destination, such as a Databricks workspace, and return each test result.

Input

Output

Fivetran List Transformations

List Fivetran transformations (dbt Core and Quickstart) with their status, schedule, and last run times.

Input

Output

Fivetran Get Transformation

Get a Fivetran transformation with its status, schedule, and output models.

Input

Output

Fivetran Run Transformation

Start a run of a Fivetran transformation now.

Input

Output

Fivetran Cancel Transformation

Cancel a running Fivetran transformation.

Input

Output

Fivetran Get Account Info

Get the Fivetran account and the user or system key that the API key belongs to.

Input

Output

Fivetran List Users

List the users and service accounts in the Fivetran account with their role, status, and last login, for access reviews.

Input

Output

Fivetran List Connector Types

List the source connector types available in Fivetran, with the service ID to use when creating a connection.

Input

Output

Fivetran Get Connector Type

Get the configuration and authorization fields a Fivetran connector type takes, to build the config for Create Connection.

Input

Output

Fivetran Update Schema Config

Update how a Fivetran connection handles new schemas, tables, and columns, and enable or disable schemas and tables in one call.

Input

Output

Fivetran Update Connection Schema

Enable or disable syncing of one schema in a Fivetran connection, optionally changing several of its tables at once.

Input

Output

Fivetran Create Group

Create a Fivetran group. Each group holds one destination, so create the group first, then its destination.

Input

Output

Fivetran Create Destination

Create the destination for a Fivetran group, such as a Databricks workspace. The config object holds the destination-specific connection settings.

Input

Output

Triggers

A Trigger is a block that starts a workflow when an event happens in this service.

Fivetran All Events

Trigger workflow on any Fivetran sync, connection, or transformation event

Configuration

Output

---

Fivetran Connection Created

Trigger workflow when a connection is created

Configuration

Output

---

Fivetran Connection Deleted

Trigger workflow when a connection is deleted

Configuration

Output

---

Fivetran Connection Edited

Trigger workflow when connection credentials, sync frequency, or other settings change

Configuration

Output

---

Fivetran Connection Failed

Trigger workflow when Fivetran fails to connect to a source

Configuration

Output

---

Fivetran Connection Paused

Trigger workflow when a connection is paused, by a user or automatically

Configuration

Output

---

Fivetran Connection Re-sync Triggered

Trigger workflow when a historical re-sync of a connection is triggered

Configuration

Output

---

Fivetran Connection Resumed

Trigger workflow when a connection is resumed

Configuration

Output

---

Fivetran Connection Succeeded

Trigger workflow when Fivetran connects to a source successfully

Configuration

Output

---

Fivetran Manual Sync Triggered

Trigger workflow when someone triggers a manual sync of a connection

Configuration

Output

---

Fivetran Sync Ended

Trigger workflow when a connection sync finishes, succeeds, fails, or is rescheduled

Configuration

Output

---

Fivetran Sync Started

Trigger workflow when a connection starts syncing

Configuration

Output

---

Fivetran Table Re-sync Triggered

Trigger workflow when a historical re-sync of a table is triggered

Configuration

Output

---

Fivetran Transformation Failed

Trigger workflow when a transformation run fails

Configuration

Output

---

Fivetran Transformation Started

Trigger workflow when a transformation run starts

Configuration

Output

---

Fivetran Transformation Succeeded

Trigger workflow when a transformation run succeeds

Configuration

Output