I'm using the driver 'Dremio ODBC Driver 64-bit' however when I run:
engine = create_engine("""{}+pyodbc://{}:{}@{}/""".format(driver,uid,pwd,host))
with driver = 'Dremio ODBC Driver 64-bit' I get the following error (I changed it to uid:pwd for obvious reasons...)
sqlalchemy.exc.ArgumentError: Could not parse rfc1738 URL from string 'Dremio ODBC Driver 64-bit+pyodbc://uid:pwd@localhost:31010/'
which I believe comes from the spaces. I've tried changing the Driver name to Dremio by changing the header [Dremio ODBC Driver 64-bit] in odbcinst.ini to [Dremio] but that gave the error:
sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:Dremio
so I don't think I did it correctly, maybe there's something else to change?