Google BigQuery vs. SAP Datasphere

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Google BigQuery
Score 8.7 out of 10
N/A
Google's BigQuery is part of the Google Cloud Platform, a database-as-a-service (DBaaS) supporting the querying and rapid analysis of enterprise data.
$0.04
SAP Datasphere
Score 8.5 out of 10
N/A
SAP Datasphere, the next generation of SAP Data Warehouse Cloud, is a comprehensive data service that enables data professionals to deliver seamless and scalable access to mission-critical business data. It provides a unified experience for data integration, data cataloging, semantic modeling, data warehousing, data federation, and data virtualization. SAP Datasphere enables users to distribute mission-critical business data — with business context and logic preserved — across the data…N/A
Pricing
Google BigQuerySAP Datasphere
Editions & Modules
Standard edition
$0.04 / slot hour
Enterprise edition
$0.06 / slot hour
Enterprise Plus edition
$0.10 / slot hour
No answers on this topic
Offerings
Pricing Offerings
Google BigQuerySAP Datasphere
Free Trial
YesYes
Free/Freemium Version
YesNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional DetailsSAP Datasphere is available as a subscription or consumption-based model. The SAP Datasphere capacity unit (CU) offers an adaptable approach to pricing that enables any workload on any hyperscaler. The number of CUs required is determined by the unique workload, with the ability to tailor the combination of required services within SAP Datasphere utilizing a flexible tenant configuration. The services that contribute to CU consumption are the core application (compute and storage), data lake, BW bridge, data integration, and data catalog (crawling and storage).
More Pricing Information
Community Pulse
Google BigQuerySAP Datasphere
Considered Both Products
Google BigQuery
Chose Google BigQuery
Fully serverless. We don’t manage clusters or warehouses. Requires us to manage virtual warehouses. BigQuery is cheaper for exploratory heavy queries; Snowflake is more predictable for sustained workloads. BigQuery is unbeatable if you’re deep in Google’s ecosystem; Snowflake …
Chose Google BigQuery
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 …
Chose Google BigQuery
Compared to PostgreSQL and MySQL, Google BigQuery is faster and more scalable for large datasets. It’s serverless, so there’s no need to manage infrastructure. We chose Google BigQuery for its ease of use built-in analytics features
Chose Google BigQuery
The architecture of ETL was influenced by Data processing component which is Dataproc and there was a need for easy Query console with Access control capabilities with lesser overhead in managing the permission. This made the decision to move with Google BigQuery compare to …
Chose Google BigQuery
is much better as it’s easily accessible provides velvet documentation and fulfils all our needs as well as easily integrated into clients, environment
Chose Google BigQuery
Google BigQuery is simpler and I say it has simpler UI too.
If you have a clear long term ask , mainly business intelligence needs then Google BigQuery offers you good.
If you need too much of features under a single cloud and you are ok to be lil clumsy then you can check …
Chose Google BigQuery
I have used most of the data analytics platforms. Based on my work, I have found that the user interface of Google BigQuery is simple to navigate. I like the front view - ease of joining tables, and integration with other platforms.
Chose Google BigQuery
Compared to every other analytics DB solution I've used, Google BigQuery was by far the easiest to set up and maintain, and scale.
The price was also much lower for our use case (internal data analysis).
Chose Google BigQuery
For our usage, Google BigQuery is cheaper and more performant. The others have their place, but in certain scenarios, Google BigQuery is a better solution.
Chose Google BigQuery
We actually use Snowflake and BigQuery in tandem because they both currently meet various needs. Redshift, however, has barely been used since our migration away from it. In the case of both Snowflake and BigQuery, they beat Redshift by a long shot. The main reasons are their …
Chose Google BigQuery
PowerBI can connect to GA4 for example but the data processing is more complicated and it takes longer to create dashboards. Azure is great once the data import has been configured but it's not an easy task for small businesses as it is with BigQuery.
Chose Google BigQuery
I came to use BigQuery from a traditional system like MS SQL server, the features which are available in BigQuery as a cloud service far outweigh the features from SQL server. I have not used other similar tools like Amazon Redshift but Google BigQuery serves multiple use cases …
Chose Google BigQuery
Google BigQuery is cheaper and much faster as compared to both. While as compared to Snowflake , we tested it was faster and cheaper by 30%, that is after Snowflake tweaked their environment, if not for that it would have been 90% cheaper than snowflake. Redshift is not easy …
Chose Google BigQuery
In my opinion, Google BigQuery is custom made to be the best data lake system that is easy to use, scalas to fit any business size, has inbuilt security, as well as tools for data integrity. Although a few other tools have some of the same functionality, Google BigQuery is the …
Chose Google BigQuery
It's easier to connect data between BigQuery and looker studio instead of connecting the data between BigQuery and tableau in terms of data explore or dashboard creating. Therefore we are considering migrating dashboards from tableau to looker studio for the whole company.
On …
Chose Google BigQuery
When comparing Google BigQuery and Databricks, both platforms are powerful tools for managing and analyzing large datasets. BQ is ideal for businesses requiring large-scale analytics, reporting, and dashboarding with minimal operational overhead. It’s also great for ad-hoc …
Chose Google BigQuery
Google BigQuery's main advantage over its direct competitors (Amazon Redshift and Azure Synapse) is that it is widely supported by non-Google software, while the others rely heavily on their own cloud ecosystems.
Chose Google BigQuery
I have used other data manipulation tools like SQL Server and Google BigQuery feels more intuitive, Google provides so much documentation and tutorials that getting to know the software is not only easy but even satisfactory, so I'd say Google BigQuery is very superior to that …
Chose Google BigQuery
Main reason is how it integrates directly with the google ecosystem which really facilitates the automatization proceses for the whole company. This ensures that sales and all the other departments have the correct information on a daily bases with a ease of use with day to day …
Chose Google BigQuery
Amazon Redshift was a likely alternative we were considering , but it needs to be provisioned on cluster and nodes, which increases infrastructure management, whereas Google BigQuery is serverless, so no infra management :) Also, I remember when comparing them we did found out …
Chose Google BigQuery
Its same as compared to Big query. We go with big query because of clients requirements in project.
Chose Google BigQuery
Google BigQuery as a platform allows for more integrations and customizability than many other offerings. Users mostly need to understand the basics of database and SQL programming in order to get the most from the product. However, other products like Hevo do have less of a …
SAP Datasphere
Chose SAP Datasphere
We used SAP BW for modeling and loaded the data into SAP Analytics Cloud for reporting. In this scenario, we had to store data physically in SAC for reporting. Live Model reporting caused a performance issue when displaying data in SAC. After Datasphere came into the picture, …
Chose SAP Datasphere
with the support for SAP BW 7.5 ends by 2027 and extended support by 2030, also the support for BW/4HANA ends by 2040. Every organization is looking towards modernizing their data warehousing solution. SAP Datasphere stands tall as a solution for this and well suited if …
Chose SAP Datasphere
it is use d to öodernize our bw stack
Chose SAP Datasphere
Our organization selected SAP Datasphere Because, in our experience, this is a compliant way of getting data out
Chose SAP Datasphere
SAP Datasphere is cloud based, also it is designed for Logical data modeling where no much ETL needs to be used, also it has faster onboarding of business use cases, it can integrate with S4HANA CDS views with real time data extraction. Datasphere complements BW4HANA rather …
Chose SAP Datasphere
Snowflake, Databricks, Azure Data Factory... why do we choose? Strong SAP landscape, single source of truth for sensitive data, cloud capabilities, etc.
Chose SAP Datasphere
SAC with SAP Datasphere works like a charm, and it uses the Live connectivity. Negative side:-Clients cannot use SAC for regulatory reports, or they have to download the entire Data for sending it to government agencies.
Chose SAP Datasphere
SAP BW was the old world tool from on on-prem world. It lacks the cloud tool integration. Very limited scalability option. Even with robust modelling options, AIML scenarios were not possible. It was a tool for the past. Now DSP has evolved and taken over the place of BW in all …
Chose SAP Datasphere
Better data integration and less manual handling
Chose SAP Datasphere
Microsoft Asure database is the source for Databricks dataproduct for one of our projects. SAP Datasphere uses this source to develop Graphical view combined with the other data products to get the reports from Analytical Models. Also data is combined from various source in SAP …
Chose SAP Datasphere
SAP BW/4HANA, SAP Business Warehouse and SAP HANA Cloud
Chose SAP Datasphere
SAP Datasphere is much more mature than the alternative, in particular for a data warehouse focused on enterprise level modeling and governance.
Chose SAP Datasphere
Informatica Cloud API & App Integration and Talend Data Integration
Chose SAP Datasphere
There is hard to compare, because some things are missing and some are better.
Chose SAP Datasphere
SAP Ariba, SAP Analytics Cloud, SAP HANA Cloud, Snowflake and Azure Databricks
Chose SAP Datasphere
SAP Datasphere is an exciting way to modernize our data stack, and what clinched it for us was how deep we're already in with SAP - it only made sense to try and leverage the synergies between Datasphere and our other SAP products.
Chose SAP Datasphere
SAP Data Intelligence, SAP Analytics Cloud, SAP BW/4HANA, SAP HANA Cloud, SAP Business Technology Platform and SAP Data Services
Features
Google BigQuerySAP Datasphere
Database-as-a-Service
Comparison of Database-as-a-Service features of Product A and Product B
Google BigQuery
8.5
Ratings
1% above category average
SAP Datasphere
-
Ratings
Automatic software patching8.00 Ratings00 Ratings
Database scalability9.00 Ratings00 Ratings
Automated backups8.50 Ratings00 Ratings
Database security provisions8.80 Ratings00 Ratings
Monitoring and metrics8.50 Ratings00 Ratings
Automatic host deployment8.00 Ratings00 Ratings
Best Alternatives
Google BigQuerySAP Datasphere
Small Businesses
IBM Cloudant
IBM Cloudant
Score 7.4 out of 10
Google BigQuery
Google BigQuery
Score 8.7 out of 10
Medium-sized Companies
IBM Cloudant
IBM Cloudant
Score 7.4 out of 10
Snowflake
Snowflake
Score 8.7 out of 10
Enterprises
IBM Cloudant
IBM Cloudant
Score 7.4 out of 10
Snowflake
Snowflake
Score 8.7 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Google BigQuerySAP Datasphere
Likelihood to Recommend
9.0
(0 ratings)
8.5
(0 ratings)
Likelihood to Renew
8.1
(0 ratings)
6.8
(0 ratings)
Usability
6.8
(0 ratings)
8.2
(0 ratings)
Availability
7.3
(0 ratings)
-
(0 ratings)
Performance
6.4
(0 ratings)
-
(0 ratings)
Support Rating
5.0
(0 ratings)
9.0
(0 ratings)
Configurability
6.4
(0 ratings)
-
(0 ratings)
Ease of integration
7.3
(0 ratings)
-
(0 ratings)
Product Scalability
7.3
(0 ratings)
-
(0 ratings)
User Testimonials
Google BigQuerySAP Datasphere
Likelihood to Recommend
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.
Read full review
SAP Datasphere is well suited for scalable cloud based data integration scenarios which also opens up the doors for AI driven insights which are much harder to achieve with on-prem data warehouses. Considering the licensing model of SAP Datasphere being based on consumption driven capacity units cost can be a big consideration for organizations with large volumes of data that can be a pre-requisite for data mining and AI use cases. So this can be a bottleneck or not so well adopted scenario for SAP Datasphere.
Read full review
Pros
  • 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.
