'Unable to connect to Teradata using sqlalchemy

I'm trying to connect to Teradata using sqlalchemy as have to read sql using read_sql().

Code:

import pandas as pd
import numpy as np
import sqlalchemy 
import teradata
import sqlalchemy_teradata 

link = f'teradata://{username}:{password}@{hostname}/?logmech=LDAP'

connect = sqlalchemy.create_engine(link)

query_1 = "drop table TMP_WORK_DB.test1"
query_1_df = pd.read_sql(query_1, connect)

Error:

teradata.api.DatabaseError: (439, "[08001] [Teradata][socket error] (439) WSA E HostUnreach: The Teradata server can't currently be reached over this network, [Teradata][ODBC Teradata Driver] (27) Failed to log on.")

I have installed Teradata Database ODBC Driver 16.2.

Please help me with the same. Thanks in advance.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source