find_lookup_tables
Identify and extract lookup tables in MSSQL databases using table patterns and a specified schema, optimizing data analysis and reference management.
Instructions
Identify reference/lookup tables automatically based on table patterns
Input Schema
Name | Required | Description | Default |
---|---|---|---|
connectionName | No | Named connection to use (e.g., 'production', 'staging') | |
connectionString | No | SQL Server connection string (uses default if not provided) | |
maxRows | No | Maximum rows to consider as lookup table (default: 1000) | |
schema | No | Schema name (default: dbo) |