Marketing provides a CSV with 1 million rows to update an existing BigQuery table. Using UPDATE hits a quotaExceeded error. What should you do to apply the updates?

The correct approach is to load the CSV into a staging table and use a MERGE statement. BigQuery's UPDATE DML statements are subject to quotas, particularly for large numbers of rows or frequent operations. Directly updating 1 million rows with UPDATE can easily exceed these limits. Option 1 (reducing daily updates) is impractical for a 1 million-row update. Option 2 (raising quotas) is generally not possible for DML statement limits, which are often fixed or have very high default values that are difficult to increase significantly. Option 3 (splitting the CSV) still involves numerous individual UPDATE statements, which would likely hit the same DML quota. Using MERGE is the recommended pattern for large-scale updates or upserts in BigQuery. It processes changes in a single, more efficient operation, avoiding the DML statement quota issues associated with many individual UPDATE commands.