Where can you define the file format settings?

Where can you define the file format settings?
A . While creating named file formats
B. In the table definition
C. In the named stage definition
D. Directly in the COPY INTO TABLE statement when loading data

View Answer

Answer: A,B,C,D

Explanation:

Snowflake supports creating named file formats, which are database objects that encapsulate all of the required format information. Named file formats can then be used as input in all the same places where you can specify individual file format options, thereby helping to streamline the data loading process for similarly-formatted data.

Named file formats are optional, but are recommended when you plan to regularly load similarly-formatted data.

Creating a Named File Format

You can create a file format using either the web interface or SQL:

Web Interface

Click on Databases » <db_name> » File Formats

SQL

CREATE FILE FORMAT

For descriptions of all file format options and the default values, see CREATE FILE FORMAT. Overriding Default File Format Options

You can define the file format settings for your staged data (i.e. override the default settings) in any of the following locations:

In the table definition

Explicitly set the options using the FILE_FORMAT parameter. For more information, see CREATE TABLE.

In the named stage definition

Explicitly set the options using the FILE_FORMAT parameter. The stage is then referenced in the COPY INTO TABLE statement. For more information, see CREATE STAGE.

Directly in the COPY INTO TABLE statement when loading data

Explicitly set the options separately. For more information, see COPY INTO <table>.

If file format options are specified in multiple locations, the load operation applies the options in the

following order of precedence:

COPY INTO TABLE statement.

Stage definition.

Table definition.