What's New
New Tool: get_connection_schema
A unified schema inspection tool that provides two modes:
- Overview mode: Returns all schemas and tables with counts
- Table filter mode: Pass
table="schema.table_name"to get detailed column information in a single call
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
Enhanced get_table_columns
Now includes additional fields:
name_in_destination- The column name in the destinationenabled_patch_settings- Settings controlling column sync behaviorenabled_count- Count of enabled columnsprimary_keys- List of primary key columns
Documentation
- Added note about column data types not being available via Fivetran API
- Updated tool table in README