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: