get_connection_tables
Discover available tables and views in a data source to identify data for synchronization jobs. Returns table names in the exact format required for task configuration.
Instructions
Discover available tables/views in a data source. Essential before creating jobs.
RETURNS: Array of table names in exact format needed for tasks.
COMMON ERRORS:
"Connection not found" - Verify connection name
"Access denied" - Check connection permissions
"No tables found" - Verify schema/catalog settings
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connectionName | Yes | Connection to inspect. Must be created and tested first. | |
| schema | No | Specific schema to query (e.g., 'dbo', 'public'). Omit for all schemas. | |
| tableOrView | No | Filter by type: 'TABLES', 'VIEWS', or 'ALL' | ALL |
| includeSchema | No | Include schema in names (e.g., 'dbo.Table') | |
| includeCatalog | No | Include catalog in names (e.g., 'MyDB.dbo.Table') | |
| topTable | No | Maximum tables to return (default: 5000) | |
| skipTable | No | Tables to skip for pagination | |
| workspaceId | No | Workspace ID to use for this operation. Overrides the default workspace. Use 'default' for the default workspace or a UUID for specific workspaces. |