No more typing reviews! Try our Samantha, our new voice AI agent.

BigQuery vs TIBCO Live Datamart comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

BigQuery
Average Rating
8.2
Reviews Sentiment
6.8
Number of Reviews
44
Ranking in other categories
Cloud Data Warehouse (2nd)
TIBCO Live Datamart
Average Rating
9.0
Reviews Sentiment
7.0
Number of Reviews
2
Ranking in other categories
Data Warehouse (21st)
 

Featured Reviews

Mikah Sellers - PeerSpot reviewer
Principal at Sgt Suds
Has supported detailed policy and education analysis with low-code data exploration
I do not use AWS as my main cloud provider within the company and am not currently using it with AWS. My company did not buy it through the AWS Marketplace as I'm the founder of the company. I do not use BigQuery's integration with Google Analytics for custom behavior analysis. I have not utilized the geospatial analysis capabilities with BigQuery as I'm doing mostly human capital work, so geospatial wouldn't make sense. I would rate their service on a scale of one to 10 for Google as ten. I would rate BigQuery as nine out of 10. My experience with the pricing for BigQuery was through a grant from Google. Their pricing is fairly priced and pretty comparable to Microsoft's offering. I haven't had direct experience, but I did look at the pricing of the Microsoft offering and it's pretty similar. I do not deal with Google AI tools such as Vertex.
Mohsin Pathan - PeerSpot reviewer
Associate Vice President - Solutions, presales & services at Bahwan CyberTek
Standout features are real-time dashboards and powerful aggregation
This product has a powerful aggregating feature which is great. It also has its own APIs. Whenever the data comes in, it can be streamed out anywhere. It's the only solution that provides real-time dashboards. Tableau doesn't have this feature. The three variants of historical data, real-time data and predicted data from Spitfire, give more strength to LiveDatamart without any dependency on other products. The product is easy to set up with very low maintenance required.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"It has a well-structured suite of complimentary tools for data integration and so forth."
"The solution's reporting, dashboard, and out-of-the-box capabilities match exactly our requirements."
"BigQuery allows for very fast access, and it is efficient in handling large datasets compared to other SQL databases."
"The setup is simple."
"The main thing I like about BigQuery is storage. We did an on-premise BigQuery migration with trillions of records. Usually, we have to deal with insufficient storage on-premises, but in BigQuery, we don't get that because it's like cloud storage, and we can have any number of records. That is one advantage. The next major advantage is the column length. We have some limits on column length on-premises, like 10,000, and we have to design it based on that. However, with BigQuery, we don't need to design the column length at all. It will expand or shrink based on the records it's getting. I can give you a real-life example based on our migration from on-premises to GCP. There was a dimension table with a general number of records, and when we queried that on-premises, like in Apache Spark or Teradata, it took around half an hour to get those records. In BigQuery, it was instant. As it's very fast, you can get it in two or three minutes. That was very helpful for our engineers. Usually, we have to run a query on-premises and go for a break while waiting for that query to give us the results. It's not the case with BigQuery because it instantly provides results when we run it. So, that makes the work fast, it helps a lot, and it helps save a lot of time. It also has a reasonable performance rate and smart tuning. Suppose we need to perform some joins, BigQuery has a smart tuning option, and it'll tune itself and tell us the best way a query can be done in the backend. To be frank, the performance, reliability, and everything else have improved, even the downtime. Usually, on-premise servers have some downtime, but as BigQuery is multiregional, we have storage in three different locations. So, downtime is also not getting impacted. For example, if the Atlantic ocean location has some downtime, or the server is down, we can use data that is stored in Africa or somewhere else. We have three or four storage locations, and that's the main advantage."
"BigQuery is similar to Snowflake in the way it manages data analytics and completely decouples storage from compute, offering a 100% managed, infrastructure-free solution where you can build an end-to-end data platform directly from a browser console."
"The initial setup is simple."
"Once we moved to BigQuery, we saw ROI in terms of cost savings, with 27% performance improvement in most of our queries and total costs reduced by about 17%."
"You can create your own rules that include mathematic calculations."
"The solution is mature and stable, even more so since it was acquired by TIBCO."
"The three variants of historical data, real-time data and predicted data from Spitfire, give more strength to LiveDatamart without any dependency on other products."
"The solution has a powerful aggregating feature"
 

Cons

"The process of migrating from Datastore to BigQuery should be improved."
"There are some limitations in the query latency compared to what it was three years ago."
"When I execute a query, the dashboard doesn't always present the output seamlessly. Troubleshooting requires opening each pipeline individually, which is time-consuming."
"I would like to see version-based implementation and a fallback arrangement for data stored in BigQuery storage. These are some features I'm interested in."
"Sometimes, support specialists might not have enough experience or business understanding, which can be an issue."
"The main challenges are in the areas of performance and cost optimizations."
"BigQuery can be very expensive if not used properly. Introducing AI tools that would allow you to optimize the data extraction process is an area of serious improvement."
"There are many tools that you have to use with BigQuery that are different services also provided for by Google. They need to all be integrated into BigQuery to make the solution easier to use."
"The solution's setup could be quicker and easier."
"Improvements need to be made on the load balancing side."
"Live Datamart runs on JVM which only holds Java and only 60 GB of data. If you try to get more out of it than that, it crashes."
 

Pricing and Cost Advice

"The product operates on a pay-for-use model. Costs include storage and query execution, which can accumulate based on data volume and complexity."
"We are above the free threshold, so we are paying around 40 euros per month for BigQuery."
"1 TB is free of cost monthly. If you use more than 1 TB a month, then you need to pay 5 dollars extra for each TB."
"BigQuery pricing can increase quickly. It's a high-priced solution."
"The pricing is adaptable, ensuring that organizations can tailor their usage and costs based on their specific requirements and configurations within the Google Cloud Platform."
"The solution is pretty affordable and quite cheap in comparison to PDP or Cloudera."
"BigQuery is inexpensive."
"One terabyte of data costs $20 to $22 per month for storage on BigQuery and $25 on Snowflake. Snowflake is costlier for one terabyte, but BigQuery charges based on how much data is inserted into the tables. BigQuery charges you based on the amount of data that you handle and not the time in which you handle it. This is why the pricing models are different and it becomes a key consideration in the decision of which platform to use."
"The solution might be considered a bit expensive because it competes with open-source products."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
915,341 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Outsourcing Company
14%
Financial Services Firm
14%
Media Company
10%
Manufacturing Company
9%
No data available
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business15
Midsize Enterprise10
Large Enterprise21
No data available
 

Questions from the Community

What is your experience regarding pricing and costs for BigQuery?
I believe the cost of BigQuery is competitive versus the alternatives in the market, but it can become expensive if the tool is not used properly. It is on a per-consumption basis, the billing, so ...
What needs improvement with BigQuery?
The queries that BigQuery provides are not optimized at a greater level. For simple tasks it is good, but if I want to write complex analyzing queries, it doesn't give the queries up to the mark, s...
What is your primary use case for BigQuery?
My main use case for BigQuery is the analysis of our data, creating dashboards from large datasets, and querying the databases that we have, including both structured and unstructured data imported...
Ask a question
Earn 20 points
 

Also Known As

BQ
Streambase, TIBCO LiveView Data Mart
 

Overview

 

Sample Customers

Information Not Available
Aerospace Corporation, Balfour Beatty Infrastructure Services, Banco Sabadell, Bolton Borough Council
Find out what your peers are saying about Snowflake Computing, Google, Databricks and others in Cloud Data Warehouse. Updated: September 2026.
915,341 professionals have used our research since 2012.