Manage Fivetran connections, syncs, and transformations
Fivetran is a Sim integration in the Databases category. Sim is the AI workspace where teams build and deploy AI agents. Sim's Fivetran integration provides 34 tools and 16 triggers that AI agents can use inside Sim's visual workflow builder. Fivetran connects with one-click OAuth. Free to start at sim.ai.
Last updated
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.
Sign up at sim.ai in seconds. No credit card required. Your workspace is ready immediately.
Open your workspace, drag a Fivetran block onto the workflow builder, and connect your account with one-click OAuth.
Pick the tool you need, wire in an AI agent for reasoning or data transformation, and run. Your Fivetran automation is live.
Add a Fivetran trigger to a Sim agent and it starts a run whenever one of these Fivetran events occurs.
Trigger workflow when a connection sync finishes, succeeds, fails, or is rescheduled
Trigger workflow when a connection starts syncing
Trigger workflow when Fivetran fails to connect to a source
Trigger workflow when Fivetran connects to a source successfully
Trigger workflow when a connection is created
Trigger workflow when connection credentials, sync frequency, or other settings change
Trigger workflow when a connection is paused, by a user or automatically
Trigger workflow when a connection is resumed
Trigger workflow when a connection is deleted
Trigger workflow when someone triggers a manual sync of a connection
Trigger workflow when a historical re-sync of a connection is triggered
Trigger workflow when a historical re-sync of a table is triggered
Trigger workflow when a transformation run starts
Trigger workflow when a transformation run succeeds
Trigger workflow when a transformation run fails
Trigger workflow on any Fivetran sync, connection, or transformation event
Ready-to-use templates featuring Fivetran. Click any to build it instantly.
34 Fivetran tools available to Sim agents.
List Fivetran connections with their sync state, schedule, and last success or failure, optionally filtered by group or schema name.
Get a Fivetran connection, including its setup, sync, and update state, open tasks and warnings, and schedule.
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.
Update a Fivetran connection: pause or resume it, change its sync frequency or schedule, or update its configuration.
Delete a Fivetran connection. This cannot be undone.
Start an incremental sync of a Fivetran connection now, without changing its schedule.
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.
Run a historical re-sync of specific tables in a Fivetran connection without changing its schedule.
Run the setup tests of a Fivetran connection without changing its configuration, and return each test result.
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.
List the active warnings on a Fivetran connection, grouped by destination table.
Get the schemas, tables, and columns a Fivetran connection syncs, and whether each is enabled.
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.
Enable or disable syncing of one table in a Fivetran connection, and optionally change its sync mode.
Enable or disable syncing of one schema in a Fivetran connection, optionally changing several of its tables at once.
Update how a Fivetran connection handles new schemas, tables, and columns, and enable or disable schemas and tables in one call.
Generate a Connect Card link that lets someone authorize and finish setting up a Fivetran connection in a Fivetran-hosted form.
List the groups in the Fivetran account. Each group pairs with one destination, so the group ID is also the destination ID.
Get a Fivetran group by ID.
Create a Fivetran group. Each group holds one destination, so create the group first, then its destination.
List the destinations in the Fivetran account, such as Databricks or Snowflake, with their region and setup status.
Get a Fivetran destination with its region, time zone, and setup status.
Create the destination for a Fivetran group, such as a Databricks workspace. The config object holds the destination-specific connection settings.
Run the setup tests of a Fivetran destination, such as a Databricks workspace, and return each test result.
List Fivetran transformations (dbt Core and Quickstart) with their status, schedule, and last run times.
Get a Fivetran transformation with its status, schedule, and output models.
Start a run of a Fivetran transformation now.
Cancel a running Fivetran transformation.
Get the Fivetran account and the user or system key that the API key belongs to.
List the users and service accounts in the Fivetran account with their role, status, and last login, for access reviews.
List the source connector types available in Fivetran, with the service ID to use when creating a connection.
Get the configuration and authorization fields a Fivetran connector type takes, to build the config for Create Connection.
Sim's Fivetran integration adds 34 tools and 16 triggers to the AI agents you build in Sim's visual workflow builder. Manage Fivetran connections, syncs, and transformations.