Read full review
  • SAP Data Warehouse Cloud offers free trial for 90 days with free 128 GB of storage and 64 GB memory.
  • Availability of self-service data modeling and analytics on SAP Data Warehouse Cloud enables users to access and analyze data without getting support from the IT team.
  • Without zero coding while collecting, connecting, analyzing and modeling data, it saves us time and operational costs of partnering with external IT support experts.
Read full review
Cons
  • 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.
Read full review
  • SAP Data Warehouse Cloud is quite complex, therefore, some extra orientation or training might be essential, more so on cloud.
  • Secondly, SAP Data installation fee, and the monthly subscription amounts is slightly demanding, and the developer should refocus on changing them.
  • Nonetheless, SAP Data rectified other challenges like flexibility and customization, making us happy clients.
Read full review
Likelihood to Renew
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.
Read full review
Datasphere can come with its own challenges which can feel like a mountain to get over. However, once one has an understanding of how the product works it becomes easier to use. Once the time is spent to get it setup and working correctly very little is needed to keep it running smoothly. Its a great tool it just takes time to learn.
Read full review
Usability
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
Read full review
SAP has suggested that BW 7.5 will be sunset soon. Usability is good in SAP BW Modernization. Instead of going with other non-SAP tools, staying with SAP will be suitable for existing users. Across the board, many of them are moving to DataSphere.
Read full review
Reliability and Availability
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.
Read full review
No answers on this topic
Performance
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.
Read full review
No answers on this topic
Support Rating
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.
Read full review
I would greatly acknowledge the services of Sap Data [warehouse Cloud] because we were struggling before its arrival where we used to get manual data connections and this used to consume a lot of time but after its use, we now are able to connect data easily saving a lot of time and finances.
Read full review
Alternatives Considered
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.
Read full review
Each of these listed software has its own unique strength and capacity that scales well. SAP Datasphere on its end up against them with more suitability for large establishments with complex data ecosystems with scalability support. Also, it avails a pay-as-you-go pricing for users, and it is widely up for data quality, data governance, and data discovery.
Read full review
Scalability
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.
Read full review
No answers on this topic
Return on Investment
  • 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.
