Google BigQuery vs. IBM watsonx.data

Google BigQuery is great for being the central datastore and entry point of data if you're on GCP. It seamlessly integrates with other Google products, meaning you can ingest data from other Google products with ease and little technical knowledge, and all of it is near real-time. Being serverless, BigQuery will scale with you, which means you don't have to worry about contention or spikes in demand/storage. This can, however, mean your costs can run away quickly or mount up at short notice.

Incentivized

Datastax Cassandra is a Java based linearly scalable NoSQL database, best-in-class tunable performance, fault tolerant, distributed, masterless, time series database and has easy-to-use administration and monitoring functionality with opscenter. Configured correctly there is no downtime and no data loss. The documentation is exhaustive, and the community is agile and supportive, and Datastax provides good support. For all these reasons, Datastax Cassandra has become a NoSQL technology of choice for many platforms. However it has some time investment on infrastructure and regular operational tasks, and if you do not have bandwidth for it, a managed NoSQL solution like DynamoDB might be more appropriate. Also if you have search needs on Cassandra and do not have corresponding Spark/Solr setup, Datastax Cassandra might not be ideal for you.

Incentivized

• Its serverless architecture and underlying Dremel technology are incredibly fast even on complex datasets. I can get answers to my questions almost instantly, without waiting hours for traditional data warehouses to churn through the data.
• Previously, our data was scattered across various databases and spreadsheets and getting a holistic view was pretty difficult. Google BigQuery acts as a central repository and consolidates everything in one place to join data sets and find hidden patterns.
• Running reports on our old systems used to take forever. Google BigQuery's crazy fast query speed lets us get insights from massive datasets in seconds.

Incentivized

• It doesn't just store data but unlocks potential. I am able to analyse a vast amount of information, identify trends, and predict future outcomes.
• It not only gives me high quality but accessible data as well. It handles missing values, outliers and feature engineering with case.

Incentivized

• It is challenging to predict costs due to BigQuery's pay-per-query pricing model. User-friendly cost estimation tools, along with improved budget alerting features, could help users better manage and predict expenses.
• The BigQuery interface is less intuitive. A more user-friendly interface, enhanced documentation, and built-in tutorial systems could make BigQuery more accessible to a broader audience.

Incentivized

• Integration complexity with Security Tools while watsonx.Data is well-suited for native tools, but integration with third-party security tools requires custom connectors or manual ETL pipelines. which leads to an increase in setup time.
• User interface and query time can be improved.

Incentivized

We have to use this product as its a 3rd party supplier choice to utilise this product for their data side backend so will not be likely we will move away from this product in the future unless the 3rd party supplier decides to change data vendors.

Incentivized

As an open source technology Cassandra can be readily used with or without any commercial support. DataStax provides value-added services and features, and in the end it is up to individual situations to strike a balance between the desirability of such support/service versus the associated cost.

Incentivized

web UI is easy and convenient. Many RDBMS clients such as aqua data studio, Dbeaver data grid, and others connect. Range of well-documented APIs available. The range of features keeps expanding, increasing similar features to traditional RDBMS such as Oracle and DB2

DataStax has a good community built around it and has amazing scalability options. Though the initial setup is a bit costly, in the long run, it makes up for it. It also has powerful monitoring tools and a clean UI.

Incentivized

I have never had any significant issues with Google Big Query. It always seems to be up and running properly when I need it. I cannot recall any times where I received any kind of application errors or unplanned outages. If there were any they were resolved quickly by my IT team so I didn't notice them.

Incentivized

good recovery features

Incentivized

I think Google Big Query's performance is in the acceptable range. Sometimes larger datasets are somewhat sluggish to load but for most of our applications it performs at a reasonable speed. We do have some reports that include a lot of complex calculations and others that run on granular store level data that so sometimes take a bit longer to load which can be frustrating.

Incentivized

scalable product

Incentivized

BigQuery can be difficult to support because it is so solid as a product. Many of the issues you will see are related to your own data sets, however you may see issues importing data and managing jobs. If this occurs, it can be a challenge to get to speak to the correct person who can help you.

Incentivized

We have had a few situations where we caused an outage or something has gone wrong and we are able to get a support person to offer live help within minutes. The escalation process is excellent - the best I've seen - and the support team is incredibly strong. Outside of emergencies, the team is very helpful with general questions and working through data model exercises and the subscription I believe still comes with some hours to help get the data model reviewed.

easy to follow documentation, support is there when needed

Incentivized

use saas service

Incentivized

Google BigQuery of course collects a much much larger array of raw data and can handle (practically) an unlimited amount of data. For a large enterprise like ours that relies on large-scale analytics, this is absolutely imperative. Google BigQuery can also combine GA4 data with external sources (like CRM tools), so our analytics can be unified. Due to our heavy reliance on GA4, Google BigQuery is the natural choice since it is a Google product and has better integration.

Incentivized

I believe DataStax Enterprise is the best in class. There are some things that are different with the schema-less systems but I found DataStax Enterprise easiest to implement while evaluating. The replication is on par or better than others in practice. We are evaluating Astra in our test environment and that has additional benefits we are looking forward to using.

We have continued to expand out use of Google Big Query over the years. I'd say its flexibility and scalability is actually quite good. It also integrates well with other tools like Tableau and Power BI. It has served the needs of multiple data sources across multiple departments within my company.

Incentivized

cognos integration works great

Incentivized

• In some places, Google BigQuery has helped us save some money by avoiding the need for expensive infrastructure and reducing some of the operational costs.
• Scalability is up-to-date and really helpful in multiple places.
• Knowledge transfer is easy as it is very user-friendly, so the learning curve has been reduced.
• Also, it gives us more insights from our data, helping us make smarter decisions for our business.

Incentivized

• for one automation project, we managed to cut cloud storage costs by a third through IBM watsonx.data's lakehouse optimization
• data integration projects have had a 20 % reduction in turnaround times. Can only imagine how that will improve with the Claude partnership

Incentivized