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 the bq CLI tool
Use the client libraries
Plan
Organize resources
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 tables
Introduction
Types of external tables
BigLake external tables
BigQuery Omni
Object tables
External tables
External table definition file
External tables for on Hive partitioned data
Use metadata caching
External tables for S3
Apache Iceberg external tables
External tables for Azure Blob storage
Bigtable external table
External tables for Cloud Storage
Cloud Storage object tables
External tables for Cloud Storage
Apache Iceberg managed tables
Views
Overview
Logical views
Introduction
Create logical views
Materialized views
Introduction