Fivetran
API integration

list_all_fivetran_users

List all users in your Fivetran account. Returns each user's id, email, role, active flag, logged_in_at, and created_at. Max 1000 per page.

get_single_fivetran_user_by_id

Get a single Fivetran user by id. Returns the user object including id, email, verified, role, active, and created_at. Required: id.

delete_a_fivetran_user_by_id

Delete a Fivetran user by id. Returns a confirmation message on success. Required: id. The last remaining account owner cannot be deleted.

update_a_fivetran_user_by_id

Update an existing Fivetran user by id. Returns the updated user object including id, email, verified, role, active, and created_at. Required: id.

create_a_fivetran_user

Invite a new user to your Fivetran account. Regular users get an invitation email they must accept; service accounts are created immediately. Returns: id, email, verified, role, active, given_name, family_name, created_at, and 6 more. Required: email, given_name, family_name. A service account user can't create another service account user.

list_all_fivetran_roles

List all predefined and custom roles in your Fivetran account. Returns: name, description, scope, is_custom, is_deprecated, replacement_role_name. Max 1000 per page.

list_all_fivetran_groups

List all groups (destinations) in your Fivetran account. Returns: id, name, created_at. Max 1000 per page.

get_single_fivetran_group_by_id

Get a single Fivetran group by id. Returns: id, name, created_at. Required: id.

create_a_fivetran_group

Create a new group in your Fivetran account. Returns: id, name, created_at. Groups and destinations map 1:1, so a group must exist before you can create a destination in it.

delete_a_fivetran_group_by_id

Delete a group from your Fivetran account by id. Returns a confirmation message that the group has been deleted. Required: id.

update_a_fivetran_group_by_id

Update the name of an existing group in your Fivetran account by id. Returns: id, name, created_at. Required: id.

list_all_fivetran_teams

List all teams in your Fivetran account. Returns each team's id, name, description, and role.

get_single_fivetran_team_by_id

Get details of a single team in your Fivetran account by id. Returns: id, name, description, role. Required: id.

create_a_fivetran_team

Create a new team in your Fivetran account with a name, description, and role. Returns the created team's id, name, description, and role.

delete_a_fivetran_team_by_id

Delete a team from your Fivetran account by id. Returns the deletion status message on success. Required: id.

update_a_fivetran_team_by_id

Update an existing team in your Fivetran account by id to change its name, description, or role. Returns the updated team's id, name, description, and role. Required: id.

list_all_fivetran_account

Get Fivetran account information for the authenticated API key. Returns: account_id, account_name, user_id, system_key_id.

create_a_fivetran_certificate

Approve a certificate for a Fivetran connection or destination so Fivetran trusts the source/destination database certificate during setup tests. Deprecated. Returns a confirmation message once approved. Required: hash, encoded_cert.

list_all_fivetran_connection_certificates

List certificates approved for a Fivetran connection. Returns: id, name, hash, type, sha1, sha256, public_key, validated_date, validated_by. Max 1000 per page. Required: connection_id, connectionId.

create_a_fivetran_connection_certificate

Approve a certificate for a Fivetran connection so its setup tests trust the source database certificate. Returns: id, name, hash, sha1, sha256, validated_date. Only needed for MySQL, PostgreSQL, or SQL Server sources. Required: connection_id, connectionId, hash, encoded_cert.

fivetran_connection_certificates_bulk_delete

Revoke a certificate from a Fivetran connection by its hash. Returns an empty 204 response on success. Required: connection_id, hash.

list_all_fivetran_connection_certificates_connections

Retrieve the details of a single certificate for a Fivetran connection by its hash. Returns: id, name, hash, type, sha1, sha256, public_key, validated_date, validated_by. Required: connection_id, hash.

create_a_fivetran_connection_connect_card

Create a Connect Card for a Fivetran connection, generating the Connect Card URI for end-user setup. Returns: connector_id, connect_card, connect_card_config. Required: connection_id, connectionId, connect_card_config.

list_all_fivetran_connection_fingerprints

List the approved SSH fingerprints for a Fivetran connection. Returns: hash, attributes. Required: connection_id, connectionId.

create_a_fivetran_connection_fingerprint

Approve an SSH fingerprint for a Fivetran connection, letting Fivetran trust it when connecting to the source database through an SSH tunnel. Returns the approved fingerprint record: hash, attributes. Required: connection_id, connectionId, hash, public_key.

fivetran_connection_fingerprints_bulk_delete

Revoke an approved SSH fingerprint from a Fivetran connection by its hash. Returns an empty 204 response on success. Required: connection_id, hash.

