Skip to content

Start building

Integration · Analytics and data

AI agents for Fivetran

Watch and run Fivetran data pipelines: list groups and connections, check a connection's sync status and errors, start a sync, pause or resume it, and change how often it syncs, with an API key and secret.

Actions
7
Read
5
Write
2

Actions

What your agents can do in Fivetran

7 actions. Each one is a tool your agents can call and a step your workflows can run.

Read 5

Look things up. Nothing changes.

  • List groups

    Lists the account's groups (each is one destination with its connections), as data.items: each with id, name and created_at, and data.next_cursor for the next page.

  • List connections

    Lists the account's connections (pipelines from a source), as data.items.

  • Get a connection

    Reads one connection in data: its service, schema, group, whether it is paused, its schedule.

  • Get a connection's schemas and tables

    Reads which schemas, tables and columns a connection syncs, in data.schemas.

  • Run a connection's setup tests

    Runs a connection's setup tests (can Fivetran reach and read the source?)

Write 2

Create, change or send.

  • Start a sync

    Starts an incremental sync of a connection now.

  • Pause, resume or reschedule a connection

    Changes a connection's schedule: paused true stops its syncs and false resumes them; sync_frequency sets minutes between syncs (1, 5, 15, 30, 60, 120, 180, 360, 480, 720 or 1440); daily_sync_time.

A person can approve first

Any write action can be set to wait for a person's approval before it runs, so an agent asks before it changes anything.

Connection

How it connects

Connect it once in the console, then give it to the agents and workflows that need it.

Username and key

Enter the API credentials from your Fivetran account.

What you enter

  • API key
  • API secret

Kept safe

  • Credentials are stored encrypted with your organization's own keys.
  • They are opened only by the process that makes the call, at the moment it runs, and never go into a prompt or the browser.
  • Calls go only to the tool's own servers.

How we protect your data

Ideas

Ideas to start with

Starting points made only from the actions above. Mix them with any other tool your agents can use.

  • 01

    Ask about your Fivetran data

    Ask a question in plain words. The agent can list groups, list connections or get a connection in Fivetran, then answers with what it found.

  • 02

    Let an agent update Fivetran

    Have the agent start a sync or pause, resume or reschedule a connection in Fivetran as part of a larger task. Turn on approval and a person signs off on each change first.

  • 03

    Share what it finds in Slack

    Give one agent Fivetran and Slack: it can list groups in Fivetran and post a summary to a Slack channel in the same run.

FAQ

Fivetran and MyDeepAgents

Can MyDeepAgents connect to Fivetran?

Yes. The Fivetran connector has 7 actions: 5 read and 2 make changes. Your agents can call them as tools, and your workflows can run them as steps.

How do I connect Fivetran?

Enter the API credentials from your Fivetran account. You'll need: API key and API secret. Credentials are stored encrypted with your organization's own keys and are opened only at the moment of a call.

Can an agent change data in Fivetran without asking?

Only if you let it. Each of the 2 actions that change data can be set to wait for a person's approval before it runs.

Can I use Fivetran in workflows as well as agents?

Yes. Every Fivetran action also works as a step in a workflow, and the same connection serves your agents and your workflows.

Early access

Put Fivetran to work

Connect it in a few minutes, give an agent the actions it needs, and decide which changes wait for a person.