I’m trying to create performance and usage metrics of our Snowflake database. It would be very helpful if there was a way to determine which dashboard/report and which Holistics user was responsible for a specific query. One way to do this would be to insert some metadata in a SQL comment, which could then be parsed from the SQL logs. Something like:
SELECT * FROM (
...
) holistics_awesome_table LIMIT 1000000
-- Holistics metdata: {'report_title': 'Awesome report', 'report_url': 'https://....', 'username': '[email protected]', ... }