FORMAT_NAME and TYPE are mutually exclusive in the COPY command.

FORMAT_NAME and TYPE are mutually exclusive in the COPY command.
A . TRUE
B. FALSE

View Answer

Answer: A

Explanation

FILE_FORMAT = ( FORMAT_NAME = ‘file_format_name’ ) or FILE_FORMAT = ( TYPE = CSV | JSON | AVRO | ORC | PARQUET | XML [ … ] )

Specifies the format of the data files to load:

FORMAT_NAME = ‘file_format_name’

Specifies an existing named file format to use for loading data into the table. The named file format determines the format type (CSV, JSON, etc.), as well as any other format options, for the data files. For more information, see CREATE FILE FORMAT.

TYPE = CSV | JSON | AVRO | ORC | PARQUET | XML [ … ]

Specifies the type of files to load into the table. If a format type is specified, then additional format-specific options can be specified. For more details, see Format Type Options (in this topic). Note

FORMAT_NAME and TYPE are mutually exclusive; specifying both in the same COPY command might result in unexpected behavior.