import pyodbc conn = pyodbc.connect('DSN=Teradata_Dev;UID=user;PWD=pass') cursor = conn.cursor() cursor.execute("SELECT COUNT(*) FROM dbc.tables") print(cursor.fetchone())
Download and install the Teradata ODBC driver from the Teradata website. teradata odbc driver
: Offers flexible security options including LDAP, Kerberos (KRB5) , Teradata 2 (TD2), and Single Sign-On (SSO). Newer versions support JSON Web Token (JWT) and CloudSSO via external browsers. import pyodbc conn = pyodbc
Data → Get Data → From Database → From ODBC → DSN name. import pyodbc conn = pyodbc.connect('DSN=Teradata_Dev