list_all_fivetran_connection_fingerprints_connections

Retrieve details of a specific connection fingerprint for a Fivetran connection. Returns: id, hash, public_key, validated_date, validated_by. Required: connection_id, hash.

create_a_fivetran_connection_move

Move a Fivetran connection to a different destination group. Returns: connection_id, destination_group_id, sync_behavior, moved_at, job_id. Connection must be paused first; job_id tracks async progress. sync_behavior: CONTINUE, BACKFILL, CONTINUE_WITH_DATA (Snowflake Lakehouse only). Required: connection_id, connectionId, destination_group_id.

get_single_fivetran_connection_move_by_id

Get the status of a Fivetran connection move job by id. Returns: id, status, connection_id, source_group_id, destination_group_id, created_at, started_at, completed_at, error_message. Used to monitor a move initiated with CONTINUE_WITH_DATA. Required: id, connection_id, connectionId, jobId.

create_a_fivetran_connection_resync

Trigger a full historical re-sync of a Fivetran connection, optionally limited to specific tables. Returns the confirmation message once the sync is triggered. Fails with a conflict error if a sync is already in progress; paused connections schedule the sync until re-enabled. Required: connection_id, connectionId.

list_all_fivetran_connection_schemas

Retrieve the top-level schema configuration for a Fivetran connection, including global flags and the schema-to-table selection tree. Returns: schemas, schema_change_handling, enable_new_by_default, row_filtering_supported. Unedited columns are omitted from the response. Required: connection_id, connectionId.

create_a_fivetran_connection_schema

Set up a schema config for a new Fivetran connection before the schema is captured from the source. Returns: schemas, schema_change_handling, enable_new_by_default, row_filtering_supported. Settings for entities that cannot be excluded are ignored. Required: connection_id, connection_id, schemas.

update_a_fivetran_connection_schema_by_id

Update the database schema config for a single schema of a Fivetran connection. Returns: schemas, schema_change_handling, enable_new_by_default, row_filtering_supported. Required: connection_id, schema_name, connection_id, enabled.

fivetran_connection_schemas_bulk_update

Update a Fivetran connection's schema config, including schemas, tables, sync modes, and row filters. Returns: schemas, schema_change_handling, enable_new_by_default, row_filtering_supported. Required: connection_id. Column drops take effect at the next sync.

delete_a_fivetran_schemas_drop_column_by_id

Drop multiple blocked columns from your Fivetran destination tables; columns are marked for deletion now and physically removed during the next sync. Returns a success confirmation. Required: connection_id, connectionId, schemas.

create_a_fivetran_schemas_reload

Reload the full schema configuration for an existing Fivetran connection from its data source. Returns the reload status message. May take a long time to complete depending on the schema size and the number of databases, tables, and columns. Required: connection_id, connectionId.

create_a_fivetran_tables_resync

Trigger a historical re-sync of the specified tables within a Fivetran connection. Returns: code, message. Does not override the connection's standard sync frequency set in the Fivetran dashboard. Required: connection_id, connectionId.

fivetran_schema_tables_bulk_update

Update a table's sync configuration within a Fivetran connection schema. Returns: enable_new_by_default, schemas, row_filtering_supported, schema_change_handling. Required: connection_id, schema_name, table_name, enabled.

list_all_fivetran_table_columns

Retrieve the real-time column configuration for a source table in a Fivetran connection. Returns: columns (enabled and hashed flags per column). Only for connections in a Connected state; the table must report supports_columns_config. Required: connection_id, schema, table, connectionId.

fivetran_table_columns_bulk_update

Update a column's configuration for a Fivetran connection (enable, hash, primary key, target data type). Returns: schemas, schema_change_handling, enable_new_by_default, row_filtering_supported. Required: connection_id, schema_name, table_name, column_name, enabled.

fivetran_table_columns_bulk_delete

Drop a blocked column from the destination for a Fivetran connection table. Returns an empty 204 response on success. Required: connection_id, schema_name, table_name, column_name.

get_single_fivetran_connection_state_by_id

Retrieve the connection state for a Fivetran Function or Connector SDK connection. Returns: state. Required: id. Other connection types return a 400 Bad Request error.

fivetran_connection_states_bulk_update

Update the stored connection state for a Fivetran Function or Connector SDK connection. Returns the updated state with its code and message. Required: connection_id. Only supported for Function and Connector SDK connectors; pause the connection first, and the update fails with 409 if a sync is in progress.

