teradatasqlalchemy_connection_and_simple_query_quickstart.py

1from sqlalchemy import create_engine
2
3# Replace the placeholders with your actual Teradata credentials and connection details
4host = 'your_teradata_host'
5username = 'your_username'
6password = 'your_password'
7
8# Create the engine using the teradatasql dialect
9# The connection string format is: teradatasql://{user}:{password}@{host}
10engine = create_engine(f'teradatasql://{username}:{password}@{host}')
11
12# Use the engine to connect and execute a simple query
13with engine.connect() as connection:
14    result = connection.execute("SELECT DATABASE")
15    for row in result:
16        print(row)