Trino is a distributed SQL query engine for big data analytics.
Installation
Required packages: trino
pip install "apache-superset[trino]"Drivers
trinoRecommended
PyPI Package:
trinotrino://{username}:{password}@{hostname}:{port}/{catalog}Supported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Feature Score: 149/201
Time Grains
Common Time Grains:
SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR
Extended Time Grains:
FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR
Extended Aggregate Functions
The base aggregates (SUM, COUNT, AVG, MIN, MAX, COUNT DISTINCT) are supported everywhere; these are opt-in per engine.
MEDIANSTDDEV_SAMPVAR_SAMP
Compatible Databases
The following databases are compatible with the Trino driver:
Starburst GalaxyStarburst Galaxy is a fully-managed cloud analytics platform built on Trino. It provides data lake analytics with enterprise security and governance.
trino://{username}:{password}@{host}:{port}/{catalog}Parameters:
| Parameter | Description |
|---|---|
| username | Starburst Galaxy username (email/role) |
| password | Starburst Galaxy password or token |
| host | Your Galaxy cluster hostname |
| port | Port (default 443) |
| catalog | Catalog name |
Starburst EnterpriseStarburst Enterprise is a self-managed Trino distribution with enterprise features, security, and support.
trino://{username}:{password}@{hostname}:{port}/{catalog}