create_a_fivetran_connection_sync

Trigger an on-demand data sync for a Fivetran connection without waiting for the next scheduled run. Returns a confirmation message that the sync was triggered. This does not override the connection's normal sync schedule; for manual-schedule connections, syncs only run through this endpoint. Required: connection_id, connectionId.

get_single_fivetran_connection_sync_history_by_id

Retrieve sync history records for a Fivetran connection by id. Returns: sync_id, status, start, end, reason, stages. Max 7-day time window; use start_time and end_time to narrow it (duration is deprecated). Required: id, connectionId.

create_a_fivetran_connection_test

Run the setup tests for an existing Fivetran connection without changing its configuration. Returns the connection object including its id, service, status, setup_tests, and sync_frequency. Required: connection_id, connectionId.

list_all_fivetran_connection_warnings

List all active warnings for a Fivetran connection, grouped by destination table; each warning includes a code, message, error details, and creation timestamp. Returns: items, next_cursor. Required: connection_id, connectionId.

fivetran_connection_warnings_bulk_delete

Dismiss connection warnings of a specific type for a Fivetran connection. Returns an empty 204 response on success. Required: connection_id, warning_type.

list_all_fivetran_connections

List all connections in your Fivetran account. Returns each connection's id, service, schema, paused, status, sync_frequency, and created_at.

create_a_fivetran_connection

Create a new connection in Fivetran. Runs setup tests and returns the created connection with id, service, schema, paused, status, and created_at. Requires group_id and service; destination_schema_names will soon be required. Required: group_id, service.

get_single_fivetran_connection_by_id

Get a Fivetran connection's configuration and status details by id. Returns: id, service, schema, paused, status, schedule, group_id, service_version, connected_by, created_at, succeeded_at, failed_at, pause_after_trial, sync_frequency, data_delay_threshold, data_delay_sensitivity, private_link_id, setup_tests, and 12 more. Required: id.

update_a_fivetran_connection_by_id

Update parameters of an existing Fivetran connection by id. Returns the updated connection with id, service, schema, paused, status, and sync_frequency. Requires id plus at least one persistent parameter such as paused, sync_frequency, or config; test-only flags like run_setup_tests cannot be used alone. Required: id.

delete_a_fivetran_connection_by_id

Delete a Fivetran connection by id. Returns a confirmation message on success. Required: id.

list_all_fivetran_connections_proxy

List all Fivetran connections attached to a proxy agent. Returns: connection_id. Required: agent_id.

list_all_fivetran_connector_sdk_packages

List all Connector SDK packages in your Fivetran account. Returns: id, connection_id, connection_ids, created_by, last_updated_by, created_at, updated_at, file_sha256_hash.

create_a_fivetran_connector_sdk_package

Upload a new Connector SDK package (a ZIP file of your connector code) to Fivetran. Returns: id, connection_id, connection_ids, created_by, last_updated_by, created_at, updated_at, file_sha256_hash. Required: file. Each package can be associated with only one connection at a time.

get_single_fivetran_connector_sdk_package_by_id

Get details for a specific Connector SDK package in Fivetran by id. Returns: id, connection_id, connection_ids, created_by, last_updated_by, created_at, updated_at, file_sha256_hash. Required: id.

update_a_fivetran_connector_sdk_package_by_id

Update a Connector SDK package by uploading a new ZIP version of the connector code. Returns: id, connection_id, connection_ids, created_by, last_updated_by, created_at, updated_at, file_sha256_hash. Required: id, file. Connections using the package automatically use the updated code on their next sync.

delete_a_fivetran_connector_sdk_package_by_id

Permanently delete a Connector SDK package from your Fivetran account by id. Returns a confirmation message on success. Required: id. Packages associated with a connection cannot be deleted until the connection is deleted first.

list_all_fivetran_destination_certificates

List the certificates approved for a Fivetran destination. Returns: id, name, hash, type, sha256, validated_date. Max 1000 per page. Required: destination_id, destinationId.

fivetran_destination_certificates_bulk_delete

Revoke a certificate approved for a Fivetran destination by its hash. Returns a confirmation message. Required: destination_id, hash.

create_a_fivetran_destination_certificate

Approve a certificate for a Fivetran destination database connection. Returns: id, name, hash, type, sha256, validated_date. Only needed for MySQL, PostgreSQL, and SQL Server destinations. Required: destination_id, destinationId, hash, encoded_cert.

list_all_fivetran_destinations

