TrustRadius
Snowflake is the eponymous data warehouse with an emphasis on analysis, from the company in San Mateo, California.https://media.trustradius.com/product-logos/mJ/cO/J5XIE3MICFO8.PNGExtremely fast and efficient data warehouse tool.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.,9,Much more reliable access to data encourages more people to utilize what is available. Quicker queries means that you can get data much more quickly. Queries no longer have a limit in size since the computing power scales up with the size of the query meaning that the types of things we're able to look for has significantly expanded. On the downside, this is definitely more expensive than our previous software.,Amazon Redshift,G Suite, Airtable, GoToMeeting,8Snowflake's ease of use allows you to focus on what matters most - the data you're filling it withMy 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,9,Centralized disparate data sources across the company Used to associate fragmented and unlock key insights Integrates easily with our business intelligence tool, Sisense,Amazon Redshift, Google Cloud Datastore and Microsoft Azure,Sisense, Matillion,9Snowflake - flexible and isolated workloadsCapital 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.,9,Quick installation/setup for a data warehouse solution. Make easy to handle/manage the various type of semi-structured data using the native solutions and provided new data modeling concepts such as schema-read data model and schema-write data model. Make easy and simplified the workload management using virtual warehouses and materialized views.,Amazon Redshift and Apache Hive,AWS OpsWorks, Azure API Management, Amazon Redshift,8Snowflake Cloud Data Warehouse - The Good, the Bad and the UglySnowflake is being used across our whole organization. It addresses the need to combine disparate data sources into one single data source and discover insights into our business that would not be easily possible with lots of disconnected data sources. It also delivers world-class query performance and the ability for different business divisions to query their own data quickly and create reports in a fraction of the time as opposed to a traditional data warehouse solution. We are also using it to drive machine learning, and the data scientists are gaining insights into our business data that would not be possible otherwise. It is addressing multiple business problems, from distribution of our products all the way through to billing.,Reporting queries run in a fraction of the time that they would in our production systems. For example, we can take the original MS SQL reporting queries , that used to take hours to run in our OLTP databases, and convert it into snow SQL, and run almost the exact same query in Snowflake in minutes, if not seconds. Having all our different data sources in one data warehouse database means we can start looking for links between data sources and different business units to tie all our data together. We can see from when a customer was dialled, through to when/if they bought a product, to when they were actually billed, and identify where in the process we are most efficient, and where we can improve our services and product offerings. Having a truly automated database system, without the need to create indices or maintain them, means we can spend more time in gaining insights into our data and getting actual results/data out, rather than spending time managing and maintaining the solution.,There is no easy way to schedule any type of task.,9,I have no idea on ROI.,,Fivetran, Azure SQL Database,8Cloud-Based Data Warehousing Done RightWe replaced our RDS Postgres based DW with Snowflake. We use it as the main data source for all analytics components within our SaaS product, internal reporting, and ad hoc analysis by power users. We are now also able to analyze JSON without the need for transformation by easily replicating S3 buckets with Snowpipe.,Provision compute resources instantly and autoscaling. True elastic, pay as you go pricing model. Secure Data Sharing. No other vendor offers this. This is big if you have the need to do a lot of data extracts. Ability to segregate clusters of computer resources (warehouses) by use pool. You can give power users access without the fear of slowing down critical applications. Cloud first architecture offers simple integration with other cloud-centric technologies/tools like S3 storage, streaming/replication brokers like Kafka, Alooma and cloud base BI tools. Big Data analytics capabilities with the familiarity of ANSI SQL. Short learning curve.,Compilation times on somewhat complex queries is high. We use materialized views to address this problem and take advantage of caching, but we believe there is room for improvement here. SLA's dependent on the big cloud player (AWS, Azure, GCP). If they have interruptions, you have interruptions. This is the current reality of cloud computing.,10,Cost and performance vs our previous DW are several times better. Shorter development cycles are possible based on the ability to easily ingest and query semi-structured data. Data sharing capability can be a catalyst for new products.,Amazon Redshift, Amazon Aurora and Amazon Relational Database Service,Alooma, Dundas BI, Pentaho, TIBCO Jaspersoft Community Edition, PostgreSQL,9Seamless and InvisibleWe use Snowflake as a virtual warehouse to hold our data in a layer which is organised in a way that is ready and efficient for analysing. We drop data into it with a scheduled ETL tool, and then use a BI tool to refresh the data extracts overnight each night.,Scales up and down seamlessly Only charges when it's being used Easy and transparent to use,Coding language is a little tricky in places, not quite the SQL used elsewhere Setting up not quite as seamless as expected,9,We are able to manage our usage perfectly, keeping costs down It will scale with us, immediately and transparently,Matillion, Tableau Desktop and Tableau Online,Matillion, Tableau Desktop, Tableau Online,9Great DW tool!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.,10,Snowflake allows us to iterate quickly. It allows us to start small. We can scale quickly.,Oracle Database and MySQL,9Snowflake(cloud-only) Data Warehouse: Excellent Performance and ScalabilityA 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.,9,Faster data retrieval makes real time analysis possible. Option to create multiple warehouses enable us to track usages and cost by departments. Option to scale up/down computational warehouse to support peak hours and month end loads makes Snowflake cost effective. Zero-copy cloning reduces storage and deployment cost. Multiple users can access the same amount of data without deadlocks which is a common scenario in relational databases.,Amazon Redshift, Microsoft SQL Server and PostgreSQL,9Snowflake ReviewIt 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.,10,Analysts are able to write heavy queries at the same time which increases the speed of analyses dramatically.,,6,Looker, VerticaSnowflake Performance for Large CompanyWe 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,10,It will save the company money by providing a new business solution to data warehousing Pay as you go allows the company to choose what it wants to pay for and use,Amazon Redshift,Tableau Desktop, AWS CodePipeline, AWS Cloud9,10Flexible and feature rich Data Warehouse, worth a try.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,8,Saved a lot of money when we moved from Redshift (on demand clusters) Saved time thanks to instant on demand compute instances Dont have to worry about cluster setup like in Redshift,Amazon Redshift and Google BigQuery,IntelliJ IDEA, Looker,8The best data warehouse on the marketWe use Snowflake across our entire organization. We selected Snowflake to replace Redshift as our data warehouse. All of our data now funnels into Snowflake and users are able to query it and draw insights that they have never had before. Additionally, we were able to build and release a reporting dashboard for our external clients to see all of their historical data with us in one place.,You only pay for the resources when you are using them ANSI SQL compliant Great documentation Native Apache Spark connector,Does not support Dynamic SQL Right now you can write User-Defined Functions (UDFs) in pure SQL or Javascript. I would love to see support for something like Python We have been seeing more downtime lately as of writing this review,10,As an engineer, I don't see as much of the financial impact. I do know at least 10 customers have signed with us specifically after seeing the dashboards/insights they would get from our Snowflake data warehouse.,Amazon Redshift and Panoply,Databricks Unified Analytics Platform, Azure DevOps (formerly VSTS), Amazon S3 (Simple Storage Service), MySQL,10Snowflake - a very cost effective JSON querying tool.Snowflake is currently being used to ingest daily JSON files exported from an analytics package into S3. We use Snowflake for Ad Hoc Queries, aggregating daily KPIs and pushing that data into a SQL Server, as well as creating Tableau extracts for our dashboards. We have also started using it for deeper Machine Learning types of analysis - such as creating predictive models.,Process Engine control - we can stop/pause/start engines for various tasks. Processing speed is adequate unless there are many users on at the same time. Web interface is easy and intuitive, like the fact that your queries are automatically saved in tabs.,Very limited amount of tabs - saved queries, which requires us to store the code somewhere else and re-use existing queries. Performance can really be a problem if there are many users on the system at the same time. SnowFlake support sometimes can be hard to reach.,7,We are able to organize all the various data sources into one place and run Ad hoc queries against them. Snowflake being very cost effective is definitely saving us $ over their competitors. We are able to track KPIs across various games and compare them to each other, thus knowing where to invest our marketing dollars.,Treasure Data,Tableau Desktop, JIRA Software, Anaconda, GitHub,10,7,Ad Hoc Analysis of various things that are going on in our games. In-Depth model building to improve our users' experience. Aggregating data and create dashboards to display our KPIs to management.,We've been able to leverage the cost of Snowflake to get better deals out of our other vendors. Machine Learning model building. In-Depth analytics investigation into performance of our games.,Expand our portfolio of games that use SnowFlake. Add data from other marketing sources into SnowFlake to integrate with gaming data. Build a warehouse sitting on top of SnowFlake with aggregated data.,8Why I love Snowflake!!!Snowflake is currently used by our business intelligence team. The data from Snowflake is used by entire organization in the form of Tableau reports/dashboards etc. Snowflake database is used to deliver information for the following: - Data science projects for decision making on products, game performance, user acquisition etc. - Marketing Programs. Data is used to target users for marketing special offers. - Make changes and improve the game interface for the user. - Ad-hoc extracts for functional teams such as marketing, product and third party vendors.,Truly elastic & highly optimized SQL database Minimal management overhead Support for both structured and semi-structured data Uses standard SQL Seamless integration between file system & S3,Documentation,10,Cost effective Plays well with other tools in our technology stack Rapid development time,Amazon Redshift,Talend Integration SuiteYour DWH entirely on the cloud!The analytics and reporting team uses Snowflake as their primary Business Intelligence (BI) tool. Combined with several reporting and charting tools, Snowflake provides insight across all departments in the organisation. Snowflake helps provide the business with crucial analytical understanding of performance which, in turn, influences business strategy for the entire organisation.,Easy to set up and get running. Great support. Integrates well with Amazon AWS.,Charting features could be better. Reporting tools are not very extensive, creating a need for combining with other tools like Tableau. Data Warehouse entirely on the cloud might be a problem for some businesses.,8,Significantly improved the efficiency of analytics and reporting. Performance of queries has gone up. Allows for easy changes, making project timelines move faster.,Informatica Enterprise Data Integration,Informatica Enterprise Data Integration, Talend Data Integration, Talend Open Studio
Unspecified
Snowflake
50 Ratings
Score 9.1 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>

