This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

Query history in BigQuery

Posted 2 weeks ago
adkrk
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

Hello everyone,

Is it possible to see the query with which a table in BigQuery was created? I’ve tried checking the logs for a specific date range and managed to get results only for scheduled queries, but not for the one I’m looking for. The table was created in February, so it’s within the 90-day period.

1 2 131
Topic Labels
2 REPLIES 2

Posted on --/--/---- --:-- AM
mdideles
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

Try looking for this table in INFORMATION_SCHEMA.TABLES view.  There is a DDL column on this view.

0 Likes

Posted on --/--/---- --:-- AM
ibaui
Staff
Reply posted on --/--/---- --:-- AM

Hi @adkrk,

Welcome to Google Cloud Community!

In addition to @mdideles, you can refer to this documentation, which describes how to view the history of a session in BigQuery. Just make sure you have the necessary permissions to access the session history.

Was this helpful? If so, please accept this answer as “Solution”. If you need additional assistance, reply here within 2 business days and I’ll be happy to help.

0 Likes