List all Fivetran connections in the account.

Get detailed status for a specific Fivetran connection.

Returns comprehensive information including sync state, tasks with full details, warnings, and scheduling configuration. Use this for investigating connection issues and understanding sync status.

Trigger a data sync for a Fivetran connection.

This starts a sync without waiting for the next scheduled sync time. Does not override the standard sync frequency.

Trigger a full historical resync for a Fivetran connection.

This re-syncs all historical data from the source. Use with caution as it may take significant time and resources.

Trigger a historical resync for specific tables within a connection.

This re-syncs historical data only for the specified tables, not the entire connection. Useful when you need to refresh specific tables without a full resync.

Pause a Fivetran connection.

Paused connections will not sync data until resumed.

Resume a paused Fivetran connection.

The connection will start syncing according to its schedule.

List all Fivetran groups (destinations) in the account.

Groups represent destinations where data is synced to.

Test a Fivetran connection to diagnose connectivity and configuration issues.

Executes diagnostic tests to identify root causes when syncs fail, validate connection health proactively, and support incident response workflows.

Retrieve the complete schema configuration for a Fivetran connection.

Returns all schemas and tables with their enabled/disabled status, sync modes, and configuration. Useful for understanding what data is being synced and investigating missing tables.

Retrieve schema information for a Fivetran connection with optional table filter.

When called without a table parameter, returns all schemas and tables. When a table is specified (format: "schema.table_name"), returns detailed information for that specific table including all column metadata.

This is useful for:

• Debugging dbt model failures when columns are missing

• Detecting schema changes

• Building new models with accurate column metadata

• Identifying which columns are actively synced vs excluded

List all tables in a Fivetran connection with their sync status.

Provides a flattened view of all tables across all schemas, showing enabled status, sync mode, and configuration. Useful for quickly seeing which tables are being synced.

Retrieve column details for a specific table in a Fivetran connection.

Returns column names, sync configuration, and metadata. Useful for investigating schema issues or understanding table structure.

Note: Column data types are not available via the Fivetran API. Data types can be queried directly from your destination database.

Reload the schema configuration from the source for a Fivetran connection.

Fetches the latest schema from the data source and updates the configuration. Useful after source schema changes to detect new tables or columns.

Get per-table sync status for a Fivetran connection.

Returns detailed status for each table including enabled/disabled state, sync configuration, and metadata from the most recent successful sync. Useful for debugging large connectors with many tables, identifying stale tables, and monitoring data freshness.

For connectors with many tables (e.g., Airtable with 20+ bases, or Postgres with 50+ tables), this provides visibility into which specific tables are configured and their sync settings.

Note: Table metadata (like destination names) is only available after at least one successful sync has completed.