The Google BigQuery - Fill Task loads data into Google BigQuery private dataset table.
The BigQuery Tasks require the Google Cloud Connection.
Input format
Can be CSV or JSON. When CSV is selected - CSV related settings can be updated:
Data has header row
Checking this one means that first line contains header row, and column named mapping can be used when running this task. Otherwise positional mapping would be applied.
Field separator
describes character that separates one field from another within one line;
Text qualifier
Text quotation setting (if set in input data). Character mentioned here will be removed from TEXT fields start and ending.
Line break
describes symbol(s) that are used for line breaking when parsing.
When input format is JSON
Valid JSON array of JSON objects is expected on input, column mapping will be done via JSON object property names.
Input type
File or String Data. When input type is file - file path needs to be specified.
Otherwise String value will be used as input. Both of these fields support Variables.