sys.dm_pdw_exec_connections (Transact-SQL)

Applies to: Azure Synapse Analytics Analytics Platform System (PDW)

Returns information about the connections established to this instance of Azure Synapse Analytics and the details of each connection.

Note

This syntax is not supported by serverless SQL pool in Azure Synapse Analytics. For serverless SQL pool use sys.dm_exec_connections (Transact-SQL).

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 encrypted).
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 purposes, use the session_id instead.

Permissions

Requires VIEW SERVER STATE permission on the server.

Relationship Cardinalities

From	To	Relationship
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 Synapse Analytics and Analytics Platform System (PDW)

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

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