STORAGE.EXTERNAL_TABLE_FILE_FORMAT

Target database: Snowflake

STORAGE.EXTERNAL_TABLE_FILE_FORMAT option specifies the file format being used.

One can either refer to an existing named file format that describes the staged data files to scan with FORMAT_NAME or one can define the TYPE directly.

See also:

Usage

CODE

STORAGE.EXTERNAL_TABLE_FILE_FORMAT: String

Default: Empty

Mandatory: Yes

Content either:

FORMAT_NAME = file_format_name

Specifies an existing named file format that describes the staged data files to scan. The named file format determines the format type (such as, CSV, JSON), and any other format options, for data files.

TYPE = CSV | JSON | AVRO | ORC | PARQUET [ ... ]

Specifies the format type of the staged data files to scan when querying the external table.

If a file format type is specified, additional format-specific options can be specified. For more information, see Format Type Options.

Notes

Supports only Snowflake External table

Examples

Snowflake: Set the STORAGE.EXTERNAL_TABLE_FILE_FORMAT

Setting STORAGE.EXTERNAL_TABLE_FILE_FORMAT for an External table (e.g. publish.F_TRIP):

CODE

STORAGE.EXTERNAL_TABLE_FILE_FORMAT: TYPE = PARQUET

DDL generated by Agile Data Engine:

CODE

CREATE EXTERNAL TABLE publish.F_TRIP (
  ...
)
..
FILE_FORMAT = (TYPE = PARQUET);
...;