App comparison

Add up to 4 apps below to see how they compare. You can also use the "Compare" buttons while browsing.

GetApp offers objective, independent research and verified user reviews. We may earn a referral fee when you visit a vendor through our links. Learn more

Snowflake vs Oracle Database Comparison

Add to Compare

Compare similar apps

MySQL logo

MySQL

4.6

Microsoft SQL Server logo

Microsoft SQL Server

4.6

Google Cloud logo

Google Cloud

4.7

PostgreSQL logo

PostgreSQL

4.6

Google Cloud BigQuery logo

Google Cloud BigQuery

4.8

Amazon Redshift logo

Amazon Redshift

4.4

Good recommendations?

Overview

Category Leaders

Snowflake is a cloud data platform that can enable critical data workloads and secure collaboration. This solution can be...

Category Leaders

Oracle Database is a data warehouse software designed to help businesses of all sizes manage data and automate recurring...

  • Platforms supported
  • Web-based
  • iPhone app
  • Android app
  • Windows Phone app
  • Typical customers
  • Freelancers
  • Small businesses
  • Mid size businesses
  • Large enterprises
  • Customer support
  • Phone
  • Online
  • Knowledge base
  • Video tutorials
  • Platforms supported
  • Web-based
  • iPhone app
  • Android app
  • Windows Phone app
  • Typical customers
  • Freelancers
  • Small businesses
  • Mid size businesses
  • Large enterprises
  • Customer support
  • Phone
  • Online
  • Knowledge base
  • Video tutorials

Video & Screenshots

Pricing

Starting from

23

Per month

  • Free trial available
  • Credit cardless trial
  • Free account
  • Subscription based

Starting from

ic-pricetag

No pricing info

  • Free trial available
  • Credit cardless trial
  • Free account
  • Subscription based

User reviews

4.6

78

5

4

3

2

1

52

23

3

0

0

  • Value for money
  • Ease of use
  • Features
  • Customer support
97%
would recommend this app

4.6

458

5

4

3

2

1

289

141

23

3

2

  • Value for money
  • Ease of use
  • Features
  • Customer support
96%
would recommend this app

Pros

They just added visualization and it is amazing. Super fast to run queries and extremely easy to use and share.
I almost used all the OLAP databases but this is what I loved a lot, less in price Great Performance & User Friendly.
It is a great data warehouse that allows you to create different tables very quickly. It has been great to use even if there are some quirks with it.

Pros

I am very happy with the software, in fact, I am making an living as an oracle DBA, once you know the product, it is a super good database product.
For me this is the best Database, because it is safe, reliable and very nice organized. It handles tremendous amounts of data without problems.
If you know SQL, then you can use Oracle Database. Easy interface, easy of use and a great variety of resources makes this tool excellent to develop and maintain your own database.

Cons

Script error messages could be more specific and helpful with identifying errors and troubleshooting.
Costly if data is too big. You can't own the data, you have to depend on the Data Engineering team.
A minute potion of the syntax of sql is slightly different from psql, which makes it hard to migrate the application from different psql service providers.

Cons

It is really unusual to allow a bad programmer to use a sequence for several tables. Beyond that that would be a bad development practice the biggest mistake is that the tool invites you to commit it.
This comment is about personal preference: it is sometimes difficult to switch between Oracle and MS-SQL, which is a problem as we run software that uses both.
But sometimes it will keep having you put information in at every startup of your computer at that part can be annoying.
  • Vendor responds to reviews
  • Last reviewa month ago
  • Vendor responds to reviews
  • Last review3 months ago

