Honeydew can integrate with Python code, including Jupyter, using the Trino Python client package.Here are some general guidelines for connecting python code to Honeydew JDBC interface.
Before you start, make sure you have the Trino Python client installed in your Jupyter environment:
Copy
Ask AI
pip install trino
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.
It is recommended to use an API Key for setting up the connection.
Copy
Ask AI
import trinofrom trino.dbapi import connectfrom trino.auth import BasicAuthenticationconn = 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>'),(or to the user's password in Honeydew). # 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)