connecting_to_presto.md

Connecting to Presto DB

How to connect to PrestoDB via Python using presto-python-client

The BasicAuthentication class can be used to connect to a LDAP-configured Presto cluster:

import prestodb

def connect_to_presto():
    try:
        with prestodb.dbapi.connect(
            host="host url",
            port=1234,
            user="username",
            catalog="catalog",
            schema="schema",
            http_scheme="https",
            auth=prestodb.auth.BasicAuthentication("principal id", "password"),
        ) as conn:
            cur = conn.cursor()
            cur.execute('SELECT * FROM some.table')
            return cur.fetchall()

        except prestodb.exceptions.HttpError as err:
            raise SystemExit(err)

Everything above is quite self explainitory however I wasnt to sure what principal id was. After asking the right people at my place of work, it was the same as my username.