---
title: Write to Google BigQuery
description: Use sql.to() with the bigquery driver to write data to Google BigQuery.
url: https://docs.influxdata.com/flux/v0/write-data/sql/bigquery/
estimated_tokens: 630
product: Flux
version: v0
publisher: InfluxData
canonical: https://docs.influxdata.com/flux/v0/write-data/sql/bigquery/
date: '2023-09-12T23:33:31-06:00'
lastmod: '2023-09-12T23:33:31-06:00'
---

To write data to [Google BigQuery](https://cloud.google.com/bigquery) with Flux:

1. Import the [`sql` package](/flux/v0/stdlib/sql/).

2. Pipe-forward data into [`sql.to()`](/flux/v0/stdlib/sql/to/) and provide
   the following parameters:

   * **driverName**: bigquery
   * **dataSourceName**: *See [data source name](#bigquery-data-source-name)*
   * **table**: Table to write to
   * **batchSize**: Number of parameters or columns that can be queued within
     each call to `Exec` (default is `10000`)

```js
import "sql"

data
    |> sql.to(
        driverName: "bigquery",
        dataSourceName: "bigquery://projectid/?apiKey=mySuP3r5ecR3tAP1K3y",
        table: "exampleTable",
    )
```

## BigQuery data source name

The `bigquery` driver uses the following DSN syntaxes (also known as a **connection string**):

```
bigquery://projectid/?param1=value&param2=value
bigquery://projectid/location?param1=value&param2=value
```

### Common BigQuery URL parameters

* **dataset** - BigQuery dataset ID. When set, you can use unqualified table names in queries.

### BigQuery authentication parameters

The Flux BigQuery implementation uses the [Google Cloud Go SDK](https://cloud.google.com/go/docs/reference/cloud.google.com/go/latest).
Provide your authentication credentials using one of the following methods:

* Set the `GOOGLE_APPLICATION_CREDENTIALS` environment variable to identify the
  location of your credential JSON file.

* Provide your base-64 encoded service account, refresh token, or JSON credentials
  using the **credentials** URL parameter in your BigQuery DSN.

  ###### Example credentials URL parameter ######

  ```
  bigquery://projectid/?credentials=eyJ0eXBlIjoiYXV0...
  ```

## Flux to BigQuery data type conversion

`sql.to()` converts Flux data types to BigQuery data types.

|              Flux data type               |BigQuery data type|
|-------------------------------------------|------------------|
|   [int](/flux/v0/data-types/basic/int/)   |      INT64       |
| [float](/flux/v0/data-types/basic/float/) |     FLOAT64      |
|[string](/flux/v0/data-types/basic/string/)|      STRING      |
|  [bool](/flux/v0/data-types/basic/bool/)  |       BOOL       |
|  [time](/flux/v0/data-types/basic/time/)  |    TIMESTAMP     |

#### Related

* [sql.to() function](/flux/v0/stdlib/sql/to/)
| Flux data type | BigQuery data type |
| --- | --- |
| Flux data type | BigQuery data type |
| int | INT64 |
| float | FLOAT64 |
| string | STRING |
| bool | BOOL |
| time | TIMESTAMP |