Python

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:

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. When Snowflake, Databricks or BigQuery uses per-user OAuth, use a per-user API key: an organization-level key cannot run warehouse queries.

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)

Quick Start

Semantic Ecosystem

Modeling Reference

Context Layer

Management

Integrations

Security

Release Notes