Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
Option
| Description
|
---|---|
Target Table Name
| Specify the Google BigQuery target table name.
|
Dataset ID
| Specify the Google BigQuery dataset name.
|
Add Parameters
| Create an expression to add it as
Target Table Name and
Dataset ID parameters. For more information, see
Add Parameters.
|
Field Delimiter
| Indicates whether Google BigQuery V2 Connector must allow field separators for the fields in a .csv file.
|
Quote Character
| Specifies the quote character to skip when you write data to Google BigQuery. When you write data to Google BigQuery and the source table contains the specified quote character, the task fails. Change the quote character value to a value that does not exist in the source table.
|
Allow Quoted Newlines
| Indicates whether Google BigQuery V2 Connector must allow the quoted data sections with newline character in a .csv file.
|
Allow Jagged Rows
| Indicates whether Google BigQuery V2 Connector must accept the rows without trailing columns in a .csv file.
|
Skip Leading Rows
| Specifies the number of top rows in the source file that Google BigQuery V2 Connector skips when loading the data.
The default value is 0.
|
Data format of the File
| Specifies the data format of the source file. You can select one of the following data formats:
|
Write Disposition
| Specifies how Google BigQuery V2 Connector must write data in bulk mode if the target table already exists.
You can select one of the following values:
|