connection_schema_config
Retrieve the full schema configuration for a Fivetran connection, including global flags, schemas, tables, and overridden columns. Use it to read current data-selection, back up schema, or copy to another connection.
Instructions
⚠️ IMPORTANT - If a table's parent schema is not enabled, the table will not be replicated. Check before telling the table the column is enabled. Returns the top-level schema configuration for an existing connection within your Fivetran account. The response includes global flags, every schema, each table, and only the columns that were explicitly overridden. Use this endpoint to read the current data-selection tree for a connection, to back up the schema before making edits, or to copy the configuration to another connection. > NOTE: To restore a backed-up schema or copy the configuration to another connection, use the Update a Connection Schema Config endpoint. For more information, see the Connection Schema config tutorial. > NOTE: Unedited columns (those following table defaults) are omitted from the response. For a real-time, exhaustive column list for a specific table, call the Retrieve Source Table Columns Config endpoint. For the NetSuite SuiteAnalytics, and Salesforce and Salesforce Sandbox connectors, the 'schemas' map field contains a single entry with the 'netsuite' or 'salesforce' key, respectively. For the 'schema.name_in_destination` name field, these connectors always return the destination schema name you set in the connection setup form. For more information on using this API endpoint with the the Oracle Fusion Cloud Applications connectors, see the Schema information documentation. > IMPORTANT: This endpoint does not apply to Magic Folder connectors.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema_file | Yes | REQUIRED: You must first read the schema file at 'open-api-definitions/connections/connection_schema_config.json', then provide this exact path here to confirm. | |
| connection_id | Yes | The unique identifier for the connection |