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."I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system."
"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."
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"Self-patching and runs machine-learning across its logs all the time"
"The product is easy to use."
"The performance and scalability are awesome."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"It is a stable and scalable solution."
"It's user-friendly. It's SQL-driven. The fact that business can also go to this application and query because they know SQL is the biggest factor."
"It's ultra-fast at handling queries, which is what we find very convenient."
"The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power."
"The most valuable feature of Snowflake is it's an all-in-one data warehousing solution."
"From a data warehouse perspective, it's an excellent all-round solution. It's very complete."
"The technical support is pretty good, particularly if you are a more technical user."
"The most valuable feature of Snowflake is its performance. We can access the data quickly. Additionally, it handles structured and non-structured data."
"Can be leveraged with respect to better performance, auto tuning and competition."
"The installation process is complex. Oracle can make the installation process better."
"The initial setup was pretty complex. It was not easy."
"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."
"Ease of connectivity could be improved."
"A lot of the tools that were previously there have now been taken away."
"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."
"I think that Snowflake could improve its user interface. The current one is not interactive."
"The solution should offer an on-premises version also. We have some requirements where we would prefer to use it as a template."
"The product's performance could be improved."
"Snowflake could improve if they had an Operational Data Store(ODS) space."
"The user interface continues to be an issue, especially when we need to get data out of Snowflake. It's very easy to get data in, but it's not too easy to get it out or extract it."
"If you go with one cloud provider, you can't switch."
"Support needs improvement, as it can take several days before you get some initial support."
"We would like to see more security including more masking and more encryption at the database level."
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 95 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 Amazon EMR. 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.