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 product is easy to use."
"The performance and scalability are awesome."
"Self-patching and runs machine-learning across its logs all the time"
"It is a very stable tool...It is an extremely scalable tool."
"It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues."
"The solution integrates well with Power BI."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"The analytics have been very good. We've found them to be quite useful."
"The solution is easy to use."
"It is a highly scalable solution. There is no limit on storage or computing."
"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."
"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."
"It is very fast and the performance is great."
"Snowflake's most valuable features are data enrichment and flattening."
"My company wanted to have all our data in one single place and this what we use Snowflake for. Snowflake also allows us to build connectors to different data sources."
"The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power."
"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."
"It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment."
"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."
"A lot of the tools that were previously there have now been taken away."
"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."
"Sometimes it can be tricky to manage multiple environments if you're purely using Snowflake as your scripting and pipeline environment."
"I don't know about GCP, if they have connected for GCP. If they don't, they should allow for it."
"It would benefit from an administration that allows you to be aware of your credit consumption once you have the service so that you may be sure how many credits you are consuming when you use the platform and to make sure that you are making the most efficient use of these resources. In other words, to improve their interface so that you may monitor the consumption of your credits on Cloud."
"The documentation could improve. They should provide architecture information."
"If they could bring in some tools for data integration, it would be really great."
"The solution could improve the user interface and add functionality to the system."
"The price could be improved."
"It needs a bit more rigor and governance, which is something you don't get with newer tools. This makes it less enterprise scalable. Its governance and structure can be enhanced, which would really be valuable. I would like to see some kind of prebuilt functionality in terms of having almost like a pre-built data warehouse. A functionality for generating automated kind of pieces would be good."
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.