View query logs

Is there a way to view a given query’s execution log? For example, if I have a query that runs every day, is there a way to see a log of its execution everyday and also if it failed? For example, say I have query A that runs every day. Would love to see:

Monday = Query A ran successfully and returned these results
Tuesday = Query A failed to run because of a timeout
Thursday = Query A ran successfully and returned these results

That way I know there was an issue on Tuesday, and probably another issue on Wednesday since there was no log recorded.

There isn’t a clean way to get this info.

You can see adhoc executions in the metadatadb on the events table. But scheduled executions don’t appear there.

You could monitor the logs from the or even the redis queue directly. But this would take a bit of work :frowning: