Write to Vertica
To write data to Vertica with Flux:
Import the
sql
package.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 is10000
)
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.
Flux data type | Vertica data type |
---|---|
float | FLOAT |
int | INTEGER |
uint | INTEGER |
string | VARCHAR |
bool | BOOL |
time | TIMESTAMP |
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for Flux and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.