How to see the query in the query_execution?

Is there any way to see the query made by someone in the table query_execution?

Yes, you can see the queries there

No, I only can see the query_hash. How to get the real query?

Check in report_card which should have the queries


Understand. How about to get the query for the ad-hoc? Is there any table hold the data?

yes, the table query will have those

Sorry, I dont get it.

What I mean here is I have to create a native ad-hoc then the record appears in query_execution. But the table only shows the query hash column. Where can I get the real query?

Can you show an example? Thanks!