Amazon QuickSight vs Snowflake

Likelihood to Recommend

I'm likely to recommend it because it would become so native if other cloud services are based on AWS infrastructure, like our current setup. It is very seamlessly integrated with other services to feed in data for the visualization. In addition, supporting a reasonably large number of users concurrently is not an issue and should be able to scale horizontally as needed.

Read full review

Verified User

Director in Research & Development

Computer Software Company, 51-200 employees

View all 4 answers on this topic

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.

Read full review

Brian Bickell

Data Practice Director

InterWorksInformation Services, 201-500 employees

View all 23 answers on this topic

Feature Rating Comparison

Amazon QuickSight

Snowflake

Pixel Perfect reports

Customizable dashboards

Report Formatting Templates

Amazon QuickSight

Customizable Platform (Open Source)

Pros

Lightweight and serverless BI tool that can be used for niche dashboards.
Its integration into other AWS Services is one of its most appealing features.
The low monthly cost is another benefit.

Read full review

Verified User

Vice-President in Information Technology

Higher Education Company, 10,001+ employees

View all 4 answers on this topic

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

Read full review

Jake Schlingman

Product Manager

AppFolio, Inc.Computer Software, 1001-5000 employees

View all 23 answers on this topic

Cons

One of the primary challenges I've had with Amazon QuickSight so far is that some of the reports I want to build use data from different data sets. Instead of being able to put all of the information I want to see into one report.
Some of our Amazon QuickSight reports only update every 24 hours. It would be great to see that data in real-time.
I would remove the various time zones from Amazon QuickSight and only use the time zone we are in.

Read full review

Megan Sullivan

Marketing Director

LightRx Face & BodyConsumer Services, 201-500 employees

View all 4 answers on this topic

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.

Read full review

Verified User

Team Lead in Engineering

Computer Games Company, 51-200 employees

View all 23 answers on this topic

Likelihood to Renew

No score

No answers yet

No answers on this topic

Snowflake 8.0

Based on 1 answer

SnowFlake is very cost effective and we also like the fact we can stop, start and spin up additional processing engines as we need to. We also like the fact that it's easy to connect our SQL IDEs to Snowflake and write our queries in the environment that we are used to

Read full review

Verified User

Team Lead in Engineering

Computer Games Company, 51-200 employees

View all 1 answers on this topic

Usability

No score

No answers yet

No answers on this topic

Snowflake 8.7

Based on 11 answers

Extensive documentation and several tutorial videos are available online which reduces learning and deployment time. User Interface is very intuitive and provide flexibility to create databases, schema, tables and assign permissions in a few clicks (no need to write SQL queries). SQL History helps to track usages and billing dashboard provide credit breakup per warehouse. Create views and write procedures in JavaScript for more complex data transformation requirement

Read full review

Verified User

Analyst in Information Technology

Consumer Goods Company, 51-200 employees

View all 11 answers on this topic

Support Rating

No score

No answers yet

No answers on this topic

Snowflake 8.7

Based on 10 answers

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.

Read full review

Verified User

Analyst in Corporate

Cosmetics Company, 10,001+ employees

View all 10 answers on this topic

Alternatives Considered

In our case, we are storing our large amount of data in the cloud so using QuickSight adds up to the performance of the reporting. We are using it as a secondary reporting tool so that a business user can generate their own report. We are using Tableau as our primary reporting tool.

Read full review

Verified User

Consultant in Information Technology

Building Materials Company, 501-1000 employees

View all 4 answers on this topic

The average percentage of time that a data warehouse is actually doing something is around 20%. Given this, the price by query estimate becomes an important pricing consideration. For this, Snowflake crucially decouples of storage and compute. With Snowflake you pay for 1) storage space used and 2) amount of time spent querying data. Snowflake also has a notion of a “logical warehouse” which is the “compute” aspect of the database. These warehouses can be scaled up or down to deliver different grades of performance. You can also configure the number of compute nodes to parallelize query execution. These warehouses can be configured to “pause” when you’re not using them for cost efficiency. As a result, you can have a super beefy warehouse for BI queries that’s only running when people are using your BI tools, while your background batch jobs can use cheaper hardware.

Read full review

Andrew Goss

Data Engineer

InterfolioInternet, 51-200 employees

View all 23 answers on this topic

Return on Investment

No answers on this topic

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.

Read full review

Jacob Biguvu

Database Engineer/DBA (Cloud and On-Premises)

Capital OneFinancial Services, 10,001+ employees

View all 23 answers on this topic

Pricing Details

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Amazon QuickSight Editions & Modules

Edition

Authors	$24.00¹
Readers	$5.00¹

Per Month

Additional Pricing Details

—

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Snowflake Editions & Modules

Edition

US East	$20.00¹

Per TB

Additional Pricing Details

—

Rating Summary

Amazon QuickSight

Snowflake

Amazon QuickSight

Snowflake

Amazon QuickSight

Snowflake

Amazon QuickSight

Snowflake

Likelihood to Recommend