CODEWITHSUNDEEP
google-cloud-platformgoogle-bigquery
Adithya
Adithya

Reputation: 3

BigQuery dataset maintenance

It looks like over the period we have different versions of Tables/Views in the BigQuery data set. It's confusing at time to pick which one to use.

What is the best way to cleanup unnecessary/unused tables apart.

Upvotes: 0

Views: 129

Answers (1)

Elad Amit
Elad Amit

Reputation: 605

You can add an export sink from the bq access logs and then identify the unused tables based on that https://cloud.google.com/bigquery/docs/reference/auditlogs/

Upvotes: 1

Related Questions