CODEWITHSUNDEEP
snowflake-cloud-data-platform
Brian
Brian

Reputation: 976

Where are snowflake tables stored?

I'm considering snowflake for a customer, but I can't tell fr the documentation where do they store the data? Seems to be s3 but why such expensive storage costs? Is the data in the user's s3 or snowflakes s3?

Upvotes: 0

Views: 3941

Answers (1)

Sriga
Sriga

Reputation: 1321

Snowflake is cloud based analytical data warehouse provided as Saas and it is not built on an existing database or “big data” software platform such as Hadoop and its available on below cloud environment

  1. AWS
  2. Azure
  3. GCP

Based on the choice of your cloud environment your storage and computation region will be decided. If you selected snowflake on AWS, your data will be stored in snowflake managed S3 bucket(By default snowflake compress your data before it stores in your final target table), Its depends upon you and your business choice on which cloud your data should be stored.

Upvotes: 6

Related Questions