Jupyter on Docker dremio AWS

I have been using jupyter notebook from my windows laptop and installed dremio on docker on EC2 on AWS.
Using below code for connection using client:

What should be driver in this case and where it should be dumped onto Ec2 or onto My machine and where.

import pyodbc, pandas

host =
port = 31010
uid =
pwd =
driver =

cnxn = pyodbc.connect(“Driver={};ConnectionType=Direct;HOST={};PORT={};AuthenticationType=Plain;UID={};PWD={}”.format(driver, host,port,uid,pwd),autocommit=True)

sql = ‘’‘SELECT * FROM foo.bar’’’

dataframe = pandas.read_sql(sql,cnxn)


ODBC driver is always on the client so in your case would be your jupyter notebook on your windows laptop