TrustRadius
Snowflake is the eponymous data warehouse with an emphasis on analysis, from the company in San Mateo, California.https://dudodiprj2sv7.cloudfront.net/product-logos/bt/dw/2T2R5G719T12.pngSnowflake - 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.,8Your 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 StudioWhy 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 Suite
Unspecified
Snowflake
16 Ratings
Score 7.1 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

Snowflake Reviews

Snowflake
16 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.1 out of 101
Show Filters 
Hide Filters 
Filter 16 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-3 of 3)
  Vendors can't alter or remove reviews. Here's why.
No photo available
August 06, 2018

Review: "Snowflake - a very cost effective JSON querying tool."

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
No photo available
October 11, 2017

Snowflake Review: "Your DWH entirely on the cloud!"

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
Rajesh Ganesan profile photo
January 25, 2016

User Review: "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

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