Skip to content

Latest commit

 

History

History
302 lines (206 loc) · 9.85 KB

resources.md

File metadata and controls

302 lines (206 loc) · 9.85 KB
layout menu_id title show_hero
default
resources
Resources
true

Client libraries {#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 {#ui}

Quix is a multi-user, easy-to-use notebook manager. By utilizing Trino 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 Trino 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 Trino, 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 Trino. 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 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 {#tools}

The Datadog integration allows the observability service for cloud-scale applications to monitor your Trino cluster. It accesses the JMX metrics provided by Trino, and exposes them in Datadog for monitoring, inspection, and troubleshooting purposes.

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

The Workload Analyzer collects Trino workload statistics, and analyzes them. The resulting report provides improved visibility into your analytical workloads, and enables cluster performance optimization. For installation, see here.

Enterprise support {#support}

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 Starburst Enterprise, a fully supported, enterprise ready Trino distribution. 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.

Managed services {#managed}

Starburst Galaxy is the leading SaaS offering of Trino. It is capable of running clusters in all major clouds, and is fully managed for you by Starburst.

It includes a rich user interface with query editor, query history, cluster management, security configuration, and much more. Watch one of the demo videos and find details in the comprehensive user documentation.

Amazon Athena is an interactive query service based on an older version of Trino 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 Trino 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 {#cloud}

Trino is readily available in AWS and Azure cloud environments.

AWS {#aws}

Starburst Enterprise 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 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.

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 Trino cluster in minutes. You don't need to worry about node provisioning, cluster setup or tuning.

Using Trino 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 {#azure}

Starburst Enterprise is available via the Azure Marketplace.

Google Cloud {#gcp}

Starburst Enterprise is available via the Google Cloud Marketplace.