thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Intermediate

File Format Object

A named Snowflake object that stores parsing options (type, delimiter, compression, header skipping, NULL handling) for loading and unloading files.

Definition

Supported types are CSV, JSON, Avro, ORC, Parquet and XML. A file format can be attached to a stage or referenced in COPY INTO.

Example

CREATE FILE FORMAT csv_ff TYPE = 'CSV' FIELD_DELIMITER = '|' SKIP_HEADER = 1 NULL_IF = ('', 'NULL');

Exam tip

Options set directly in COPY INTO override those of the stage or file format.

Related terms