# Connections to Dremio

**URL:** <https://community.dremio.com/t/connections-to-dremio/10887>\
**Category:** Dremio Cloud\
**Created:** [August 10, 2023, 6:49am UTC](https://community.dremio.com/t/connections-to-dremio/10887 "2023-08-10T06:49:36Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![zac](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/zac/32/5077_2.png) [@zac](https://community.dremio.com/u/zac)\
**Post date:** [August 10, 2023, 6:49am UTC](https://community.dremio.com/t/connections-to-dremio/10887/1 "2023-08-10T06:49:36Z")

</div>

Hello all, I am new to Dremio. I want to connect our Dremio instance with python. The first choice is via Glue job in AWS. I can use local pyspark docker env to connect to Dremio via jdbc connection which is good without any issue. Then I apply the same logic into Glue. Here is the exception I am facing:  
java.sql.SQLException:cfjd.org.apache.arrow.flight.FlightRuntimeException:UNAVAILABLE: unresolved address.  
The logic I used for above(local docker and aws Glue):

```auto
table_data_dev = spark.read.format("jdbc") \
.option("user",user_dev)\
.option("password", password_dev) \
.option("driver", "org.apache.arrow.driver.jdbc.ArrowFlightJdbcDriver") \
.option("url", jdbc_uri_dev) \
.option("disableCertificateVerification", "true") \
.option("threadPoolSize",100)\
.option("query", 'SELECT * FROM INFORMATION_SCHEMA."TABLES"') \
.load()

```

Then I followed example from link below on my local dev machine:

> **[GitHub - dremio-hub/arrow-flight-client-examples](https://github.com/dremio-hub/arrow-flight-client-examples/tree/main)**
>
> main

This time,I got another exception  
pyarrow.\_flight.FlightUnavailableError: Flight returned unavailable error, with message: DNS resolution failed for https:: C-ares status is not ARES\_SUCCESS qtype=AAAA name=https is\_balancer=0: Domain name not found

The goal for us is to fetch data from Dremio and store them in our s3 bucket. Glue job is the top choice, or python logic in ec2 as the second.

From exceptions above seems there are some net work or cert related configurations have been ignored from our side. There are limited resources for above two exceptions and we are blocked by them.May I know if someone can help regarding this? Thanks in advance.

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [August 15, 2023, 6:58am UTC](https://community.dremio.com/t/connections-to-dremio/10887/2 "2023-08-15T06:58:51Z")

</div>

@zac Are you able to add the S3 bucket as a S3 source in Dremio? Once that is done, you can then write a SQL that fetches the data you need. Once that is done you can add a “Create Table \<table\_name\> as Select …” on top of it. This should write the results as Iceberg or Parquet to the path you specify on the CTAS command. Have you tried that?

> **[Tables | Dremio Documentation](https://docs.dremio.com/current/reference/sql/commands/tables/)**
>
> Tables can be created in either the shared $scratch location or in filesystem sources types.

---

<div class="post-metadata">

**Author:** ![zac](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/zac/32/5077_2.png) [@zac](https://community.dremio.com/u/zac)\
**Post date:** [October 5, 2023, 11:50pm UTC](https://community.dremio.com/t/connections-to-dremio/10887/3 "2023-10-05T23:50:51Z")

</div>

Hello,  
Thanks for the reply. Yes, our team fix that issue and we are able to get data from Dremio.

Thanks

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [October 7, 2023, 6:47pm UTC](https://community.dremio.com/t/connections-to-dremio/10887/4 "2023-10-07T18:47:07Z")

</div>

Thanks for the update @zac

---

<div class="post-metadata">

**Author:** ![julian.schaefer](https://avatars.discourse-cdn.com/v4/letter/j/b5a626/32.png) [@julian.schaefer](https://community.dremio.com/u/julian.schaefer)\
**Post date:** [February 5, 2024, 10:31am UTC](https://community.dremio.com/t/connections-to-dremio/10887/5 "2024-02-05T10:31:44Z")

</div>

Hello Zac,

we have been encountering exactly the same issue at our end. Can you share any details on how your team has resolved the same ?

Thanks and best regards,  
Julian