Documentation

Query Vertica

To query Vertica with Flux:

  1. Import the sql package.

  2. Use sql.from() and provide the following parameters:

    • driverName: vertica or vertigo
    • dataSourceName: See data source name
    • query: PSQL query to execute
import "sql"

sql.from(
    driverName: "vertica",
    dataSourceName: "vertica://username:password@localhost:5433/dbname",
    query: "SELECT * FROM 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.

Vertica to Flux data type conversion

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

Vertica data type Flux data type
INT, INTEGER, BIGINT, SMALLINT, TINYINT, INT2, INT4, INT8, SERIAL2, SERIAL4, SERIAL8 int
FLOAT, FLOAT4, FLOAT8 float
DATE, TIME, TIMESTAMP time
BOOL bool
TEXT, VARCHAR, VARBINARY string

All other Vertica data types are converted to strings.


Was this page helpful?

Thank you for your feedback!


Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.