Dremio Python connection

[gpalazzo]

Hi community.

I’m new to Dremio. I was able to successfully setup a dremio service, create a dataset through query.
Now I would like to retrieve this dataset from Python.

I’ve explored the following solutions:

1. Dremio REST API | Dremio
2. Dremio

The errors I receive for each attempt are:

1. TypeError: ‘NoneType’ object is not subscriptable – when executing the step: jobid = querySQL(query)
2. FlightUnavailableError: Flight returned unavailable error, with message: failed to connect to all addresses

My next attempt will be via pyodbc.

Any ideas on how to solve the issues? I particularly like the solution number 1 with direct connect to Dremio API.

PS: not sure if it’s relevant, but I’m using Dremio Community Edition inside a Docker Container.

Thanks.

[YEN]

Hi, if you want to use Arrow flight, try to look over there:

Install/config issue arrow flight on dremio docker

Hi, Yes, you will have to amend the dremio.conf config file. You can use a “docker exec -it yourdockername bash” but the issue is that you will not have any editor to amend the file inside of the container. you will still be able to find the file: [image] I end up moving the file between the host and the docker with: docker cp youdockername:/opt/dremio/conf/dremio.conf . [image] Amend the file: [image] The save it / copy back to the container docker cp dremio.conf dremio13v2:/opt/dremi…

You should have all steps regarding the docker amendment and py script.

[gpalazzo]

hi there @YEN !
thanks for answering my question.

I was doing a port mapping the wrong way, that’s why it wasn’t working.
Following this tutorial: Dremio with latest dremio-oss docker image works like a charm.

Thanks.