Snowflake

Snowflake

Top Rated
About TrustRadius Scoring
Score 8.9 out of 100
Top Rated
Snowflake

Overview

Recent Reviews

What makes Snowflake amazing

8 out of 10
November 09, 2021
Snowflake is currently used as the main data warehouse for the company, by creating a replica of the databases in production and storing …
Continue reading

Reviewer Sentiment

N/A
Positive ()
N/A
Negative ()
Learn how we calculate reviewer sentiment

Awards

TrustRadius Award Top Rated 2022
TrustRadius Award Top Rated 2020
TrustRadius Award Top Rated 2019

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Snowflake, and make your voice heard!

Pricing

View all pricing

US East

$20.00

Cloud
Per TB

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Features Scorecard

No scorecards have been submitted for this product yet..

Product Details

What is Snowflake?

The Snowflake Cloud Data Platform is the eponymous data warehouse with, from the company in San Mateo, a cloud and SQL based DW that aims to allow users to unify, integrate, analyze, and share previously siloed data in secure, governed, and compliant ways. With it, users can securely access the Data Cloud to share live data with customers and business partners, and connect with other organizations doing business as data consumers, data providers, and data service providers.

Snowflake Data Marketplace gives data scientists, business intelligence and analytics professionals, and everyone who desires data-driven decision-making access to live and ready-to-query data from your ecosystem of business partners and customers, and from potentially thousands of data providers and data service providers.

Snowflake Technical Details

Deployment TypesSaaS
Operating SystemsUnspecified
Mobile ApplicationNo

Comparisons

View all alternatives

Frequently Asked Questions

What is Snowflake?

The Snowflake Cloud Data Platform is the eponymous data warehouse with, from the company in San Mateo, a cloud and SQL based DW that aims to allow users to unify, integrate, analyze, and share previously siloed data in secure, governed, and compliant ways. With it, users can securely access the Data Cloud to share live data with customers and business partners, and connect with other organizations doing business as data consumers, data providers, and data service providers.

What is Snowflake's best feature?

Reviewers rate Usability highest, with a score of 8.5.

Who uses Snowflake?

The most common users of Snowflake are from Mid-sized Companies (51-1,000 employees) and the Information Technology & Services industry.

Reviews

(1-25 of 32)
Companies can't remove reviews or game the system. Here's why
Score 7 out of 10
Vetted Review
Verified User
Review Source
Snowflake is being used as a data warehouse solution based on the cloud. We're creating a data lake with Snowflake and other tools like Databricks. Currently, different business teams are using different solutions for reporting and analytics. We are currently developing a centralized solution for the entire launch systems on our product portfolio.
  • Query results can be fetched very fast.
  • Easy to use and handle.
  • Data stored in cloud env.
  • Data structure is limited.
  • Bulk data processing is difficult.
  • Data connection can be improved.
Snowflake is mainly used as Datamart for the front-end UI team, they connect to Snowflake and built the templates and also Customers can use and pay for storage and computation separately because Snowflake allows storage and computation to scale independently. Once developed, this cloud-based solution requires little maintenance. Snowflake makes complex calculations and computations very fast.
Shiv Shrotriya | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Snowflake is being used as a could based data warehousing solution. We are building a data lake using Snowflake and other tools such as HVR and Dell Boomi. Currently, we are having different solutions used by different business teams for reporting and analytics purposes. Now we are building a centralized solution for the entire organization.
  • Cloud-based Data warehousing
  • Very fast data processing and Analytics
  • easy to learn and work
  • limitation with unstructured data
  • while importing data from other sources only bulk load
Snowflake is a cloud-based warehousing solution that is very quick and easy to maintain. Snowflake stores data in blocks by compressing the data. This allows query processing to be much faster compared to fetching rows. Also, you can change the resource consumption as per need. It has limitations while working with unstructured data.
Snowflake allows storage and computing to scale independently, so customers can use and pay for storage and computation separately. This cloud-based solution requires minimum support once the development is completed. Complex calculation and computation are very fast using Snowflake.
Score 9 out of 10
Vetted Review
Verified User
Review Source
We use Snowflake to query data from AWS S3. SQL query is easy to use for all level of data analysts/data scientists and as a result, Python or R is not required to pull data from Snowflake. Snowflake is widely used in my organization from customer acquisition to customer management.
  • Query.
  • Easy to use.
  • Low requirements.
  • Data type.
  • Speed.
  • Integration.
