Starburst | Starburst

<!DOCTYPE html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"> <meta http-equiv="x-ua-compatible" content="ie=edge"> <title>Starburst | Starburst</title> <meta name="viewport" content="width=device-width"> <meta property="og:type" content="website"> <meta property="og:title" content="Starburst - Starburst"> <meta property="og:description" content="Your hub to all knowledge about Starburst products."> <meta property="og:image" content="/assets/img/starburst-og-image.png"> <link rel="stylesheet" href="https://fonts.googleapis.com/css2?family=Material+Symbols+Rounded">  <link rel="stylesheet" href="/assets/css/bootstrap.min.css"> <link rel="stylesheet" href="/assets/css/mdb.min.css"> <link rel="stylesheet" href="/assets/css/highlight.css"> <link rel="stylesheet" href="/assets/css/fonts.css"> <link rel="stylesheet" href="/assets/css/style.css"> <script async src="https://www.googletagmanager.com/gtag/js?id=G-CY10FQPGJS"></script> <script> window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', 'G-CY10FQPGJS'); </script> <script type="text/javascript"> window.heap=window.heap||[],heap.load=function(e,t){window.heap.appid=e,window.heap.config=t=t||{};var r=document.createElement("script");r.type="text/javascript",r.async=!0,r.src="https://cdn.heapanalytics.com/js/heap-"+e+".js";var a=document.getElementsByTagName("script")[0];a.parentNode.insertBefore(r,a);for(var n=function(e){return function(){heap.push([e].concat(Array.prototype.slice.call(arguments,0)))}},p=["addEventProperties","addUserProperties","clearEventProperties","identify","resetIdentity","removeEventProperty","setEventProperties","track","unsetEventProperty"],o=0;o<p.length;o++)heap[p[o]]=n(p[o])}; heap.load("588835629"); </script> <script> var ALGOLIA_INSIGHTS_SRC = "https://cdn.jsdelivr.net/npm/search-insights@2.2.1"; !function(e,a,t,n,s,i,c){e.AlgoliaAnalyticsObject=s,e[s]=e[s]||function(){ (e[s].queue=e[s].queue||[]).push(arguments)},i=a.createElement(t),c=a.getElementsByTagName(t)[0], i.async=1,i.src=n,c.parentNode.insertBefore(i,c) }(window,document,"script",ALGOLIA_INSIGHTS_SRC,"aa"); </script>  <title>Starburst | Your hub to all knowledge about Starburst products.</title> <meta name="generator" content="Jekyll v4.2.2" /> <meta property="og:title" content="Starburst" /> <meta property="og:locale" content="en_US" /> <meta name="description" content="Your hub to all knowledge about Starburst products." /> <meta property="og:description" content="Your hub to all knowledge about Starburst products." /> <link rel="canonical" href="https://docs.starburst.io/" /> <meta property="og:url" content="https://docs.starburst.io/" /> <meta property="og:site_name" content="Starburst" /> <meta property="og:type" content="website" /> <meta name="twitter:card" content="summary" /> <meta property="twitter:title" content="Starburst" /> <script type="application/ld+json"> {"@context":"https://schema.org","@type":"WebSite","description":"Your hub to all knowledge about Starburst products.","headline":"Starburst","name":"Starburst","publisher":{"@type":"Organization","logo":{"@type":"ImageObject","url":"https://docs.starburst.io/assets/img/logo/starburst-reverse.png"}},"url":"https://docs.starburst.io/"}</script>  </head> <body> <header class="main-header navbar-expand-md"> <div class="navbar fixed-top navbar-dark"> <div class="container"> <div class="navbar-left-container"> <a class="navbar-brand" href="https://www.starburst.io/"> <img src="/assets/img/logo/Starburst_Logo_White+Blue.svg" height="25" alt="Starburst"> </a> <span class="navbar-divider"></span> <a href="/" class="header-text">Documentation</a> </div> <div class="nav-item dropdown" id="site-search"> <div id="dropdownSearchDisplay" aria-labelledby="dropdownSearch"> <div id="algolia-search"> <div id="searchbox"></div> <div class="refinement-list" id="versionsRefinementList" style="display: none" ></div> <div class="refinement-list" id="product-list"> <h6>Product:</h6> </div> <div id="hits"></div> <div id="stats"></div> </div> </div> </div> <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation"> <span class="navbar-toggler-icon"></span> </button> </div> </div> <nav class="primary-nav"> <div class="container collapse navbar-collapse" id="navbarSupportedContent"> <ul class="navbar-layout navbar-nav mr-auto"> <li class="nav-item dropdown"> <a id="introduction" class="nav-link dropdown-toggle" aria-haspopup="true" aria-label="Introduction" data-is-click="false" href="/introduction/index.html">Introduction</a> <div class="dropdown-menu dropdown-docs"> <a class="dropdown-item" href="/introduction/concepts.html">Concepts</a> <a class="dropdown-item" href="/introduction/architecture.html">Architecture</a> <a class="dropdown-item" href="/introduction/choose-your-starburst-product.html">Choose your Starburst product</a> <a class="dropdown-item" href="/introduction/data-sources-catalogs.html">Data sources and catalogs</a> <a class="dropdown-item" href="/introduction/data-lake.html">Data lakes</a> <a class="dropdown-item" href="/introduction/object-storage.html">Using object storage systems</a> <a class="dropdown-item" href="/introduction/metastores.html">Metastore options</a> <a class="dropdown-item" href="/introduction/security.html">Security</a> <a class="dropdown-item" href="/introduction/querying-data.html">Querying data with Starburst products</a> <a class="dropdown-item" href="/introduction/starburst-sql.html">Using SQL</a> <a class="dropdown-item" href="/introduction/migration.html">Migrating queries to Starburst</a> <a class="dropdown-item" href="/introduction/query-performance.html">Query performance</a> <a class="dropdown-item" href="/introduction/performance-features.html">Performance features</a> </div> </li> <li class="nav-item dropdown"> <a id="clients" class="nav-link dropdown-toggle" aria-haspopup="true" aria-label="Clients" data-is-click="false" href="/clients/index.html">Clients</a> <div class="dropdown-menu dropdown-docs"> <a class="dropdown-item" href="/clients/index.html">All clients</a> <a class="dropdown-item" href="/clients/gather-connection-information.html">Gather connection information</a> <a class="dropdown-item" href="/clients/cli.html">Trino CLI</a> <a class="dropdown-item" href="/clients/jdbc.html">JDBC driver</a> <a class="dropdown-item" href="/clients/odbc.html">ODBC driver</a> <a class="dropdown-item" href="/clients/machine-learning.html">Machine learning</a> </div> </li> <li class="nav-item dropdown"> <a id="starburst-galaxy" class="nav-link dropdown-toggle" aria-haspopup="true" aria-label="Starburst Galaxy" data-is-click="false" href="/starburst-galaxy/index.html">Starburst Galaxy</a> <div class="dropdown-menu dropdown-docs"> <a class="dropdown-item" href="/starburst-galaxy/get-started/index.html">Get started</a> <a class="dropdown-item" href="/starburst-galaxy/get-started/get-support.html">Help center</a> <a class="dropdown-item" href="/starburst-galaxy/working-with-data/index.html">Working with data</a> <a class="dropdown-item" href="/starburst-galaxy/working-with-data/query-data/index.html"> Query data</a> <a class="dropdown-item" href="/starburst-galaxy/working-with-data/explore-data/index.html"> Explore data</a> <a class="dropdown-item" href="/starburst-galaxy/working-with-data/create-catalogs/index.html">Manage catalogs</a> <a class="dropdown-item" href="/starburst-galaxy/working-with-data/explore-data/browse-data-products.html">Data products</a> <a class="dropdown-item" href="/starburst-galaxy/data-engineering/index.html">Data engineering</a> <a class="dropdown-item" href="/starburst-galaxy/cluster-administration/index.html">Cluster administration</a> <a class="dropdown-item" href="/starburst-galaxy/security-and-compliance/index.html">Security and compliance</a> <a class="dropdown-item" href="/starburst-galaxy/troubleshooting/index.html">Troubleshooting</a> <a class="dropdown-item" href="/starburst-galaxy/developer-tools/python/index.html">Python</a> <a class="dropdown-item" href="/starburst-galaxy/reference/sql/index.html">SQL</a> <a class="dropdown-item" href="/starburst-galaxy/reference/index.html">Reference</a> </div> </li> <li class="nav-item dropdown"> <a id="starburst-enterprise" class="nav-link dropdown-toggle" aria-haspopup="true" aria-label="Get started" data-is-click="false" href="/starburst-enterprise/index.html">Starburst Enterprise</a> <div class="dropdown-menu dropdown-docs"> <a class="dropdown-item" href="/latest/index.html">Latest documentation</a> <a class="dropdown-item" href="/latest/language.html">SQL reference</a> <a class="dropdown-item" href="/latest/connector.html">Connect to data sources</a> <a class="dropdown-item" href="/latest/admin-topics.html">Administration topics</a> <a class="dropdown-item" href="/latest/security.html">Security</a> <a class="dropdown-item" href="/latest/versions.html">Version information</a> </div> </li> <li class="nav-item dropdown"> <a id="resources" class="nav-link dropdown-toggle" aria-haspopup="true" aria-label="resources" data-is-click="false" href="/resources.html">Resources</a> <div class="dropdown-menu dropdown-docs"> <a class="dropdown-item" href="/support.html">Support</a> <a class="dropdown-item" href="https://www.starburst.io/community/forum/">Community forum</a> <a class="dropdown-item" href="https://www.starburst.io/blog/technical">Technical blog</a> <a class="dropdown-item" href="/security/index.html">Security</a> <a class="dropdown-item" href="https://academy.starburst.io/">Starburst Academy</a> <a class="dropdown-item" href="/videos/index.html">Video library</a> <a class="dropdown-item" href="/glossary.html">Glossary</a> <a class="dropdown-item" href="/conventions.html">Conventions</a> <a class="dropdown-item" href="/iconography.html">Iconography</a> </div> </li> </ul> </div> </nav> </header> <div class="landing-page"> <div class="homepage-hero"> <div class="container"> <div class="row"> <div class="col-md-12"> <h1>Starburst documentation</h1> </div> </div> </div> </div> <div class="homepage-personas bg-opacity-50">  <div class="container">  <div class="row spacer-30 center">  <div class="col-md-12"> <div class="card"> <div class="card-body"> <div class="tile-title"><a href="./introduction/index.html">Learn the basics</a></div> <p>Starburst products are built on <a href="../introduction/concepts.html#trino">Trino</a>, the fastest open source, massively parallel processing SQL query engine designed for analytics on your data lake, as well as other data sources. Learn about our <a href="./introduction/architecture.html">architecture</a>, <a href="./introduction/security.html">security</a>, <a href="./introduction/querying-data.html">SQL</a>, <a href="./introduction/performance-features.html">performance features</a>, and other topics in our <a href="./introduction/index.html">Introduction section</a>. </p> </div> </div> </div> </div>  <div class="row spacer-30 center">  <div class="col-md-12"> <div class="card"> <div class="card-body"> <div class="tile-title"><a href="./clients/index.html">Connect your favorite clients</a></div> <p>Starburst Galaxy and Starburst Enterprise connect to all your favorite data tools. Learn how to connect <a href="./clients/tableau/index.html">Tableau</a>, <a href="./clients/powerbi.html">Power BI</a>, <a href="./clients/looker.html">Looker</a>, as well as <a href="./clients/index.html">other BI tools</a>, data tools such as <a href="./clients/dbt.html">dbt</a> and <a href="./clients/airbyte.html">Airbyte</a>, and of course <a href="./clients/python/index.html">Python clients</a>. </p> </div> </div> </div> </div>  <div class="row spacer-30 center">  <div class="col-md-6">  <div class="card"> <div class="card-body"> <div class="tile-title"><a href="./starburst-galaxy/index.html">Starburst Galaxy</a></div> <p style="margin-top: 1em">Starburst Galaxy is a fully-managed data lake analytics platform built on top of <a href="./get-started/concepts.html#trino\">Trino</a>. It takes care of the heavy lifting of designing, provisioning, maintaining, and securing your data infrastructure while making it easy to discover, govern, and consume your data. <br /><br /> Keep up with Starburst's <a href="./starburst-galaxy/release-notes.html">rapid-fire Starburst Galaxy releases</a>, or dive into these popular documentation topics: <br /> <h6 style="text-align:left;">Finding and querying data</h6> <ul style="text-align:left;"> <li><a href="./starburst-galaxy/working-with-data/query-data/query-editor-basics.html">Query editor</a></li> <li><a href="./starburst-galaxy/global/global-search.html">Universal search</a></li> <li><a href="./starburst-galaxy/data-products/index.html">Data products</a></li> </ul> <h6 style="text-align:left;">Creating catalogs</h6> <ul style="text-align:left;"> <li>Object storage catalogs using <a href="./starburst-galaxy/working-with-data/create-catalogs/object-storage/s3.html">S3</a>, <a href="./starburst-galaxy/working-with-data/create-catalogs/object-storage/adls.html">ADLS</a>, or <a href="./starburst-galaxy/working-with-data/create-catalogs/object-storage//gcs.html">Google Cloud Storage</a> data in your <a href="./starburst-galaxy/data-engineering/working-with-data-lakes/table-formats/index.html">preferred table format</a></li> <li><a href="./starburst-galaxy/working-with-data/create-catalogs/non-object-storage/snowflake.html">Snowflake</a></li> <li><a href="./starburst-galaxy/working-with-data/create-catalogs/non-object-storage/oracle.html">Oracle</a></li> <li><a href="./starburst-galaxy/working-with-data/create-catalogs/non-object-storage/postgresql.html">PostgreSQL</a></li> <li><a href="./starburst-galaxy/working-with-data/create-catalogs/non-object-storage/mysql.html">MySQL</a></li> <li><a href="./starburst-galaxy/working-with-data/create-catalogs/non-object-storage/index.html">Many others</a></li> </ul> <h6 style="text-align:left;">Boosting performance</h6> <ul style="text-align:left;"> <li><a href="./starburst-galaxy/data-engineering/optimization-performance-and-quality/workload-optimization/warp-speed-enabled.html">Starburst Warp speed</a></li> <li><a href="./starburst-galaxy/data-engineering/optimization-performance-and-quality/workload-optimization/clusters-with-fte.html">Fault tolerant execution</a></li> <li><a href="./starburst-galaxy/cluster-administration/monitor-and-manage-cost-and-performance/configure-autoscaling.html#configure-autoscaling">Autoscaling</a></li> </ul> <h6 style="text-align:left;">Starburst Galaxy reference material</h6> <ul style="text-align:left;"> <li><a href="./starburst-galaxy/reference/sql/index.html">SQL language</a></li> <li><a href="./starburst-galaxy/developer-tools/api/index.html">REST API</a></li> </ul> </p> <p>Don't see what you are looking for? View the <a href="./starburst-galaxy/index.html">Starburst Galaxy documentation</a>. </p> </div> </div> </div>  <div class="col-md-6">  <div class="card"> <div class="card-body"> <a name="sep"></a> <div class="tile-title"><a href="./latest/index.html">Starburst Enterprise</a></div> <p style="margin-top: 1em">Starburst Enterprise platform (SEP) is a fully-supported, self-hosted distribution of <a href="./get-started/concepts.html#trino\">Trino</a>. It adds integrations and more supported data sources, improves performance, provides additional security, and works in most cloud platforms. <br /><br /> Read the latest Starburst Enterprise <a href="./latest/release.html">release notes</a>, or dive into these popular documentation topics: <br /> <h6 style="text-align:left;">Finding and querying data</h6> <ul style="text-align:left;"> <li><a href="./latest/client/query-editor.html">Query editor</a></li> <li><a href="./latest/data-products/index.html">Data products</a></li> </ul> <h6 style="text-align:left;">Creating catalogs</h6> <ul style="text-align:left;"> <li>Data lake catalogs using <a href="./latest/connector/starburst-iceberg.html">Iceberg</a>, <a href="./latest/connector/starburst-delta-lake.html">Delta lake</a>, or <a href="./latest/connector/starburst-hive.html">Hive</a> data in your favorite object storage</li> <li><a href="./latest/connector/starburst-snowflake.html">Snowflake</a></li> <li><a href="./latest/connector/starburst-oracle.html">Oracle</a></li> <li><a href="./latest/connector/starburst-postgresql.html">PostgreSQL</a></li> <li><a href="./latest/connector/starburst-teradata.html">Teradata</a></li> <li><a href="./latest/connector/starburst-kafka.html">Kafka</a></li> <li><a href="./latest/connector.html">Many others</a></li> </ul> <h6 style="text-align:left;">Boosting performance</h6> <ul style="text-align:left;"> <li><a href="./latest/connector/starburst-warp-speed.html">Warp speed</a></li> <li><a href="./latest/admin/fault-tolerant-execution.html">Fault tolerant execution</a></li> <li><a href="./latest/admin/starburst-cached-views.html">Cache service</a></li> </ul> <h6 style="text-align:left;">Starburst Enterprise reference material</h6> <ul style="text-align:left;"> <li><a href="./latest/language.html">SQL language</a></li> <li><a href="./latest/starburst-rest-api.html">REST API</a></li> </ul> </p> <p>Looking for other information? View the <a href="./latest/index.html">SEP documentation</a>. </p> </div> </div> </div>  </div>  </div>  </div> <p></p> <div class="container text-center"> <div class="row"> <div class="col-md-12"> <h3>Want to know more?</h3>  </div> </div> <div class="row spacer-30 center"> <div class="col-md-4"> <div class="card"> <div class="card-body"> <a name="academytile"></a> <div class="tile-title"><a href="https://academy.starburst.io">Starburst Academy</a></div> <p style="margin-top: 1em"><a href="https://academy.starburst.io">Starburst Academy</a> offers self-paced online training courses for Starburst products and concepts. <br /> <br /> <a href="https://academy.starburst.io/page/starburst-certification">Earn your Starburst certification today</a> </p> </div> </div> </div> <div class="col-md-4"> <div class="card"> <div class="card-body"> <a name="securitytile"></a> <div class="tile-title"><a href="./security/index.html">Security information</a></div> <p style="margin-top: 1em">Starburst is committed to providing you with secure products and services, and to the continual improvement of our information security controls and practices. <br /> <br /> <a href="./security/index.html">Learn more about Starburst's security practices</a> </p> </div> </div> </div> <div class="col-md-4"> <div class="card"> <div class="card-body"> <a name="forumtile"></a> <div class="tile-title"><a href="https://www.starburst.io/community/forum/">Community forum</a></div> <p style="margin-top: 1em">Starburst provides a community forum for users where they can share knowledge and talk to experts. <br /> <br /> <a href="https://www.starburst.io/community/forum/">Visit the community forum</a> </p> </div> </div> </div> </div> <div class="row"> <div class="col-md-12"> <br /> <br /> <img src="./assets/img/logo/trino.png" alt="Trino" /> <p style="margin-top: 1em">Starburst products are built on Trino (formerly Presto庐 SQL), the fastest <a href="./get-started/concepts.html#oss">open source</a>, <a href="./get-started/concepts.html#mpp">massively parallel processing</a> <a href="./get-started/concepts.html#sql">SQL</a> <a href="./get-started/concepts.html#query-engine">query engine</a> designed for <a href="./get-started/concepts.html#analytics">analytics</a> of large datasets distributed over one or more data sources in object storage, databases and other systems. <br /> <br /> <a href="https://trino.io/">Learn more about Trino</a> </p> </div> </div> </div> <div class="container"> <div class="row"> <div class="col-md-5" style="padding:30px;"> <img class="img-fluid" src="./assets/img/graphics/graphic-starburst.svg" /> </div> <div class="col-md-7" style="padding:60px 30px;"> <h2>Other resources</h2> <p>No matter which Starburst product you use, or what you are trying to achieve, you can find even more help on these pages:</p> <ul> <li>Learn about Starburst's <a href="./support.html">customer support</a>.</li> <li>View our <a href="./videos/index.html">video library</a>.</li> <li>Read our <a href="https://www.starburst.io/blog/technical">technical blog</a>. (Hint: It's not just for developers!)</li> </ul> </div> </div> </div> </div> <div style="margin-bottom: 50px"></div><footer class="page-footer"> <div class="container"> <div class="row"> <div class="col-md-6"> <p style="font-weight:900">Resources</b></p> <ul> <li class="footer-item"><a href="/videos/index.html">Video library</a></li> <li class="footer-item"><a href="/glossary.html">Glossary</a></li> <li class="footer-item"><a href="https://www.starburst.io/info/oreilly-trino-guide/" target="_blank">Free O'Reilly book - Trino: The Definitive Guide</a></li> <li class="footer-item"><a href="https://trino.io/broadcast/" target="_blank">Trino Community Broadcast</a></li> <li class="footer-item"><a href="https://www.starburst.io/community/forum/" target="_blank">Starburst forum</a></li> <li class="footer-item"><a href="https://blog.starburstdata.com/" target="_blank">Starburst blog</a></li> </ul> </div> <div class="col-md-3"> <p style="font-weight:900">Contact and more</p> <ul> <li class="footer-item"><a href="https://www.starburst.io" target="_blank">Starburst</a></li> <li class="footer-item"><a href="https://www.starburst.io/#download" target="_blank">Start a trial</a></li> <li class="footer-item"><a href="/support.html" target="_blank">Get support</a></li> <li class="footer-item"><a href="https://www.starburst.io/contact/" target="_blank">Contact us</a></li> </ul> </div> <div class="col-md-3" style="text-align:right;"> <a href="https://www.starburst.io/" target="_blank"><img src="/assets/img/logo/Starburst_Logo_White+Blue.svg" height="34" alt=" Starburst" style="margin-bottom:20px;"></a> <li class="footer-item" style="padding-right:10px;"> <a href="/disclaimers.html#copyright">Copyright 漏 2017-2025<br> Starburst Data</a> </li> <li class="footer-item" style="padding-right:10px;"> <a href="/disclaimers.html#trademarks">Trademark information</a> </li> </div> </div> <div class="row"> <div class="col-md-12 center spacer-30"> <a href="https://twitter.com/starburstdata" target="_blank" class="footer-icon"><i class="fab fa-twitter"></i></a> <a href="https://linkedin.com/starburstdata" target="_blank" class="footer-icon"><i class="fab fa-linkedin"></i></a> <a href="https://www.youtube.com/channel/UCXjkuWSO9CV_cSI3Mvo4a4w" target="_blank" class="footer-icon"><i class="fab fa-youtube"></i></a> <a href="https://github.com/starburstdata" target="_blank" class="footer-icon"><i class="fab fa-github"></i></a> </div> </div> </div> </footer> <script type="text/javascript" src="/assets/js/jquery.min.js"></script> <script type="text/javascript" src="/assets/js/popper.min.js"></script> <script type="text/javascript" src="/assets/js/bootstrap.min.js"></script> <script type="text/javascript" src="/assets/js/mdb.min.js"></script> <script type="text/javascript" src="/assets/js/custom.js"></script> <script type="text/javascript" src="/assets/js/algolia.js"></script> <script type="text/javascript" src="/assets/js/search-box.js"></script> <script type="text/javascript" src="/assets/js/search-results.js"></script> </body> </html>

CINXE.COM

Starburst | Starburst