List all destinations in your Fivetran account. Returns: id, service, region, group_id, time_zone_offset, setup_status, daylight_saving_time_enabled, private_link_id, networking_method, local_processing_agent_id, hybrid_deployment_agent_id, proxy_agent_id, external_secrets_manager_id, setup_tests, config.

create_a_fivetran_destination

Create a Fivetran destination within an existing group. Returns: id, service, region, group_id, time_zone_offset, setup_status, daylight_saving_time_enabled, private_link_id, networking_method, setup_tests, config, and 4 more. Required: group_id, service, and time_zone_offset; groups and destinations map 1:1, so the group must already exist.

get_single_fivetran_destination_by_id

Get a single Fivetran destination by id. Returns: id, service, region, group_id, time_zone_offset, setup_status, daylight_saving_time_enabled, private_link_id, networking_method, local_processing_agent_id, hybrid_deployment_agent_id, proxy_agent_id, external_secrets_manager_id, setup_tests, config. Required: id.

update_a_fivetran_destination_by_id

Update an existing Fivetran destination by id. Returns: id, service, region, group_id, time_zone_offset, setup_status, daylight_saving_time_enabled, private_link_id, networking_method, local_processing_agent_id, hybrid_deployment_agent_id, proxy_agent_id, external_secrets_manager_id, setup_tests, config. Required: id, time_zone_offset.

delete_a_fivetran_destination_by_id

Delete a Fivetran destination by id. Returns a confirmation message when the destination has been removed. Required: id.

get_single_fivetran_package_download_by_id

Download the connector code package file (code.zip) for a specific Connector SDK package in Fivetran. Returns the raw ZIP file as a binary octet-stream response, not a JSON record with fields. Required: id.

list_all_fivetran_public_connector_types

List all available Fivetran source (connector) types with their metadata, including display names, icons, feature support, and links to docs. Returns: id, name, type, description, icon_url, link_to_docs, connector_class, supported_features, service_status, supports_schema_reload.

create_a_fivetran_account_test

Run the setup tests for the account-level logging service in Fivetran. Returns: setup_tests.

list_all_fivetran_destination_certificates_destinations

Get the details of an SSL/TLS certificate registered for a Fivetran destination. Returns: id, name, hash, type, sha1, sha256, public_key, validated_date, validated_by. Required: destination_id, hash.

fivetran_destination_fingerprints_bulk_delete

Revoke an approved SSH fingerprint from a Fivetran destination by its hash. Returns the API confirmation message. Required: destination_id, hash.

create_a_fivetran_destination_fingerprint

Approve an SSH fingerprint in Fivetran so it can be trusted for a destination database and connected to via an SSH tunnel. Returns: hash, public_key. Required: destination_id, destinationId, hash, public_key.

list_all_fivetran_destination_fingerprints

List the SSH fingerprints approved for a Fivetran destination. Returns the collection of approved fingerprints, each with its Base64URL-encoded hash and public key. Required: destination_id. Max 1000 per page (default 100).

list_all_fivetran_destination_fingerprints_destinations

Retrieve the details of a Fivetran destination fingerprint identified by its hash. Returns: id, hash, public_key, validated_date, validated_by. Required: destination_id, hash.

create_a_fivetran_destination_test

Run the setup tests for an existing destination in Fivetran. Returns: id, service, region, group_id, time_zone_offset, setup_status, daylight_saving_time_enabled, private_link_id, networking_method, local_processing_agent_id, hybrid_deployment_agent_id, proxy_agent_id, and 3 more. Required: destination_id, destination_id.

fivetran_external_logging_accounts_bulk_delete

Delete the account-level external logging service in Fivetran. Returns an empty 204 response on success.

fivetran_external_logging_accounts_bulk_update

Update the account-level external logging service in Fivetran. Returns the updated log service with id, service, enabled, status, and setup_tests.

create_a_fivetran_external_logging_account

Create an account-level external logging service in Fivetran. Returns the created log service with id, service, enabled, status, and setup_tests.

list_all_fivetran_external_logging_accounts

Get the account-level external logging service in Fivetran. Returns: id, service, enabled, status, setup_tests.

create_a_fivetran_external_logging_test

Run the setup tests for an existing group-level external logging service in Fivetran. Returns the setup-test result record with its id and attributes. Required: log_id, logId.

create_a_fivetran_external_logging

Create a new group-level logging service in Fivetran. Returns: id, service, enabled, status, setup_tests. Requires group_id and service.

delete_a_fivetran_external_logging_by_id

Delete a group-level logging service from Fivetran by id. Returns a confirmation message on success. Required: id.

