How to connect to dremio community edition with pyarrow

1

I am able to connect to my dremio community container using DremioFlightEndpoint library. But I am struggling to ingest data. So I tried pyarrow, but I am struggling generating the access token. Looks like PAT is not possible in community edition. Is there a way to connect using username / password, e.g. generate a bearer token based on username / password, or how would that work ?

would be super helpful to get this connection working

Thanks

Chris

2

ah, took me a while, and surprisingly the bearer token can be generated using username / pw:

bearer_token = client.authenticate_basic_token(“user”, “password”)
options = flight.FlightCallOptions(headers=[bearer_token])

3

Thanks for the update @chrisRains