Use BigQuery Omni with Azure

To use BigQuery Omni with Azure, perform the following steps:

  1. Create a connection. This step authorizes BigQuery Omni to read the data in your Azure storage.

  2. Create an external table. Create a BigQuery external table that references the raw data in Azure storage. The data can be in Avro, CSV, JSON, ORC, or Parquet format. As with other BigQuery tables, BigQuery can infer the table schema. You can also manually specify a schema for CSV or JSON data.

  3. Run queries. Once the external table is created, you can use Standard SQL to query the data, like any other BigQuery table. For more information, see Overview of querying BigQuery data.

  4. Export query results to Azure Storage. Optionally, you can write query results to your Azure storage, in which case there is no cross-region copy of the results data.

What's next