Snowflake Reviews

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Snowflake
50 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9.1 out of 101

Do you work for this company?

TrustRadius Top Rated for 2019
Show Filters 
Hide Filters 
Filter 51 vetted Snowflake reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role

Reviews (1-15 of 15)

Companies can't remove reviews or game the system. Here's why.
Jake Schlingman profile photo
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.
Read Jake Schlingman's full review
Andrew Goss profile photo
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.
Read Andrew Goss's full review
Jacob Biguvu profile photo
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.
Read Jacob Biguvu's full review
Wicks Justin profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source
Snowflake is being used across our whole organization. It addresses the need to combine disparate data sources into one single data source and discover insights into our business that would not be easily possible with lots of disconnected data sources. It also delivers world-class query performance and the ability for different business divisions to query their own data quickly and create reports in a fraction of the time as opposed to a traditional data warehouse solution. We are also using it to drive machine learning, and the data scientists are gaining insights into our business data that would not be possible otherwise. It is addressing multiple business problems, from distribution of our products all the way through to billing.
  • Reporting queries run in a fraction of the time that they would in our production systems. For example, we can take the original MS SQL reporting queries , that used to take hours to run in our OLTP databases, and convert it into snow SQL, and run almost the exact same query in Snowflake in minutes, if not seconds.
  • Having all our different data sources in one data warehouse database means we can start looking for links between data sources and different business units to tie all our data together. We can see from when a customer was dialled, through to when/if they bought a product, to when they were actually billed, and identify where in the process we are most efficient, and where we can improve our services and product offerings.
  • Having a truly automated database system, without the need to create indices or maintain them, means we can spend more time in gaining insights into our data and getting actual results/data out, rather than spending time managing and maintaining the solution.
  • There is no easy way to schedule any type of task.
