SQL Source Fields Analyzer

Features

• Supports SparkSQL, MySQL, T-SQL, and more
• Analyzes source fields usage per table
• Instantly delivers analysis report (text/Excel)

Usage

1. Open a SQL-like script you want to analyze

2. Activate the analysis via keyboard shortcut Ctrl+Alt+q. Alternatively, open Command Palette (Ctrl+Shift+P), type "Analyze SQL Source Fields+", and press Enter

3. 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

Requirements

• To get ideal results, the script should be free of syntax errors, i.e., executable in your data environment

Changing the Shortcut

If the shortcut conflicts with another command:

1. Go to File > Preferences > Keyboard Shortcuts.
2. Search for Analyze SQL Source Fields+.
3. Click the pencil icon to set a new keybinding.