We performed a comparison between Oracle Big Data Appliance and Snowflake based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."This is a comprehensive solution that is easy to deploy."
"Because Big Data Appliance allows me to have a single source of truth, it means I have clean data that can be monetized and leveraged to gain more insights with real-time reports from the dashboard."
"The best thing about the product is that the end-user can build the reports by themselves without really knowing anything about databases."
"It is a very good platform. It can handle structured and semi-structured data, and it can be used for your data warehouse or data lake. It can load and deal with any data that you have. It can extract data from an on-premises database or a website and make it available in the cloud. It has very fast implementation and integration as compared to other solutions. There is no need for the DBA to manage or do the day-to-day DBA tasks, which is one of the greatest things about it."
"From a data warehouse perspective, it's an excellent all-round solution. It's very complete."
"It helped us to build MVP (minimum viable product) for our idea of building a data warehouse model for small businesses."
"The initial setup is very simple."
"We find the data sharing and data marketplace aspects of Snowflake absolutely amazing."
"It was relatively easy to use, and it was easy for people to convert to it."
"Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake."
"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 seems like the deployment of repositories has become more difficult in later versions of the product rather than easier."
"From a technical perspective, Big Data Appliance could be improved with more innovation in the AI and machine-learning parts instead of relying on Cloudera."
"The product should be simplified for the average user."
"To ensure the proper functioning of Snowflake as an MDS, it relies heavily on other partner 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."
"I have heard people having difficulty with the machine learning model, so there may be room for improvement."
"Snowflake has to improve their spatial parts since it doesn't have much in terms of geo-spatial queries."
"Support needs improvement, as it can take several days before you get some initial support."
"These aren't as crucial, but there are common errors sometimes where the database is down, or a table is nullified and a new table is added and you are not given access to that. With those errors, you don't have permissions."
"The data science functionality could be improved in terms of the machine learning process."
"Snowflake could improve if they had an Operational Data Store(ODS) space."
Oracle Big Data Appliance is ranked 12th in Data Warehouse with 5 reviews while Snowflake is ranked 1st in Data Warehouse with 92 reviews. Oracle Big Data Appliance is rated 8.0, while Snowflake is rated 8.4. The top reviewer of Oracle Big Data Appliance writes "Fast, and you don't need technical expertise to use it and produce results". 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 Big Data Appliance is most compared with Oracle Exadata, Apache Hadoop, Teradata and Microsoft Azure Synapse Analytics, whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and AWS Lake Formation.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all 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.