Jupyter

import trino

from trino.dbapi import connect
from trino.auth import BasicAuthentication
conn = connect(
    # If your organization uses a custom hostname for the JDBC connection,
    # you can locate it in the Honeydew UI, under the JDBC section in Settings.
    host="jdbc.honeydew.cloud",
    port=443,
    http_scheme='https',

    # For credentials, pass the API key (or a Honeydew username),
    # and the API secret (or the Honeydew password)
    auth=BasicAuthentication('<api key name>', '<api key secret>'),

    # catalog is based on the Honeydew "workspace" and "branch" you would like to connect to.
    # Omit the branch value if connecting to "prod".
    # For example, for workspace "tpch", branch "prod", the value would be: "tpch".
    catalog="<workspace>__<branch>"
)

cur = conn.cursor()
cur.execute("SHOW TABLES FROM domains")
rows = cur.fetchall()
print(rows)

cur.execute('SELECT "orders.o_orderdate", AGG("lineitem.revenue") FROM domains.my_domain')
rows = cur.fetchall()
print(rows)