FlightSQL
Flight SQL Data Connector Documentation
import Tabs from '@theme/Tabs'; import TabItem from '@theme/TabItem';
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}
Configuration
from
from
The from
field takes the form flightsql:dataset
where dataset
is the fully qualified name of the dataset to read from.
name
name
The dataset name. This will be used as the table name within Spice.
params
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}
.
Last updated
Was this helpful?