Skip to main content

Flight SQL Data Connector

Connect to any Flight SQL compatible server (e.g. Influx 3.0, CnosDB, other Spice runtimes!) as a connector for federated SQL queries.

- from: flightsql:my_catalog.good_schemas.cool_dataset
name: cool_dataset
params:
flightsql_endpoint: http://127.0.0.1:50051
flightsql_username: spicy
flightsql_password: ${secrets:my_flightsql_pass}

params​

  • flightsql_endpoint: The Apache Flight endpoint used to connect to the Flight SQL server.
  • flightsql_username: Optional. The username to use in the underlying Apache flight Handshake Request to authenticate to the server (see reference).
  • flightsql_password (optional): The password to use in the underlying Apache flight Handshake Request to authenticate to the server. Use the secret replacement syntax to load the password from a secret store, e.g. ${secrets:my_flightsql_pass}.

Auth Example​

Check Secrets Stores for more details.

MY_USERNAME=<flight_username> \
MY_PASSWORD=<flight_password> \
spice run

.env

MY_USERNAME=<flight_username>
MY_PASSWORD=<flight_password>

spicepod.yaml

version: v1beta1
kind: Spicepod
name: spice-app

secrets:
- from: env
name: env

datasets:
- from: flightsql:my_catalog.good_schemas.cool_dataset
name: cool_dataset
params:
flightsql_endpoint: http://1.2.3.4:50051
flightsql_username: ${env:MY_USERNAME}
flightsql_password: ${env:MY_PASSWORD}

Learn more about Env Secret Store.