sys.dm_pdw_errors (Transact-SQL)

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

Holds information about all errors encountered during execution of a request or query.


This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.

Column Name Data Type Description Range
error_id nvarchar(36) Key for this view.

Unique numeric id associated with the error.
Unique across all query errors in the system.
source nvarchar(64) Information not available. Information not available.
type nvarchar(4000) Type of error that occurred. Information not available.
create_time datetime Time at which the error occurred. Smaller or equal to current time.
pwd_node_id int Identifier of the specific node involved, if any. For additional information on node ids, see sys.dm_pdw_nodes (Transact-SQL).
session_id nvarchar(32) Identifier of the session involved, if any. For additional information on session ids, see sys.dm_pdw_exec_sessions (Transact-SQL).
request_id nvarchar(32) Identifier of the request involved, if any. For additional information on request ids, see sys.dm_pdw_exec_requests (Transact-SQL).
spid int spid of the SQL Server session involved, if any.
thread_id int Information not available.
details nvarchar(4000) Holds the full error text description.

For information about the maximum rows retained by this view, see the Metadata section in the Capacity limits topic.

See Also

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