'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?
Solution 1:[1]
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.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Dharman |