Snowflake works really well when you have all different levels of data analysts in one team. Snowflake can be the common tool to pull data and create tables since SQL is such a basic and easy-to-use data science language without the requirement of fully understanding the data type.
All the questions you have with Snowflake on the coding level is just SQL for which you can get the support from any SQL tutorial website such as W3 schools; on the access level it's based on your organization's authorization and you cannot really require Snowflake to figure that out.
Score 10 out of 10
Vetted Review
Verified User
Review Source
My company switched from Amazon Redshift to Snowflake a while ago, and we got a huge improvement in data to pull by using Snowflake. The tool is widely used in multiple departments within the company and people with all level of data science skill and retrieve the data easily by using SQL.
  • data pull
  • access management
  • data transfer
  • speed
  • data type
  • better integration
Snowflake is suitable for the situations that you are working with all levels of analysts in terms of data science skills. By using SQL, the user does not need to understand data type, etc. before using the tool. However, it could be potential trouble when consuming the data in python later.
Overall, the support from Snowflake has been very good. Since we are one of the major users for Snowflake and have a dedicated tech team to solve all the technical problem on our way. On the side of the technical problem, any sql related questions can be found from everywhere online.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Snowflake is currently used as the main data warehouse for the company, by creating a replica of the databases in production and storing them all in one single data warehouse, it gives access to the whole company to data in almost real time, the lag is about 5 to 30 minutes depending on the size of the DB. with this solution all teams have access to data in a single place in order to perform their respective tasks
  • Provide a front to make queries of different DBs in a single place
  • Cross tables from different schemas
  • Run complex queries faster than other providers
  • Graphic outputs
  • Dashboard creation
it is really useful when it comes to running highly elaborated queries that will die in other environments. it also is great for crossing tables of different schemas that are not necessarily related. It doesn't perform well when it comes to dashboard creation/sharing or graphic solutions like drawing pies or bars out of a query
Haven't had the need to use it actually, thus the qualification I gave
Score 9 out of 10
Vetted Review
Verified User
Review Source
Snowflake is used as a scale-out data lake and data warehouse at Spireon. The separation of compute from storage enables the company to provide timely and scalable insights. The confluence of streaming and batch processing at a pay-as-you-go pricing model aids in being intelligent and efficient on budget planning and use.
  • Massive parallel processing
  • SQL for schema-on-read data lakes
  • Secure and compressed storage for semi-structured data
  • Support site
  • Transparency on performance
  • Full text search
Cloud based analytical data store type workloads where data is volumous and query access patterns are well-known is Snowflake's sweet spot. The MPP engine is second to none and being able to scale up or down on demand enables queries that weren't previously possible. Where Snowflake isn't particularly suited is for on-premise or smaller data workloads or transactional processing workloads.
Score 10 out of 10
Vetted Review
Verified User
Review Source
Snowflake is used as the central data warehouse for data coming from all divisions of the College. Once in Snowflake, we use a variety of business intelligence tools to pull the data and do reporting and analysis. It also allows us to spend as we grow our data needs, rather than spending a huge up-front investment.
  • Efficient handling of large data sets in a scalable way
  • Ability to connect from a variety of tools (Tableau, Metabase, JDBC, many more)
  • Querying and output of data in JSON format
  • Built-in query and export tools
  • Security roles and access are hard to understand and manage
  • Rollout of new features seems to heavily favor US West coast, everyone else has to wait
  • Visual interface does not allow you to manage custom functions and routines. For those, it is code only. Management of tables and views is visual.
Snowflake is very well suited if your organization wants to start small with minimal investment, and then grow at any pace. It is also good for teams that already know SQL from working on another platform, such as MS SQL Server. It pairs really well with integration tasks because of its native ability to handle JSON data, for both import and querying.

If your tools can only connect by JDBC (no native Snowflake connector) you may have some issues with large data sets. This is really a limitation of using JDBC, not Snowflake, but it is something to be aware of.
Score 9 out of 10
Vetted Review
Verified User
Review Source
Snowflake is the database used by my company to store data across the organization. It helps us keep the data in one place, organized, and ready to use. The main application for this data is to analyze and report back to the stakeholders on how the business is running. Snowflake also helps us to create tables and schemas in the existing database for sandbox analytics.
  • User friendly.
  • Easy to use even for beginners.
  • Specifically, I like the drag and drop of tables into the query which makes it easier to write complex queries.
  • I am not able to recover the query sheets which got deleted by mistake.
  • Higher prices.
  • Easier integration option with BI tools.
