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.