Skip to content
BoilStream

Connect with FlightSQL

tutorialpreview
TL;DR

FlightSQL returns Arrow batches for SQL queries and metadata discovery. Use it only as a preview within a trusted deployment, with the endpoint and TLS settings supplied by your administrator. Writes, prepared statements and cross-tenant isolation guarantees remain outside the supported contract; use PGWire for the documented write workflow.

Message sequenceFlight SQL uses a statement and a result stream
Flight SQL uses a statement and a result streamAn authenticated Flight SQL client submits a SQL statement, receives information for its result and retrieves Arrow record batches. This documentation qualifies the read path as a preview.Flight SQL clientBoilStreamAuthenticate and select catalogGetFlightInfo: SQL statementResult endpoint / ticketDoGet: result ticketArrow record batchesTime moves downward · dashed arrows are responsesFlight SQL uses a statement and a result streamAn authenticated Flight SQL client submits a SQL statement, receives information for its result and retrieves Arrow record batches. This documentation qualifies the read path as a preview.Flight SQLclientBoilStreamAuthenticate and selectcatalogGetFlightInfo: SQLstatementResult endpoint / ticketDoGet: result ticketArrow record batchesTime moves downward · dashed arrows are responses
Read preview only: implemented write handlers are not a qualified public write contract.

Connect

Section titled “Connect”

Use the FlightSQL host, port, TLS roots, and token supplied by your deployment. The default port is configurable; do not infer it from the PGWire endpoint.

Use a FlightSQL client such as the Apache Arrow ADBC Flight SQL driver. Configure the TLS endpoint, trusted CA and authorization header through the driver’s connection options. Do not disable certificate verification or embed credentials in SQL.

Start with SELECT 1 to check connectivity, then query an authorized table. A connectivity check does not establish tenant isolation or visibility of recent streaming rows. Test the driver version and query workflow against your server release before use.

Operation limits

Section titled “Operation limits”

Read the FlightSQL reference before using this preview. Use PGWire for the documented write workflow.