'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 |
|---|
