Reference

Authentication Flight SQL (token)

Description

No description available [API reference]

Instructions

InfluxDB 3 SQL is exposed over Arrow Flight SQL. Create an API token in the Influx console (same idea as a Stripe secret key).

  1. Log in to your InfluxDB 3 Cloud or Core/Enterprise UI.
  2. Open API Tokens (or influx auth create on Core) and create a token with query permission on the database.
  3. Copy the host (no https://) and Flight/SQL port. Cloud often uses 443 with TLS.
  4. Paste the token into Token. Set database name to your Influx database/bucket equivalent.
  5. Do not point the Flight URL at a random redirect; this is host:port of the Flight SQL endpoint, not an OAuth callback.
  6. Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
  7. Done. You can query from C#, Python, PowerShell, and ODBC apps.

Parameters

Parameter Required Default value Options
Name: DriverFilePaths

Label: JDBC driver file(s)

Filled by the wizard after download. Separate multiple JARs with a semicolon (e.g. C:\ZappySys\Jdbc\MyConnector\driver.jar). 		YES C:\ZappySys\Jdbc\InfluxDB 3\flight-sql-jdbc-driver-19.0.0.jar
Name: HostName

Label: Host

JDBC host name or IP (e.g. MyHostName). 		YES MyHostName
Name: Port

Label: TCP port

JDBC port (e.g. 443). 		YES 443
Name: token

Label: Token

InfluxDB 3 API token with query access. Create it in the Influx UI or CLI. 		YES
Name: database

Label: Database

InfluxDB 3 database name to query. 		YES
Name: DriverClass

Label: Driver class

Optional. Leave blank to auto-detect from the JAR unless SPI is ambiguous (e.g. org.apache.arrow.driver.jdbc.ArrowFlightJdbcDriver). 		org.apache.arrow.driver.jdbc.ArrowFlightJdbcDriver
Name: useEncryption

Label: Use encryption

Set true for TLS (Cloud / 443). Set false only for local Core without TLS. 		true