get_single_fivetran_external_logging_by_id

Get details of a group-level logging service in Fivetran by id. Returns: id, service, enabled, status, setup_tests. Required: id.

list_all_fivetran_external_loggings

List all accessible logging services in your Fivetran account. Returns: id, service, enabled, status.

update_a_fivetran_external_logging_by_id

Update an existing group-level logging service in Fivetran by id. Returns: id, service, enabled, status, setup_tests. Required: id.

list_all_fivetran_external_secrets_manager_entities

List the source connections and destinations using a specific External Secrets Manager in Fivetran. Returns: id, name, enabled, type, secret_manager_id, created_at. Required: esm_id, esmId.

create_a_fivetran_external_secrets_manager

Create a new External Secrets Manager instance in Fivetran. Returns: id, type, name, config, is_hybrid_deployment, created_at, updated_at. Required: type, name, config.

delete_a_fivetran_external_secrets_manager_by_id

Delete an External Secrets Manager instance from Fivetran by id; the instance must not be in use by any connections or destinations. Returns the deletion confirmation message. Required: id.

get_single_fivetran_external_secrets_manager_by_id

Retrieve the details of an existing External Secrets Manager instance in Fivetran by id. Returns: id, type, name, config, is_hybrid_deployment, created_at, updated_at. Required: id.

list_all_fivetran_external_secrets_managers

List all External Secrets Manager instances in your Fivetran account. Returns: id, type, name, config, is_hybrid_deployment, created_at, updated_at. Max 1000 per page, defaults to 100.

update_a_fivetran_external_secrets_manager_by_id

Update the configuration of an existing External Secrets Manager instance in Fivetran by id. Returns: id, type, name, config, is_hybrid_deployment, created_at, updated_at. Required: id, config.

list_all_fivetran_group_connections

List all Fivetran connections within a group. Returns: id, service, schema, paused, status, created_at, sync_frequency. Required: group_id, groupId.

get_single_fivetran_group_public_key_by_id

Retrieve the public SSH key for a Fivetran group. Returns the public_key from the SSH key pair associated with the group. Required: id.

get_single_fivetran_group_service_account_by_id

Get the Fivetran service account associated with a group. Returns: service_account. Required: id.

create_a_fivetran_group_user

Add an existing user to a group in Fivetran. Returns a confirmation message on success. Required: group_id, groupId.

delete_a_fivetran_group_user_by_id

Remove an existing user from a group in Fivetran. Returns a confirmation message on success. Required: id, group_id, groupId, userId.

list_all_fivetran_group_users

List all users within a group in Fivetran. Returns: id, email, role, verified, active, logged_in_at, created_at. Max 1000 per page. Required: group_id, groupId.

create_a_fivetran_hvr_register_hub

Register a new HVR hub within your Fivetran account. Returns: access_token, registration_id. Required: fingerprint.

fivetran_hybrid_deployment_agent_re_auths_bulk_update

Regenerate authentication keys for a Fivetran hybrid deployment agent. Returns the agent object including its id, display_name, token, group_id, enabled, online, registered_at, and last_used_at. Required: agent_id.

create_a_fivetran_hybrid_deployment_agent_reset_credential

Reset the credentials for a Fivetran Hybrid Deployment Agent. Returns: code, message confirming the reset. Required: agent_id, agentId.

create_a_fivetran_hybrid_deployment_agent

Create a new Hybrid Deployment Agent in a Fivetran group. Returns the created agent including id, display_name, group_id, deployment_type, and registered_at. Requires display_name, env_type, and accept_terms. Required: display_name, env_type, accept_terms.

delete_a_fivetran_hybrid_deployment_agent_by_id

Delete a Hybrid Deployment Agent from Fivetran by id. Returns a confirmation message on success. Required: id.

get_single_fivetran_hybrid_deployment_agent_by_id

Get the details of a Hybrid Deployment Agent in Fivetran by id, including its usage. Returns: id, version, enabled, online, files, token, display_name, group_id, registered_at, created_by, deployment_type, updated_at, last_used_at. Required: id.

list_all_fivetran_hybrid_deployment_agents

List all Hybrid Deployment Agents in your Fivetran account along with their usage, optionally filtered to a single group. Returns: id, version, enabled, online, files, token, display_name, group_id, registered_at, created_by, deployment_type, updated_at, last_used_at.

list_all_fivetran_metadata_connector_types

List all available connector source types in your Fivetran account, with proper display names ('Facebook Ads' instead of 'facebook_ads'), icons, Hybrid deployment support info, and links to Fivetran resources. Returns: id, name, type, description, icons, icon_url, link_to_docs, connector_class, supported_features, link_to_erd, and 3 more.

