Properties
Select one of these options:
- Create: The default option. Creates a new file format. This will generate an error if a file format with the same name already exists, but will never destroy existing data.
- Create if not exists: This will only create a new format if one of the same name does not already exist.
- Drop: Drop the file format of the given name. This is useful for deleting file formats. This will fail if a file format of the given name does not exist.
- Drop if exists: Drop the file format of the given name. This is useful for deleting file formats. This will succeed even if a file format of the given name does not exist.
- Replace: Creates a new format and replaces any format of the same name, overwriting it.
The Snowflake database that the newly created file format will be stored in. The special value
[Environment Default] uses the schema defined in the environment. Read Database, Schema, and Share DDL to learn more.The Snowflake schema that the newly created file format will be stored in. The special value
[Environment Default] uses the schema defined in the environment. Read Database, Schema, and Share DDL to learn more.The type of file the format applies to. Available options are: AVRO, CSV, JSON, ORC, PARQUET, and XML.The properties below change depending on the option selected here.
- AVRO
- CSV
- JSON
- ORC
- PARQUET
- XML
Whether the input file is compressed in gzip format, BROTLI, BZ2, DEFLATE, RAW_DEFLATE, ZSTD, or not compressed at all.
Enter one or more strings that will be replaced with NULL if found in the source. Only applies to columns that are nullable.