Hi.
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)