File tab

Pentaho Data Integration

Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA003-15


File tab, Google BigQuery Loader

Field Description
Type Specify the file type. The values are CSV (default), JSON, and Avro. You must specify the correct File type that is associated with the Storage source URL field in the Setup tab.
Leading rows to skip Specify how many rows of the CSV file to skip.
Delimiter Specify the delimiter character used by the CSV file.
Quote character Specify the escape (quote) character used for values that have the delimiter character in them. For example, when the delimiter character is a comma, and a field contains a comma, and the quote character is a backslash, inserting a backslash before the comma in the field will prevent that field from being evaluated as the beginning of a new field value.