Unable to retrieve job history beyond 2 months in BigQuery Web UI

1
votes

I want to repeat a load job for a table I created 3 months ago, but I am only able to see 2 months of job history in BigQuery browser UI. I would like the table schema used in that specific load job.

Is there any way to view it?

1
google-bigquery

1 Answers

1
votes

Use the Jobs.list in the BigQuery API:

Lists all jobs that you started in the specified project. Job information is available for a six month period after creation

You could also use the cli tool:

bq ls --jobs --all

Or, you could use audit logs too.