Activate the analysis via keyboard Ctrl+Alt+Q. Alternatively, open Command Palette (Ctrl+Shift+P), type "Analyze SQL Source Fields+", and press Enter
Choose analysis mode:
Schema-Less : Enter a single source table name
Schema-Based :
Provide an Excel file with table schemas (Table names as Worksheet names, Table fields listed in Column A of each sheet)
Analysis accuracy may be affected if schema is incomplete or inaccurate
If the Excel file is saved in a OneDrive or auto-sync path, you may need to close the file before activating the extension. Otherwise, save the schema file in a non-sync path so you can keep it open in Excel while using the extension
In case table name length exceeds the allowed sheet name length, use the reserved _table_mapping sheet to specify the table name and its corresponding sheet. When the corresponding sheet is missing, the table will be analyzed without schema
Requirements
To get ideal results, the script should be free of syntax errors, i.e., executable in your data environment
