Performance tuning and best practices for Google BigQuery V2 Connector

Performance tuning and best practices for Google BigQuery V2 Connector

Data format of the staging file

Data format of the staging file

You can optimize the performance of a Google BigQuery mapping by specifying the data format of local staging file in the Google BigQuery target transformation.
The following graph illustrates the impact that different data formats for the staging files has on the writer performance:
The image shows the impact of staging file formats on writer performance.