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."Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"The analytics have been very good. We've found them to be quite useful."
"It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions."
"A very good integration feature that restricts access to unauthorized people."
"Self-patching and runs machine-learning across its logs all the time"
"The product is easy to use."
"It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues."
"The solution integrates well with Power BI."
"The most valuable feature is the clone copy."
"The product's most important feature is unloading data to S3."
"Snowflake has a variety of other ETL provisions that they provide. You can use your own ETL pipeline. Additionally, they provide adapters, and they are always evolving, it is a well-developed solution."
"It is very fast and the performance is great."
"The syntax is advanced which reduces the time to write code."
"The feature that is really striking is the ability to translate the SQL workloads into the NoSQL version that can be used by Snowflake."
"The solution speeds up the process of onboarding."
"The most valuable features are the clustering, LS50, being able to change the size, the pay per use feature, the flexibility with many different sources and analytic applications."
"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."
"I would like to see Application Express and Oracle R Enterprise fully supported, and I would like to see Oracle Data Mining supported as a front end."
"I would like to see an on-premise solution in the future."
"Ease of connectivity could be improved."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"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."
"A lot of the tools that were previously there have now been taken away."
"My main suggestion for Oracle is the configuration and key values that come for JSON files. When we create a table, especially if you see in our RedShift or some other stuff, if I create a table on top of a JSON file with multiple array columns or superset columns, those column values create some difficulty in Oracle."
"The cost efficiency and monitoring of this solution could be improved. It's easy to spend a lot on Snowflake and it does offer monitoring tools but they're pretty basic."
"They have a new console, but I couldn't figure out anything in the new console. So, if I shift to the old console, I can figure out where to create the database schema and other things, but I have no idea where to go in the new console. That's one thing they can improve. I don't know why they created a new console to confuse. The old, classic console is much better."
"Availability is a problem."
"They should improve the reporting tools."
"There are some stored procedures that we've had trouble with. The solution also needs to fine-tune the connectors to be able to connect into the system source."
"Portability is a big hurdle right now for our clients. Porting all of your existing SQL ecosystem, such as stored procedures, to Snowflake is a major pain point. Currently, Snowflake stored procedures use JavaScript, but they should support SQL-based stored procedures. It would be a huge advantage if you can write your stored procedures using SQL. It seems that they are working on this feature, and they are yet to release it. I remember seeing some notes saying that they were going to do that in the future, but the sooner this feature comes out, it would be better for Snowflake because there are a lot of clients with whom I'm interacting, and their main hurdle is to take their existing Oracle or SQL Server stored procedures and move them into Snowflake. For this, you need to learn JavaScript and how it works, which is not easy and becomes a little tricky. If it supports SQL-based procedures, then you can just cut-paste the SQL code, run it, and easily fix small issues."
"Their UiPath, the workspace area, needs some work."
"In future releases, it can also support full unstructured data."
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 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.