If you need a totally managed cloud data warehouse solution that is as fast as lightning, then snowflake is for you.
I would not use it for any OLTP production type of solution.
Read Wicks Justin's full review
Carlos Fares, CBIP profile photo
Score 10 out of 10
Vetted Review
Verified User
Review Source
We replaced our RDS Postgres based DW with Snowflake. We use it as the main data source for all analytics components within our SaaS product, internal reporting, and ad hoc analysis by power users. We are now also able to analyze JSON without the need for transformation by easily replicating S3 buckets with Snowpipe.
  • Provision compute resources instantly and autoscaling. True elastic, pay as you go pricing model.
  • Secure Data Sharing. No other vendor offers this. This is big if you have the need to do a lot of data extracts.
  • Ability to segregate clusters of computer resources (warehouses) by use pool. You can give power users access without the fear of slowing down critical applications.
  • Cloud first architecture offers simple integration with other cloud-centric technologies/tools like S3 storage, streaming/replication brokers like Kafka, Alooma and cloud base BI tools.
  • Big Data analytics capabilities with the familiarity of ANSI SQL. Short learning curve.
  • Compilation times on somewhat complex queries is high. We use materialized views to address this problem and take advantage of caching, but we believe there is room for improvement here.
  • SLA's dependent on the big cloud player (AWS, Azure, GCP). If they have interruptions, you have interruptions. This is the current reality of cloud computing.
Snowflake is an analytics data store. If your main use case for evaluating it is analytics workload, then there is no reason to at least do a POC. If your workload is more transactional, real-time log analytics or search, then there are other options.
Read Carlos Fares, CBIP's full review
Martin Haw profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source
We use Snowflake as a virtual warehouse to hold our data in a layer which is organised in a way that is ready and efficient for analysing. We drop data into it with a scheduled ETL tool, and then use a BI tool to refresh the data extracts overnight each night.
  • Scales up and down seamlessly
  • Only charges when it's being used
  • Easy and transparent to use
  • Coding language is a little tricky in places, not quite the SQL used elsewhere
  • Setting up not quite as seamless as expected
As a small, growing business, the model is ideal for us as it can scale perfectly with us, and our needs of this layer of our stack.
Read Martin Haw's full review
Eric Fischer profile photo
May 27, 2019

Great DW tool!

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.
Read Eric Fischer's full review
No photo available
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.
Read this authenticated review
No photo available
October 03, 2019

