Connecting to StarTree Cloud using Python

pip install pinotdb

from pinotdb import connect

USERNAME = '<your-username>'
PASSWORD = '<your-password>'
BROKER_HOST_URL = 'broker.pinot.<your-url>.startree.cloud'

conn = connect(
    host=f'{USERNAME}:{PASSWORD}@{BROKER_HOST_URL}',
    port=443,
    path='/query/sql', 
    scheme='https'
)
curs = conn.cursor()
curs.execute("select * from myTable limit 10")

for row in curs:
    print(row)

from sqlalchemy import *
from sqlalchemy.engine import create_engine
from sqlalchemy.schema import *

engine = create_engine('pinot://localhost:8099/query/sql?controller=http://localhost:9000/')  # uses HTTP by default
# engine = create_engine('pinot+http://localhost:8099/query/sql?controller=http://localhost:9000/')
# engine = create_engine('pinot+https://localhost:8099/query/sql?controller=http://localhost:9000/')

places = Table('places', MetaData(bind=engine), autoload=True)
print(select([func.count('*')], from_obj=places).scalar())

git clone git@github.com:python-pinot-dbapi/pinot-dbapi.git
cd pinot-dbapi