---
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: 267
product: Flux
version: v0
publisher: InfluxData
canonical: https://docs.influxdata.com/flux/v0/stdlib/sql/to/
date: '2024-04-08T16:01:02-06:00'
lastmod: '2024-04-08T16:01:02-06:00'
---

* Flux 0.34.0+

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/)