Mage AI home pagelight logodark logo
  • GitHub
  • Community
  • Mage Pro
  • Get a demo
  • Get a demo
Documentation
Development
Production
AI
Observability
Integrations
Extensibility
Quickstart
  • Guides
  • Tips & tricks
Developer experience
  • Code editor
  • Dependency tree
  • Pipeline dependencies
  • Pipeline canvas
  • File browser
  • Code browser
  • Sidekick
  • Personalize
  • Workspaces
  • Visual Studio Code
Version control
  • Version control guide
  • Configurations
  • Git application
  • Git sync
  • Git terminal
  • Git integration
  • File versioning
Blocks
  • Reorder
  • Detach
  • Dynamic
  • Dynamic blocks 2.0
  • Batch read/write
  • Polars
  • Replicate
  • Transformers
  • Custom
  • Markdown
  • SQL
  • R
Pipelines
  • Batch
  • Data integration
  • Streaming
    • Overview
    • Sources
    • Destinations
      • ActiveMQ
      • Amazon S3
      • BigQuery
      • ClickHouse
      • DuckDB
      • Dummy
      • Elasticsearch
      • Google Cloud PubSub
      • Google Cloud Storage
      • InfluxDB
      • Kafka
      • Kinesis
      • MongoDB
      • Microsoft SQL Server
      • MySQL
      • Opensearch
      • Oracle Database
      • Postgres
      • RabbitMQ
      • Redshift
      • Snowflake
      • Trino
    • Tutorials
  • Importing
  • Community Examples
dbt
  • Overview
  • Getting started
  • New project
  • Configuration
  • Models
  • Commands
Destinations

BigQuery

​
Basic config

connector_type: bigquery
profile: default    # profile in the io_config.yaml
config:
  table_id: table_id
  if_exists: "append"

​
Optional fields

database: database  # Override the database

Was this page helpful?

Suggest editsRaise issue
Amazon S3ClickHouse
On this page
  • Basic config
  • Optional fields
Mage AI home pagelight logodark logo
githubslacklinkedintwitter

OSS

CodeDemo playground

Mage Pro

Get started for free

Community

ChatFacebookYoutubeInstagramMedium
githubslacklinkedintwitter
Powered by Mintlify
Assistant
Responses are generated using AI and may contain mistakes.