list_all_fivetran_metadata_connector_types_connector_types

Retrieve configuration and authorization metadata for a specified Fivetran connector type. Returns: id, name, type, description, icons, config, auth, icon_url, link_to_docs, connector_class, supported_features, link_to_erd, service_status, service_status_updated_at, supports_schema_reload, external_secrets_keys_config. Required: service.

create_a_fivetran_private_link

Create a new private link in your Fivetran account. Returns: id, name, region, service, state, cloud_provider, created_at, created_by. Required: name, region, service.

delete_a_fivetran_private_link_by_id

Delete a private link from your Fivetran account by id. Returns a confirmation message that the private link is marked for deletion. Required: id.

get_single_fivetran_private_link_by_id

Get a private link's details by id. Returns: id, name, region, service, state, host, cloud_provider, created_at. Required: id.

list_all_fivetran_private_links

List all private links in your Fivetran account. Returns: id, name, region, service, state, cloud_provider, created_at, created_by. Max 1000 per page.

update_a_fivetran_private_link_by_id

Update an existing private link in your Fivetran account by id. Returns the updated private link object including its id and the upstream-defined link attributes. Required: id.

list_all_fivetran_proxies

List all proxy agents in your Fivetran account. Returns: id, account_id, registered_at, region, created_by, display_name, version, status, connector_count, destination_count. Max 1000 per page.

create_a_fivetran_proxy

Create a new proxy agent in Fivetran. Returns the agent's agent_id, auth_token, client_cert, client_private_key, orchestrator_host, and orchestrator_port. Requires display_name and group_region.

delete_a_fivetran_proxy_by_id

Delete a Fivetran proxy agent by id. Returns a confirmation message on success. Deletion fails if the agent has attached connections. Required: id.

get_single_fivetran_proxy_by_id

Get a single Fivetran proxy agent by id. Returns the agent's details including id, account_id, registered_at, region, display_name, version, status, and the connections currently using it (usage). Required: id.

list_all_fivetran_external_secrets_managers_entities

List all source connections and destinations that use an External Secrets Manager in your Fivetran account. Returns: id, name, enabled, type, secret_manager_id, created_at.

create_a_fivetran_regenerate_secret

Regenerate the secrets for a proxy agent in Fivetran. Returns the proxy agent record including id, display_name, region, registered_at, version, status, created_by, and account_id. Required: agent_id, agentId.

create_a_fivetran_system_key_rotate

Rotate a Fivetran system key, regenerating its secret value and updating its expired_at date. Returns: id, name, key, secret, permissions, created_at, updated_at, expired_at, last_used_at. Required: key_id, keyId.

create_a_fivetran_system_key

Create a new system key in Fivetran. Returns: id, name, key, secret, permissions, created_at, updated_at, expired_at, last_used_at. Requires name, expiration_period, and permissions (resource_type/access_level pairs).

delete_a_fivetran_system_key_by_id

Delete a system key from your Fivetran account by id. Returns a confirmation message on success. Required: id.

get_single_fivetran_system_key_by_id

Get a Fivetran system key's details by id. Returns: id, name, key, secret, permissions, created_at, updated_at, expired_at, last_used_at. Required: id.

list_all_fivetran_system_keys

List all system keys in your Fivetran account. Returns: id, name, key, secret, permissions, created_at, updated_at, expired_at, last_used_at. Max 1000 per page (default 100).

update_a_fivetran_system_key_by_id

Update a Fivetran system key's name and permissions by id. Returns: id, name, key, secret, permissions, created_at, updated_at, expired_at, last_used_at. Required: id.

create_a_fivetran_team_connection

Add a Fivetran team as a member of a connection. Returns: id, role, created_at. Requires team_id, id (the connection id), and role. Required: team_id, teamId, id, role.

delete_a_fivetran_team_connection_by_id

Remove a team's membership in a Fivetran connection. Returns a confirmation message on success. Requires team_id and id. Required: id, team_id, teamId, connectionId.

get_single_fivetran_team_connection_by_id

Get details of a Fivetran team's membership in a connection. Returns: id, role, created_at. Requires team_id and id. Required: id, team_id, teamId, connectionId.

list_all_fivetran_team_connections

List all connections a Fivetran team has membership in. Returns: id, role, created_at for each membership. Requires team_id. Required: team_id, teamId.

update_a_fivetran_team_connection_by_id

