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 Cloud de Confiance 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 Cloud de Confiance version of BigQuery and the Google Cloud version. Some notable differences include the following:
- Most external connections to data sources are unavailable. These include services such as BigQuery Migration Service, BigQuery sharing (formerly known as Analytics Hub), BigQuery Connection API and BigQuery Omni (AWS and Azure connections), and Lakehouse 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 Cloud de Confiance. We also recommend reviewing the general differences between Cloud de Confiance and Google Cloud.
If you would like to use a particular BigQuery feature that isn't currently available in Cloud de Confiance, contact Cloud de Confiance support. To be notified when new features roll out in Cloud de Confiance, subscribe to the release notes. Unless otherwise specified, features that are in preview are not available in Cloud de Confiance.
API and service availability
The following BigQuery APIs and services are unavailable in Cloud de Confiance by S3NS:
- Dataform API
- Migration API
- Analytics Hub API
- Data Transfer API
- Data Policy API
- Connection API
- BigQuery Omni
Regions and zones
| Regions and zones | Cloud de Confiance 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 Cloud de Confiance. |
Cost management
| Cost saving features |
Cloud de Confiance by S3NS offers spend-based committed use discounts (CUDs) for BigQuery reservations. To purchase spend-based commitments, contact Cloud de Confiance by S3NS billing support. For more information, see the billing differences page. All other cost-saving features aren't available in Cloud de Confiance, including capacity commitments. |
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. |
| Active Assist | Recommendations are unavailable. |
Workflows and tools
| Terraform support | Terraform support is unavailable. |
| BigQuery ML | BigQuery ML supports only internal models. |
| Gemini in BigQuery | Gemini in BigQuery is unavailable. |
| bq command-line tool | Because Cloud Shell is unavailable in Cloud de Confiance, the bq command-line tool must be installed locally. |
| Public datasets | BigQuery public datasets are not available in Cloud de Confiance. You must import your own data to try BigQuery, including when following our tutorials. |
| Scheduled queries | Scheduled queries are unavailable. |
| Continuous queries | Continuous queries are unavailable. |
| Saved queries and notebooks | Saved queries and notebooks are unavailable in BigQuery Studio. |
| Table sources | Only Cloud Storage and local data can be used as sources for BigQuery tables. Other sources are unavailable. |
| Lakehouse (formerly BigLake) | Lakehouse (BigLake) tables are not available. |
| BigQuery pipelines | Pipelines are not available. |
Related guides
The following information might also affect how you use and design for BigQuery in Cloud de Confiance by S3NS. These guides include general information about working in Cloud de Confiance, including documentation, security and access control, billing, tooling, and service usage.
For details about other services and features in Cloud de Confiance and their differences from their Google Cloud counterparts, see the product list.