The following client libraries can be used to run queries from several programming languages, and programs using the related platform:
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 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 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 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.
Presto-Admin is a tool for installing and managing the Presto query engine on a cluster. It provides easy-to-use commands:
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 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.
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.
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 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.
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.
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 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:
Starburst Enterprise Presto is available via the Azure Marketplace.
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.
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.