Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
What is the best approach to resolve a quotaExceeded error when attempting to update a CSV file containing 1 million records in BigQuery?
A
Limit the number of records updated each day to avoid hitting the BigQuery UPDATE DML statement limit.
B
Import the new records from the CSV file into a new BigQuery table. Merge the new records with the existing records using a BigQuery job and write the results to a new BigQuery table.
C
Increase the BigQuery UPDATE DML statement limit in the Quota management section of the Google Cloud Platform Console.
D
Split the source CSV file into smaller CSV files in Cloud Storage to reduce the number of BigQuery UPDATE DML statements per BigQuery job.
