First-party app
Fivetran

Fivetran

Run the pipelines that fill a warehouse — trigger and watch connection syncs, pause and resume them, run dbt transformations, and read the destinations and sync history behind it.

stable Data Warehousing & ETLDevOps & InfrastructureAnalytics & BI

About

Fivetran ships in the w6w first-party pack. It declares 20 actions, 3 health checks, and the host runs its code in a sandbox that never sees the credential.

App id
io.w6w.fivetran
Version
0.1.1
Author
w6w
Licence
MIT
Categories
Data Warehousing & ETL · DevOps & Infrastructure · Analytics & BI

Overview

Fivetran automates the pipelines that load a data warehouse, and this app reaches into that pipeline from a workflow: list and inspect connections, trigger an incremental sync or a full historical resync, pause and resume a connection, and run or cancel the dbt transformations that turn raw rows into models.

It also reads the destinations, connector types, sync history and account info behind those pipelines, so a workflow can answer practical questions — which connections are broken, which are merely paused, which destination is failing every connection writing to it — without opening the Fivetran dashboard. Sync and resync are kept distinct on purpose: an incremental sync is the routine, low-cost call, while a full resync rereads a source’s entire history and is billed accordingly, so it requires an explicit acknowledgement rather than being one flag away from the ordinary sync.

This app is built for operating pipelines that already exist — triggering and monitoring syncs and transformations, reading what is broken or paused — rather than for creating connections and destinations or managing who can reach them, neither of which is exposed here.

Build with Fivetran

Three routes to the same 20 actions. The Workflow tab is generated from Fivetran's own manifest and carries its real ids, so it is copy-pasteable; the Code and CLI examples are the same call for any action on any app, so every app-specific value in them is a blank you fill in.

Get account info

account-info-get

Which account this key belongs to and on what plan — a trial is capped at 500 API requests an hour against 20,000, and nothing else tells you which you are on.

Get a connection

connection-get

Whether a pipeline works. `setup_state: broken` stops syncing silently, and a connection can be syncing happily while carrying warnings that mean the data is incomplete.

List connections

connection-list

Every pipeline, with the broken, warning and paused ones separated. A paused connection is somebody's decision rather than an incident.

Pause or resume a connection

connection-pause

Stop or restart a pipeline. Resuming catches up everything that changed while it was paused, in one sync — which after a long pause is a much larger sync than usual.

Re-sync a connection (historical)

connection-resync

Re-read the ENTIRE source from the beginning. Fivetran bills by monthly active rows, so this re-bills every row — hours to days of work and real money on next month's invoice.

Get a connection's schema config

connection-schema-get

Which tables and columns are actually syncing. The answer to 'why is that column missing' — usually disabled rather than broken, and blocked columns are the ones nobody chose.

Sync a connection

connection-sync

Trigger an incremental sync now. It returns when the sync is QUEUED, not when data has landed — poll `connection-get` for that.

Get a connection's sync history

connection-sync-history

Recent sync runs, with durations and outcomes — where a flaky source hiding behind a green dashboard shows up. Fivetran caps the window at SEVEN DAYS.

Run a connection's setup tests

connection-test

Re-check credentials and connectivity after fixing something at the source. Setup tests have their own tight budget — 50 an hour on a trial — so this is a repair step, not a monitor.

List connector types

connector-type-list

Every source Fivetran can read, with the `service` identifier a connection is created with. Metadata rather than account data, so it is the same for everybody.

Get a destination

destination-get

One warehouse, with the region data physically lands in — a compliance answer, and one that cannot be changed after creation.

List destinations

destination-list

The warehouses being written into. A destination with expired credentials breaks every connection at once — which looks like a dozen unrelated sources failing together.

List a group's connections

group-connection-list

Everything feeding one warehouse — the natural question before a migration or a maintenance window, and the check that finds a connection pointed at the wrong environment.

List groups

group-list

The destinations, under Fivetran's other name for them — a group IS a destination, same object and same id. Several usually means separate environments.

Cancel a transformation

transformation-cancel

Stop a running transformation. Models already built stay built, so the warehouse is left internally inconsistent — fix the cause and run again rather than assuming it reverted.

Get a transformation

transformation-get

One dbt job and its schedule. A transformation scheduled by its upstream connections will also fire on a sync you trigger — which is how the models get run twice.

List transformations

transformation-list

The dbt jobs Fivetran runs — your own project or its prebuilt Quickstart packages, which Fivetran versions and can upgrade under you.

