| <!doctype html><html lang=en dir=ltr class="docs-wrapper plugin-docs plugin-id-user_docs docs-version-6.1.0 docs-doc-page docs-doc-id-databases/supported/apache-drill" data-has-hydrated=false><head><meta charset=UTF-8><meta name=generator content="Docusaurus v3.10.1"><title data-rh=true>Apache Drill | Superset</title><meta data-rh=true name=viewport content="width=device-width, initial-scale=1.0"/><meta data-rh=true property=og:url content=https://superset.apache.org/user-docs/6.1.0/databases/supported/apache-drill /><meta data-rh=true property=og:locale content=en /><meta data-rh=true name=docusaurus_locale content=en /><meta data-rh=true name=docsearch:language content=en /><meta data-rh=true name=keywords content="data visualization, business intelligence, BI, dashboards, SQL, analytics, open source, Apache, charts, reporting"/><meta data-rh=true property=og:type content=website /><meta data-rh=true property=og:site_name content="Apache Superset"/><meta data-rh=true property=og:image content=https://superset.apache.org/img/superset-og-image.png /><meta data-rh=true property=og:image:width content=1200 /><meta data-rh=true property=og:image:height content=630 /><meta data-rh=true name=twitter:card content=summary_large_image /><meta data-rh=true name=twitter:image content=https://superset.apache.org/img/superset-og-image.png /><meta data-rh=true name=twitter:site content=@ApacheSuperset /><meta data-rh=true name=docusaurus_version content=6.1.0 /><meta data-rh=true name=docusaurus_tag content=docs-user_docs-6.1.0 /><meta data-rh=true name=docsearch:version content=6.1.0 /><meta data-rh=true name=docsearch:docusaurus_tag content=docs-user_docs-6.1.0 /><meta data-rh=true property=og:title content="Apache Drill | Superset"/><meta data-rh=true name=description content="Apache Drill is a schema-free SQL query engine for Hadoop and NoSQL."/><meta data-rh=true property=og:description content="Apache Drill is a schema-free SQL query engine for Hadoop and NoSQL."/><link data-rh=true rel=icon href=/img/favicon.ico /><link data-rh=true rel=canonical href=https://superset.apache.org/user-docs/6.1.0/databases/supported/apache-drill /><link data-rh=true rel=alternate href=https://superset.apache.org/user-docs/6.1.0/databases/supported/apache-drill hreflang=en /><link data-rh=true rel=alternate href=https://superset.apache.org/user-docs/6.1.0/databases/supported/apache-drill hreflang=x-default /><link data-rh=true rel=preconnect href=https://WR5FASX5ED-dsn.algolia.net crossorigin=anonymous /><script data-rh=true type=application/ld+json>{"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","item":"https://superset.apache.org/user-docs/6.1.0/databases/","name":"Connecting to Databases","position":1},{"@type":"ListItem","item":"https://superset.apache.org/user-docs/6.1.0/databases/supported/apache-drill","name":"Apache Drill","position":2}]}</script><script data-rh=true type=application/ld+json>{"@context":"https://schema.org","@type":"TechArticle","author":{"@type":"Organization","name":"Apache Superset Contributors","url":"https://github.com/apache/superset/graphs/contributors"},"description":"Apache Drill is a schema-free SQL query engine for Hadoop and NoSQL.","headline":"Apache Drill","mainEntityOfPage":{"@id":"https://superset.apache.org/user-docs/6.1.0/databases/supported/apache-drill","@type":"WebPage"},"proficiencyLevel":"Beginner","publisher":{"@type":"Organization","logo":{"@type":"ImageObject","url":"https://www.apache.org/foundation/press/kit/asf_logo.png"},"name":"Apache Software Foundation","url":"https://www.apache.org/"},"url":"https://superset.apache.org/user-docs/6.1.0/databases/supported/apache-drill"}</script><link rel=search type=application/opensearchdescription+xml title=Superset href=/opensearch.xml><script type=application/ld+json>{"@context":"https://schema.org","@type":"SoftwareApplication","applicationCategory":"BusinessApplication","author":{"@type":"Organization","logo":"https://www.apache.org/foundation/press/kit/asf_logo.png","name":"Apache Software Foundation","url":"https://www.apache.org/"},"description":"Apache Superset is a modern, enterprise-ready business intelligence web application for data exploration and visualization.","featureList":["Interactive dashboards","SQL IDE","40+ visualization types","Semantic layer","Role-based access control","REST API"],"license":"https://www.apache.org/licenses/LICENSE-2.0","name":"Apache Superset","offers":{"@type":"Offer","price":"0","priceCurrency":"USD"},"operatingSystem":"Cross-platform","url":"https://superset.apache.org"}</script><script type=application/ld+json>{"@context":"https://schema.org","@type":"WebSite","name":"Apache Superset","potentialAction":{"@type":"SearchAction","query-input":"required name=search_term_string","target":{"@type":"EntryPoint","urlTemplate":"https://superset.apache.org/search?q={search_term_string}"}},"url":"https://superset.apache.org"}</script><link rel=preconnect href=https://WR5FASX5ED-dsn.algolia.net crossorigin=anonymous><link rel=preconnect href=https://analytics.apache.org><script src=https://widget.kapa.ai/kapa-widget.bundle.js async data-website-id=c6a8a8b8-3127-48f9-97a7-51e9e10d20d0 data-project-name="Apache Superset" data-project-color=#FFFFFF data-project-logo=https://superset.apache.org/img/superset-logo-icon-only.png data-modal-override-open-id=ask-ai-input data-modal-override-open-class=search-input data-modal-disclaimer="This is a custom LLM for Apache Superset with access to all [documentation](superset.apache.org/docs/intro/), [GitHub Open Issues, PRs and READMEs](github.com/apache/superset).&#10;&#10;Companies deploy assistants like this ([built by kapa.ai](https://kapa.ai)) on docs via [website widget](https://docs.kapa.ai/integrations/website-widget) (Docker, Reddit), in [support forms](https://docs.kapa.ai/integrations/support-form-deflector) for ticket deflection (Monday.com, Mapbox), or as [Slack bots](https://docs.kapa.ai/integrations/slack-bot) with private sources." data-modal-example-questions="How do I install Superset?,How can I contribute to Superset?" data-button-text-color=rgb(81,166,197) data-modal-header-bg-color=#ffffff data-modal-title-color=rgb(81,166,197) data-modal-title="Apache Superset AI" data-modal-disclaimer-text-color=#000000 data-consent-required=true data-consent-screen-disclaimer="By clicking "I agree, let's chat", you consent to the use of the AI assistant in accordance with kapa.ai's [Privacy Policy](https://www.kapa.ai/content/privacy-policy). This service uses reCAPTCHA, which requires your consent to Google's [Privacy Policy](https://policies.google.com/privacy) and [Terms of Service](https://policies.google.com/terms). By proceeding, you explicitly agree to both kapa.ai's and Google's privacy policies."></script><link rel=stylesheet href=/assets/css/styles.c802b717.css /><script src=/assets/js/runtime~main.d3cd9308.js defer></script><script src=/assets/js/main.198cbbee.js defer></script></head><body><svg style="display: none;"><defs> |
| <script>!function(){var t=function(){try{return new URLSearchParams(window.location.search).get("docusaurus-theme")}catch(t){}}()||function(){try{return window.localStorage.getItem("theme")}catch(t){}}();document.documentElement.setAttribute("data-theme",t||(window.matchMedia("(prefers-color-scheme: dark)").matches?"dark":"light")),document.documentElement.setAttribute("data-theme-choice",t||"system")}(),function(){try{for(var[t,e]of new URLSearchParams(window.location.search).entries())if(t.startsWith("docusaurus-data-")){var a=t.replace("docusaurus-data-","data-");document.documentElement.setAttribute(a,e)}}catch(t){}}()</script><div id=__docusaurus><div role=region aria-label="Skip to main content"><a class=skipToContent_fXgn href=#__docusaurus_skipToContent_fallback>Skip to main content</a></div><nav aria-label=Main class="theme-layout-navbar navbar navbar--fixed-top"><div class=navbar__inner><div class="theme-layout-navbar-left navbar__items"><button aria-label="Toggle navigation bar" aria-expanded=false class="navbar__toggle clean-btn" type=button><svg width=30 height=30 viewBox="0 0 30 30" aria-hidden=true><path stroke=currentColor stroke-linecap=round stroke-miterlimit=10 stroke-width=2 d="M4 7h22M4 15h22M4 23h22"/></svg></button><a class=navbar__brand href=/><div class=navbar__logo><img src=/img/superset-logo-horiz.svg alt="Superset Logo" class="themedComponent_mlkZ themedComponent--light_NVdE"/><img src=/img/superset-logo-horiz-dark.svg alt="Superset Logo" class="themedComponent_mlkZ themedComponent--dark_xIcU"/></div></a><div class="navbar__item dropdown dropdown--hoverable"><a aria-current=page class="navbar__link active" aria-haspopup=true aria-expanded=false role=button href=/user-docs/>Users</a><ul class=dropdown__menu><li><a class=dropdown__link href=/user-docs/>Overview</a><li><a class=dropdown__link href=/user-docs/quickstart>Quickstart</a><li><a class=dropdown__link href=/user-docs/using-superset/creating-your-first-dashboard>Using Superset</a><li><a class=dropdown__link href=/user-docs/databases/>Connecting to Databases</a><li><a class=dropdown__link href=/user-docs/faq>FAQ</a></ul></div><div class="navbar__item dropdown dropdown--hoverable"><a class=navbar__link aria-haspopup=true aria-expanded=false role=button href=/admin-docs/>Admins</a><ul class=dropdown__menu><li><a class=dropdown__link href=/admin-docs/>Overview</a><li><a class=dropdown__link href=/admin-docs/installation/installation-methods>Installation</a><li><a class=dropdown__link href=/admin-docs/configuration/configuring-superset>Configuration</a><li><a class=dropdown__link href=/user-docs/databases/>Database Drivers</a><li><a class=dropdown__link href=/admin-docs/security/>Security</a></ul></div><div class="navbar__item dropdown dropdown--hoverable"><a class=navbar__link aria-haspopup=true aria-expanded=false role=button href=/developer-docs/>Developers</a><ul class=dropdown__menu><li><a class=dropdown__link href=/developer-docs/>Overview</a><li><a class=dropdown__link href=/developer-docs/contributing/overview>Contributing</a><li><a class=dropdown__link href=/developer-docs/extensions/overview>Extensions</a><li><a class=dropdown__link href=/developer-docs/testing/overview>Testing</a><li><a class=dropdown__link href=/developer-docs/components/>UI Components</a><li><a class=dropdown__link href=/developer-docs/api>API Reference</a></ul></div><div class="navbar__item dropdown dropdown--hoverable"><a class=navbar__link aria-haspopup=true aria-expanded=false role=button href=/community>Community</a><ul class=dropdown__menu><li><a class=dropdown__link href=/community>Resources</a><li><a href=https://github.com/apache/superset target=_blank rel="noopener noreferrer" class=dropdown__link>GitHub<svg width=12 height=12 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a><li><a href=http://bit.ly/join-superset-slack target=_blank rel="noopener noreferrer" class=dropdown__link>Slack<svg width=12 height=12 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a><li><a href=https://lists.apache.org/list.html?dev@superset.apache.org target=_blank rel="noopener noreferrer" class=dropdown__link>Mailing List<svg width=12 height=12 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a><li><a href=https://stackoverflow.com/questions/tagged/apache-superset target=_blank rel="noopener noreferrer" class=dropdown__link>Stack Overflow<svg width=12 height=12 aria-label="(opens in new tab)" class=iconExternalLink_nPIU><use href=#theme-svg-external-link /></svg></a><li><a class=dropdown__link href=/community#superset-community-calendar>Community Calendar</a><li><a class=dropdown__link href=/inTheWild>In the Wild</a></ul></div></div><div class="theme-layout-navbar-right navbar__items navbar__items--right"><style data-emotion="css kad2tq">.css-kad2tq{z-index:2;border-radius:10px;align-items:stretch;width:176px;margin-right:20px;font-size:18px;font-weight:700;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex;position:relative;overflow:hidden}.css-kad2tq .split-main{color:#fff;-webkit-flex:1;-ms-flex:1;flex:1;justify-content:center;align-items:center;min-width:0;padding:7px 8px;-webkit-text-decoration:none;text-decoration:none;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex}.css-kad2tq .split-main:hover{color:#fff}.css-kad2tq .split-divider{background:#ffffff61;-ms-flex-negative:0;-webkit-flex-shrink:0;flex-shrink:0;align-self:stretch;width:1px;margin:6px 0}.css-kad2tq .split-dropdown-trigger{cursor:pointer;color:#fff;background:0 0;border:none;-ms-flex-negative:0;-webkit-flex-shrink:0;flex-shrink:0;justify-content:center;align-items:center;width:38px;margin:0;padding:0;font-size:10px;display:-webkit-box;display:-webkit-flex;display:-ms-flexbox;display:flex}.css-kad2tq .split-dropdown-trigger:hover{color:#fff}</style><div class="default-button-theme get-started-split get-started-button css-kad2tq"><a class=split-main href=/user-docs/>Get Started</a><span class=split-divider aria-hidden=true></span><button type=button class="ant-dropdown-trigger split-dropdown-trigger" aria-haspopup=menu aria-label="Choose documentation: Users, Admins, or Developers"><span role=img aria-label=down class="anticon anticon-down"><svg viewBox="64 64 896 896" focusable=false data-icon=down width=1em height=1em fill=currentColor aria-hidden=true><path d="M884 256h-75c-5.1 0-9.9 2.5-12.9 6.6L512 654.2 227.9 262.6c-3-4.1-7.8-6.6-12.9-6.6h-75c-6.5 0-10.3 7.4-6.5 12.7l352.6 486.1c12.8 17.6 39 17.6 51.7 0l352.6-486.1c3.9-5.3.1-12.7-6.4-12.7z"/></svg></span></button></div><a href=https://github.com/apache/superset target=_blank rel="noopener noreferrer" class="navbar__item navbar__link github-button"></a><div class="toggle_vylO colorModeToggle_DEke"><button class="clean-btn toggleButton_gllP toggleButtonDisabled_aARS" type=button disabled title="system mode" aria-label="Switch between dark and light mode (currently system mode)"><svg viewBox="0 0 24 24" width=24 height=24 aria-hidden=true class="toggleIcon_g3eP lightToggleIcon_pyhR"><path fill=currentColor d="M12,9c1.65,0,3,1.35,3,3s-1.35,3-3,3s-3-1.35-3-3S10.35,9,12,9 M12,7c-2.76,0-5,2.24-5,5s2.24,5,5,5s5-2.24,5-5 S14.76,7,12,7L12,7z M2,13l2,0c0.55,0,1-0.45,1-1s-0.45-1-1-1l-2,0c-0.55,0-1,0.45-1,1S1.45,13,2,13z M20,13l2,0c0.55,0,1-0.45,1-1 s-0.45-1-1-1l-2,0c-0.55,0-1,0.45-1,1S19.45,13,20,13z M11,2v2c0,0.55,0.45,1,1,1s1-0.45,1-1V2c0-0.55-0.45-1-1-1S11,1.45,11,2z M11,20v2c0,0.55,0.45,1,1,1s1-0.45,1-1v-2c0-0.55-0.45-1-1-1C11.45,19,11,19.45,11,20z M5.99,4.58c-0.39-0.39-1.03-0.39-1.41,0 c-0.39,0.39-0.39,1.03,0,1.41l1.06,1.06c0.39,0.39,1.03,0.39,1.41,0s0.39-1.03,0-1.41L5.99,4.58z M18.36,16.95 c-0.39-0.39-1.03-0.39-1.41,0c-0.39,0.39-0.39,1.03,0,1.41l1.06,1.06c0.39,0.39,1.03,0.39,1.41,0c0.39-0.39,0.39-1.03,0-1.41 L18.36,16.95z M19.42,5.99c0.39-0.39,0.39-1.03,0-1.41c-0.39-0.39-1.03-0.39-1.41,0l-1.06,1.06c-0.39,0.39-0.39,1.03,0,1.41 s1.03,0.39,1.41,0L19.42,5.99z M7.05,18.36c0.39-0.39,0.39-1.03,0-1.41c-0.39-0.39-1.03-0.39-1.41,0l-1.06,1.06 c-0.39,0.39-0.39,1.03,0,1.41s1.03,0.39,1.41,0L7.05,18.36z"/></svg><svg viewBox="0 0 24 24" width=24 height=24 aria-hidden=true class="toggleIcon_g3eP darkToggleIcon_wfgR"><path fill=currentColor d="M9.37,5.51C9.19,6.15,9.1,6.82,9.1,7.5c0,4.08,3.32,7.4,7.4,7.4c0.68,0,1.35-0.09,1.99-0.27C17.45,17.19,14.93,19,12,19 c-3.86,0-7-3.14-7-7C5,9.07,6.81,6.55,9.37,5.51z M12,3c-4.97,0-9,4.03-9,9s4.03,9,9,9s9-4.03,9-9c0-0.46-0.04-0.92-0.1-1.36 c-0.98,1.37-2.58,2.26-4.4,2.26c-2.98,0-5.4-2.42-5.4-5.4c0-1.81,0.89-3.42,2.26-4.4C12.92,3.04,12.46,3,12,3L12,3z"/></svg><svg viewBox="0 0 24 24" width=24 height=24 aria-hidden=true class="toggleIcon_g3eP systemToggleIcon_QzmC"><path fill=currentColor d="m12 21c4.971 0 9-4.029 9-9s-4.029-9-9-9-9 4.029-9 9 4.029 9 9 9zm4.95-13.95c1.313 1.313 2.05 3.093 2.05 4.95s-0.738 3.637-2.05 4.95c-1.313 1.313-3.093 2.05-4.95 2.05v-14c1.857 0 3.637 0.737 4.95 2.05z"/></svg></button></div><div class=navbarSearchContainer_Bca1><button type=button class="DocSearch DocSearch-Button" aria-label="Search (Meta+k)" aria-keyshortcuts=Meta+k><span class=DocSearch-Button-Container><svg width=20 height=20 class=DocSearch-Search-Icon viewBox="0 0 24 24" aria-hidden=true><circle cx=11 cy=11 r=8 stroke=currentColor fill=none stroke-width=1.4 /><path d="m21 21-4.3-4.3" stroke=currentColor fill=none stroke-linecap=round stroke-linejoin=round /></svg><span class=DocSearch-Button-Placeholder>Search</span></span><span class=DocSearch-Button-Keys></span></button></div></div></div><div role=presentation class=navbar-sidebar__backdrop></div></nav><div id=__docusaurus_skipToContent_fallback class="theme-layout-main main-wrapper mainWrapper_z2l0"><div class=docsWrapper_hBAB><button aria-label="Scroll back to top" class="clean-btn theme-back-to-top-button backToTopButton_sjWU" type=button></button><div class=docRoot_UBD9><aside class="theme-doc-sidebar-container docSidebarContainer_YfHR"><div class=sidebarViewport_aRkj><div class=sidebar_njMd><nav aria-label="Docs sidebar" class="menu thin-scrollbar menu_SIkG"><ul class="theme-doc-sidebar-menu menu__list"><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-1 menu__list-item"><a class=menu__link href=/user-docs/6.1.0/><span title=Overview class=linkLabel_WmDU>Overview</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-1 menu__list-item"><a class=menu__link href=/user-docs/6.1.0/quickstart><span title=Quickstart class=linkLabel_WmDU>Quickstart</span></a><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item"><div class=menu__list-item-collapsible><a class="categoryLink_byQd menu__link menu__link--sublist menu__link--sublist-caret" role=button aria-expanded=true href=/user-docs/6.1.0/using-superset/creating-your-first-dashboard><span title="Using Superset" class=categoryLinkLabel_W154>Using Superset</span></a></div><ul class=menu__list><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/using-superset/creating-your-first-dashboard><span title="Creating Your First Dashboard" class=linkLabel_WmDU>Creating Your First Dashboard</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/using-superset/exploring-data><span title="Exploring Data in Superset" class=linkLabel_WmDU>Exploring Data in Superset</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/using-superset/sql-templating><span title="SQL Templating" class=linkLabel_WmDU>SQL Templating</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/using-superset/issue-codes><span title="Issue Codes" class=linkLabel_WmDU>Issue Codes</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/using-superset/using-ai-with-superset><span title="Using AI with Superset" class=linkLabel_WmDU>Using AI with Superset</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/using-superset/embedding><span title="Embedding Superset" class=linkLabel_WmDU>Embedding Superset</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/using-superset/handlebars-chart><span title="Handlebars Chart" class=linkLabel_WmDU>Handlebars Chart</span></a></ul><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item"><div class=menu__list-item-collapsible><a class="categoryLink_byQd menu__link menu__link--sublist menu__link--active" href=/user-docs/6.1.0/databases/><span title="Connecting to Databases" class=categoryLinkLabel_W154>Connecting to Databases</span></a><button aria-label="Collapse sidebar category 'Connecting to Databases'" aria-expanded=true type=button class="clean-btn menu__caret"></button></div><ul class=menu__list><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/><span title=Overview class=linkLabel_WmDU>Overview</span></a><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item"><div class=menu__list-item-collapsible><a class="categoryLink_byQd menu__link menu__link--sublist menu__link--sublist-caret menu__link--active" role=button aria-expanded=true tabindex=0 href=/user-docs/6.1.0/databases/supported/amazon-athena><span title="Supported Databases" class=categoryLinkLabel_W154>Supported Databases</span></a></div><ul class=menu__list><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/amazon-athena><span title="Amazon Athena" class=linkLabel_WmDU>Amazon Athena</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/amazon-dynamodb><span title="Amazon DynamoDB" class=linkLabel_WmDU>Amazon DynamoDB</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/amazon-redshift><span title="Amazon Redshift" class=linkLabel_WmDU>Amazon Redshift</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/apache-doris><span title="Apache Doris" class=linkLabel_WmDU>Apache Doris</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link menu__link--active" aria-current=page tabindex=0 href=/user-docs/6.1.0/databases/supported/apache-drill><span title="Apache Drill" class=linkLabel_WmDU>Apache Drill</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/apache-druid><span title="Apache Druid" class=linkLabel_WmDU>Apache Druid</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/apache-hive><span title="Apache Hive" class=linkLabel_WmDU>Apache Hive</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/apache-impala><span title="Apache Impala" class=linkLabel_WmDU>Apache Impala</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/apache-iotdb><span title="Apache IoTDB" class=linkLabel_WmDU>Apache IoTDB</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/apache-kylin><span title="Apache Kylin" class=linkLabel_WmDU>Apache Kylin</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/apache-phoenix><span title="Apache Phoenix" class=linkLabel_WmDU>Apache Phoenix</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/apache-pinot><span title="Apache Pinot" class=linkLabel_WmDU>Apache Pinot</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/apache-solr><span title="Apache Solr" class=linkLabel_WmDU>Apache Solr</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/apache-spark-sql><span title="Apache Spark SQL" class=linkLabel_WmDU>Apache Spark SQL</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/arc><span title=Arc class=linkLabel_WmDU>Arc</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/ascend><span title=Ascend class=linkLabel_WmDU>Ascend</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/aurora-mysql-data-api><span title="Aurora MySQL (Data API)" class=linkLabel_WmDU>Aurora MySQL (Data API)</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/aurora-mysql><span title="Aurora MySQL" class=linkLabel_WmDU>Aurora MySQL</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/aurora-postgresql-data-api><span title="Aurora PostgreSQL (Data API)" class=linkLabel_WmDU>Aurora PostgreSQL (Data API)</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/aurora-postgresql><span title="Aurora PostgreSQL" class=linkLabel_WmDU>Aurora PostgreSQL</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/azure-data-explorer><span title="Azure Data Explorer" class=linkLabel_WmDU>Azure Data Explorer</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/azure-synapse><span title="Azure Synapse" class=linkLabel_WmDU>Azure Synapse</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/clickhouse><span title=ClickHouse class=linkLabel_WmDU>ClickHouse</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/cloudflare-d1><span title="Cloudflare D1" class=linkLabel_WmDU>Cloudflare D1</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/cockroachdb><span title=CockroachDB class=linkLabel_WmDU>CockroachDB</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/couchbase><span title=Couchbase class=linkLabel_WmDU>Couchbase</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/cratedb><span title=CrateDB class=linkLabel_WmDU>CrateDB</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/databend><span title=Databend class=linkLabel_WmDU>Databend</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/databricks-interactive-cluster><span title="Databricks Interactive Cluster" class=linkLabel_WmDU>Databricks Interactive Cluster</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/databricks><span title=Databricks class=linkLabel_WmDU>Databricks</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/denodo><span title=Denodo class=linkLabel_WmDU>Denodo</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/dremio><span title=Dremio class=linkLabel_WmDU>Dremio</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/duckdb><span title=DuckDB class=linkLabel_WmDU>DuckDB</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/elasticsearch><span title=Elasticsearch class=linkLabel_WmDU>Elasticsearch</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/exasol><span title=Exasol class=linkLabel_WmDU>Exasol</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/firebird><span title=Firebird class=linkLabel_WmDU>Firebird</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/firebolt><span title=Firebolt class=linkLabel_WmDU>Firebolt</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/google-bigquery><span title="Google BigQuery" class=linkLabel_WmDU>Google BigQuery</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/google-datastore><span title="Google Datastore" class=linkLabel_WmDU>Google Datastore</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/google-sheets><span title="Google Sheets" class=linkLabel_WmDU>Google Sheets</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/greenplum><span title=Greenplum class=linkLabel_WmDU>Greenplum</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/hologres><span title=Hologres class=linkLabel_WmDU>Hologres</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/ibm-db2-for-i><span title="IBM Db2 for i" class=linkLabel_WmDU>IBM Db2 for i</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/ibm-db2><span title="IBM Db2" class=linkLabel_WmDU>IBM Db2</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/ibm-netezza-performance-server><span title="IBM Netezza Performance Server" class=linkLabel_WmDU>IBM Netezza Performance Server</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/mariadb><span title=MariaDB class=linkLabel_WmDU>MariaDB</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/microsoft-sql-server><span title="Microsoft SQL Server" class=linkLabel_WmDU>Microsoft SQL Server</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/monetdb><span title=MonetDB class=linkLabel_WmDU>MonetDB</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/mongodb><span title=MongoDB class=linkLabel_WmDU>MongoDB</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/motherduck><span title=MotherDuck class=linkLabel_WmDU>MotherDuck</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/mysql><span title=MySQL class=linkLabel_WmDU>MySQL</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/oceanbase><span title=OceanBase class=linkLabel_WmDU>OceanBase</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/ocient><span title=Ocient class=linkLabel_WmDU>Ocient</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/oracle><span title=Oracle class=linkLabel_WmDU>Oracle</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/parseable><span title=Parseable class=linkLabel_WmDU>Parseable</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/postgresql><span title=PostgreSQL class=linkLabel_WmDU>PostgreSQL</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/presto><span title=Presto class=linkLabel_WmDU>Presto</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/risingwave><span title=RisingWave class=linkLabel_WmDU>RisingWave</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/sap-hana><span title="SAP HANA" class=linkLabel_WmDU>SAP HANA</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/sap-sybase><span title="SAP Sybase" class=linkLabel_WmDU>SAP Sybase</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/shillelagh><span title=Shillelagh class=linkLabel_WmDU>Shillelagh</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/singlestore><span title=SingleStore class=linkLabel_WmDU>SingleStore</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/snowflake><span title=Snowflake class=linkLabel_WmDU>Snowflake</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/sqlite><span title=SQLite class=linkLabel_WmDU>SQLite</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/starrocks><span title=StarRocks class=linkLabel_WmDU>StarRocks</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/superset-meta-database><span title="Superset meta database" class=linkLabel_WmDU>Superset meta database</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/tdengine><span title=TDengine class=linkLabel_WmDU>TDengine</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/teradata><span title=Teradata class=linkLabel_WmDU>Teradata</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/timescaledb><span title=TimescaleDB class=linkLabel_WmDU>TimescaleDB</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/trino><span title=Trino class=linkLabel_WmDU>Trino</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/vertica><span title=Vertica class=linkLabel_WmDU>Vertica</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/ydb><span title=YDB class=linkLabel_WmDU>YDB</span></a><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class=menu__link tabindex=0 href=/user-docs/6.1.0/databases/supported/yugabytedb><span title=YugabyteDB class=linkLabel_WmDU>YugabyteDB</span></a></ul></ul><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-1 menu__list-item"><a class=menu__link href=/user-docs/6.1.0/faq><span title=FAQ class=linkLabel_WmDU>FAQ</span></a></ul></nav><button type=button title="Collapse sidebar" aria-label="Collapse sidebar" class="button button--secondary button--outline collapseSidebarButton_PEFL"><svg width=20 height=20 aria-hidden=true class=collapseSidebarButtonIcon_kv0_><g fill=#7a7a7a><path d="M9.992 10.023c0 .2-.062.399-.172.547l-4.996 7.492a.982.982 0 01-.828.454H1c-.55 0-1-.453-1-1 0-.2.059-.403.168-.551l4.629-6.942L.168 3.078A.939.939 0 010 2.528c0-.548.45-.997 1-.997h2.996c.352 0 .649.18.828.45L9.82 9.472c.11.148.172.347.172.55zm0 0"/><path d="M19.98 10.023c0 .2-.058.399-.168.547l-4.996 7.492a.987.987 0 01-.828.454h-3c-.547 0-.996-.453-.996-1 0-.2.059-.403.168-.551l4.625-6.942-4.625-6.945a.939.939 0 01-.168-.55 1 1 0 01.996-.997h3c.348 0 .649.18.828.45l4.996 7.492c.11.148.168.347.168.55zm0 0"/></g></svg></button></div></div></aside><main class=docMainContainer_TBSr><div class="container padding-top--md padding-bottom--lg"><div class=row><div class="col docItemCol_VOVn"><div class=docItemContainer_Djhp><article><nav class="theme-doc-breadcrumbs breadcrumbsContainer_Z_bl" aria-label=Breadcrumbs><ul class=breadcrumbs><li class=breadcrumbs__item><a aria-label="Home page" class=breadcrumbs__link href=/><svg viewBox="0 0 24 24" class=breadcrumbHomeIcon_YNFT><path d="M10 19v-5h4v5c0 .55.45 1 1 1h3c.55 0 1-.45 1-1v-7h1.7c.46 0 .68-.57.33-.87L12.67 3.6c-.38-.34-.96-.34-1.34 0l-8.36 7.53c-.34.3-.13.87.33.87H5v7c0 .55.45 1 1 1h3c.55 0 1-.45 1-1z" fill=currentColor /></svg></a><li class=breadcrumbs__item><a class=breadcrumbs__link href=/user-docs/6.1.0/databases/><span>Connecting to Databases</span></a><li class=breadcrumbs__item><span class=breadcrumbs__link>Supported Databases</span><li class="breadcrumbs__item breadcrumbs__item--active"><span class=breadcrumbs__link>Apache Drill</span></ul></nav><span class=versionBadge_QOso>Version:<!-- --> <a class="ant-dropdown-trigger versionSelector_oOvN">6.1.0<!-- --> <span role=img aria-label=down class="anticon anticon-down"><svg viewBox="64 64 896 896" focusable=false data-icon=down width=1em height=1em fill=currentColor aria-hidden=true><path d="M884 256h-75c-5.1 0-9.9 2.5-12.9 6.6L512 654.2 227.9 262.6c-3-4.1-7.8-6.6-12.9-6.6h-75c-6.5 0-10.3 7.4-6.5 12.7l352.6 486.1c12.8 17.6 39 17.6 51.7 0l352.6-486.1c3.9-5.3.1-12.7-6.4-12.7z"/></svg></span></a></span><div class="theme-doc-markdown markdown"> |