sqlalchemy_redshift_connection_quickstart_simple_query.py

1from sqlalchemy import create_engine
2
3# Replace placeholders with your actual Redshift credentials
4# The connection string format is:
5# redshift+psycopg2://username:password@host:port/dbname
6engine = create_engine('redshift+psycopg2://username:password@host.amazonaws.com:5439/database')
7
8with engine.connect() as connection:
9    result = connection.execute("SELECT 1")
10    for row in result:
11        print(row)