hi i would like to log and make a view page to log all running queries by userid ,time and sql text .from my understanding with every sql execute[POST] i have to pass the data to a html page and store in the database of postgres ,i need to know which method is actually doing the execute task and passing the query text .
Do you need a view of currently executing queries or past executing queries? Do you need adhoc queries (triggered by a human) or scheduled as well?
Hi Arik,
ill be much happier to log just committed executing [past] quires for now .
Then check the events
table. One of the logged events is for every executed query.
@arikfr - how to locate the event table, kindly guide i am new to redash… my requirement is to capture / log all the queries executed on redash for security purpose. since anyone (who have access on redash can execute any query - we can not control right? at present).
Does events table have info about the scheduled queries. didn’t found any action name for the scheduled queries.
It does not. This could be an easy addition, however.