Hi! I’ve been able to connect to my Dremio Cloud instance with JDBC. Unfortunately, I’m having trouble connecting via Arrow Flight. Is this option enabled for Dremio Cloud?
My python script is as follows and I am using dremio_client:
from dremio_client import init
import pandas as pd
query = 'select 1'
client = init(simple_client=True)
results = client.query(self, query)
pd.DataFrame(results)
I then run:
DREMIO_HOSTNAME=data.dremio.cloud DREMIO_PORT=32010 DREMIO_AUTH_USERNAME='$token' DREMIO_AUTH_PASSWORD=<PersonalAccessToken> python3 -m flight_example
and get an error like:
requests.exceptions.ConnectTimeout: HTTPConnectionPool(host=‘data.dremio.cloud’, port=32010): Max retries exceeded with url: /apiv2/login (Caused by ConnectTimeoutError(<urllib3.connection.HTTPConnection object at 0x7fb1f51d9150>, ‘Connection to data.dremio.cloud timed out. (connect timeout=10)’))
I’ve also tried to use the example here, e.g.
python3 example.py -query 'SELECT 1' -host data.dremio.cloud -port 32010 -authToken <PersonalAccessToken>
and I then get the error:
OSError: gRPC returned unavailable error, with message: failed to connect to all addresses. Detail: Unavailable
which appears to be caused when the server is not accepting connections from Apache Flight.
Is the issue just that Dremio Cloud doesn’t support Arrow Flight?