Metabase log each query

nitikesh · January 27, 2016, 12:09pm

Hi,

Team is there a way we can log each query executed in the metabase? If yes, can you please let me know, how can we enable this?

Regards,

Nitikesh Bhavsar

agilliland · January 31, 2016, 6:33pm

What specific information about the query are you attempting to log? The application currently records the basic state of each query that gets executed and by whom, but we do not store any of the results of the query.

Note that this information is not surfaced anywhere in the application UI at the moment.

obaqueiro · June 21, 2016, 7:52pm

Hello,

Can you specify how can I get the info of who is making a query in the log? Currently I am only able to see the timestamp of the query and the query itself, but it seems Metabase is not logging the name or email of whoever performed the query:

04-12 23:02:19 ^[[1mDEBUG driver.query-processor^[[0m :: ^[[34m QUERY: 😎 {:database 2, :type "native", :native {:query " SELECT DATE(XYZ) as x,y,count(*)\n FROM x\n INNER JOIN y on barf = biff\n WHERE DATE(borf) > '2016-04-08' and burf = false and barf not in ('foo','baz', 'bar') group by barf, DATE(birf) order by borf;"}, :constraints {:max-results 10000, :max-results-bare-rows 2000}} ^[[0m

sameer · June 21, 2016, 8:03pm

This is actually in our 0.18 release which will be out this afternoon!

github.com/metabase/metabase

Feature Request: Prepend Query Metadata in SQL Comment

opened 08:37AM - 20 Apr 16 UTC

closed 09:46PM - 14 Jun 16 UTC

robinfrick

Querying/Processor

Hey, I'm back with a new feature request. Metabase is a very powerful tool, but… in the hands of the wrong people it can do more harm than good. We had the case this week that one of our colleagues put up a dashboard with fairly intensive queries in a loop where it would refresh every 30 seconds. That put a heavy load on the database as you can imagine. It was kind of difficult for us to find the culprit and what was going on because we could see the queries and that they were originating from the user designated for metabase, but it was difficult to find out what questions it were and who was executing them. Re:Dash has a nice solution to this they prepend a comment to every SQL Query stating among other things the question id and user like this: `/* Username: Scheduled, Task ID: 66c28896-d5a0-4230-be02-ea0da7c8e92d, Query ID: 15, Queue: scheduled_queries, Query Hash: 59ad1137f86748f72eec0bd0a9acb8c1 */` With this information I can quickly identify a query that is causing performance issues and also why/by whom it is being executed. It would be really nice to have the same on Metabase as well. Thanks for your awesome work :)

obaqueiro · June 22, 2016, 3:30am

Thanks, I just installed the 0.18 release. I can see :info {:executed-by 58, . That should work but I am not sure of how to relate the user id to the actual user.

How could I do this?

sameer · June 22, 2016, 4:38pm

I think you will need to look at the user table of the application database.

It’s expected that if you’re debugging SQL you’ll be pretty sophisticated. Do you have H2 or a MySQL/PostgreSQL box running?

What we do is point Metabase itself (usually a non-production instance or a developers personal Mac app) to the application database itself and lookup the user by id.

obaqueiro · June 22, 2016, 4:51pm

Hello,

Yeah, I have no problem looking at the database directly. I think I am using H2… I am using the default stuff that is generated by running java --server --jar metabase.jar And this generates the h2 files.

Thanks a lot

cloudops · April 15, 2020, 7:11am

I am running latest version of metabase, I am not able to see below prepend data
in any query(select * from query).Could anyone help me where this prepend data is stored for each query?

-- Metabase:: userID: 2 executionID: 170cbab5-090b-4be5-b286-1168f9439b5a queryType: MBQL queryHash: 1005045833

Is there a FLAG or some settings, We have to modify?
Thanks