set_user_agent.py

from databricks import sql
import os

with sql.connect(
    server_hostname=os.getenv("DATABRICKS_SERVER_HOSTNAME"),
    http_path=os.getenv("DATABRICKS_HTTP_PATH"),
    access_token=os.getenv("DATABRICKS_TOKEN"),
    _user_agent_entry="ExamplePartnerTag",
) as connection:

    with connection.cursor() as cursor:
        cursor.execute("SELECT * FROM default.diamonds LIMIT 2")
        result = cursor.fetchall()

        for row in result:
            print(row)