Philipp Johannis on 17 Oct 2022 19:45:41
Other reporting tools like Redash or Metabase automatically annotate SQL queries when executed which is extremely helpful for auditing, monitoring and logging and increases visibility for a DBA.
Example from Redash
/* Username: xxx@xxx.com, query_id: adhoc, Queue: queries, Job ID: 8d95c387-5654-4f4e-8bc3-d8cf97012b6b, Query Hash: 69ed10acxxxx11fddf45c6059ec192e7, Scheduled: False */
Example from Metabase
-- Metabase:: userID: 46 queryType: native queryHash: 78c24ebf5c08aed9xxxx8fb0c689273839648a7dad227b937b238f6be588e4bb
Information that could be annotated
- Dataset Id
- Workspace
- RefreshType