Key features

  • Total features31
  • Access Controls/Permissions
  • Activity Dashboard
  • Alerts/Notifications
  • Application-Level Analysis
  • Backup and Recovery
  • Cloud Backup
  • Compliance Management
  • Compression
  • Dashboard
  • Data Capture and Transfer
  • Data Cleansing
  • Data Connectors
  • Data Dictionary Management
  • Data Discovery
  • Data Integration
  • Data Management
  • Data Migration
  • Data Replication
  • Data Retrieval
  • Data Security
  • Data Storage Management
  • Data Synchronization
  • Data Virtualization
  • Data Visualization
  • Database Conversion
  • ETL - Extract Transfer Load
  • Encryption
  • For NoSQL Databases
  • High Volume Processing
  • In-Database Processing
  • Information Governance
  • ML Algorithm Library
  • Metadata Management
  • Model Training
  • Multiple Programming Languages Supported
  • Multitenancy
  • OLAP
  • Performance Analysis
  • Real-Time Data
  • Real-Time Monitoring
  • Relational Database Management
  • Reporting/Analytics
  • Role-Based Permissions
  • Secure Data Storage
  • Third-Party Integrations
  • User Management
  • Workflow Management
  • Total features28
  • Access Controls/Permissions
  • Activity Dashboard
  • Alerts/Notifications
  • Application-Level Analysis
  • Backup and Recovery
  • Cloud Backup
  • Compliance Management
  • Compression
  • Dashboard
  • Data Capture and Transfer
  • Data Cleansing
  • Data Connectors
  • Data Dictionary Management
  • Data Discovery
  • Data Integration
  • Data Management
  • Data Migration
  • Data Replication
  • Data Retrieval
  • Data Security
  • Data Storage Management
  • Data Synchronization
  • Data Virtualization
  • Data Visualization
  • Database Conversion
  • ETL - Extract Transfer Load
  • Encryption
  • For NoSQL Databases
  • High Volume Processing
  • In-Database Processing
  • Information Governance
  • ML Algorithm Library
  • Metadata Management
  • Model Training
  • Multiple Programming Languages Supported
  • Multitenancy
  • OLAP
  • Performance Analysis
  • Real-Time Data
  • Real-Time Monitoring
  • Relational Database Management
  • Reporting/Analytics
  • Role-Based Permissions
  • Secure Data Storage
  • Third-Party Integrations
  • User Management
  • Workflow Management

Integrations

  • Total integrations257
  • Bitbucket
  • Datadog
  • Dropbox Business
  • GitHub
  • GitLab
  • Google Drive
  • HubSpot CRM
  • Jenkins
  • Jira
  • Microsoft 365
  • Microsoft Azure
  • Microsoft Teams
  • NetSuite
  • PagerDuty
  • ServiceNow
  • Shopify
  • Slack
  • Trello
  • Zapier
  • Zendesk Suite
  • Total integrations62
  • Bitbucket
  • Datadog
  • Dropbox Business
  • GitHub
  • GitLab
  • Google Drive
  • HubSpot CRM
  • Jenkins
  • Jira
  • Microsoft 365
  • Microsoft Azure
  • Microsoft Teams
  • NetSuite
  • PagerDuty
  • ServiceNow
  • Shopify
  • Slack
  • Trello
  • Zapier
  • Zendesk Suite

User reviews that mention these apps

AvatarImg

Verified reviewer

Telecommunications, 5,001-10,000 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Snowflake logo

Snowflake

Snowflake - Best Cloud database you could get to build data warehouse

Reviewed a year ago

I would give my over all rating for this product as 10 on 10 . Coming from ORACLE background I really liked this product . You could avoid the entire database management tasks since its been taken care by the snowflake itself.

Pros

The I/O operation within the database are handled well . Repeated same query results are being cached to avoid I/O operations, which is great!

Cons

The Task functionality can have a separate UI to manage the scheduled tasks . The Web workbook could have been improved with more features.

AvatarImg

Verified reviewer

Telecommunications, 5,001-10,000 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Snowflake logo

Snowflake

Snowflake: Modern OLTP DB

Reviewed a year ago

Great to have snowflake as out OLTP system. High volume data processing are happening real quick.

Pros

Performance is outstanding. No explicit maintenance is needed. High availability. No need to worry about SQL processing speed, easy scalability.

Cons

Quit expensive while comparing to other database.

AvatarImg

Verified reviewer

Pharmaceuticals,

Used weekly for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support

Share this review:

Snowflake logo

Snowflake

Did a proof of concept for my company comparing Snowflake to other databases that we use.

Reviewed 7 years ago
Pros

The three features of many great features that stand out are: -The REAL separation of compute and storage gives the ultimate flexibility. You can match workloads to the proper level of compute without having one workload collide with another. You can optimize what you spend by only using what you need with the ability to change the size of your compute multiple times a day and the ability to...

Cons

One of the positives above can also be a negative. Snowflake is a service and not software that you can run in your own data center or your own cloud VPC. This CON can be overcome with end to end encryption where you own the key and other Snowflake features.

JL
AvatarImg

John L.

Sports, 11-50 employees

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Snowflake logo

Snowflake

Operate a relational database in the cloud!

Reviewed 3 years ago
Pros

With Snowflake, developing and deploying a cloud based relational database infrastructure has never been simpler.

Cons

Support for unstructured data could be better.

AZ
AvatarImg

