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."The best thing about the product is that the end-user can build the reports by themselves without really knowing anything about databases."
"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."
"Snowflake is scalable both in terms of the amount of data that you can run through it and the number of users that engage with it."
"The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power."
"Its performance is a big advantage. When you run a query, its performance is very good. The inbound and outbound share features are also very useful for sharing a particular database. By using these features, you can allow others to access the Snowflake database and query it, which is another advantage of this solution. It has good security, and we can easily integrate it. We can connect it with multiple source systems."
"Time travel is one feature that really helps us out."
"It is quite easy to manage."
"They separate compute and storage. You can scale storage independently of the computer, or you can scale computing independently of storage. If you need to buy more computer parts you can add new virtual warehouses in Snowflake. Similarly, if you need more storage, you take more storage. It's most scalable in the database essentially; typically you don't have this scalability independence on-premises."
"The initial setup is very simple."
"Everything is automatic, and I don't have to do any maintenance."
"The product should be simplified for the average user."
"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."
"It seems like the deployment of repositories has become more difficult in later versions of the product rather than easier."
"More data governance and access control features would be a welcome addition."
"The pricing of the solution should be much easier to calculate or find by yourself."
"Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway."
"We are yet to figure out how to integrate tools, such as Liquibase, to release changes to our data warehouse model."
"Getting data out of the tool to third-party applications is difficult."
"There could be better ELT tools that are appropriate for Snowflake. We decided on Matillion and it seemed to be the only one. There need to be better choices, it would be great if Snowflake provided an ELT solution that people could use. Additionally, if there was a pure cloud-based ELT tool it would be useful."
"The solution could use a little bit more UI."
"The product's performance could be improved."
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.