CODEWITHSUNDEEP
snowflake-cloud-data-platform
Charlie Truong
Charlie Truong

Reputation: 143

Is it possible to use Snowflake user and named stages for long term data file storage?

Instead of creating our own S3 bucket, I'm wondering if I can just leverage user and named stages as ways to store data files (that may not be loaded into tables). Or are files in these stages automatically purged by Snowflake at times?

Upvotes: 0

Views: 204

Answers (1)

Anshul Thakur
Anshul Thakur

Reputation: 524

Internal Stages are not managed by Users, so anything you upload into Internal Stages if you want to query has to be copied into the tables eventually.

If you are using PUT command, you can list the files and then use copy into tables command. https://docs.snowflake.com/en/sql-reference/sql/put.html

Using PUT operation into Internal Stages will incur Storage Charges as applicable.

Upvotes: 1

Related Questions