Snowflake Solutions Expertise and
Community Trusted By

Enter Your Email Address Here To Join Our Snowflake Solutions Community For Free

Snowflake Solutions Community

How do you unload data from a stage in Snowflake?

532 viewsData Loading and Unloading
0

How do you unload data from a stage in Snowflake?

Daniel Steinhold Answered question August 19, 2023
0

There are two ways to unload data from a stage in Snowflake: using the COPY INTO statement or using the Snowsight user interface.

To unload data from a stage using the COPY INTO statement, you need to specify the following:

- The name of the stage
- The location where you want to unload the data
- The file format of the data in the output file

The following is an example of a COPY INTO statement for unloading data from an internal stage to a local file system:

`COPY INTO file:///path/to/output.csv @my_stage;`

The following is an example of a COPY INTO statement for unloading data from an external stage to an Amazon S3 bucket:

`COPY INTO s3://my-bucket/my-output-folder @my_external_stage;`

To unload data from a stage using Snowsight, you need to follow these steps:

1. Go to the Snowsight user interface.
2. Click on the **Data** tab.
3. Click on the **Stages** tab.
4. Click on the name of the stage that you want to unload data from.
5. Click on the **Unload Data** button.
6. Select the location where you want to unload the data.
7. Click on the **Unload** button.

Once you have unloaded the data from the stage, you can access it from the location that you specified.

Here are some additional things to keep in mind when unloading data from a stage:

- The location where you are unloading the data must be accessible by Snowflake.
- If you are unloading data to an external location, you must have the appropriate permissions to access the external location.

Daniel Steinhold Answered question August 19, 2023

Maximize Your Data Potential With ITS

Feedback on Q&A