sqlalchemy_dremio arrow flight ssl certificates about sqlalchemy_dremio HOT 2 OPEN

Please add the following property to dremio.conf, restart the server and try again:

services.flight.auth.mode: "legacy.arrow.flight.auth"

from sqlalchemy_dremio.

Not sure this helps, but I also had problems connection Superset to Dremio using Flight, and after some fiddling around this worked for me. Using legacy auth actually broke it (again) for me, so I commented it out.

1. Change dremio.conf and enable SSL:

services: {
  # ...
  flight.use_session_service: true
  # flight.auth.mode: "legacy.arrow.flight.auth"
  flight.ssl.enabled: true
  flight.ssl.auto-certificate.enabled: true
}

2. Use this kind of connection string:
   dremio+flight://superset:XXXXXX@dremio:32010/dremio?UseEncryption=true&disableCertificateVerification=true

from sqlalchemy_dremio.