For an organization that has small, medium, or large data collection, Snowflake provides the best infrastructure to store, manage, utilize and analyze the data. Especially for companies that are growing at a really fast pace, it helps you not only with warehouse capabilities but also its connection with several BI tools give you the flexibility and option to connect and analyze the data [in] real time.
Darren Mihalic | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source
Snowflake has enabled me to connect with data service providers. Through this software, I am capable of making data-driven decisions and providing my customers modern and integrated data applications. It is a cost-effective tool and we are its satisfied customers. This software has occupied every nook and corner of my IT department and we are at ease to handle the online data and supply it to our customers.
  • This is a cloud-based application that provides me a secure platform for the easy sharing of data with my clients.
  • I feel confident to connect with my numerous business partners just because of its advanced security and effective programming.
  • Through this tool, I am capable of integrating, analyzing, and the entire data in a precise form and with analytics as well, due to which I always have a transparent idea about the data extraction and its transfer from multiple clouds.
  • This tool is very much technical and proper knowledge is required, so mostly you have to hire an IT team.
  • I wish if various videos could be available for basic quires like its initiation, then I think it would act as a guideline and would help the beginners a lot.
It is highly recommended to those companies that need a track and secure mode for the transfer of the data. Its sharing is amazing for the business community. It will be suitable for the B2B type business setups. This tool is very cost-effective and will align your daily technical queries for better handling.
Score 9 out of 10
Vetted Review
Verified User
Review Source
Snowflake was our data warehousing solution of choice, which we migrated from Treasure Data. It is used across the whole organization. It is used as a source of data for the entire organization, powering our dashboards and machine learning solutions.
  • Computation is handled under the hood, freeing resources that would be used for maintainence of clusters
  • Handling large data scale and ingestion
  • Ability to query large volumes of data with speed due to their unique architecture
  • Snowflake UI can be clunky and breaks sometimes, which can be annoying
  • Snowflake has to be paired with the Data Build Tool (DBT) to allow for templating and macro usage. No inbuilt solution.
  • Snowflake Python connector development doesn't necessarily track popular packages such as Pandas as quickly as Pandas releases
  • Could do with better machine learning capability over warehouse tables, but I assume this is coming soon
Snowflake is a powerful warehousing solution and suits companies with large scale of data. It helps with fast querying of data, and there is little need to manage computation, since it is managed for you.

However, it does require a dedicated team and an upfront cost in setting up an structuring the warehouse. Some solutions such as AWS's Redshift or GCP's Bigquery could be a better alternatives if is already within the AWS or GCP ecosystem. Bigquery in particular has a low upfront cost and a better pricing model.
Score 10 out of 10
Vetted Review
Verified User
Review Source
Powers our entire data warehouse
  • storage
  • compute
  • query time
  • admin maintenance
  • lack of multiple indexes
  • indexing by primary key is non performant
Best analytics database in existence.
Able to be setup and administered by a lightly technical SQL user !
Performance performance performance
Able to query terabytes of data in seconds
Brian Bickell | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Reseller
Review Source
Snowflake is a modern cloud data platform that InterWorks refers, resells, and implements for our data analytics clients. We also use it to back our internal data analytics initiatives within InterWorks. Customers of ours use Snowflake across every vertical and industry for any problem where they need an efficient, easy to use, scalable data environment.
  • Snowflake is very easy to use and doesn't have heavy DBA overhead.
  • Snowflake's ability to separate storage and compute is a radical departure from how databases of the past were built.
  • Snowflake is very easy for customers to scale as their needs shrink and grow.
  • Snowflake still has room to grow in the advanced analytics use cases with the addition of Python, Scala, or Java running natively on Snowflake virtual warehouses.
  • Snowflake can be somewhat unintuitive for customers coming from a prior RDBMS background because some of the concepts are such a radical departure.
  • Snowflake is still not especially suited for many database use cases, such as OLTP scenarios. It's hard to call this a con, since that's obviously not what the product was designed for, but users should be aware.
Specific scenarios where Snowflake is very strong include analytical data processing scenarios. Snowflake is wonderful at inexpensively consolidating and storing data and allowing very fast access to that data while maintaining a low cost profile with it's ability to automatically resume and suspend virtual warehouses.

