Performance tuning and best practices for Google BigQuery V2 Connector

Performance tuning and best practices for Google BigQuery V2 Connector

Write modes for Google BigQuery targets

Write modes for Google BigQuery targets

You can configure different modes to optimize the performance when you write data to a Google BigQuery target. If you want to write large volumes of data to a Google BigQuery target, specify the
Write mode
as
Bulk
in the advanced target properties.
The following graph illustrates the impact of Write modes on the writer performance:
The performance increases when you configure staging mode for reading large volumes of data.