Update a Fivetran team's membership role in a connection. Returns: id, role, created_at. Requires team_id, id, and role. Required: id, team_id, teamId, connectionId, role.

create_a_fivetran_team_group

Add a Fivetran team as a member of a group. Returns the created membership object: id, role, created_at. Required: team_id, teamId, id, role.

delete_a_fivetran_team_group_by_id

Delete a Fivetran team's membership in a group. Returns a confirmation message that the group membership has been deleted. Required: id, team_id, teamId, groupId.

get_single_fivetran_team_group_by_id

Get details of a Fivetran team's membership in a specific group. Returns: id, role, created_at. Required: id, team_id, teamId, groupId.

list_all_fivetran_team_groups

List all groups in which a Fivetran team has membership. Returns membership records with id, role, and created_at for each group. Required: team_id, teamId.

update_a_fivetran_team_group_by_id

Update a Fivetran team's membership in a group, changing its role. Returns the updated membership: id, role, created_at. Required: id, team_id, teamId, groupId, role.

fivetran_team_roles_bulk_delete

Delete role assignments from a Fivetran team. Returns an empty 204 response on success. Required: team_id.

list_all_fivetran_team_users

List all users and their roles within a Fivetran team. Returns: user_id, role, created_at. Max 1000 per page. Required: team_id, teamId.

get_single_fivetran_team_user_by_id

Retrieve a user's membership details in a Fivetran team by id. Returns: user_id, role, created_at. Required: id, team_id, teamId, userId.

create_a_fivetran_team_user

Add a user to a Fivetran team by assigning them a role. Returns: user_id, role, created_at. Required: team_id, teamId, user_id.

update_a_fivetran_team_user_by_id

Update a user's role in a Fivetran team by id. Returns: user_id, role, created_at. Required: id, team_id, teamId, userId, role.

delete_a_fivetran_team_user_by_id

Remove a user from a Fivetran team by id. Returns a removal confirmation message on success. Required: id, team_id, teamId, userId.

create_a_fivetran_transformation_project_test

Trigger tests for an existing transformation project in Fivetran. Returns the project details object: id and attributes (project-specific fields; consult the upstream docs for the full breakdown). Required: project_id, projectId.

list_all_fivetran_transformation_projects

List all Fivetran transformation projects in your account. Returns: id, type, created_at, created_by_id, group_id.

create_a_fivetran_transformation_project

Create a new transformation project in Fivetran. Returns the created project with id, type, status, errors, group_id, and setup_tests. Requires group_id and type.

get_single_fivetran_transformation_project_by_id

Get details of a single Fivetran transformation project by id. Returns: id, type, status, errors, created_at, created_by_id, group_id, setup_tests. Required: id.

update_a_fivetran_transformation_project_by_id

Update a Fivetran transformation project by id. Returns the updated project with id, type, status, errors, group_id, and setup_tests. Required: id.

delete_a_fivetran_transformation_project_by_id

Delete a Fivetran transformation project by id. Returns a confirmation message on success. Required: id.

create_a_fivetran_transformation_run

Run a Fivetran transformation on demand by triggering it with its unique identifier. Returns a confirmation message once the transformation run has started. Required: transformation_id, transformationId.

create_a_fivetran_transformation_upgrade

Upgrade a Quickstart transformation package in Fivetran to its latest version. Returns the confirmation message, e.g. 'Transformation package has been upgraded'. Required: transformation_id, transformationId.

fivetran_transformations_cancel_cancel

Cancel a running transformation in Fivetran by its id. Returns the confirmation status message, e.g. "Transformation with id 'string' has been canceled". Required: transformation_id.

list_all_fivetran_transformations_package_metadatas

List all available Quickstart transformation package metadata in Fivetran. Returns: id, name, version, connector_types, output_model_names, configurable_variables.

get_single_fivetran_transformations_package_metadata_by_id

Retrieve the metadata details of a single Quickstart transformation package in Fivetran by id. Returns: id, name, version, connector_types, output_model_names, configurable_variables. Required: id.

list_all_fivetran_transformations_v_1

List all Transformations in Fivetran. Returns: id, status, schedule, type, paused, created_at, created_by_id, last_started_at, last_ended_at, output_model_names.

create_a_fivetran_transformations_v_1

Create a Transformation in Fivetran. Returns the created transformation including its id, status, schedule, type, paused, and created_at.

get_single_fivetran_transformations_v_1_by_id

Get a Fivetran Transformation by id. Returns the transformation details including id, status, schedule, type, paused, and created_at. Required: id.

