[Sqlalchemy-tickets] Issue #3994: Azure SQL Datawarehouse error (zzzeek/sqlalchemy)

[James B. <iss...@bi...>]

New issue 3994: Azure SQL Datawarehouse error
https://bitbucket.org/zzzeek/sqlalchemy/issues/3994/azure-sql-datawarehouse-error

James Bashforth:

I am receiving the following error when connecting to Azure SQL DW.  On further investigation it seems the the management view below has a slightly different name in Azure SQL DW. "sys.dm_pdw_exec_sessions" not sure if this is the cause of the issue, but if I run the following query on the SQL DW it returns results

SELECT login_name ,COUNT(session_id) AS session_count   
FROM sys.dm_pdw_exec_sessions   
GROUP BY login_name;  

Error Message
sqlalchemy.exc.ProgrammingError: (pyodbc.ProgrammingError) ('42000', "[42000] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Catalog view 'dm_exec_sessions' is not supported in this version. (104385) (SQLExecDirectW)")