I’ve not been blogging much over the past few months and weeks as I’ve been working on a new technology called Snowflake. As the title says “Snowflake – The Data Warehouse Built for the Cloud” is a data warehouse that sits on Amazon S3.
All you need to access your data warehouse is a live connection to the internet. “Snowflake eliminates the administration and management demands of traditional data warehouses and big data platforms. ” I’ve had instances where I’ve had to manually
update the software on databases, causing a lot of stress, to make sure all goes through smoothly, as well as scheduling the maintenance at times that does not impact our users.
Traditional data warehouses in the past have had huge upfront costs, meaning that you were paying for storage that you might not even actually fill in the future. With Snowflake, you “pay only for what you use” for both storage and computational power.
A very interesting feature Snowflake has, is the ability to share read only access to databases without having to export the data set. This feature works between Snowflake accounts only.
Snowflake has a lot to offer but these are only some of the key aspects I’ve come across so far and will be updating this blog as I learn more!
For further information: Snowflake