CODEWITHSUNDEEP
azure-synapse
Steve
Steve

Reputation: 558

Session/Query Context Info in logs for Azure SQL Data Warehouse

Does Azure SQL Data Warehouse provide a feature to allow the context of the query to be logged? I have read that the JDBC API Specification refers to this kind of database feature as "Client Info". Oracle provides a built-in procedure dbms_application_info.set_client_info to set Client Info, and Oracle stores the Client Info in a column in Oracle's v$session table. Teradata calls their feature QueryBand and stores the information in their query log (DBQL).

My basic use case is for the dynamic SQL being generated by an application to include the context related to who (i.e., user, department) is responsible for the resulting query.

Upvotes: 0

Views: 152

Answers (1)

Alexandre Gattiker
Alexandre Gattiker

Reputation: 749

You can achieve that with query labels.

Upvotes: 2

Related Questions