Skip to main content
Technology areas
close
AI and ML
Application development
Application hosting
Compute
Data analytics and pipelines
Databases
Distributed, hybrid, and multicloud
Industry solutions
Migration
Networking
Observability and monitoring
Security
Storage
Cross-product tools
close
Access and resources management
Costs and usage management
Infrastructure as code
SDK, languages, frameworks, and tools
/
Console
English
Deutsch
Español
Español – América Latina
Français
Indonesia
Italiano
Português
Português – Brasil
עברית
中文 – 简体
中文 – 繁體
日本語
한국어
Sign in
BigQuery
Start free
Overview
Guides
Reference
Samples
Resources
Technology areas
More
Overview
Guides
Reference
Samples
Resources
Cross-product tools
More
Console
Discover
Product overview
Try BigQuery using the sandbox
Get started
Console walkthroughs and videos
Use the console
Explore the console
Load and query data
Use Notebook gallery
Create reservations
Try DataFrames
Use agents
Analyze data with the Colab Data Science Agent
Use the bq CLI tool
Use the client libraries
Plan
Introduction to the resource hierarchy
API dependencies
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
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 data sources
Introduction
BigLake tables
Introduction
Create Amazon S3 BigLake tables
Create Azure Blob storage BigLake tables
Create Cloud Storage BigLake tables
Object tables
Introduction
Create Cloud Storage object tables
External tables
Introduction
Create Apache Iceberg external tables
Create Bigtable external tables
Create Cloud Storage external tables
Create Google Drive external tables
Use metadata caching
Manage Hive partitioned data
Create a table definition file for external data
Federated datasets
Create and manage AWS Glue federated datasets
Create Spanner external datasets
Apache Iceberg managed tables
Interact with Lakehouse data
Views
Overview
Logical views
Introduction
