Skip to main content
Technology areas
close
AI and ML
Application development
Application hosting
Compute
Data analytics and pipelines
Databases
Distributed, hybrid, and multicloud
Generative AI
Industry solutions
Networking
Observability and monitoring
Security
Storage
Cross-product tools
close
Access and resources management
Costs and usage management
Infrastructure as code
Migration
SDK, languages, frameworks, and tools
Related sites
close
Google Cloud Home
Free Trial and Free Tier
Architecture Center
Blog
Contact Sales
Google Cloud Developer Center
Google Developer Center
Google Cloud Marketplace
Google Cloud Marketplace Documentation
Google Cloud Skills Boost
Google Cloud Solution Center
Google Cloud Support
Google Cloud Tech Youtube Channel
/
English
Deutsch
Español
Español – América Latina
Français
Indonesia
Italiano
Português
Português – Brasil
中文 – 简体
中文 – 繁體
日本語
한국어
Console
Sign in
BigQuery
Guides
Reference
Samples
Resources
Contact Us
Start free
Technology areas
More
Guides
Reference
Samples
Resources
Cross-product tools
More
Related sites
More
Console
Contact Us
Start free
Discover
Product overview
Try BigQuery using the sandbox
Get started
Use the console
Explore the console
Load and query data
Try DataFrames
Use the bq CLI tool
Use the client libraries
Design
Organize resources
API dependencies
Understand editions
Datasets
Introduction
Create datasets
List datasets
Cross-region replication
Managed disaster recovery
Migrate to managed disaster recovery
Dataset data retention
Tables
BigQuery tables
Introduction
Create and use tables
BigLake Iceberg tables in BigQuery
Specify table schemas
Specify a schema
Specify nested and repeated columns
Specify default column values
Specify ObjectRef values
Segment with partitioned tables
Introduction
Create partitioned tables
Manage partitioned tables
Query partitioned tables
Optimize with clustered tables
Introduction
Create clustered tables
Manage clustered tables
Query clustered tables
Use metadata indexing
External tables
Introduction
Types of external tables
BigLake external tables
BigQuery Omni
Object tables
External tables
External table definition file
Externally partitioned data
Use metadata caching
Amazon S3 BigLake external tables
Apache Iceberg external tables
Azure Blob Storage BigLake tables
Bigtable external table
BigLake external tables for Cloud Storage
Cloud Storage object tables
Cloud Storage external tables
Delta Lake BigLake tables
Google Drive external tables
Views
Logical views