Snowflake is less suited to transaction processing scenarios and isn't a best choice to back up an online order processing system.
Score 6 out of 10
Vetted Review
Verified User
Review Source
Snowflake was chosen as our data warehouse to replace Amazon Redshift. It is used by all areas of the company including data science, product teams, sales, marketing, operations, finance, executives, etc. It sources data from various cloud data sources and is being fed from integration tools (Fivetran, Stitch) or ETL (Matillion).
  • Can scale up or across depending on workload type
  • Separation of compute and storage
  • Query Profiler gives you a pictorial idea of where the query is spending time
  • Very expensive
  • Needs to compute more to efficiently and cost-effectively deliver the data (needs to know your access patterns)
  • Query history is tricky to play with and system catalog views are either nonexistent or not well designed
It's easy to scale up/down or expand/shrink. However, without any tuning capabilities in SQL, more materialization of the data needs to be done to use the database cost effectively. It is time to look into other services that don't charge arm and leg. Customer service is slow to respond.
Score 10 out of 10
Vetted Review
Verified User
Review Source
Snowflake is being used across all departments of the company. It's our main data warehouse and system of record for sales, inventory and other metrics of the company. Snowflake helps us address different business questions from executives and help them make decisions based on the different metrics being analyzed.
  • Snowflake computes really fast and can handle high volumes of data with ease.
  • Snowflake has some features that have really helped DBAs and developers particularly with Time Travel, it has help us with many processes in our company where we had to rollback or re-apply sweep processes which would be time consuming.
  • Snowflake has forced ETL developers to write better code (forcing ANSI standards) and avoided implicit conversions in specific data-types for different subject areas.
  • Loading processes have improved. Prior to Snowflake, some ETL processes would take double the time to execute. With Snowflake those same processes finish in half the time.
  • Integration with other tools, particularly with connectivity. We have observed metadata callbacks being generated which are time consuming and annoying. These can be avoided but extra work is required.
  • Out of the box tools could be better. Specifically the querying tool is lacking a few features that other software offer for easy of use for users and developers.
  • Not really a Con, but in Snowflake there's no concept for Indexes, maybe because they are not required but we have seen particular cases where we believe an index would help speed some of the queries being executed.
- Well suited when handling high volume of data.
- In the cloud computing. Quick availability of data online.
- Data sharing across multiple departments and perhaps companies.
- Good for Archiving of data.
Sudarshan Kothari | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
Snowflake is acting as a company-wide Data Repository. With its cloud architecture and scalability, it addresses our storage, warehouse, and computation problem at the same time. Snowflake has powerful group roles and policy, which makes it beneficial for enterprise edition and usage. The ability to change the computational resources anytime is one of the biggest advantages. We have from manager to analyst been consuming the Snowflakes as a data repo. We have around a few hundred TB of data stored and it works smoothly on data growing exponentially too.
  • Hosted on cloud: Helps with scalability.
  • Community is active and ever-growing: You will have someone from the community to help whenever you need it.
  • The new functionality and thoughtful design are based on new world problems.
  • Support for JSON and XML is one of the main advantages.
  • Beta testing functionality needs to be properly tested and stick to the committed deadline set at the initial release.
  • The ODBC connector could be improved to accommodate multiple roles.
  • Updates on functionality need to be informed to the user. Just a document update might not be the right approach every time.
Snowflake acts as a single platform for both data storage and warehousing needs. For deployment purposes, it has the best group policy management and the best UI I've encountered personally. It also accommodates direct connection with AWS and Azure, which is another advantage. The only scenario where Snowflake would require second thought would be data that has PII information, as it doesn't have encryption options for such data points.
November 25, 2019

Amazing cloud-based DB

Torrey Vegter | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
We use Snowflake on our Data Engineering team to house our data warehouse and offload a substantial amount of our ETL processes to Snowflake. Snowflake enables us to offer ultra-fast querying to the business to quickly gain insights into our current data set.
  • Extremely intuitive and easy to use querying language.
  • Allows high performance querying of large data sets with very little setup and configuration.
  • Interfaces very easily with AWS S3.
  • Works seamlessly with both structured and unstructured data sets.
  • Very granular security.
  • IDE is OK but can be a bit clunky given it's web-based.
