Reference

Authentication Token

Description

No description available [API reference]

Instructions

Flight SQL token authentication (bearer / PAT). Still a generic protocol tile -- InfluxDB 3 keeps its own connector.

  1. Create an API token or personal access token in the Flight SQL server UI (same idea as a Stripe secret key).
  2. Paste the token into Token. Leave user/password empty unless the server requires both.
  3. Java 16+ may need --add-opens=java.base/java.nio=ALL-UNNAMED on the Bridge JVM.
  4. After Finish, replace host and port. Cloud endpoints often use 443 with TLS.
  5. Finish the wizard. Then click Test Connection on the DSN Main UI (the wizard does not run Test Connection).
  6. 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\Arrow Flight SQL\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. 32010). 		YES 32010
Name: token

Label: Token

Flight SQL bearer / API token. Create it in the server UI or CLI. 		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 (default). Set false only for a local plaintext Flight SQL server. 		true