Accessing snowflake file system

182 Views Asked by At

I am new to snowflake and I have two questions regarding Snowflake on AWS.

  1. I registered for a free account of Snowflake and It gave me a link to access its web UI and thereafter I could create a stage in WebUI using my exist AWS S3 bucket , however after loading of data , I am not sure , where does snowflake stores the data. Can I access its file system? Can I change its file system to my existing AWS S3?
  2. While registration of Snowflake on AWS , I went to AWS Marketplace and Subscribed to snowflake account and it gave a snowflake webUI. Do I need to do anything else for deployment of Snowflake on AWS?
1

There are 1 best solutions below

7
Hans Henrik Eriksen On BEST ANSWER
  1. The data you imported from S3 into Snowflake now resides in a logical database table. The database stores its data in its own S3 bucket. The database storage format is proprietary, and a database abstract storage layer S3 bucket possibly contains data from multiple customers. The data is encrypted, and in the end Snowflake probably doesn't even know eg. which disk the data is on, they are S3 users like everyone else.
  2. You can do almost anything from the GUI. But the GUI doesn't provide a proper archive for code and object history etc. Snowflake has recently acquired a company with a development tool, so maybe something more than the GUI is in the coming.