Pyarrow flight DNS fails in Windows 10

Hello,
We are facing dns error while connecting dremio with grpc+tls only in windows 10 machine(using visual studio code). The same works fine in Mac machine.
Please let me know if any one has faced this issue…

flight_info = client.get_flight_info(flight.FlightDescriptor.for_command(query), options)
File “pyarrow_flight.pyx”, line 1603, in pyarrow._flight.FlightClient.get_flight_info
File “pyarrow_flight.pyx”, line 68, in pyarrow._flight.check_flight_status
pyarrow._flight.FlightUnavailableError: Flight returned unavailable error, with message: DNS resolution failed for dremio-xxx-xxx-xxx.xxx.xxx-digital.net:443: C-ares status is not ARES_SUCCESS qtype=A name=dremio-xxx-xxx-xxx.xxx.xxx-digital.net is_balancer=0: Domain name not found

@rajan-raman-maersk Welcome to the Dremio Community!

Try setting the gRPC DNS resolver to native. Add the following to your python code:

from os import environ
environ["GRPC_DNS_RESOLVER"] = "native"

Thanks for the response, I tried this earlier, but not helping. Pls find the below error

flight_info = client.get_flight_info(flight.FlightDescriptor.for_command(query), options)

File “pyarrow_flight.pyx”, line 1603, in pyarrow._flight.FlightClient.get_flight_info
File “pyarrow_flight.pyx”, line 68, in pyarrow._flight.check_flight_status
pyarrow._flight.FlightUnavailableError: Flight returned unavailable error, with message: empty address list:

Looks like you may have progressed as this is a different error from the DNS resolution error you got earlier. Could you confirm that flight url & port specified is correct dremio-xxx-xxx-xxx.xxx.xxx-digital.net:443?

It is interesting that the same python code works on Mac but not on Windows (wonder if there’s a firewall or something?). Could you paste the code if possible?