Asking here as a last resort, we've been having many issues trying to connect to Azure SQL DW from a non-Windows environment (Linux, Mac) where SQL Server Managment Studio (SSMS) is not an option.
The core requirement is a GUI for analysis (DataGrip, SQLWorkbench/J, DBeaver, etc..)
Using SQLWorkbench/J, JDK 8 and sqljdbc42.jar with the following connection string taken from Azure Portal:
jdbc:sqlserver://<server_name>.database.windows.net:1433;database=<db_name>;user=<user_name>@<server_name>;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;
In SQLWorkbench/J we're getting the following error:
Parse Error at line 5, column 28: Incorrect syntax near '(' [SQL State: S0001, DB Errorcode: 13010]
DataGrip just hangs when trying to load a schema/tables.
So currently we have no way of connecting via a non-Windows environment to SQL DW, has anyone encountered this and has a workaround?
Tried to comment, but we use DBeaver with great success to work with Azure SQL Data Warehouse.