List transformation projects

transformation-project-list

The dbt repositories Fivetran builds from — repo, branch and dbt version. Where 'the models changed and nobody deployed' turns out to be a project tracking main.

Run a transformation

transformation-run

Run the dbt models. Firing this before the sync has finished transforms yesterday's data — not an error, and quietly a day old.

List users

user-list

Who can reach the pipelines — an access review over the system holding credentials for every source a company syncs, and one of the least reviewed accounts anywhere.

A workflow step names the app and the action, and the editor fills in the connection when you pick one. This is the Step shape from the workflow spec, carrying Fivetran's real ids.

{
  "manifestVersion": "2",
  "name": "fivetran-example",
  "steps": [
    {
      "id": "connection-get",
      "uses": {
        "app": "io.w6w.fivetran",
        "action": "connection-get",
        "connection": "conn_YOUR_CONNECTION_ID"
      },
      "with": {
        "connectionId": "<connectionId>"
      }
    }
  ]
}

Here are some of the things you can do

  • Get a connection

    read
    connection-get
  • Get account info

    read
    account-info-get
  • List connections

    read
    connection-list
  • Pause or resume a connection

    perform
    connection-pause
  • Re-sync a connection (historical)

    perform
    connection-resync

+15 more actions available

Every app-specific value here is a blank you have to fill in. An app action is reached through the connection that authenticates it, so the address is a connection id, not the app id — and connections belong to your account, so a public page cannot know yours. Create one for Fivetran, then fill in the three blanks: conn_YOUR_CONNECTION_ID, the action key, and the parameters that action declares. The call itself is real — the shape is transcribed from the studio's own snippet builder, which prints the same kind of blanks — but nothing in it is specific to Fivetran. The Workflow tab is where this app's real ids are.

Install
npm install @w6w/sdk
yarn add @w6w/sdk
pnpm add @w6w/sdk
deno add npm:@w6w/sdk
Code
import { W6wClient, isActionRun } from "@w6w/sdk";

// Reads W6W_BASE_URL and W6W_TOKEN from the environment when omitted.
const client = new W6wClient();

const envelope = await client.run({
  urn: "conn_YOUR_CONNECTION_ID",
  action: "connection-get",
  payload: {
    connectionId: "<value>",
  },
});

if (isActionRun(envelope)) console.log(envelope.value);
Install the CLI
npm install -g @w6w/cli
CLI
w6w run conn_YOUR_CONNECTION_ID --action connection-get --payload '{"connectionId":"<value>"}'

Give an AI agent Fivetran — without giving it Fivetran's credentials. One MCP endpoint exposes every app, function and workflow the caller is entitled to, as tools it can discover and run. Access is granted per team while we onboard.

One tool call
{
  "name": "w6w_invoke",
  "arguments": {
    "ref": "app:io.w6w.fivetran#connection-get",
    "input": {
      "connectionId": "<connectionId>"
    }
  }
}

Every tool names its target with a single ref. The app: form above doesn't name a connection at all — the host resolves which of the caller's Fivetran connections to sign with, and refuses rather than guesses when the answer is ambiguous.

What the agent gets

Credentials it can't read

The token is attached host-side, at the moment of the call. It is never a tool argument, never in the model's context, and never in a transcript — so a prompt injection has nothing to exfiltrate.

A tool surface scoped to the caller

Tools are derived per end user from what that person has actually connected and is entitled to — not one shared bot identity carrying the union of everyone's access.

A durable workflow in one call

Multi-step work runs on the workflow engine and returns a run handle the agent can poll — retries, branching and state survive the conversation that started them.

Health-aware discovery

Fivetran's declared health checks are on the surface too, so an agent can tell "the vendor is down" from "your credential expired" before it burns a retry on either.

The MCP surface is part of the hosted platform. Fivetran itself is MIT, and the runtime that executes it is source-available (FSL).

Request MCP access

Health checks

Fivetran declares its own checks, so its health is a property of the app rather than something the host guesses at.

service

Fivetran platform status

The overall indicator from Fivetran's status page, which is all it publishes — its components and incidents endpoints both answer 404.

dependency

Pipeline health

Whether this account's connections are actually syncing. A broken connection stops silently — the warehouse does not empty, it stops changing, and dashboards keep rendering.

quota

API request headroom

Requests left this hour, read from Fivetran's own headers. A trial account allows 500 an hour against 20,000 on a paid plan — forty times tighter.