Query CockroachDB

To query CockroachDB with Flux:

1. Import the sql package.

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

   • driverName: postgres
   • dataSourceName: See data source name
   • query: PSQL query to execute

import "sql"

sql.from(
    driverName: "postgres",
    dataSourceName:
        "postgresql://username:password@localhost:26257/cluster_name.defaultdb?sslmode=verify-full&sslrootcert=certs_dir/cc-ca.crt",
    query: "SELECT * FROM example_table",
)

CockroachDB data source name

The postgres driver uses the following DSN syntax (also known as a connection string) to connect to CockroachDB :

postgres://username:password@localhost:26257/cluster_name.defaultdb?sslmode=verify-full&sslrootcert=certs_dir/cc-ca.crt

CockroachDB to Flux data type conversion

sql.from() converts PostgreSQL and CockroachDB data types to Flux data types.