[BUG]: Profiler Support for Legacy DWH for Synapse Profiler

[sundarshankar89]

Is there an existing issue for this?

• I have searched the existing issues

Category of Bug / Issue

Profiler bug

Current Behavior

Currently, We generate the list of sqlpools to the profiler by listing them using the workspace api

dedicated_sqlpools = workspace.list_sql_pools()
all_dedicated_pools_list = [pool for poolPages in dedicated_sqlpools for pool in poolPages]

• Azure SQL Data Warehouse (Gen1/Gen2) was a standalone service
• Azure Synapse Analytics was introduced later as a unified workspace
• Legacy SQL DW instances were not automatically migrated to Synapse Workspaces
• Customers can still run legacy SQL DW without a workspace
• These legacy instances don't expose workspace-level APIs

Expected Behavior

No response

Steps To Reproduce

No response

Relevant log output or Exception details

Logs Confirmation

• I ran the command line with --debug
• I have attached the lsp-server.log under USER_HOME/.databricks/labs/remorph-transpilers/<converter_name>/lib/lsp-server.log

Sample Query

Operating System

macOS

Version

latest via Databricks CLI