JSONFileFormat
A JSON file format in Snowflake.
Examples
Python
file_format = JSONFileFormat(
name="some_json_file_format",
owner="SYSADMIN",
compression="AUTO",
date_format="AUTO",
time_format="AUTO",
timestamp_format="AUTO",
binary_format=BinaryFormat.HEX,
trim_space=False,
null_if=["NULL"],
file_extension="json",
enable_octal=False,
allow_duplicate=False,
strip_outer_array=False,
strip_null_values=False,
replace_invalid_characters=False,
ignore_utf8_errors=False,
skip_byte_order_mark=True,
comment="This is a JSON file format."
)
YAML
file_formats:
- name: some_json_file_format
owner: SYSADMIN
compression: AUTO
date_format: AUTO
time_format: AUTO
timestamp_format: AUTO
binary_format: HEX
trim_space: false
null_if:
- NULL
file_extension: json
enable_octal: false
allow_duplicate: false
strip_outer_array: false
strip_null_values: false
replace_invalid_characters: false
ignore_utf8_errors: false
skip_byte_order_mark: true
comment: This is a JSON file format.
Fields
name
(string, required) - The name of the file format.owner
(string or Role) - The owner role of the file format. Defaults to "SYSADMIN".compression
(string) - The compression type for the file format. Defaults to "AUTO".date_format
(string) - The format used for date values. Defaults to "AUTO".time_format
(string) - The format used for time values. Defaults to "AUTO".timestamp_format
(string) - The format used for timestamp values. Defaults to "AUTO".binary_format
(BinaryFormat) - The format used for binary data. Defaults to HEX.trim_space
(bool) - Whether to trim spaces. Defaults to False.null_if
(list) - A list of strings to be interpreted as NULL.file_extension
(string) - The file extension used for files of this format.enable_octal
(bool) - Whether to enable octal values. Defaults to False.allow_duplicate
(bool) - Whether to allow duplicate keys. Defaults to False.strip_outer_array
(bool) - Whether to strip the outer array. Defaults to False.strip_null_values
(bool) - Whether to strip null values. Defaults to False.replace_invalid_characters
(bool) - Whether to replace invalid characters. Defaults to False.ignore_utf8_errors
(bool) - Whether to ignore UTF-8 errors. Defaults to False.skip_byte_order_mark
(bool) - Whether to skip the byte order mark. Defaults to True.comment
(string) - A comment for the file format.
Last updated