Snowflake works extremely well for storing a data warehouse as the querying is optimized for larger tables that are filled in batches. It also works extremely well with unstructured data and has basically replaced any need we previously had for NoSQL databases. Snowflake does not perform well for transactional databases.
I've only had to deal with them once. They were responsive and helped me clear up the issue although it took a day or two longer than I would have preferred.
Duncan Hernandez | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Snowflake is being used on top of our Azure data warehouse. It solves our issue of queries running at the same time and has drastically improved our server performance. All of our reports connect to Snowflake and they all run very fast. It is currently being used across the entire company.
  • You are able to adjust the power that you give a query. For the big queries, you can give more CPU to it so it runs faster.
  • It can now sit on Google Cloud, S3, and Azure.
  • Concurrency is a thing of the past.
  • I'd love to see a desktop tool for Snowflake. Currently, it is all web-based.
  • Database navigation can be smoother. It's not as efficient as a SQL workbench.
  • Row-level security is possible, but it was difficult to figure out.
The best reason to go to Snowflake is if there is a lot of stress on the server and queries are running slow. Snowflake does what it says it will do and improve this dramatically.

The only reason why someone would is because it is pricy or if there isn't much data at one's organization.
Overall great group of people and they are very insightful. They try to understand what the overall problem is rather than just focusing on the exact issue, which helps put a lot of things into perspective. The turnaround time is very good. I never found myself waiting for more than a couple of days, which is reasonable.
October 23, 2019

Snowflake Review

Score 8 out of 10
Vetted Review
Verified User
Review Source
It is used by the whole company. We went with Snowflake because it is faster than Vertica and easier to manage different warehouses with.
  • Great for managing different warehouses.
  • Quick and efficient.
  • Doesn't have the function of auto-fill.
Snowflake is very efficient for my company, and it's very easy to assign and manage different warehouses with it.
I have never used the support function, but I've heard great things about its customer service.
Jake Schlingman | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Snowflake was implemented around 6 months ago to replace Redshift as the SQL level that allows us to query our data. Snowflake enables us to query our data quickly and effectively to get insights into various aspects of the program as well as various aspects of our users' behavior. It allows us to make smarter business decisions by making that data more readily available and reliable than our previous solution was.
  • Resources that scale up and down automatically to ensure that queries run quickly and efficiently without paying for computing power that is not being used
  • Much more reliable than our previous software
  • No noticable limit to query size
  • Runs very quickly
  • The SQL syntax used is different from Redshift in a number of ways. Would be nice to have more readily available help documentation around the differences built into the system.
  • Would be awesome of there was a way to see relations between tables more effectively.
Snowflake is great when you need to store large amounts of data while retaining the ability to query that data quickly. It is very reliable and allows for auto-scaling on large queries meaning that you're only paying for the power you actually use. It's taken queries that took 20+ minutes to run on redshift down to 2 minutes on Snowflake.
Score 9 out of 10
Vetted Review
Verified User
Review Source
A few months ago, we'd decided to migrate our on-premise BI stack to cloud as on-premise solutions were not able to meet growing demands. Clearly, we were looking for cloud-only solutions. After extensive research and POC of several tools, we've on-boarded Snowflake. Snowflake is primarily used by the BI developers as our primary data warehouse and the resulting data is used by the whole organization via the dashboard or Excel extracts. Impressive data compression rate and faster data retrieval make it the best choice as an enterprise data warehouse.
  • Impressive data retrieval and data compression ratio.
  • Semi-structured data (JSON, XML) can be loaded as is and retrieved in a tabular structure on the fly using the flatten function.
  • Zero-copy cloning is an excellent feature which saves hours to refresh latest data in development instance.
  • Extensive usages documentation with examples makes development easy.
  • Stored procedures are implemented through JavaScript. Would be an additional overhead if your team doesn't have expertise.
  • No option to run multiple queries and analyze the results set in the same console window.
Snowflake is the data warehouse built for the cloud, enabling the data-driven enterprise with instant elasticity, secure data sharing, and per-second pricing. Faster data retrieval and on the fly retrieval of semi-structured data in tabular format. Excellent data compression ratio. Could be pricey for very large deployments.
Andrew Goss | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
My company adopted Snowflake as our first cloud-based data warehouse. It is being used as a central repository for all company data from each business unit for the purposes of business intelligence.
  • Ease of use
  • Separation of storage and compute resources
  • Simple to scale up or down with virtual warehouses
  • Built-in support for the most popular data formats
  • Standard SQL dialect
  • Robust function library
  • Lacks support for common table expressions
  • Lacks support for correlated subqueries
  • Better technical support for customer identified bugs
  • Clearer pricing model
