What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
145 Ratings
6 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 5 out of 100

Snowflake

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
145 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 9 out of 100

Likelihood to Recommend

Db2 Warehouse on Cloud

Db2 is not a solution that I recommend. We have a lot of experience and we are not satisfied with the product or the support that we received. Because of the way our environment works, serving branches, it becomes a challenge to satisfy the customers or users.
Ankur Varshney | TrustRadius Reviewer

Snowflake

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.
Rounak Verma | TrustRadius Reviewer

Pros

Db2 Warehouse on Cloud

  • You can size dashDB to your current needs and expand its capability later on as the needed.
  • I like the way dashDB allow for connecting to the cloud that my network engineer to set things up quickly.
  • IBM dashDB's ability to store and provide fast access to data both on-premise and in the cloud makes it a real winner for me.
Anonymous | TrustRadius Reviewer

Snowflake

  • 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.
Darren Mihalic | TrustRadius Reviewer

Cons

Db2 Warehouse on Cloud

  • We have been facing some challenges with Db2 when scaling up the operations in terms of availability. It becomes a single point of failure and it pollutes the whole system, leaving us challenges in serving the traffic. This is the reason that we are considering migrating to Oracle.
  • Scalability has been a problem area. We have traffic on the order of gigabytes per second and it impacts our queries and responses a lot. Considering the volume that we have, it manifests itself into a multitude of issues.
  • We have dealt with technical support on several occasions. Whenever we run into issues, the specialist team is involved and the resolution cycle is stretched. We have to rely on make-shift solutions and the issues keep recurring. Ultimately, the product itself has challenges and we are not currently satisfied with the support, either.
Ankur Varshney | TrustRadius Reviewer

Snowflake

  • 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
Anonymous | TrustRadius Reviewer

Likelihood to Renew

Db2 Warehouse on Cloud

No score
No answers yet
No answers on this topic

Snowflake

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
Anonymous | TrustRadius Reviewer

Usability

Db2 Warehouse on Cloud

No score
No answers yet
No answers on this topic

Snowflake

Snowflake 8.1
Based on 12 answers
The interface is similar to other SQL query systems I've used and is fairly easy to use. My only complaint is the syntax issues. Another thing is that the error messages are not always the easiest thing to understand, especially when you incorporate temp tables. Some of that is to be expected with any new database.
Jake Schlingman | TrustRadius Reviewer

Support Rating

Db2 Warehouse on Cloud

No score
No answers yet
No answers on this topic

Snowflake

Snowflake 7.5
Based on 11 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.
Anonymous | TrustRadius Reviewer

Alternatives Considered

Db2 Warehouse on Cloud

IBM dashDB stacks up well against both on-premise (SQL Server and DB2), but it was a tough choice to go with over AzureDB. Ultimately, the deep discount by IBM led us to go with dashDB with the understanding that we could back out of the technology at a later date.
Anonymous | TrustRadius Reviewer

Snowflake

In my experience running the data management practice at InterWorks, we believe that cloud data warehouse products will eventually serve the majority of data warehousing use cases and power data analytics at most companies. Of this cohort, we believe that Snowflake is the best among them for most customers. It's easier to manage, in many cases faster, and in almost all cases it is less expensive because of the ability to automatically resume and suspend depending on usage.
Brian Bickell | TrustRadius Reviewer

Return on Investment

Db2 Warehouse on Cloud

  • We have dealt with technical support on several occasions. Whenever we run into issues, the specialist team is involved and the resolution cycle is stretched. We have to rely on makeshift solutions and the issues keep recurring. Ultimately, the product itself has challenges and we are not currently satisfied with the support, either.
  • Scalability has been a problem area. We have traffic on the order of gigabytes and it impacts our queries and responses a lot. Considering the volume that we have, it manifests itself into a multitude of issues.
Ankur Varshney | TrustRadius Reviewer

Snowflake

  • 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.
Anonymous | TrustRadius Reviewer

Screenshots

Pricing Details

Db2 Warehouse on Cloud

General

Free Trial
Yes
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Entry-level set up fee?
No

Db2 Warehouse on Cloud Editions & Modules

Edition
dashDB Entry50 / month1
dashDB EnterpriseVaries
dashDB Enterprise MPPVaries
dashDB Entry (Free)$03
  1. Per instance
  2. none
  3. Up to 50 GB
Additional Pricing Details

Snowflake

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Snowflake Editions & Modules

Edition
US East$20.001
  1. Per TB
Additional Pricing Details

Add comparison