Answer-first summary for fast verification
Answer: 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.
Option B is the correct approach. By importing the new records into a separate BigQuery table and then merging them with the existing records through a BigQuery job, you can circumvent the quotaExceeded error. This method not only avoids the quota limitation but also provides greater flexibility and control over the update process, making it an ideal solution for frequent updates.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
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.
No comments yet.