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 – América Latina
Français
Indonesia
Italiano
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
Create logical views
Materialized views
Introduction
Create materialized views
Load, transform, and export
Introduction
Build a data pipeline with Data Engineering Agent
Migrate data
Introduction
Migration assessment
Migrate schema and data
Migrate data pipelines
Use custom organization policies
Migrate SQL
Translate SQL queries interactively
Translate SQL queries using the API
Translate SQL queries in batch
Generate metadata for translation and assessment
Transform SQL translations with YAML
Map SQL object names for batch translation
Load data
Introduction
Create data integration workflows using the BigQuery web UI
Storage overview
BigQuery Data Transfer Service
Introduction
Supported data sources
Data location and transfers
Authorize transfers
Enable transfers
Set up network connections
Cloud SQL instance access
AWS VPN and network attachment
Azure VPN and network attachment
Manage transfers
Transfer run notifications
Troubleshoot transfer configurations
Use service accounts
Use third-party transfers
Use custom organization policies
Data source change log
Event-driven transfers
Transfer data into Managed Iceberg tables
Batch load data
Introduction
Auto-detect schemas
Load Avro data
Load Parquet data
Load ORC data
Load CSV data
Load JSON data
Load externally partitioned data
Load data from a Datastore export
Load data from a Firestore export
Load data using the Storage Write API
Load data into partitioned tables
Write and read data with the Storage API
Read data with the Storage Read API
Write data with the Storage Write API
Introduction
Use the Storage Write API (gRPC)
Overview
Stream data
Batch load data
Stream updates with change data capture ingestion
Best practices
Supported protocol buffer and Arrow data types
Use the Storage Write API (REST)
Load data from other Google services
Discover and catalog Cloud Storage data
Load data using third-party apps
Load data using BigQuery Omni operations
Optimize load jobs
Transform data
Introduction
Prepare data
Introduction
Prepare data with Gemini
Transform with DML
Transform data in partitioned tables
Work with change history
Transform data with pipelines
Introduction
Create pipelines
Export data
Introduction
Export query results
Export to Cloud Storage
Export to Bigtable
Export to Spanner
Export to AlloyDB
Export to Pub/Sub
Export as Protobuf columns
ELT tutorials
Build ELT for marketing analytics data
Analyze
Introduction
Explore your data
Search for resources
Profile your data
Data insights
About data insights
Generate table insights
Generate dataset insights
Analyze with a data canvas
Analyze data with Gemini
Analyze data with the Gemini CLI
Analyze your data
Run a query
Write queries with Gemini
Write query results
Query data with SQL
Introduction
Arrays
JSON data
Multi-statement queries
Parameterized queries
Pipe syntax
Analyze data using pipe syntax
Recursive CTEs
Sketches
Table sampling
Time series
Transactions
Wildcard tables
Use notebooks
Introduction
