Flight SQL is not supported in Python (client or server). For the server side, I think we can consider PRs. The API surface is large, so I worry it would be tedious to maintain.
For the client side, there is an experimental driver available for ADBC [1]. For the ODBC driver, IIRC James Duong has stated it was mostly tested against Dremio. (It's not part of the Arrow project due to licensing issues, because it has code derived from a GPL codebase - though I believe those parts could be rewritten eventually.) So this is a case of 'try it and see'. [1]: https://github.com/apache/arrow-adbc/tree/main/python/adbc_driver_flightsql On Wed, Feb 1, 2023, at 09:00, Philip Moore wrote: > Hi Chang, > > Here are the examples from the Arrow repo: > https://github.com/apache/arrow/tree/master/cpp/src/arrow/flight/sql/example > > They have SQLite and Acero example servers built… > > Thanks. > > Phil > > *From: *Chang She <[email protected]> > *Date: *Tuesday, January 31, 2023 at 10:01 PM > *To: *[email protected] <[email protected]> > *Subject: *example pyarrow flight sql server? > Hi there, > > I was looking to play around with flight sql server but couldn't find an > example/reference server implementation to help me get started. If anyone can > point me in the right direction I'd really appreciate it. > > Thanks! > > Chang
