Write to Vertica

To write data to Vertica with Flux:

1. Import the sql package.

2. Pipe-forward data into sql.to() and provide the following parameters:

   • driverName: vertica or vertigo
   • dataSourceName: See 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)

import "sql"

data
    |> sql.to(
        driverName: "vertica",
        dataSourceName: "vertica://username:password@localhost:5433/dbname",
        table: "public.example_table",
    )

Vertica data source name

The vertica and vertigo drivers use the following DSN syntax (also known as a connection string):

vertica://<user>:<password>@<host>:<port>/<database>?<queryArgs>

The vertica and vertigo drivers use the vertica/vertica-sql-go implementation. For information about supported DSN query arguments, see the vertica/vertica-sql-go documentation.

Flux to Vertica data type conversion

sql.to() converts Flux data types to Vertica data types.