Snowflake Destination

Developed in 2012, Snowflake is a fully managed SaaS (software as a service) that provides a single platform for data warehousing, data lakes, data engineering, data science, data application development, and secure sharing and consumption of real-time / shared data. Snowflake features out-of-the-box features like separation of storage and compute, on-the-fly scalable compute, data sharing, data cloning, and third-party tools support in order to handle the demanding needs of growing enterprises.

Read The Docs

The different types of destinations

There is no one size fits all solution when it comes to databases, datalakes and data warehouses. Each one had different benefits and drawbacks which you can read more about here

Analytical vs Transactional

Analytical Data Stores (OLAPs)

The analytical data stores include normally all of the data warehouse vendors such as Snowflake, Redshift, Bigquery and many others. Analytical data stores are normally columnar data bases which are optimized for storing vast amounts of data at a decent price while at the same time allowing you to issue complex queries to understand your business data.
Using one of this solutions for operational queries where a lot of updating happens would be costly and inefficient.

Transactional Data Stores

Transactional Data Stores are more commonly used for operational workloads such as managing all the data from a web application. Common web solutions such as Wordpress rely on these type of data stores. Some examples are MongoDB, Postgresql, MySQL and many others.
These type of data bases can handle a huge volume of updates as users interact with the product.