Alex Z.

Real Estate, 201-500 employees

Used daily for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

Snowflake logo

Snowflake

Great product

Reviewed 2 years ago
Pros

I really like the speed and the quality of the Snowflake UI. It is the easiest database tool I have ever used in my career.

Cons

It is costly to use Snowflake so as a company you always have to fight for the value it brings to the company as a whole.

AvatarImg

Verified reviewer

Information Technology and Services, 501-1,000 employees

Used weekly for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Snowflake logo

Snowflake

Snowflake - Speed in the Cloud!

Reviewed 5 years ago

Maintaining on-premise database systems is expensive and maintenance heavy. Moving to a cloud database like Snowflake cuts down costs and is easy to maintain also. Since Snowflake supports a variety of flat file formats as sources, it becomes easier to bulk load data as flat files in storage spaces like AWS S3. Migrating data from cloud storage to Snowflake becomes much more easier.

Pros

Snowflake is a database and a storage warehouse on the cloud. Since it's scalable on demand, retrieving data through Snowflake Warehouses is lighting fast. All the computing power required to run the SQL queries are taken care by the Warehouse size we choose. If a query is taking too long to run a quick switch to a bigger warehouse does wonders. Migrating and loading data into Snowflake is a breeze too via Snowflake Stages and COPY TO commands.

Cons

Snowflake doesn't enforce constraints, especially primary keys. So, care should be taken while doing INSERTs and UPSERTs to maintain data integrity. This lack of this feature is understandable since it's projected more as a storage warehouse.

AvatarImg
AvatarImg

Matthew C.

Marketing and Advertising, 51-200 employees

Used daily for less than 6 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Snowflake logo

Snowflake

Impressive product with a promising future

Reviewed 3 years ago

Overall, Snowflake has made managing, processing, aggregating and sharing data easier across the organization. It still has some work to do in terms of UI to make the user experience smoother, but the underlying technology at its core is solid and solves many issues with backups, data retention and overall user error in working with data.

Pros

The "Time Travel" aspect of Snowflake, being able to pick a point in time and see the state/contents of nearly any table is astonishing. Very useful and impressive feature. What is equally as impressive is the overall performance of the platform. I've worked with Oracle, DB2, MySQL, Vertica, Teradata, ParAccel, and others. Maybe not always in the most optimal configurations, but Snowflake's performance has been overall the best in my experience.

Cons

As a newer platform, there are certain convenience elements that Snowflake lacks. - No auto-complete of object names. - No "easy" import wizard to import data. - Some bugs with the browser-based interface (worksheets did not properly save). - Limited customizations to filter out the tables or objects you don't work with regularly. Always shows full list, oftentimes very large.

MM
AvatarImg

MANAS M.

Retail, 1,001-5,000 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Snowflake logo

Snowflake

Cloud based database and warehousing improves performance and reduces cost

Reviewed 4 years ago

its a great experience, our API's have become faster in response time, we stoped worrying about storage size and computation power , now its scalable and decoupled

Pros

This is a fully managed cloud data-warehousing solution , or database as a service, the advantage of this with the traditional server based database is the performance boost, here the warehouse or the computing power and data storage is fully decoupled, this means , you can pay for what you need, your warehouse can be in sleep when its not in use so you save money, you can modify the size of warehouse...

Cons

we use to have some outages in the past, which was resolved quick, now a days i don't see those that's a good thing, if you are trying to migrate from a psql to snowflake then some query syntaxes will be different

AvatarImg
AvatarImg

Mansi M.

Computer Software, 10,001+ employees

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Snowflake logo

Snowflake

Great platform that can be used to govern your data, and manage data warehousing

Reviewed a year ago
Pros

I like best that they have unified all the data-relevant features on one platform, so be it a single database or end-to-end data management, all can be done using snowflake. I was able to store structured, semi-structured, and unstructured data, all in one place.

Cons

Their support team was a little slow in addressing my queries. I belive they can improve their onboarding process.

AvatarImg
AvatarImg

Todd G.

Electrical/Electronic Manufacturing, 5,001-10,000 employees

Used daily for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

Snowflake logo

Snowflake

Snowflake, Unique just like Us

Reviewed 5 years ago

My overall experience with Snowflake has been a pleasurable one. Though there have been some frustrations at times I have learned and overcome and become a better programmer, and SQL developer for it. I feel like Snowflake is an old friend now.

Pros

