Question

A data engineer runs several COPY INTO commands each day to load pipe-delimited files that all share the same field delimiter, compression, and date format settings. To avoid repeating these settings in every COPY statement and to centrally manage them, what should the engineer create?

Accepted Answer

A named file format object that is referenced by each COPY INTO command

Answer

A separate external stage for each file with the parsing options embedded

Answer

A validation-mode COPY that stores the parsing rules for later reuse

Answer

A stream on the target table that inherits the parsing options automatically