| Delimited text |
Specify the following settings for a delimited text file:
- Leading rows to skip
- Specify the number of rows to use as an offset from the beginning of the file. This option is useful to skip header lines.
- Delimiter
- Specify the character used to separate a data field. Default value is semicolon (;).
- Quote character
- Specify the character used to enclose a data field. Default value is double-quotation mark (″).
- Remove quotes
- Select one of the following values to indicate whether quotation characters should be removed from a data field during the bulk load:
- Yes: Remove the quotation characters.
- No: Retain the quotation characters.
- Empty as null
- Select one of the following values to indicate whether empty data values should be set to null during the bulk load:
- Yes: sets empty data values to null.
- No: leaves data values as empty.
- Trim whitespace
- Select one of the following values to remove trailing and leading whitespace from the data during the bulk load:
- Yes: Remove the whitespace.
- No: Retain the whitespace.
Note: For delimited text files, you must have a table in your database with all the columns you need defined.
|
| Avro |
No additional settings. |
| JSON |
- Ignore UTF8 errors
- Select one of the following values to ignore UTF8 errors in the data during the bulk load:
- Yes: Ignore UTF8 errors.
- No: Do not ignore UTF8 errors.
- Allow duplicate elements
- Select one of the following values to allow duplicate elements in the data during the bulk load:
- Yes: Allow duplicate elements.
- No: Do not allow duplicate elements.
Note: Snowflake only uses the last duplicate value and discards the others.
- Strip null values
- NULL values are stored as null in JSON files. Select one of the following values to indicate whether to delete NULL values from the data during the bulk load:
- Yes: Strip the NULL values.
- No: Store the NULL values in a variant column.
- Parse octal numbers
- Select one of the following values to indicate whether to parse octal numbers during the bulk load:
- Yes: Parse octal numbers.
- No: Do not parse octal numbers.
|
| ORC |
Additional file settings for ORC files.
|
| Parquet |
Additional file settings for Parquet files.
|
| XML |
- Ignore UTF8 errors
- Select one of the following values to indicate whether to replace UTF-8 encoding errors during the bulk load:
- Yes: Replace invalid UTF-8 sequences with Unicode character U+FFFD.
- No: Invalid UTF-8 sequences produce an encoding error (default).
- Preserve space
- Select one of the following values to indicate whether to preserve leading and trailing spaces in element content during the bulk load:
- Yes: Preserve spaces.
- No: Do not preserve spaces (default).
- Strip outer element
- Select one of the following values to indicate whether to remove the outer XML element, and expose the second level elements as separate documents during the bulk load:
- Yes: Remove the outer XML element.
- No: Do not remove the outer XML element (default).
- Enable Snowflake data
- Select one of the following values to indicate whether to enable recognition of Snowflake semi-structured data tags from the data during the bulk load:
- Yes: Enable recognition of Snowflake tags (default).
- No: Disable recognition of Snowflake tags.
- Auto convert
- Select one of the following values to indicate whether to convert numeric and Boolean values from text to native representation during the bulk load:
- Yes: Convert numeric and Boolean values (default).
- No: Do not convert numeric and Boolean values.
|