Arrow Flight with PAT

1

I am attempting to test the arrow flight client examples. It works successfully with -user and -pass, but I am unable to connect with -user and -pat.

With the Java sample I get:

[ERROR] Exception: 
org.apache.arrow.flight.FlightRuntimeException: UNAUTHENTICATED:

With the Python sample I get:

[INFO] Authentication skipped until first request
[INFO] Query:  select 1
[ERROR] Exception: OSError('gRPC returned unauthenticated error, with message: . Detail: Unauthenticated')
Traceback (most recent call last):
  File "example.py", line 263, in <module>
    args.engine, args.session_properties)
  File "example.py", line 236, in connect_to_dremio_flight_server_endpoint
    schema = client.get_schema(flight_desc, options)
  File "pyarrow\_flight.pyx", line 1300, in pyarrow._flight.FlightClient.get_schema
  File "pyarrow\error.pxi", line 99, in pyarrow.lib.check_status
OSError: gRPC returned unauthenticated error, with message: . Detail: Unauthenticated

How do I connect using a PAT?

2

Hi @Joe ,

You only need to supply -pat and not -user. However this should just cause the user to get ignored and the PAT used.

Have you been able to use the PAT elsewhere such as the REST API or through ODBC/JDBC?

3

Thanks for your reply! If I leave off -user, I get exactly the same result in both Java and Python. Yes, I’ve been using the PATH in both the REST API as well as ODBC.

It’s Dremio 16.3, if that matters.