A Data Engineer would like to define a file structure for loading and unloading data.
Where can the file structure be defined? (Choose three.)
A Data Engineer would like to define a file structure for loading and unloading data.
Where can the file structure be defined? (Choose three.)
A Data Engineer can define the file structure for loading and unloading data using the COPY command, FILE FORMAT object, and STAGE object. The COPY command allows for specifying the file structure during data load operations. FILE FORMAT objects define the format of the data files, such as CSV, JSON, or Avro, which can be referenced in other commands. STAGE objects are used to specify the location and format of files to be loaded into or unloaded from the data warehouse, thus encapsulating file structure details.
Copy into and File format but not sure which is the 3rd option
It should be FILE FORMAT object, PIPE object and STAGE object.
and stage object