import teradata

udaExec = teradata.UdaExec (appName="Test", version="1.0",logConsole=False)
# This is using odbc method; system is env name (dev, test or prod);
# enter valid user name and pwd
session = udaExec.connect(method="odbc", system="XXX", username="YYY", password="ZZZ");

for row in session.execute("SELECT count(*) from dbc.tablesv"):
    print('Output: ',row)

session.close()
print('Session Closed')