The thing that I like most about this software is really if you can think it you can do it with Snowflake. I mean as long as it deals with data. I first started at my company using oracle and I didn't stick with that for long because we adopted snowflake. When we started using snowflake my knowledge of SQL just jumped sky high. Instead of just selecting from tables, I was using cte's and partitions and all of that fun stuff. Snowflake made it super easy to understand and learn. The ability it has to handle the amount of columns that it does is amazing.

Cons

There is a little bit of a learning curve to get the hang of it. But on the surface it is just like any other sql language and you just have to figure out the different quirks that it has. I wish it could give data instantaneously and read my mind on what I want but that is pretty much impossible so I'm going to stick with what I have.

AvatarImg
AvatarImg

David W.

Information Services, 201-500 employees

Used daily for 6-12 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Snowflake logo

Snowflake

The incredible power of a cloud data platform

Reviewed 2 years ago

We use Snowflake to aggregate hundreds and hundreds of disparate databases across many different clouds and platforms into one single data warehouse allowing us, for the first time, to give customers visibility of all their data across all our products.

Pros

The concept of Snowflake is so clever - mass amounts of micro-partitions of data, with the storage and compute separated. It is a smart product that enables so much functionality and capability. It is more than simply a database in the cloud, it is truly a feature-rich platform that offers a huge amount of functionality. I also very much like that role-based access is a fundamental part of it. Its data sharing features are terrific too.

Cons

Some things are a little tricky to figure out, like row-level policies the first time you do it, or data masking. There are no triggers. Scheduled tasks are a little limited. Stored procedures are not as simple as I'd like.

MK
AvatarImg

Mahesh K.

Retail, 1,001-5,000 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Snowflake logo

Snowflake

Data warehousing and computation as a cloud service

Reviewed 3 years ago

This really speeds up your sql computation, since we can use different computation warehouse on a same datasource, which distributes the load, it is a great experience with Snowflake

Pros

This is a cloud database and warehousing service, the syntax of snowflake is like psql, they have a good community support and good documentations for all the queries, they are faster than traditional databases, and the are charged separately for compute power and the storage space , which makes it usable in a flexible cost effective manor, good support team, always respond and try to resolve the issues if any was reported, and also helped us identify any cost saving scope

Cons

The System esoterically shows outage, these type of outages are informed to use by the support team, and they resolve it quickly, a minute potion of the syntax of sql is slightly different from psql, which makes it hard to migrate the application from different psql service providers

AvatarImg

Verified reviewer

Financial Services, 51-200 employees

Used daily for less than 6 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Snowflake logo

Snowflake

A fantastic data warehouse solution that solved all our problems

Reviewed 2 years ago

I have an amazing experience using Snowflake. It is better than out previous Data Warehouse solution in everything I can think of (besides pricing). We are very satisfied with, and I feel very confident on having it as the backend of all our data needs. It is also important to notice that we had a very pleasent experience with Snowflake's sales and account managers: they were very helpful and not pushy at all.

Pros

Snowflake is exteremely stable and easy to setup. I was able to turn it on and have a reliable Data Warehouse that didn't require me having a lot of cloud knowledge to administrate. The database administration through the UI is intuitive and the Roles dynamic helps with implementing good data governance and compliance pratics inside the company. Snowflake also offers user security options out of the box, which was a huge improvement for us. The doccumentation is very well written and SnowSQL offest a lot of useful functions. The main improvement on this front was how Snowflake treats JSON, which helped us a lot.

Cons

If your revenue is not on US dollars, Snowflake is an expensive product, there is no way around that. It is indeed a very good service that charges accordingly. We are using the smallest cluster possible and it was necessary to do some convincing inside the company to approve it for our budget. That being said, the smallest cluster we are using is more than enough for our needs and will be for a long time, so it will take a long time for this cost to increase again, but it was a pretty big budget increase initially.

AvatarImg
AvatarImg

Anastasiia M.

Chemicals, 5,001-10,000 employees

Used weekly for 6-12 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend5/10

Share this review:

Oracle Database logo

Oracle Database

Oracle Database for data storage

Reviewed 2 years ago
Pros

I have used Oracle Database for data storage and performing some custom SQL Queries in order to export data and use it in other Analytical tools.

Cons

Oracle Database is a very complex and complicated RDBMS. As a person with non technical background I found it hard to use. Although there are quite a lot materials to learn (tutorials, documentation, etc.) - many of these materials are of bad quality. Also the queries took considerable amount of time to finish - the whole system was hard to scale due to on premise architecture. I found tools like Snowflake much easier to learn and work with.