Python: An example of querying trino using sqlalchemy

trino-and-sqlalchemy.py

# pip install trino

from sqlalchemy.engine import create_engine
import pandas as pd

uri = "trino://localhost:8080/tpch/sf1"
engine = create_engine(uri, connect_args={'http_scheme': 'http', 'user': 'admin'})
connection = engine.connect()
df = pd.read_sql("select * from customer", connection)