Read full review
  • Enhanced our report generation process due to presence of holistic data.
  • Centralized data from all our platforms. This has helped us visualize and analyze all data much more efficiently.
  • It is more on the expensive side from both cost and training perspective.
Read full review
ScreenShots

Google BigQuery Screenshots

Screenshot of Migrating data warehouses to BigQuery - Features a streamlined migration path from Netezza, Oracle, Redshift, Teradata, or Snowflake to BigQuery using the fully managed BigQuery Migration Service.Screenshot of bringing any data into BigQuery - Data files can be uploaded from local sources, Google Drive, or Cloud Storage buckets, using BigQuery Data Transfer Service (DTS), Cloud Data Fusion plugins, by replicating data from relational databases with Datastream for BigQuery, or by leveraging Google's data integration partnerships.Screenshot of generative AI use cases with BigQuery and Gemini models - Data pipelines that blend structured data, unstructured data and generative AI models together can be built to create a new class of analytical applications. BigQuery integrates with Gemini 1.0 Pro using Vertex AI. The Gemini 1.0 Pro model is designed for higher input/output scale and better result quality across a wide range of tasks like text summarization and sentiment analysis. It can be accessed using simple SQL statements or BigQuery’s embedded DataFrame API from right inside the BigQuery console.Screenshot of insights derived from images, documents, and audio files, combined with structured data - Unstructured data represents a large portion of untapped enterprise data. However, it can be challenging to interpret, making it difficult to extract meaningful insights from it. Leveraging the power of BigLake, users can derive insights from images, documents, and audio files using a broad range of AI models including Vertex AI’s vision, document processing, and speech-to-text APIs, open-source TensorFlow Hub models, or custom models.Screenshot of event-driven analysis - Built-in streaming capabilities automatically ingest streaming data and make it immediately available to query. This allows users to make business decisions based on the freshest data. Or Dataflow can be used to enable simplified streaming data pipelines.Screenshot of predicting business outcomes AI/ML - Predictive analytics can be used to streamline operations, boost revenue, and mitigate risk. BigQuery ML democratizes the use of ML by empowering data analysts to build and run models using existing business intelligence tools and spreadsheets.