# Does Dremio Cloud support Arrow Flight?

**URL:** <https://community.dremio.com/t/does-dremio-cloud-support-arrow-flight/8935>\
**Category:** Dremio Cloud\
**Created:** [March 24, 2022, 5:23am UTC](https://community.dremio.com/t/does-dremio-cloud-support-arrow-flight/8935 "2022-03-24T05:23:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![redgeoff](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/redgeoff/32/4040_2.png) [@redgeoff](https://community.dremio.com/u/redgeoff)\
**Post date:** [March 24, 2022, 5:23am UTC](https://community.dremio.com/t/does-dremio-cloud-support-arrow-flight/8935/1 "2022-03-24T05:23:22Z")

</div>

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](https://github.com/rymurr/dremio_client):

```auto
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:

```auto
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](https://github.com/dremio-hub/arrow-flight-client-examples/tree/main/python), e.g.

```auto
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?

---

<div class="post-metadata">

**Author:** ![James\_Gupta](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/james_gupta/32/4002_2.png) [@James\_Gupta](https://community.dremio.com/u/James_Gupta)\
**Post date:** [March 24, 2022, 2:16pm UTC](https://community.dremio.com/t/does-dremio-cloud-support-arrow-flight/8935/2 "2022-03-24T14:16:02Z")

</div>

Hi redgeoff,

Dremio certainly supports Arrow Flight. Here is our guide for getting started: [Dremio](https://docs.dremio.com/cloud/arrow-flight/)

As to your issues, we will investigate and get back to you.

---

<div class="post-metadata">

**Author:** ![redgeoff](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/redgeoff/32/4040_2.png) [@redgeoff](https://community.dremio.com/u/redgeoff)\
**Post date:** [March 24, 2022, 3:58pm UTC](https://community.dremio.com/t/does-dremio-cloud-support-arrow-flight/8935/3 "2022-03-24T15:58:55Z")

</div>

Appreciate it. I would suspect that the “Dremio Software” edition has Arrow Flight support, but does “Dremio Cloud” have support for Arrow Flight?

---

<div class="post-metadata">

**Author:** ![jduong](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/jduong/32/21_2.png) [@jduong](https://community.dremio.com/u/jduong)\
**Post date:** [March 24, 2022, 4:11pm UTC](https://community.dremio.com/t/does-dremio-cloud-support-arrow-flight/8935/4 "2022-03-24T16:11:56Z")

</div>

Hi @redgeoff ,  
Per the link @James_Gupta sent out, you should be using port 443 and enable encryption to use Arrow Flight with Dremio Cloud.

---

<div class="post-metadata">

**Author:** ![redgeoff](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/redgeoff/32/4040_2.png) [@redgeoff](https://community.dremio.com/u/redgeoff)\
**Post date:** [March 24, 2022, 4:36pm UTC](https://community.dremio.com/t/does-dremio-cloud-support-arrow-flight/8935/5 "2022-03-24T16:36:14Z")

</div>

Thank you @jduong!

I was able to get the [arrow-flight-client-examples](https://github.com/dremio-hub/arrow-flight-client-examples/tree/main/python) to work by changing the port, e.g.

```auto
python3 example.py -query 'SELECT 1' -host data.dremio.cloud -port 443 -tls -authToken <PersonalAccessToken>

```

Unfortunately, this didn’t seem to work for my code that uses [dremio\_client](https://github.com/rymurr/dremio_client) (see above). I tried:

```auto
DREMIO_HOSTNAME=data.dremio.cloud DREMIO_PORT=443 DREMIO_AUTH_USERNAME='$token' DREMIO_AUTH_PASSWORD=<PersonalAccessToken> DREMIO_SSL=true python3 -m flight_example

```

and received the error:

> requests.exceptions.HTTPError: 415 Client Error: Unsupported Media Type for url: [https://data.dremio.cloud:443/apiv2/login](https://data.dremio.cloud:443/apiv2/login)

I’m guessing this might just be a problem with `dremio_client`. I’ll post here if I find a workaround. (At least I know the arrow-flight-client-examples code works)