Snowflake architecture was designed at its foundation to take advantage of the cloud and then adds some unique benefits that support ease of use and increased productivity. The most popular cloud data warehouse platforms are all powerful tools and solid choices. With an investment in one of these, what really matters is how productive will you be using the data warehouse.

Snowflake's 'data-warehouse-as-a-service' model lessens the maintenance tasks of optimization/tuning that have traditionally fallen to DBAs and ETL developers. There are no servers to manage, software to install, or indexes to tune. This allows data engineers and analysts to focus more exclusively on analytic tasks that will translate into growth for the company.

While Snowflake doesn’t have all the performance optimization bells and whistles of other cloud data warehouse platforms, this is actually a good thing and that most people don't really need all of them or miss them. Using Snowflake on the whole means less knob-turning and futzing with setup/tweaking. Snowflake has its query optimizer already built-in.
Jacob Biguvu | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Capital One has many LOBs (lines of business). I have supported IAM and Commercial LOBs. They are using Snowflake as a data warehouse solution. The team is also using Redshift. The team noticed the concurrency limit with Redshift. Snowflake is a simple architecture with isolated compute capabilities. Redshift does not separate storage and computer capacities. Based on the workloads, the capacity is scaled up and scaled down using the option: Dataware. Right now, Snowflake is the heart-cake requirement for the company.

  • The beauty of Snowflake is virtual warehouses. This provides an isolated workload and capacity (Virtual warehouse ). This allows separating or categorizing workloads and query processing according to our requirements.
  • Snowflake provides a unique architecture that supports structured and semi-structured data. provides the ready-made solutions to process with the semi-structured data such as JSON, Avro, ORC, Parquet, and XML
  • SQL kind queries make easy to write/develop the code. Provided features such as materialized views to optimize the query processing and loads
  • Snowflake database is managed by snowflake team. This simplifies the DBA job from maintenance kinds of tasks such as patchworks and regular upgrades.
  • Performance degradation happens when many users are on the system at the same time.
  • Snowflake support is slow often.
  • Snowflake provides Virtual warehouses for having performance. however, it may cost more.
Snowflake is best for a data warehouse. When you want to compute capacities separately to manage the workloads independently, Snowflake is the best option, because it provides isolated virtual warehouses.
May 27, 2019

Great DW tool!

Eric Fischer | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
We use Snowflake for basic data munging from OLTP databases, APIs, etc. It is only used in our sizable Data department. It solves the problem of spinning up and managing a DW quickly without dedicated DBA support.
  • A nice UI with options to see the SQL/Code to automate steps in the UI.
  • Has great SQL features like LISTAGG or Count Distinct, which go above and beyond Oracle and MS SQL.
  • It's very fast!
  • The SQL editor. The worksheets are nice, but code editors today have auto-fill, debug highlighters, etc. They are working on this I'm told.
  • Worksheets (where you edit SQL) cannot be exported today.
  • Occasionally a bug is introduced during releases. It's no big deal.
Snowflake is great for quick dirty analysis.
Score 10 out of 10
Vetted Review
Verified User
Review Source
We are using Snowflake as our data warehouse. We currently are loading in our tables and data from an old IBM System to Snowflake. It is currently being used by a few departments but is planning to be used across the whole organization.
  • Performance is extremely fast
  • Pay for what you use
  • Simple and Pleasant User Interface
  • The mouse pointer can be laggy at times when hovering over a preview of a table
  • Make it easier to switch between data warehouses
Snowflake is great for storing data and using it as an endpoint to query off of. It is cloud-based so the it can be scaled to any business need. It is great for analytics as well as simply storing data.
Score 8 out of 10
Vetted Review
Verified User
Review Source
It is used by Data teams across different departments of the company for compute purposes.
  • On demand and instant spin up of compute instances is fantastic
  • I like the browser based tabs which save queries
  • Easy connection to Python and BI tools
  • SQL editor can be better with autocomplete functions
Snowflake is well suited for performing data ETL when data is stored in AWS S3 and one needs fine control over instance costs.

It is less appropriate to connect directly to a BI tool, as it may be costly to keep warehouses running.