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

The from field takes the form flightsql:dataset where dataset is the fully qualified name of the dataset to read from.

name

The dataset name. This will be used as the table name within Spice.

params

Parameter name	Description
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}.