We performed a comparison between Oracle Autonomous Data Warehouse and Snowflake based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The performance and scalability are awesome."
"A very good integration feature that restricts access to unauthorized people."
"With Oracle Autonomous Data Warehouse, things are much simpler. Creating a structure, initializing the servers, extending the servers, those are all things that are very, very easy. That's the main reason we use it."
"It is a very stable tool...It is an extremely scalable tool."
"Self-patching and runs machine-learning across its logs all the time"
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle."
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"Working with Parquet files is support out of the box and it makes large dataset processing much easier."
"The most valuable features of Snowflake are its performance and power."
"The snapshot feature is good, the rollback feature is good and the interface is user-friendly."
"The tool is very easy to use. The solution’s desktop features are also very easy to use. Also, the product’s SQL-based connectivity is also good. It can connect with any tool."
"Its speed and performance were the most valuable. Easy configuration of Snowflake in any cloud was also a benefit."
"The features I found most valuable with this solution are sharing options and built-in time zone conversion."
"The product's most important feature is unloading data to S3."
"The solution is easy to use."
"One of the major problem is creating custom tablespace. The ADB serverless option doesn't support custom tablespace creation, which could cause issues during on-premise database migration that requires specifically named tablespace. There should be an option to create customized tablespace."
"An improvement for us would be the inclusion of support for an internal IP, so we could use it directly with the VCN in Oracle Cloud."
"The initial setup was pretty complex. It was not easy."
"They should make the solution more user-friendly."
"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable."
"It doesn't work well when you have unstructured data or you need online analytics. It is not as nice as Hadoop in these aspects."
"I would like to see an on-premise solution in the future."
"There is a need for more storage to be allocated, but over a period of time, it becomes impossible to reduce it after using it."
"There could be better ELT tools that are appropriate for Snowflake. We decided on Matillion and it seemed to be the only one. There need to be better choices, it would be great if Snowflake provided an ELT solution that people could use. Additionally, if there was a pure cloud-based ELT tool it would be useful."
"Room for improvement would be writebacks. It doesn't support extensively writing back to the database, and it doesn't support web applications effectively. Ultimately, it's a database call, so if we are building web applications using Snowflake, it isn't that effective because there is some turnaround time from the database."
"Their strategy is just to leverage what you've got and put Snowflake in the middle. It does work well with other tools. You have to buy a separate reporting tool and a separate data loading tool, whereas, in some platforms, these tools are baked in. In the long-term, they'll need to add more direct partnerships to the ecosystem so that it's not like adding on tools around Snowflake to make it work. They can also consider including Snowflake native reporting tools versus partnering with other reporting tools. It would kind of change where they sit in the market."
"The price could be improved."
"If we can have a feature where the results can be moved to different tabs, so that I can compare the results with earlier queries before applying the changes, it would be great."
"The cost of the solution could be reduced."
"They should improve the reporting tools."
"The product's performance could be improved."
More Oracle Autonomous Data Warehouse Pricing and Cost Advice →
Oracle Autonomous Data Warehouse is ranked 10th in Cloud Data Warehouse with 16 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 94 reviews. Oracle Autonomous Data Warehouse is rated 8.6, while Snowflake is rated 8.4. The top reviewer of Oracle Autonomous Data Warehouse writes "A tool for data warehousing that offers scalability, stability, and ease of setup". 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 Autonomous Data Warehouse is most compared with Oracle Exadata, Microsoft Azure Synapse Analytics, BigQuery, Amazon Redshift and Teradata, whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and Microsoft Azure Synapse Analytics. See our Oracle Autonomous Data Warehouse vs. Snowflake report.
See our list of best Cloud Data Warehouse vendors.
We monitor all Cloud 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.