This means that users can miss out on the benefits of a more tightly integrated cloud ecosystem.

Each of these public clouds offers their own cloud data warehouse solution: Amazon Redshift, Google BigQuery, and Microsoft Azure SQL Data Warehouse, respectively. Lack of synergy: While Snowflake can run in the Amazon, Google, and Microsoft public clouds, it isn’t a native offering.

Snowflake is compliant with data security standards such as HIPAA, PCI DSS, and SOC 1 and SOC 2.

Strong data security: Snowflake comes with a wide variety of industry-leading data security features, including IP allow and block lists, multi-factor authentication, and automatic 256-bit AES encryption.

Automatic performance tuning: Snowflake includes built-in automatic query performance optimization via a query optimization engine, without the need for users to manually tweak the settings.

What’s more, users can quickly and easily resize the number of nodes in each cluster for optimal performance.

Extreme scalability: users can create a practically unlimited number of virtual warehouses, each one running its own workload against the data in its database.

For example, healthcare providers can use Snowflake’s data sharing feature to easily create a pointer to a patient database, rather than risk violating HIPAA through awkward, cumbersome manual processes. This means that companies using a lot of storage but little CPU, or vice versa, can save a good deal of money using Snowflake.Īnother highly valuable feature is the ability to share data externally with vendors, partners, and customers-even if these third parties aren’t Snowflake users themselves. Perhaps the most prominent feature is how the platform decouples its compute and storage capabilities, unlike many other data warehouses in the public cloud.

According to an estimate by Datanyze, Snowflake currently occupies 11 percent of the data warehousing market, second only behind SAP Business Warehouse. Snowflake is compatible with the three largest public cloud providers: Amazon Web Services, Google Cloud Platform, and Microsoft Azure. A data warehouse is a centralized data repository that acts as the endpoint for the ETL process, where information can be easily accessed and mined for insights. Did you know you can generate a full-featured, documented, and secure REST API in minutes using DreamFactory? Sign up for our free 14 day hosted trial to learn how! Our guided tour will show you how to create an API using an example MySQL database provided to you as part of the trial!Ĭreate Your RESTful API Now What is Snowflake?įounded in 2012 and based in San Mateo, California, Snowflake is a technology company offering a cloud-based data warehouse for data storage and analytics.

Storyweaver vs snowflake pro