Required Information and Metadata for Data Unloading

Snowflake requires the same information for unloading data as loading data:

  • File staging location (internal or external)
  • File format
  • Copy options

Similar to loading data, you can specify this information directly in the COPY INTO location and GET commands. You can also use file format objects and stage objects to simplify the process of unloading data.

In addition, Snowflake maintains metadata for all data unloaded from tables. You can use the metadata to manage the files generated by unloading data, as well as the overall unloading process.

For more information, see: