sys.dm_pdw_exec_connections (Transact-SQL)

APPLIES TO: noSQL Server noAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

Returns information about the connections established to this instance of SQL Data Warehouse and the details of each connection.

Column name Data type Description
session_id int Identifies the session associated with this connection. Use SESSION_ID() to return the session_id of the current connection.
connect_time datetime Timestamp when connection was established. Is not nullable.
encrypt_option nvarchar(40) Indicates TRUE (connection is encrypted) or FALSE (connection is not enctypred).
auth_scheme nvarchar(40) Specifies SQL Server/Windows Authentication scheme used with this connection. Is not nullable.
client_id varchar(48) IP address of the client connecting to this server. Is nullable.
sql_spid int The server process ID of the connection. Use @@SPID to return the sql_spid of the current connection.For most purposed, use the session_id instead.

Permissions

Requires VIEW SERVER STATE permission on the server.

Relationship Cardinalities

dm_pdw_exec_sessions.session_id dm_pdw_exec_connections.session_id One-to-one
dm_pdw_exec_requests.connection_id dm_pdw_exec_connections.connection_id Many to one

Examples: Azure SQL Data Warehouse and Parallel Data Warehouse

Typical query to gather information about a queries own connection.

SELECT  
    c.session_id, c.encrypt_option,  
    c.auth_scheme, s.client_id, s.login_name,   
    s.status, s.query_count  
FROM sys.dm_pdw_exec_connections AS c  
JOIN sys.dm_pdw_exec_sessions AS s  
    ON c.session_id = s.session_id  
WHERE c.session_id = SESSION_ID();  

See Also

SQL Data Warehouse and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)