google-bigquery - Query History on BigQuery Last 3 Months

Question

Is it possible to look up query from history for example last 3 month, because from I know BigQuery just showing last 1 month query

Thank you in advance !

标签： google-bigquery

Answer 1

If you want to use the BigQuery UI. You can go to the BigQuery Logs Viewer. The query builder let's you select the Time range, see screenshot. Then use something like the below to search for the query you want (either on a keyword inside the query or all queries).

protoPayload.methodName="jobservice.getqueryresults"
protoPayload.serviceData.jobGetQueryResultsResponse.job.jobConfiguration.query.query:"keyword_inside_the_query"
timestamp>="2019-12-04T10:32:34.065+1100"