from sqlalchemy import create_engine
url = "{AWS rds db url: postgresql://{user}:{password}@{rds endpoint}:{port}/{DB name}}"
engine = create_engine(url)
connect = engine.connect()
query = "select * from {table name}"
# output is pandas dataframe
dataframe = pd.read_sql(query, con=connect)