BigQuery is a fully managed, serverless data warehouse that enables scalable analysis over petabytes of data. BigQuery provides features such as built-in machine learning, geospatial analysis, and business intelligence. This page describes the differences between the Trusted Cloud and Google Cloud versions of BigQuery.
For more detailed information about BigQuery, see the BigQuery overview and the rest of the BigQuery documentation.
Key differences
There are some differences between the Trusted Cloud version of BigQuery and the Google Cloud version. Some notable differences include the following:
- Many external connections to data sources are unavailable. These include services such as BigQuery Data Transfer Service and BigQuery Migration Service, BigQuery sharing (formerly known as Analytics Hub), BigQuery Connection API and BigQuery Omni (AWS and Azure connections), and BigLake APIs.
- Certain advanced query features are unavailable. These include saved queries and notebooks, Gemini in BigQuery features, and BigQuery ML external models.
A more detailed list of differences is provided in the rest of this section. If you are already familiar with Google Cloud, we recommend that you review these differences carefully, particularly before designing an application to run on Trusted Cloud. We also recommend reviewing the general differences between Google Cloud and your universe in the Trusted Cloud by S3NS overview.
If you would like to use a particular BigQuery feature that isn't currently available in Trusted Cloud, contact Trusted Cloud support. To be notified when new features roll out in Trusted Cloud, subscribe to the release notes.
API and service availability
The following BigQuery APIs and services are unavailable in Trusted Cloud by S3NS:
- BigQuery Data Transfer Service API
- Dataform API
- Migration API
- Analytics Hub API
Regions and zones
| Regions and zones | Trusted Cloud has only a single region, though with multiple zones. Multi-region features and cross-region failover are not supported. |
| Cross region replication & failover | Cross region replication and failover are not available in Trusted Cloud. |
Cost management
| Cost saving features | Committed use discounts (CUDs) are unavailable in Trusted Cloud. |
Security and access control
| Data masking | Data masking is unavailable. |
| Column level access control | Column level access control is unavailable. |
| Customer-managed encryption keys | Customer-managed encryption key (CMEK) provisioning requires manual provisioning. |
Integrations
| Cloud Asset Inventory | Cloud Asset Inventory is unavailable. |
Workflows and tools
| Client libraries | Most client libraries are available for supported APIs. |
| Terraform support | Terraform support is unavailable. |
| BigQuery ML | BigQuery ML supports only internal models. |
| Gemini in BigQuery | Gemini in BigQuery is unavailable. |
Related guides
The following information might also affect how you use and design for BigQuery in Trusted Cloud by S3NS. These guides include general information about working in Trusted Cloud, including documentation, security and access control, billing, tooling, and service usage.
For details about other services and features in Trusted Cloud and their differences from their Google Cloud counterparts, see the product list.