Snowflake Review

Score 10 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.
Read this authenticated review
No photo available
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.
Read this authenticated review
No photo available
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.
Read this authenticated review
No photo available
Score 10 out of 10
Vetted Review
Verified User
Review Source
We use Snowflake across our entire organization. We selected Snowflake to replace Redshift as our data warehouse. All of our data now funnels into Snowflake and users are able to query it and draw insights that they have never had before. Additionally, we were able to build and release a reporting dashboard for our external clients to see all of their historical data with us in one place.
  • You only pay for the resources when you are using them
  • ANSI SQL compliant
  • Great documentation
  • Native Apache Spark connector
  • Does not support Dynamic SQL
  • Right now you can write User-Defined Functions (UDFs) in pure SQL or Javascript. I would love to see support for something like Python
  • We have been seeing more downtime lately as of writing this review
Snowflake is great as a data warehouse for any sized company. Since you only pay for what you use, you can request fewer resources if you are on a smaller budget.

The only time I would say Snowflake is not the right option is when you are not using one of their supported languages. My team works in Python and Spark, so we have no issue connecting to the DB. Other teams at my company use PHP, which does not have a 1st-party connector yet (it is in private preview), so they will have to use a workaround for now.
Read this authenticated review
No photo available
Score 7 out of 10
Vetted Review
Verified User
Review Source
Snowflake is currently being used to ingest daily JSON files exported from an analytics package into S3. We use Snowflake for Ad Hoc Queries, aggregating daily KPIs and pushing that data into a SQL Server, as well as creating Tableau extracts for our dashboards. We have also started using it for deeper Machine Learning types of analysis - such as creating predictive models.
  • Process Engine control - we can stop/pause/start engines for various tasks.
  • Processing speed is adequate unless there are many users on at the same time.
  • Web interface is easy and intuitive, like the fact that your queries are automatically saved in tabs.
  • Very limited amount of tabs - saved queries, which requires us to store the code somewhere else and re-use existing queries.
  • Performance can really be a problem if there are many users on the system at the same time.
  • SnowFlake support sometimes can be hard to reach.
Snowflake is great in quick process and ad hoc queries of JSON files (with built-in JSON support). Snowflake would not be the best alternative for sitting on top of Tableau Dashboards - mostly because of the engine being idle and filtering might take additional time. The fact that you only pay for engine time you actually use makes Snowflake is very cost-effective.
Read this authenticated review
Rajesh Ganesan profile photo
January 25, 2016

Why I love Snowflake!!!

Score 10 out of 10
Vetted Review
Verified User
Review Source
Snowflake is currently used by our business intelligence team. The data from Snowflake is used by entire organization in the form of Tableau reports/dashboards etc. Snowflake database is used to deliver information for the following:
- Data science projects for decision making on products, game performance, user acquisition etc.
- Marketing Programs. Data is used to target users for marketing special offers.
- Make changes and improve the game interface for the user.
- Ad-hoc extracts for functional teams such as marketing, product and third party vendors.
  • Truly elastic & highly optimized SQL database
  • Minimal management overhead
  • Support for both structured and semi-structured data
  • Uses standard SQL
  • Seamless integration between file system & S3
  • Documentation
Snowflake is very flexible. Its seamless integration with AWS S3 makes it a great candidate for companies using AWS. Many of the companies are hasty to get on to hadoop and spend a considerable amount [of time] to make it work. The Snowflake database is a finely developed database engine that can solve many use cases where hadoop is used. It is fast to implement and integrate. Our data scientist and business analyst love it as it is not complex and implements standard sql.
Read Rajesh Ganesan's full review
No photo available
Score 8 out of 10
Vetted Review
Verified User
Review Source
The analytics and reporting team uses Snowflake as their primary Business Intelligence (BI) tool. Combined with several reporting and charting tools, Snowflake provides insight across all departments in the organisation. Snowflake helps provide the business with crucial analytical understanding of performance which, in turn, influences business strategy for the entire organisation.
  • Easy to set up and get running.
  • Great support.
  • Integrates well with Amazon AWS.
  • Charting features could be better.
  • Reporting tools are not very extensive, creating a need for combining with other tools like Tableau.
  • Data Warehouse entirely on the cloud might be a problem for some businesses.
Snowflake is the perfect data warehouse for a business that operates primarily on the cloud. Since Snowflake itself is a cloud based data warehouse, this makes integration very convenient. On the other hand, if a business operates using on-premise technology and is unable to integrate well with cloud based services, Snowflake can turn out to be a disastrous option.
Read this authenticated review

About Snowflake

Snowflake is the eponymous data warehouse with an emphasis on analysis, from the company in San Mateo, California.
Categories:  Data Warehouse

Snowflake Technical Details

Operating Systems: Unspecified
Mobile Application:No