We performed a comparison between Oracle Exadata and Snowflake based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Snowflake wins out in this comparison, as it has a better user rating regarding both ease of deployment and pricing.
"It has improved the performance, now we run with more performance cores with less CPU to attend all the database demands. Reducing Time to Market, increase our ability to face the competition with speed and low cost."
"The product is flexible."
"The business intelligence is very good."
"What I like best about Oracle Exadata is its good performance. It's also a very fast solution."
"The most valuable feature of Oracle Exadata is the storage available."
"Exadata with the In-Memory option is several levels about SAP HANA."
"Backup/Restore performance: Fast backups, fast restores (especially useful for creating clone environments)."
"The most valuable feature of Oracle Exadata is the smart scan. We have large TB sessions of approximately 100 per second for each of our three instances. The smart scan allows us the obtain data in time in the enterprise manager."
"The most efficient way for real-time dashboards or analytical business intelligence reports to be sent to the customer."
"It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL."
"The technical support is pretty good, particularly if you are a more technical user."
"I like the ability to work with a managed service on the cloud and that is easy to start with."
"All the people who are working with Snowflake are extremely happy with it because it is designed from a data-warehousing point of view, not the other way around. You have a database and then you tweak it and then it becomes a data warehouse."
"Scaling is a big plus point of Snowflake."
"It is a very well-distributed system. It has different data engines for different applications. Many applications can use different computational engines at the same time. In terms of data processing, the feeling was similar to working with a relational database but in a scalable way."
"We find the data sharing and data marketplace aspects of Snowflake absolutely amazing."
"Since the product is an appliance, it is very costly."
"Setting up Exadata is complex. You need an Oracle vendor or someone who is Oracle-certified to set it up."
"I believe Oracle must improve its procedure to support the clients. The customer Ready Service must provide more use cases and benchmarks of their infrastructure to support client design decisions. Oracle must audit their partners regularly to guarantee they provide quality service even after been passed on partnership examination."
"Checking the Smart Scan issues is complicated."
"There is one aspect to Exadata that I dislike, and that's the inconsistency with other databases. When you try to get Exadata to function with another type of database like SQL, or others, there should be reliable and consistent operation. When this is improved on, we should start to see more applications growing the market."
"Oracle Exadata has room for improvement in pricing, especially for smaller companies. The solution is okay for bigger companies, but for smaller companies, it isn't."
"It's too expensive per terabyte. It's complex."
"Tech support sometimes takes some time to identify and rectify issues."
"There are a lot of features that they need to come up with. A lot of functions are missing in Snowflake, so we have to find a workaround for those. For example, OUTER APPLY is a basic function in SQL Server, but it is not there in Snowflake. So, you have to write complex code for it."
"More data governance and access control features would be a welcome addition."
"They don't have any SLAs in place. It would be better if they did."
"They need to improve its ETL functionality so that Snowflake becomes an ETL product. Snowpipe can do some pipelines and data ingestion, but as compare to Talend, these functionalities are limited. The ETL feature is not good enough. Therefore, Snowflake can only be used as a database. You can't use it as an ETL tool, which is a limitation. We have spoken to the vendor, and they said they are working on it, but I'm not sure when they will bring it to production."
"The solution could improve by allowing non-structured data, such as PDFs, images, or videos. We cannot see the data."
"There are three things that came to my notice. I am not very sure whether they have already done it. The first one is very specific to the virtual data warehouse. Snowflake might want to offer industry-specific models for the data warehouse. Snowflake is a very strong product with credit. For a typical retail industry, such as the pharma industry, if it can get into the functional space as well, it will be a big shot in their arm. The second thing is related to the migration from other data warehouses to Snowflake. They can make the migration a little bit more seamless and easy. It should be compatible, well-structured, and well-governed. Many enterprises have huge impetus and urgency to move to Snowflake from their existing data warehouse, so, naturally, this is an area that is critical. The third thing is related to the capability of dealing with relational and dimensional structures. It is not that friendly with relational structures. Snowflake is more friendly with the dimensional structure or the data masks, which is characteristic of a Kimball model. It is very difficult to be savvy and friendly with both structures because these structures are different and address different kinds of needs. One is manipulation-heavy, and the other one is read-heavy or analysis-heavy. One is for heavy or frequent changes and amendments, and the other one is for frequent reads. One is flat, and the other one is distributed. There are fundamental differences between these two structures. If I were to consider Snowflake as a silver bullet, it should be equally savvy on both ends, which I don't think is the case. Maybe the product has grown and scaled up from where it was."
"Snowflake could improve migration. It should be made easier. It would be beneficial if it could offer some OLTP features. One of our customers was using Oracle for both data warehousing and OLTP workloads, and they were able to migrate their data warehousing workloads to Snowflake without major issues. However, for some of their OLTP requirements, such as needing a response time of fewer than 10 milliseconds for certain queries, Snowflake is currently unable to provide that."
"Its transaction application needs improvement."
Oracle Exadata is ranked 2nd in Data Warehouse with 125 reviews while Snowflake is ranked 1st in Data Warehouse with 94 reviews. Oracle Exadata is rated 8.4, while Snowflake is rated 8.4. The top reviewer of Oracle Exadata writes "Offers a variety of valuable features". On the other hand, the top reviewer of Snowflake writes "Good usability, good data sharing and elastic compute features, and requires less DBA involvement". Oracle Exadata is most compared with Oracle Database Appliance, Teradata, Oracle Autonomous Data Warehouse, Amazon Redshift and VMware Tanzu Data Services, whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and Matillion ETL. See our Oracle Exadata vs. Snowflake report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.
This is a large and complex question and depends on the use case and scale. Each platform has its advantages and there are significant pros and cons for each platform. I am an independent consultant; I teach courses about these platforms and how to select one; and I advise clients.
If you would like to have a discussion about your requirements, the tradeoffs, and how to go about getting the best platform for your business, please email me at richard@wintercorp.com or book me online (no charge) at solvethepuzzle.biz