---
title: sql.to() function
description: sql.to() writes data to an SQL database.
url: https://docs.influxdata.com/flux/v0/stdlib/sql/to/
estimated_tokens: 736
product: Flux
version: v0
---

# sql.to() function

-   Flux 0.34.0+
-   View InfluxDB support

`sql.to()` writes data to an SQL database.

##### Function type signature

```js
(
    <-tables: stream[A],
    dataSourceName: string,
    driverName: string,
    table: string,
    ?batchSize: int,
) => stream[A]
```

For more information, see [Function type signatures](/flux/v0/function-type-signatures/).

## Parameters

### driverName

(Required) Driver used to connect to the SQL database.

**Supported drivers**:

-   bigquery
-   hdb
-   mysql
-   postgres
-   snowflake
-   sqlite3 *(Does not work with InfluxDB OSS or InfluxDB Cloud)*
-   sqlserver
-   vertica, vertigo

### dataSourceName

(Required) Data source name (DNS) or connection string used to connect to the SQL database.

### table

(Required) Destination table.

### batchSize

Number of parameters or columns that can be queued within each call to `Exec`. Default is `10000`.

If writing to SQLite database, set the batchSize to `999` or less.

### tables

Input data. Default is piped-forward data (`<-`).

#### Related

-   [Write to SQL databases](/flux/v0/write-data/sql/)