Presto SQL is now Trino Read why »

Resources

Client libraries

The following client libraries can be used to run queries from several programming languages, and programs using the related platform:

BI tools and notebooks

Quix

Quix is a multi-user, easy-to-use notebook manager. By utilizing Presto it provides unified access to multiple data sources and effectively acts as a shared space for your company’s BI insights and know-how.

Redash

Redash is a take on freeing the data within our company in a way that will better fit our culture and usage patterns. It has Presto support as well as other backends, and offers a query editor with syntax highlighting and completion, and creating visualizations and dashboards from query results.

Apache Superset

Apache Superset enables users to consume data in many different ways: writing SQL queries, creating new tables, creating a visualization (slice), adding that visualization to one or many dashboards and downloading a CSV. SQL Lab is a a part of Superset and provides a rich SQL editor that enables users to both query and visualize data. You can explore and preview tables in Presto, effortlessly compose SQL queries to access data. From there, you can either export a CSV file or immediately visualize your data in the Superset “Explore” view.

yanagishima

yanagishima is a web application for Presto. yanagishima provides the ability to execute query, show query, kill query, bookmark query, search table, share query/query result, format query, download as CSV/TSV file, insert chart, substitute query parameter, and so on.

Hue

Hue is a mature open source SQL assistant for querying databases and data warehouses. It is used by Fortune 500 companies, and focused on smart query typing. Follow the instructions to use the Trino connector to get started.

Management tools

Presto-Admin

Presto-Admin is a tool for installing and managing the Presto query engine on a cluster. It provides easy-to-use commands:

  • Install and uninstall Presto across your cluster
  • Configure your Presto cluster
  • Start and stop the Presto servers
  • Gather status and log information from your Presto cluster

If you need any assistance with your Presto cluster management reach out to Starburst for their Presto enterprise support offering and other Presto related services.

Presto-Gateway

Presto-Gateway is a gateway/proxy/load-balancer for multiple presto clusters. Users can register/de-register Presto clusters behind the gateway and connect to it using standard presto-clients.

Enterprise support

Starburst

Enterprise 24/7 Support, Installation, Configuration, Training, Custom Development, Tuning

At Starburst, our team is a major contributor to the open source Trino project. We consist of many of the experts and maintainers who have been contributing to and advancing the Trino product over the last few years. Starburst provides an enterprise ready Trino distribution and Trino support. Starburst’s distribution of Trino consists of additional tooling and configurations to make it work well in the enterprise. Further, it is rigorously tested at scale and patched as needed. With our wide range of services, support, and training we help you be successful in this new world of open source technologies in the enterprise.

In addition to implementing Trino internals to make it the most reliable, robust, and performant open source distributed query engine, our team at Starburst is dedicated to continually improve and add the needed features for the enterprise. Our major enterprise focus areas are ease-of-use, security, robustness, wide range of integrations, and reliable support SLAs.

Qubole

Enterprise 24/7 Support, HotFixes, Multiple Presto Versions, Backporting of critical open source fixes and enhancements, Configuration, Tuning

Qubole has been offering a managed Presto service since 2014. Qubole offers multiple Presto versions across multiple clouds (AWS, Azure and GCP) and maintains a regular upgrade process. Qubole offers 24/7 support through its support and engineering teams spread across the globe. Qubole hotfixes critical production issues or major issues addressed in open source community. Qubole also backports critical fixes and major enhancements from recent versions of Presto to older versions. Qubole helps its users configure their clusters, fine tune their workloads and get the best out of Presto.

Managed services

Presto on Qubole

Qubole has been offering a managed Presto service since 2014. Qubole has optimized Presto for the cloud. Qubole’s enhancements allow for dynamic cluster sizing, based on workload and termination of idle clusters — ensuring high reliability while reducing compute costs.

Qubole offers multiple Presto versions across multiple clouds (AWS, Azure and GCP) and maintains a regular upgrade process. Qubole blends the latest features from the open source community with Qubole’s proprietary solutions that boost performance, lower cost, improve user experience, and provide smooth administration of Presto clusters.

Amazon Athena

Amazon Athena is an interactive query service based on Presto that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run. Amazon Athena uses Presto with full standard SQL support and works with a variety of standard data formats. Athena is out-of-the-box integrated with AWS Glue Data Catalog, allowing you to create a unified metadata repository across various services, crawl data sources to discover schemas and populate your Catalog with new and modified table and partition definitions, and maintain schema versioning.

Cloud

Presto is readily available in AWS and Azure cloud environments.

AWS

Starburst Enterprise Presto on AWS

Starburst Enterprise Presto on AWS combines the reliable, scalable, and cost-effective cloud computing services provided by Amazon Web Services (AWS) with the power of Trino, the fastest growing distributed SQL query engine within the industry.

Through the use of Starburst’s CloudFormation template and Starburst Trino AMI, Starburst Enterprise Presto on AWS enables you to run analytic SQL queries across a wide variety of data sources with elastic scaling and usage-based pricing. Read more how to use Trino on AWS on our AWS Documentation site.

Presto on Qubole on AWS

Qubole offers a managed Presto service on AWS that is optimized for the cloud. Qubole supports cluster autoscaling based on workload and termination of idle clusters — ensuring high reliability while reducing compute costs. Qubole supports usage of spot nodes on AWS with built in failure resilience around spot termination notification handling and query retries. With Presto on Qubole, users can create heterogenous clusters with spot nodes from similar instance families that can further help reduce compute costs.

Amazon EMR

Amazon EMR provides a managed Hadoop framework that makes it easy, fast, and cost-effective to process vast amounts of data across dynamically scalable Amazon EC2 instances. With EMR, you can launch a large Presto cluster in minutes. You don’t need to worry about node provisioning, cluster setup or tuning.

Using Presto on EMR provides these benefits to customers:

  • Elasticity: With Amazon EMR, you can provision one, hundreds, or thousands of compute instances to process data at any scale. You can easily increase or decrease the number of instances manually or with Auto Scaling, and you only pay for what you use.
  • Simple and predictable pricing: You pay a per-second rate for every second used, with a one-minute minimum charge.

Azure

Starburst Enterprise Presto on Azure

Starburst Enterprise Presto is available via the Azure Marketplace.

Presto on Qubole on Azure

Qubole offers a managed Presto service on Azure that is optimized for the cloud. Qubole supports cluster autoscaling based on workload and termination of idle clusters — ensuring high reliability while reducing compute costs. Qubole supports both Gen1 and Gen2 of Azure Data Lake Storage (ADLS) as well as Azure Blob Storage.

GCP

Presto on Qubole on GCP

Qubole offers a managed Presto service on GCP that is optimized for cloud and is integrated with GCP marketplace. Qubole supports cluster autoscaling based on workload and termination of idle clusters — ensuring high reliability while reducing compute costs. Qubole supports use of preemptible VMs in its autoscaling to reduce costs. Qubole has also added support for faster detection of query failures in Presto caused by preemptible VM interruption.