Hello! My name is David. I’ve been using Snowflake on and off for about a year now. I would like to get to know it better, so I am blogging my experience. I am glad you are joining me!
Snowflake is great as a data warehouse for a variety of reasons. First, unlike Oracle and SQL Server, Snowflake is completely cloud-hosted. Gone are the days of climate-controlled server rooms. Snowflake takes care of all that.
Second, Snowflake is pay-as-you-go. You do not have to invest a lot of money into Snowflake in order to use it. You simply pay for the data storage, transfer, and compute costs. Credit costs vary due a number of factors, but it is inexpensive to get started. You can read more about Snowflake cost here.
Third, Snowflake has great data-sharing options. If you need to share data with a vendor or other stakeholder, you can do so easily and without a great deal of configuration
Fourth, Snowflake has great ETL tools for bringing in data from various sources.
Finally, Snowflake is powerful. You can host a bundle of data on their servers, and scale up quickly.
We will be exploring many of these features and more as we go. Thanks for joining me!