sys.dm_pdw_nodes_exec_sql_text (Transact-SQL)

Applies to: Azure Synapse Analytics

Returns the text of the SQL batch that is identified by the specified sql_handle. This table-valued function replaces the system function fn_get_sql.

Note

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

Table returned

Column name	Data type	Description
pdw_node_id	int	Unique numeric ID associated with the node.
dbid	smallint	ID of database. For unplanned and prepared SQL statements, the ID of the database where the statements were compiled.
objectid	int	ID of object. Is NULL for improvised and prepared SQL statements.
number	smallint	For a numbered stored procedure, this column returns the number of the stored procedure. For more information, see sys.numbered_procedures (Transact-SQL). Is NULL for improvised and prepared SQL statements.
encrypted	bit	1: SQL text is encrypted. 0: SQL text is not encrypted.
text	nvarchar(max)	Text of the SQL query. Is NULL for encrypted objects.

Remarks

The same remarks in sys.dm_exec_sql_text apply.

Permissions

Require sysadmin server role or VIEW SERVER STATE permission on the server.

See also

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

Next steps

For more development tips, see Azure Synapse Analytics development overview.