SQLA for Microsoft Azure SQL Data Warehouse ?

Hello,

I've some databases in Fabric.
The version of this SQL is "Microsoft Azure SQL Data Warehouse (RTM) - 12.0.2000.8"

I tried to change some "DB Queries" in SQL Assistant.
I changed all
IF @@version like '%SQL Azure%'
to
IF @@version like '%Azure%'

But only the half works, I only have DB names, no schema list, no tables list when I type in SSMS.

Any tips to have a full auto-completion in this environment ?

Thanks

I'm guessing not all changes were correct or not queries updated. There is an option in every query in the Options dialog to test it. You can use "Test..." button in the top-right corner. That could check for syntax errors

Best option is to copy each of the queries into a sql editor and execute from there with specific values instead of parameter placeholders to see what is actually returned. Pretty sure you can tune the queries to work with Azure SQL Data Warehouse.

Hi SysOp

Thanks for the reply.
It's exactly what I did.
Each query returns something, but unfortunately, there is no suggestion for schemas/columns when I type my code.
Columns must be returned by queries "Objects" and "Objects + Types Synonyms" , is it correct ?