Flight endpoint capabilities¶
This project is a Flight SQL and Flight RPC endpoint backed by Redis. Both interfaces share one gRPC service. Protocol support is distinct from validation of a particular BI application.
| Interface / operation | Behavior | Evidence |
|---|---|---|
| Flight SQL statements and prepared statements | Query/update, parameter binding, schema discovery; prepared clients must use the rebound handle | integration_test.go, JDBC smoke |
| Flight SQL ingestion | Create, append, replace, create-or-append; autocommit | TestIntegrationIngest |
| Catalogs, schemas, tables, table types | Standard Arrow schemas; optional serialized table schema; exact native types TABLE, VIEW and MATERIALIZED VIEW, including materialized-view discovery/schema validation | TestIntegrationMetadata |
| GetXdbcTypeInfo | Canonical scalar SQL types, ordered by data_type; exact optional type filter; unknown filter returns an empty standard-schema stream. Unbounded/unknown size or scale is NULL. SQL aliases and RECORD are not separate entries. | TestFlightTypeInfo, TestIntegrationTypeInfoDDL |
| GetSqlInfo | Reports server identity, SQL/ingest support, typed capability values and autocommit limitations | unit_test.go and TestIntegrationMetadata |
| Primary/foreign keys | Standard-schema empty results, because the backend has no such constraints | metadata.go |
| Sessions | Cookie sessions for settings and temporary objects; unknown state returns ABORTED before execution and a recovery cookie | session_integration_test.go |
| Shared read snapshots | Session/attempt-bound native managed-catalog view; requires TLS/ACL enterprise deployment, independent validation pending; no qualified release yet | Contract, snapshot_test.go, Python transport suite |
| Flight RPC datasets | PATH GetFlightInfo/GetSchema/PollFlightInfo, DoPut/DoGet, ListFlights, drop_dataset; nested Arrow types, columns/batch selection | dataset integration tests, Python quickstart |
| Query cancellation | CancelFlightInfo and translated legacy CancelQuery; pending/active read-only tickets, identity checks, shared Redis state, cooperative cleanup; completed/write/non-cancellable tickets return NOT_CANCELLABLE | cancellation_integration_test.go |
| DoExchange | Deferred; returns UNIMPLEMENTED and directs clients to DoPut/DoGet | TestFlightUnsupportedCapabilities |
| Transactions/savepoints | Out of scope until the Redis ADBC backend supplies transactional guarantees. BeginTransaction returns UNIMPLEMENTED; transaction IDs on statements/ingestion are rejected. GetSqlInfo advertises no transactions and no ingestion transactions. | sqlserver.go, TestFlightUnsupportedCapabilities |
| Substrait | Deferred until the backend has a supported plan execution contract. Commands return UNIMPLEMENTED and support is advertised as false. | TestFlightUnsupportedCapabilities |
DoExchange is not needed for the defined park/fetch dataset workflow. No application-specific bidirectional transform is promised. A future proposal must specify descriptor and schemas, authorization, backpressure and cancellation for an actual consumer before adding that method.
The JDBC schema limitation still applies to statements whose result schema is unknown when prepared. This matrix does not imply every SQL query streams or that Tableau/Power BI work without compatibility testing.