Skip to main content
Google Cloud Documentation
Technology areas
  • 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
  • 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
Google Cloud Documentation
  • 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