delete_a_fivetran_transformations_v_1_by_id

Delete a Fivetran Transformation by id. Returns an empty 204 response on success. Required: id.

update_a_fivetran_transformations_v_1_by_id

Update a Fivetran Transformation by id, modifying only the fields you provide (schedule, paused). Returns: id, status, schedule, type, paused, created_at, created_by_id, last_started_at, last_ended_at, output_model_names. Required: transformation_id.

list_all_fivetran_user_api_keys

Get a Fivetran service account user's API key details. Returns: key_value, key_status, created_at, expires_at, last_rotated_at. Required: user_id, userId.

create_a_fivetran_user_api_key

Create a new API key for a Fivetran service account user. Returns: key_value, key_secret, key_status, created_at, expires_at. The secret is returned once at creation and cannot be retrieved again. Required: user_id, userId.

fivetran_user_api_keys_bulk_delete

Delete API keys for a Fivetran service account user. Returns an empty 204 response on success. Required: user_id.

list_all_fivetran_users_api_keys

List all API keys for users in your Fivetran account. Returns: user_id, user_type, key_value, key_status, created_at, expires_at. Limit accepts 1–1000 per page, default 100.

create_a_fivetran_api_keys_rotate

Rotate the API key for a Fivetran service account and generate a new secret; an optional overlap window keeps the old secret valid for zero-downtime rotation. Returns: key_value, key_secret, key_status, expires_at, overlap_expires_at, last_rotated_at. Required: user_id, userId.

create_a_fivetran_user_connection

Add a connection membership for a Fivetran user. Returns the created membership with id, role, and created_at. Required: user_id, userId, id, role.

delete_a_fivetran_user_connection_by_id

Delete a user's connection membership in Fivetran by id. Returns the removed membership with id, role, and created_at. Required: id, user_id, userId, connectionId.

get_single_fivetran_user_connection_by_id

Retrieve a user's connection membership in Fivetran by id. Returns: id, role, created_at. Required: id, user_id, userId, connectionId.

list_all_fivetran_user_connections

List all connection memberships for a Fivetran user. Returns: id, role, created_at. Max 1000 per page. Required: user_id, userId.

update_a_fivetran_user_connection_by_id

Update a user's connection membership role in Fivetran by id. Returns: id, role, created_at. Required: id, user_id, userId, connectionId, role.

create_a_fivetran_user_group

Add a membership for a Fivetran user in a group. Returns: id, role, created_at. Required: user_id, userId, id, role.

delete_a_fivetran_user_group_by_id

Remove a Fivetran user from a group by deleting their group membership. Returns a confirmation message on success. Required: id, user_id, userId, groupId.

get_single_fivetran_user_group_by_id

Get the details of a Fivetran user's membership in a group. Returns: id, role, created_at. Required: id, user_id, userId, groupId.

list_all_fivetran_user_groups

List all group memberships for a Fivetran user. Returns memberships with id, role, created_at. Max 1000 per page. Required: user_id, userId.

update_a_fivetran_user_group_by_id

Update a Fivetran user's role in a group. Returns a confirmation message on success. Required: id, user_id, userId, groupId, role.

fivetran_user_roles_bulk_delete

Delete the account role assigned to a user in Fivetran. Returns a confirmation message on success. Required: user_id.

create_a_fivetran_webhook_test

Test an existing Fivetran webhook by sending a test event to the dummy connection _connection_1. Returns: succeed, status, message. Required: webhook_id, webhookId, event.

delete_a_fivetran_webhook_by_id

Delete a Fivetran webhook by id. Returns a success confirmation message that the webhook was deleted. Required: id.

get_single_fivetran_webhook_by_id

Get details of a specific Fivetran webhook by id. Returns: id, type, url, events, active, secret, group_id, created_at, created_by. Required: id.

list_all_fivetran_webhooks

List all webhooks configured for the current Fivetran account. Returns: id, type, url, events, active, secret, group_id, created_at, created_by. Max 1000 per page.

update_a_fivetran_webhook_by_id

Update an existing Fivetran webhook by id. Returns the updated webhook with id, type, url, events, active, secret, group_id, created_at, and created_by. Required: id.

create_a_fivetran_webhooks_account

Create a new webhook for the current Fivetran account. Returns the created webhook object including its id, url, events, active status, secret, and created_at. Required: url, events.

create_a_fivetran_webhooks_group

Create a new group webhook in Fivetran. Returns the created webhook including its id, type, url, events, active status, secret, and group_id. Required: group_id, groupId, url, events.