get_connection_schema
Retrieve schema information for a Fivetran connection. Optionally filter by table name to get detailed column metadata, including sync status. Debug missing columns and detect schema changes.
Instructions
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
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connection_id | Yes | The unique identifier of the connection | |
| table | No | Optional table name in "schema.table_name" format to get detailed info |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||