Connect to Teradata using jaydebeapi package

import pandas as pd

## I save my password in a seperate desktop script and import it
from misc_setup import password

import jaydebeapi
server="severname"
database="db_name"



query = """select * from table where 1=1
                       """
                     
                        

cnn = jaydebeapi.connect('com.teradata.jdbc.TeraDriver',
                            'jdbc:teradata://<server>/TMODE=TERA,FASTLOAD=YES,LOGMECH=LDAP', ['uid', password],
                            ['~/desktop/java/td/terajdbc4.jar','~/desktop/java/td/tdgssconfig.jar'])
  

            
resultData = pd.read_sql(query,cnn)

cnn.close()