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 loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"The performance and scalability are awesome."
"The analytics have been very good. We've found them to be quite useful."
"It is a stable and scalable solution."
"It is a very stable tool...It is an extremely scalable tool."
"I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system."
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"A very good integration feature that restricts access to unauthorized people."
"The way it is built and designed is valuable. The way the shared model is built and the way it exploits the power of the cloud is very good. Certain features related to administration and management, akin to Oracle Flashback and all that, are very important for modern-day administration and management. It is also good in terms of managing and improving performance, indexing, and partitioning. It is sort of completely automated. Everything is essentially under the hood, and the engine takes care of it all. As a data warehouse on the cloud, Snowflake stands strong on its ground even though each of the cloud providers has its own data warehouse, such as Redshift for AWS or Synapse for Azure."
"The ETL and data ingestion capabilities are better in this solution as compared to SQL Server. SQL Server doesn't do much data ingestion, but Snowflake can do it quite conveniently."
"This solution has helped our organization by being easy to maintain and having good technical support."
"This is the advanced version of the cloud version, so it's really a flexible tool. If you have it implemented at home, you can access it from anywhere."
"Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert."
"A user-friendly and reliable solution."
"Snowflake's most valuable features are data enrichment and flattening."
"The product is quite fast."
"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."
"The initial setup was pretty complex. It was not easy."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"The installation process is complex. Oracle can make the installation process better."
"It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment."
"I would like to see an on-premise solution in the future."
"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."
"The solution lacks visibility options."
"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."
"These days, they are pushing users towards the GUI or graphical version. However, I am more familiar with the classic version. I'd like to continue to work with it using the older approach."
"The scheduling system can definitely be better because we had to use external airflow for that. There should be orchestration for the scheduling system. Snowflake currently does not support machine learning, so it is just storage. They also need some alternatives for SQL Query. There should also be support for Spark in different languages such as Python."
"I can only access Snowflake from the web. It would be better if we could have an app that we can install locally on our laptops to connect to the server without needing to go to the web page. Apart from that, it's hard to point out any limitations in the tool."
"We would like to see more security including more masking and more encryption at the database level."
"Availability is a problem."
"Their UiPath, the workspace area, needs some work."
"Snowflake has to build more capabilities because they have only built very few adapters, but they're growing and they're building. They should provide provisions to collect ETL pipeline capabilities, reduce developer work, and make more rapid application development, rather than some customizations. There are very few options, but they are building. I hope they will build ETL rapid application development provisions with more variety."
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.