"Self-patching and runs machine-learning across its logs all the time"
"The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle."
"The performance and scalability are awesome."
"The solution integrates well with Power BI."
"The speed of data loading and being able to quickly create the environment are most valuable."
"Snowflake is a database, and it is very good and useful. The most interesting part is that memory management is very good in Snowflake. For a business intelligence project, SQL Server is taking a lot of time for reporting services. There are a lot of calculations, and the reporting time is shown as two minutes, whereas Snowflake is taking just two seconds for the same reporting services."
"Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert."
"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."
"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."
"The syntax is advanced which reduces the time to write code."
"The solution is very easy to use."
"Data sharing is a good feature. It is a majorly used feature. The elastic compute is another big feature. Separating compute and storage gives you flexibility. It doesn't require much DBA involvement because it doesn't need any performance tuning. We are not really doing any performance tuning, and the entire burden of performance tuning and SQL tuning is on Snowflake. Its usability is very good. I don't need to ramp up any user, and its onboarding is easier. You just onboard the user, and you are done with it. There are simple SQL and UI, and people are able to use this solution easily. Ease of use is a big thing in Snowflake."
"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."
"It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment."
"The initial setup was pretty complex. It was not easy."
"They should improve the reporting tools."
"There is a scope for improvement. They don't currently support integration with some of the Azure and AWS native services. It would be good if they can enhance their product to integrate with these services."
"For the Snowflake database, there should be some third-party features for the ETL. It would also be good to be able to use some kind of controls to get the data either from another database or a flat file. Its price should be improved. It should be cheaper than Microsoft."
"It would be better if they had a data profile tool that tells me where the gaps are in my time series data."
"In future releases, it can also support full unstructured data."
"Pricing is an issue for many customers."
"There is a need for improvements in the documentation, this would allow more people to switch over to this solution."
"If they could bring in some tools for data integration, it would be really great."
More Oracle Autonomous Data Warehouse Pricing and Cost Advice →
Oracle Autonomous Data Warehouse is ranked 9th in Cloud Data Warehouse with 4 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 49 reviews. Oracle Autonomous Data Warehouse is rated 9.0, while Snowflake is rated 8.4. The top reviewer of Oracle Autonomous Data Warehouse writes "Self-patching means I generally don't need a DBA; detailed analytics make it very capable". 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 Microsoft Azure Synapse Analytics, Oracle Exadata, Amazon Redshift, BigQuery and Azure Data Factory, whereas Snowflake is most compared with Microsoft Azure Synapse Analytics, Amazon Redshift, Vertica, AWS Lake Formation and SAP BW4HANA. 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.