CINXE.COM

<!doctype html> <html lang="en"> <head><script type="text/javascript" src="/_static/js/bundle-playback.js?v=HxkREWBo" charset="utf-8"></script> <script type="text/javascript" src="/_static/js/wombat.js?v=txqj7nKC" charset="utf-8"></script> <script>window.RufflePlayer=window.RufflePlayer||{};window.RufflePlayer.config={"autoplay":"on","unmuteOverlay":"hidden"};</script> <script type="text/javascript" src="/_static/js/ruffle/ruffle.js"></script> <script type="text/javascript"> __wm.init("https://web.archive.org/web"); __wm.wombat("https://docs.looker.com/data-modeling/getting-started/other-project-files","20210802015220","https://web.archive.org/","web","/_static/", "1627869140"); </script> <link rel="stylesheet" type="text/css" href="/_static/css/banner-styles.css?v=S1zqJCYt" /> <link rel="stylesheet" type="text/css" href="/_static/css/iconochive.css?v=3PDvdIFv" />   <script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://web.archive.org/web/20210802015220/https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-NWWX6K');</script>  <title>Understanding other project files</title> <link rel="canonical" href="https://web.archive.org/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/other-project-files"/> <link rel="icon" type="image/x-icon" href="/web/20210802015220im_/https://docs.looker.com/favicon.ico?v=2"/>   <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0">  <meta name="google-site-verification" content="sqgzzTMOeyBTjvU1CQzYndU5Uu4EMl461BEMxcVuK-c"/>  <meta class="swiftype" name="site-priority" data-type="integer" content="3"> <meta class="swiftype" name="site-filter" data-type="integer" content="3"> <meta class="swiftype" name="site-filter" data-type="integer" content="32"> <meta class="swiftype" name="site-filter" data-type="integer" content="34"> <meta class="swiftype" name="title" data-type="string" content="Understanding other project files"> <meta class="swiftype" name="description" data-type="string" content="Understand LookML document, data, dashboard, manifest, and strings files.">  <meta property="og:site_name" content="Looker Documentation"> <meta property="og:url" content="https://web.archive.org/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/other-project-files"> <meta property="og:type" content="article"> <meta property="og:title" content="Understanding other project files"> <meta property="og:description" content="Understand LookML document, data, dashboard, manifest, and strings files."> <meta name="description" content="Understand LookML document, data, dashboard, manifest, and strings files."> <meta name="note" content="Edit:2021-06.Partial-11, Database Dialect:Dev.Screens, Derived Table:Dev.Lines, IDE:Dev.Screens, IDE:View.Screens, Localization:Dev.Screens, LookML - Feature:Dev.Screens, LookML - Structural:Dev.Page, LookML Dashboard:Dev.Lines, Map:Dev.Screens">    <link rel="stylesheet" href="https://web.archive.org/web/20210802015220cs_/https://fonts.googleapis.com/css?family=Google+Sans:400,600">  <link rel="stylesheet" href="https://web.archive.org/web/20210802015220cs_/https://fonts.googleapis.com/css?family=Roboto:400,400italic,700,700italic">  <link rel="stylesheet" href="https://web.archive.org/web/20210802015220cs_/https://fonts.googleapis.com/css?family=Roboto+Mono:400,700">  <link rel="stylesheet" href="https://web.archive.org/web/20210802015220cs_/https://fonts.googleapis.com/css?family=Material+Icons">   <link rel="stylesheet" href="/web/20210802015220cs_/https://docs.looker.com/_themes/docs/css/normalize.css">  <link rel="stylesheet" href="/web/20210802015220cs_/https://docs.looker.com/_themes/docs/css/docs.css?v=1627674102">   <script src="https://web.archive.org/web/20210802015220js_/https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>  <script src="/web/20210802015220js_/https://docs.looker.com/_themes/docs/js/ace/ace.js"></script> <script src="/web/20210802015220js_/https://docs.looker.com/_themes/docs/js/ace/ext-static_highlight.js"></script>  <script src="/web/20210802015220js_/https://docs.looker.com/_themes/docs/js/vimeo/player.js"></script>  <script src="/web/20210802015220js_/https://docs.looker.com/_themes/docs/js/docs.js?v=1627674102" async></script>  <script type="text/javascript"> (function(w,d,t,u,n,s,e){w['SwiftypeObject']=n;w[n]=w[n]||function(){ (w[n].q=w[n].q||[]).push(arguments);};s=d.createElement(t); e=d.getElementsByTagName(t)[0];s.async=1;s.src=u;e.parentNode.insertBefore(s,e); })(window,document,'script','//web.archive.org/web/20210802015220/https://s.swiftypecdn.com/install/v2/st.js','_st'); _st('install','zgajfc-EgsKmEKBAatQg','2.0.0'); </script> </head> <body>  <noscript><iframe src="https://web.archive.org/web/20210802015220if_/https://www.googletagmanager.com/ns.html?id=GTM-NWWX6K" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript> <div id="ed-nav"> <div id="looker-logo"> <a href="https://web.archive.org/web/20210802015220/https://looker.com/"><img src="/web/20210802015220im_/https://docs.looker.com/assets/site_images/looker-logo.svg"/></a> </div> <div id="ed-options"> <a href="https://web.archive.org/web/20210802015220/https://looker.com/guide" class="custres-gtm-nav-link"><i class="material-icons">home</i> User Guide </a> <a href="https://web.archive.org/web/20210802015220/https://looker.com/guide/getting-started" class="custres-gtm-nav-link"> Getting Started </a> <a href="https://web.archive.org/web/20210802015220/https://help.looker.com/" class="custres-gtm-nav-link"> Help Center </a> <a href="/web/20210802015220/https://docs.looker.com/" class="custres-gtm-nav-link" id="docs-home"> <b>Documentation</b> </a> <a href="https://web.archive.org/web/20210802015220/https://community.looker.com/" class="custres-gtm-nav-link"> Community </a> <a href="https://web.archive.org/web/20210802015220/https://training.looker.com/" class="custres-gtm-nav-link"> Training </a> <a href="https://web.archive.org/web/20210802015220/https://looker.com/certification/" class="custres-gtm-nav-link"> Certification </a> </div> <div id="mobile-ed"> <i class="material-icons">menu</i> </div> </div> <header> <div id="menu-container"> <div id="menu-expand"> Docs menu <i class="material-icons">keyboard_arrow_down</i> </div> <section id="menu"> <div id="menu-contents"> <div class="menu-column categories"><div class="option" data-show-class="0">Looker introduction <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="1">Latest features <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="2">Find and organize content <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="3">Send and share content <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="4">Retrieve and chart data <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="5">Create dashboards and reports <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="6">Get ready for development <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="7">Write LookML <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="8">Use embedding, the API, and the extension framework <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="9">Set up and administer Looker <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="10">Looker mobile application <i class="material-icons">keyboard_arrow_right</i></div></div><div class="menu-column sub-categories 0"><div class="option" data-show-class="0-0">Quick start pages <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="0-1">Personalizing Looker <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="0-2">Keyboard shortcuts <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="0-3">Video tutorials <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="0-4">Looker glossary <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="0-5">Looker error catalog <i class="material-icons">keyboard_arrow_right</i></div></div><div class="menu-column sub-categories 2"><div class="option" data-show-class="2-0">Finding and viewing content <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="2-1">Organizing content <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="2-2">For developers and admins <i class="material-icons">keyboard_arrow_right</i></div></div><div class="menu-column sub-categories 3"><div class="option" data-show-class="3-0">Sharing data overview <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="3-1">One-time sharing <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="3-2">Periodic sharing <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="3-3">Conditional sharing <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="3-4">Video tutorials <i class="material-icons">keyboard_arrow_right</i></div></div><div class="menu-column sub-categories 4"><div class="option" data-show-class="4-0">Retrieving data <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="4-1">Creating your own fields <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="4-2">Creating charts <i class="material-icons">keyboard_arrow_right</i></div></div><div class="menu-column sub-categories 5"><div class="option" data-show-class="5-0">Creating saved reports (Looks) <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="5-1">Creating user-defined dashboards <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="5-2">Creating and managing LookML dashboards <i class="material-icons">keyboard_arrow_right</i></div></div><div class="menu-column sub-categories 6"><div class="option" data-show-class="6-0">Development basics <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="6-1">SQL in Looker <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="6-2">Creating and editing projects <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="6-3">Git and version control <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="6-4">Setting up a database connection <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="6-5">Looker Marketplace <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="6-6">Video tutorials <i class="material-icons">keyboard_arrow_right</i></div></div><div class="menu-column sub-categories 7"><div class="option" data-show-class="7-0">Getting started with LookML <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="7-1">Basic concepts <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="7-2">Advanced concepts <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="7-3">LookML reference <i class="material-icons">keyboard_arrow_right</i></div></div><div class="menu-column sub-categories 8"><div class="option" data-show-class="8-0">Looker API <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="8-1">Embedding <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="8-2">Extension framework and UI components <i class="material-icons">keyboard_arrow_right</i></div></div><div class="menu-column sub-categories 9"><div class="option" data-show-class="9-0">Getting started with setup and admin <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="9-1">Installation and maintenance <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="9-2">Setting up a database connection <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="9-3">Admin tutorials <i class="material-icons">keyboard_arrow_right</i></div><div class="option" data-show-class="9-4">Admin panel reference <i class="material-icons">keyboard_arrow_right</i></div></div><div class="menu-column pages 0-0"><a href="https://web.archive.org/web/20210802015220/https://vimeo.com/215917994" class="gtm-nav-link"><div class="option" data-page-id="0-0-0">Logging in video tutorial</div></a><a href="/web/20210802015220/https://docs.looker.com/intro" class="gtm-nav-link"><div class="option" data-page-id="0-0-1">Looker introduction</div></a><a href="/web/20210802015220/https://docs.looker.com/relnotes/intro" class="gtm-nav-link"><div class="option" data-page-id="0-0-2">Latest features</div></a><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing" class="gtm-nav-link"><div class="option" data-page-id="0-0-3">Find and organize content</div></a><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/send-share-intro" class="gtm-nav-link"><div class="option" data-page-id="0-0-4">Send and share content</div></a><a href="/web/20210802015220/https://docs.looker.com/exploring-data/retrieve-chart-intro" class="gtm-nav-link"><div class="option" data-page-id="0-0-5">Retrieve and chart data</div></a><a href="/web/20210802015220/https://docs.looker.com/dashboards/dashboards-reports-intro" class="gtm-nav-link"><div class="option" data-page-id="0-0-6">Create and edit dashboards and reports</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling" class="gtm-nav-link"><div class="option" data-page-id="0-0-7">Get ready for development</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/lookml-intro" class="gtm-nav-link"><div class="option" data-page-id="0-0-8">Write LookML</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/api-embedding-intro" class="gtm-nav-link"><div class="option" data-page-id="0-0-9">Use embedding and the API</div></a><a href="/web/20210802015220/https://docs.looker.com/admin-options" class="gtm-nav-link"><div class="option" data-page-id="0-0-10">Set up and administer Looker</div></a></div><div class="menu-column pages 0-1"><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/user-menu" class="gtm-nav-link"><div class="option" data-page-id="0-1-0">Personalizing your user profile</div></a><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/user-account" class="gtm-nav-link"><div class="option" data-page-id="0-1-1">Personalizing user account settings</div></a><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/user-history" class="gtm-nav-link"><div class="option" data-page-id="0-1-2">Viewing your query history</div></a><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/user-schedules" class="gtm-nav-link"><div class="option" data-page-id="0-1-3">Viewing your scheduled data deliveries</div></a><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/user-alerts" class="gtm-nav-link"><div class="option" data-page-id="0-1-4">Viewing your conditional alert notifications</div></a><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/user-sessions" class="gtm-nav-link"><div class="option" data-page-id="0-1-5">Viewing information about your session</div></a></div><div class="menu-column pages 0-2"><a href="/web/20210802015220/https://docs.looker.com/exploring-data/exploring-data/keyboard-shortcuts" class="gtm-nav-link"><div class="option" data-page-id="0-2-0">Keyboard shortcuts in Looker</div></a></div><div class="menu-column pages 0-3"><a href="https://web.archive.org/web/20210802015220/https://vimeo.com/268498280" class="gtm-nav-link"><div class="option" data-page-id="0-3-0">Why use Looker?</div></a><a href="/web/20210802015220/https://docs.looker.com/video-library/exploring-data" class="gtm-nav-link"><div class="option" data-page-id="0-3-1">Business user tutorials</div></a><a href="/web/20210802015220/https://docs.looker.com/video-library/data-modeling" class="gtm-nav-link"><div class="option" data-page-id="0-3-2">Admin and developer tutorials</div></a></div><div class="menu-column pages 0-4"><a href="/web/20210802015220/https://docs.looker.com/reference/glossary" class="gtm-nav-link"><div class="option" data-page-id="0-4-0">Looker glossary</div></a></div><div class="menu-column pages 0-5"><a href="/web/20210802015220/https://docs.looker.com/reference/looker-error-catalog" class="gtm-nav-link"><div class="option" data-page-id="0-5-0">Looker error catalog</div></a></div><div class="menu-column pages 1-0"><a href="/web/20210802015220/https://docs.looker.com/relnotes" class="gtm-nav-link"><div class="option" data-page-id="1-0-0">Looker 21 release highlights</div></a><a href="/web/20210802015220/https://docs.looker.com/relnotes/v21-changelog" class="gtm-nav-link"><div class="option" data-page-id="1-0-1">Looker 21 changelog</div></a><a href="/web/20210802015220/https://docs.looker.com/relnotes/v7-release-notes" class="gtm-nav-link"><div class="option" data-page-id="1-0-2">Looker 7 release highlights</div></a><a href="/web/20210802015220/https://docs.looker.com/relnotes/v7-changelog" class="gtm-nav-link"><div class="option" data-page-id="1-0-3">Looker 7 changelog</div></a><a href="/web/20210802015220/https://docs.looker.com/relnotes/esr-notes" class="gtm-nav-link"><div class="option" data-page-id="1-0-4">Extended support release notes</div></a><a href="/web/20210802015220/https://docs.looker.com/relnotes/v6-release-notes" class="gtm-nav-link"><div class="option" data-page-id="1-0-5">Looker 6 release notes</div></a><a href="/web/20210802015220/https://docs.looker.com/relnotes/v5-release-notes" class="gtm-nav-link"><div class="option" data-page-id="1-0-6">Looker 5 release notes</div></a><a href="/web/20210802015220/https://docs.looker.com/relnotes/v4-release-notes" class="gtm-nav-link"><div class="option" data-page-id="1-0-7">Looker 4 release notes</div></a><a href="/web/20210802015220/https://docs.looker.com/relnotes/v3-release-notes" class="gtm-nav-link"><div class="option" data-page-id="1-0-8">Looker 3 release notes</div></a></div><div class="menu-column pages 2-0"><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/finding-content" class="gtm-nav-link"><div class="option" data-page-id="2-0-0">Finding content in Looker</div></a><a href="/web/20210802015220/https://docs.looker.com/dashboards/new-dashboard-experience" class="gtm-nav-link"><div class="option" data-page-id="2-0-1">Viewing dashboards</div></a><a href="/web/20210802015220/https://docs.looker.com/dashboards/viewing-user-dashboards" class="gtm-nav-link"><div class="option" data-page-id="2-0-2">Viewing legacy dashboards in Looker</div></a><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/viewing-looks" class="gtm-nav-link"><div class="option" data-page-id="2-0-3">Viewing Looks in Looker</div></a><a href="/web/20210802015220/https://docs.looker.com/video-library/exploring-data#find_and_view_content" class="gtm-nav-link"><div class="option" data-page-id="2-0-4">Video tutorials</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/filter-expressions" class="gtm-nav-link"><div class="option" data-page-id="2-0-5">Looker filter expressions</div></a></div><div class="menu-column pages 2-1"><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/organizing-spaces" class="gtm-nav-link"><div class="option" data-page-id="2-1-0">Organizing and managing access to content</div></a><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/presenting-content" class="gtm-nav-link"><div class="option" data-page-id="2-1-1">Presenting content with boards</div></a></div><div class="menu-column pages 2-2"><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/admin-spaces" class="gtm-nav-link"><div class="option" data-page-id="2-2-0">Deleted and unused content for admins</div></a></div><div class="menu-column pages 3-0"><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/sharing-data" class="gtm-nav-link"><div class="option" data-page-id="3-0-0">Sharing data</div></a></div><div class="menu-column pages 3-1"><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/downloading" class="gtm-nav-link"><div class="option" data-page-id="3-1-0">Downloading content</div></a><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/publishing-looks-with-public-urls" class="gtm-nav-link"><div class="option" data-page-id="3-1-1">Public sharing, importing, and embedding of Looks</div></a><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/sharing-urls" class="gtm-nav-link"><div class="option" data-page-id="3-1-2">Sharing data from URLs</div></a></div><div class="menu-column pages 3-2"><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/scheduling-and-sharing/scheduling" class="gtm-nav-link"><div class="option" data-page-id="3-2-0">Using the Looker Scheduler to Deliver Content</div></a><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/scheduling-and-sharing/scheduling-new-dashboards" class="gtm-nav-link"><div class="option" data-page-id="3-2-1">Scheduling and sending dashboards</div></a><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/scheduling-and-sharing/scheduling-slack" class="gtm-nav-link"><div class="option" data-page-id="3-2-2">Scheduling deliveries to the Slack integration</div></a><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/action-hub" class="gtm-nav-link"><div class="option" data-page-id="3-2-3">Sharing data through an action hub</div></a><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/scheduling-and-sharing/scheduling-for-admins" class="gtm-nav-link"><div class="option" data-page-id="3-2-4">Configuring content deliveries for Looker users (Looker admins)</div></a></div><div class="menu-column pages 3-3"><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/scheduling-and-sharing/delivering-looks-explores#send_this_schedule_if" class="gtm-nav-link"><div class="option" data-page-id="3-3-0">Conditionally delivering Looks and Explores</div></a><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/alerts" class="gtm-nav-link"><div class="option" data-page-id="3-3-1">Conditional alerts overview</div></a><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/alerts-for-admins" class="gtm-nav-link"><div class="option" data-page-id="3-3-2">Configuring conditional alerts for Looker users (Looker admins)</div></a></div><div class="menu-column pages 3-4"><a href="/web/20210802015220/https://docs.looker.com/video-library/exploring-data#send_and_share_content" class="gtm-nav-link"><div class="option" data-page-id="3-4-0">Video tutorials</div></a></div><div class="menu-column pages 4-0"><a href="/web/20210802015220/https://docs.looker.com/exploring-data/exploring-data" class="gtm-nav-link"><div class="option" data-page-id="4-0-0">Exploring data in Looker</div></a><a href="/web/20210802015220/https://docs.looker.com/exploring-data/filtering-and-limiting" class="gtm-nav-link"><div class="option" data-page-id="4-0-1">Filtering and limiting data</div></a><a href="/web/20210802015220/https://docs.looker.com/exploring-data/exploring-data/merged-results" class="gtm-nav-link"><div class="option" data-page-id="4-0-2">Merging results from different Explores</div></a><a href="/web/20210802015220/https://docs.looker.com/video-library/exploring-data#how_to_retrieve_data" class="gtm-nav-link"><div class="option" data-page-id="4-0-3">Video tutorials</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/filter-expressions" class="gtm-nav-link"><div class="option" data-page-id="4-0-4">Looker filter expressions</div></a><a href="/web/20210802015220/https://docs.looker.com/exploring-data/creating-looker-expressions/looker-functions-and-operators" class="gtm-nav-link"><div class="option" data-page-id="4-0-5">Looker functions and operators</div></a><a href="/web/20210802015220/https://docs.looker.com/exploring-data/custom-formatting" class="gtm-nav-link"><div class="option" data-page-id="4-0-6">Adding custom formatting to numeric fields</div></a></div><div class="menu-column pages 4-1"><a href="/web/20210802015220/https://docs.looker.com/exploring-data/using-table-calculations" class="gtm-nav-link"><div class="option" data-page-id="4-1-0">Using table calculations</div></a><a href="/web/20210802015220/https://docs.looker.com/exploring-data/adding-fields/custom-measure" class="gtm-nav-link"><div class="option" data-page-id="4-1-1">Adding custom fields</div></a><a href="/web/20210802015220/https://docs.looker.com/exploring-data/creating-looker-expressions" class="gtm-nav-link"><div class="option" data-page-id="4-1-2">Creating Looker expressions</div></a><a href="/web/20210802015220/https://docs.looker.com/exploring-data/creating-looker-expressions/looker-functions-and-operators" class="gtm-nav-link"><div class="option" data-page-id="4-1-3">Looker functions and operators</div></a></div><div class="menu-column pages 4-2"><a href="/web/20210802015220/https://docs.looker.com/exploring-data/visualizing-query-results" class="gtm-nav-link"><div class="option" data-page-id="4-2-0">Creating visualizations and graphs</div></a><a href="/web/20210802015220/https://docs.looker.com/exploring-data/visualizing-query-results/visualization-types" class="gtm-nav-link"><div class="option" data-page-id="4-2-1">Visualization types</div></a><a href="/web/20210802015220/https://docs.looker.com/exploring-data/visualizing-query-results/color-collections" class="gtm-nav-link"><div class="option" data-page-id="4-2-2">Color collections</div></a><a href="/web/20210802015220/https://docs.looker.com/exploring-data/visualizing-query-results/time-formatting-for-charts" class="gtm-nav-link"><div class="option" data-page-id="4-2-3">Time formatting for charts</div></a><a href="/web/20210802015220/https://docs.looker.com/video-library/exploring-data#how_to_create_charts" class="gtm-nav-link"><div class="option" data-page-id="4-2-4">Video tutorials</div></a></div><div class="menu-column pages 5-0"><a href="/web/20210802015220/https://docs.looker.com/exploring-data/saving-and-editing-looks" class="gtm-nav-link"><div class="option" data-page-id="5-0-0">Saving and editing Looks</div></a></div><div class="menu-column pages 5-1"><a href="/web/20210802015220/https://docs.looker.com/dashboards/creating-dashboards-beta" class="gtm-nav-link"><div class="option" data-page-id="5-1-0">Creating user-defined dashboards</div></a><a href="/web/20210802015220/https://docs.looker.com/dashboards/editing-dashboards-beta" class="gtm-nav-link"><div class="option" data-page-id="5-1-1">Editing user-defined dashboards</div></a><a href="/web/20210802015220/https://docs.looker.com/dashboards/dashboard-beta-filters" class="gtm-nav-link"><div class="option" data-page-id="5-1-2">Adding and editing user-defined dashboard filters</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/filter-expressions" class="gtm-nav-link"><div class="option" data-page-id="5-1-3">Looker filter expressions</div></a><a href="/web/20210802015220/https://docs.looker.com/dashboards/cross-filtering" class="gtm-nav-link"><div class="option" data-page-id="5-1-4">Cross-filtering dashboards</div></a><a href="/web/20210802015220/https://docs.looker.com/dashboards/embedding-dashboards-beta" class="gtm-nav-link"><div class="option" data-page-id="5-1-5">Embedding dashboards</div></a><a href="/web/20210802015220/https://docs.looker.com/dashboards/legacy-dashboards-landing" class="gtm-nav-link"><div class="option" data-page-id="5-1-6">Legacy dashboards</div></a><a href="/web/20210802015220/https://docs.looker.com/video-library/exploring-data#creating_user-defined_dashboards" class="gtm-nav-link"><div class="option" data-page-id="5-1-7">Video tutorials</div></a></div><div class="menu-column pages 5-2"><a href="/web/20210802015220/https://docs.looker.com/dashboards/creating-lookml-dashboards" class="gtm-nav-link"><div class="option" data-page-id="5-2-0">Building LookML dashboards</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/lookml-dashboard-overview" class="gtm-nav-link"><div class="option" data-page-id="5-2-1">LookML dashboard reference</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/dashboard-reference/lookml-visualization-reference" class="gtm-nav-link"><div class="option" data-page-id="5-2-2">Dashboard element parameters</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/dashboard-reference/lookml-reference-lines-reference" class="gtm-nav-link"><div class="option" data-page-id="5-2-3">Dashboard reference line parameters</div></a><a href="/web/20210802015220/https://docs.looker.com/dashboards/lookml-to-user-dashboard" class="gtm-nav-link"><div class="option" data-page-id="5-2-4">Converting from LookML to user-defined dashboards</div></a><a href="/web/20210802015220/https://docs.looker.com/dashboards/creating-lookml-dashboards#create_a_lookml_copy_of_a_user-defined_dashboard" class="gtm-nav-link"><div class="option" data-page-id="5-2-5">Converting from user-defined to LookML dashboards</div></a></div><div class="menu-column pages 6-0"><a href="/web/20210802015220/https://docs.looker.com/data-modeling" class="gtm-nav-link"><div class="option" data-page-id="6-0-0">Get ready for development</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/how-project-works" class="gtm-nav-link"><div class="option" data-page-id="6-0-1">How a project works in Looker</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/dev-mode-prod-mode" class="gtm-nav-link"><div class="option" data-page-id="6-0-2">Development Mode and Production Mode</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project" class="gtm-nav-link"><div class="option" data-page-id="6-0-3">LookML project files</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/model-development" class="gtm-nav-link"><div class="option" data-page-id="6-0-4">Understanding model and view files</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/other-project-files" class="gtm-nav-link"><div class="option" data-page-id="6-0-5">Understanding other project files</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/ide-folders" class="gtm-nav-link"><div class="option" data-page-id="6-0-6">Working with folders in the IDE</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/object-browser" class="gtm-nav-link"><div class="option" data-page-id="6-0-7">Navigating projects with the object browser panel</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/lookml-metadata" class="gtm-nav-link"><div class="option" data-page-id="6-0-8">Metadata for LookML objects</div></a></div><div class="menu-column pages 6-1"><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/how-looker-generates-sql" class="gtm-nav-link"><div class="option" data-page-id="6-1-0">How Looker generates SQL</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/sql-runner" class="gtm-nav-link"><div class="option" data-page-id="6-1-1">SQL Runner basics</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/sql-runner-create-queries" class="gtm-nav-link"><div class="option" data-page-id="6-1-2">Using SQL Runner to create queries and Explores</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/sql-runner-create-dts" class="gtm-nav-link"><div class="option" data-page-id="6-1-3">Using SQL Runner to create derived tables</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/sql-runner-manage-db" class="gtm-nav-link"><div class="option" data-page-id="6-1-4">Managing database functions with SQL Runner</div></a></div><div class="menu-column pages 6-2"><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/create-projects" class="gtm-nav-link"><div class="option" data-page-id="6-2-0">Creating a new LookML project</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/manage-projects" class="gtm-nav-link"><div class="option" data-page-id="6-2-1">Accessing and editing project information</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/connect-to-db-and-generate-model" class="gtm-nav-link"><div class="option" data-page-id="6-2-2">Generating a model</div></a></div><div class="menu-column pages 6-3"><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/setting-up-git-connection" class="gtm-nav-link"><div class="option" data-page-id="6-3-0">Setting up and testing a Git connection</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/git-options" class="gtm-nav-link"><div class="option" data-page-id="6-3-1">Configuring project version control settings</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/webhook-deploy-secret" class="gtm-nav-link"><div class="option" data-page-id="6-3-2">Configuring the webhook deploy secret</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/advanced-deploy-mode" class="gtm-nav-link"><div class="option" data-page-id="6-3-3">Advanced deploy mode</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/version-control-and-deploying-changes" class="gtm-nav-link"><div class="option" data-page-id="6-3-4">Using version control and deploying</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/git-command-reference" class="gtm-nav-link"><div class="option" data-page-id="6-3-5">Git command reference</div></a></div><div class="menu-column pages 6-4"><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/enabling-secure-db" class="gtm-nav-link"><div class="option" data-page-id="6-4-0">Enabling secure database access</div></a><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/database-config" class="gtm-nav-link"><div class="option" data-page-id="6-4-1">Database configuration instructions</div></a><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/connecting-to-db" class="gtm-nav-link"><div class="option" data-page-id="6-4-2">Connecting Looker to your database</div></a><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/connecting-to-db/testing-db-connectivity" class="gtm-nav-link"><div class="option" data-page-id="6-4-3">Testing database connectivity</div></a></div><div class="menu-column pages 6-5"><a href="/web/20210802015220/https://docs.looker.com/data-modeling/marketplace" class="gtm-nav-link"><div class="option" data-page-id="6-5-0">Using the Looker Marketplace</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/marketplace/customize-blocks" class="gtm-nav-link"><div class="option" data-page-id="6-5-1">Customizing Looker Marketplace Blocks</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/marketplace/adding-block-marketplace" class="gtm-nav-link"><div class="option" data-page-id="6-5-2">Developing a custom block for the Looker Marketplace</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/marketplace/adding-viz-marketplace" class="gtm-nav-link"><div class="option" data-page-id="6-5-3">Developing a custom visualization for the Looker Marketplace</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/extension-framework/data-dictionary" class="gtm-nav-link"><div class="option" data-page-id="6-5-4">Using the Looker Data Dictionary</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/extension-framework/lookml-diagram-admins" class="gtm-nav-link"><div class="option" data-page-id="6-5-5">Configuring the LookML Diagram</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/extension-framework/lookml-diagram" class="gtm-nav-link"><div class="option" data-page-id="6-5-6">Using the LookML Diagram</div></a></div><div class="menu-column pages 6-6"><a href="/web/20210802015220/https://docs.looker.com/video-library/data-modeling" class="gtm-nav-link"><div class="option" data-page-id="6-6-0">Video tutorials</div></a></div><div class="menu-column pages 7-0"><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml" class="gtm-nav-link"><div class="option" data-page-id="7-0-0">Steps to learning LookML</div></a><a href="/web/20210802015220/https://docs.looker.com/video-library/data-modeling" class="gtm-nav-link"><div class="option" data-page-id="7-0-1">Video tutorials</div></a></div><div class="menu-column pages 7-1"><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/what-is-lookml" class="gtm-nav-link"><div class="option" data-page-id="7-1-0">What is LookML?</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/lookml-terms-and-concepts" class="gtm-nav-link"><div class="option" data-page-id="7-1-1">LookML terms and concepts</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/lookml-validation" class="gtm-nav-link"><div class="option" data-page-id="7-1-2">Editing and validating LookML</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/look-validation" class="gtm-nav-link"><div class="option" data-page-id="7-1-3">Content validation</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/sql-and-referring-to-lookml" class="gtm-nav-link"><div class="option" data-page-id="7-1-4">Incorporating SQL and referring to LookML objects</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/advanced-lookml-concepts" class="gtm-nav-link"><div class="option" data-page-id="7-1-5">Additional LookML basics</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/working-with-joins" class="gtm-nav-link"><div class="option" data-page-id="7-1-6">Working with joins in LookML</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/derived-tables" class="gtm-nav-link"><div class="option" data-page-id="7-1-7">Derived tables in Looker</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/creating-ndts" class="gtm-nav-link"><div class="option" data-page-id="7-1-8">Creating native derived tables</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/incremental-pdts" class="gtm-nav-link"><div class="option" data-page-id="7-1-9">Incremental PDTs</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/explore-menu-and-field-picker" class="gtm-nav-link"><div class="option" data-page-id="7-1-10">Changing the Explore menu and field picker</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/filter-suggestions" class="gtm-nav-link"><div class="option" data-page-id="7-1-11">Changing filter suggestions</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/looker-blocks" class="gtm-nav-link"><div class="option" data-page-id="7-1-12">Looker Blocks</div></a></div><div class="menu-column pages 7-2"><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/caching" class="gtm-nav-link"><div class="option" data-page-id="7-2-0">Caching queries and rebuilding PDTs with datagroups</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/aggregate_awareness" class="gtm-nav-link"><div class="option" data-page-id="7-2-1">Aggregate awareness</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/extends" class="gtm-nav-link"><div class="option" data-page-id="7-2-2">Reusing code with extends</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/refinements" class="gtm-nav-link"><div class="option" data-page-id="7-2-3">LookML refinements</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/importing-projects" class="gtm-nav-link"><div class="option" data-page-id="7-2-4">Importing files from other projects</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/templated-filters" class="gtm-nav-link"><div class="option" data-page-id="7-2-5">Templated filters and Liquid parameters</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/liquid-variables" class="gtm-nav-link"><div class="option" data-page-id="7-2-6">Liquid variable reference</div></a><a href="/web/20210802015220/https://docs.looker.com/admin-options/security/html-sanitization" class="gtm-nav-link"><div class="option" data-page-id="7-2-7">HTML sanitization</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/model-localization" class="gtm-nav-link"><div class="option" data-page-id="7-2-8">Localizing your model</div></a></div><div class="menu-column pages 7-3"><a href="/web/20210802015220/https://docs.looker.com/reference/lookml" class="gtm-nav-link"><div class="option" data-page-id="7-3-0">LookML parameter reference by function</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/lookml-quick-reference" class="gtm-nav-link"><div class="option" data-page-id="7-3-1">LookML quick reference</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/manifest-reference" class="gtm-nav-link"><div class="option" data-page-id="7-3-2">Project manifest parameters</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/model-reference" class="gtm-nav-link"><div class="option" data-page-id="7-3-3">Model parameters</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/explore-reference" class="gtm-nav-link"><div class="option" data-page-id="7-3-4">Explore parameters</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/join-reference" class="gtm-nav-link"><div class="option" data-page-id="7-3-5">Join parameters</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/view-reference" class="gtm-nav-link"><div class="option" data-page-id="7-3-6">View parameters</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/field-reference" class="gtm-nav-link"><div class="option" data-page-id="7-3-7">Field parameters</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/field-reference/dimension-type-reference" class="gtm-nav-link"><div class="option" data-page-id="7-3-8">Dimension, filter, and parameter types</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/field-reference/measure-type-reference" class="gtm-nav-link"><div class="option" data-page-id="7-3-9">Measure types</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/filter-expressions" class="gtm-nav-link"><div class="option" data-page-id="7-3-10">Looker filter expressions</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/liquid-variables" class="gtm-nav-link"><div class="option" data-page-id="7-3-11">Liquid variable reference</div></a></div><div class="menu-column pages 8-0"><a href="/web/20210802015220/https://docs.looker.com/reference/api-and-integration/api-getting-started" class="gtm-nav-link"><div class="option" data-page-id="8-0-0">Getting started with the Looker API</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/api-and-integration/api-auth" class="gtm-nav-link"><div class="option" data-page-id="8-0-1">Looker API authentication</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/api-and-integration/api-cors" class="gtm-nav-link"><div class="option" data-page-id="8-0-2">Looker API authentication using OAuth</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/api-and-integration/api-versioning" class="gtm-nav-link"><div class="option" data-page-id="8-0-3">Looker API versioning</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/api-and-integration/api-explorer" class="gtm-nav-link"><div class="option" data-page-id="8-0-4">Using the API Explorer</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/api-and-integration/api-reference/v3.0" class="gtm-nav-link"><div class="option" data-page-id="8-0-5">Looker 3.0 API (legacy) reference</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/api-and-integration/api-reference/v3.1" class="gtm-nav-link"><div class="option" data-page-id="8-0-6">Looker 3.1 API reference</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/api-and-integration/api-reference/v4.0" class="gtm-nav-link"><div class="option" data-page-id="8-0-7">Looker 4.0 API reference (experimental)</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/api-and-integration/api-sdk" class="gtm-nav-link"><div class="option" data-page-id="8-0-8">Looker API SDKs</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/api-and-integration/api-troubleshooting" class="gtm-nav-link"><div class="option" data-page-id="8-0-9">Looker API troubleshooting</div></a></div><div class="menu-column pages 8-1"><a href="/web/20210802015220/https://docs.looker.com/reference/embedding/security" class="gtm-nav-link"><div class="option" data-page-id="8-1-0">Security best practices for embedded analytics</div></a><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/embedding" class="gtm-nav-link"><div class="option" data-page-id="8-1-1">Private embedding</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/embedding/sso-embed" class="gtm-nav-link"><div class="option" data-page-id="8-1-2">Single sign-on (SSO) embedding</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/embedding/viewing" class="gtm-nav-link"><div class="option" data-page-id="8-1-3">Viewing embedded Looks, Explores, and dashboards</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/embedding/embed-javascript-events" class="gtm-nav-link"><div class="option" data-page-id="8-1-4">Embedded Javascript events</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/embedding/timezones" class="gtm-nav-link"><div class="option" data-page-id="8-1-5">SSO embedding time zone reference</div></a><a href="/web/20210802015220/https://docs.looker.com/admin-options/settings/themes" class="gtm-nav-link"><div class="option" data-page-id="8-1-6">Custom themes for embedded dashboards</div></a><a href="/web/20210802015220/https://docs.looker.com/reference/embed-sdk" class="gtm-nav-link"><div class="option" data-page-id="8-1-7">Embed SDK</div></a></div><div class="menu-column pages 8-2"><a href="/web/20210802015220/https://docs.looker.com/data-modeling/extension-framework" class="gtm-nav-link"><div class="option" data-page-id="8-2-0">Getting started with the Looker extension framework</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/extension-framework/permissions" class="gtm-nav-link"><div class="option" data-page-id="8-2-1">Setting permissions for Looker extensions</div></a><a href="/web/20210802015220/https://docs.looker.com/data-modeling/extension-framework/filter-components" class="gtm-nav-link"><div class="option" data-page-id="8-2-2">Looker filter components</div></a></div><div class="menu-column pages 9-0"><a href="/web/20210802015220/https://docs.looker.com/admin-options" class="gtm-nav-link"><div class="option" data-page-id="9-0-0">Set up and administer Looker overview</div></a><a href="/web/20210802015220/https://docs.looker.com/admin-options/supported-browsers" class="gtm-nav-link"><div class="option" data-page-id="9-0-1">Supported browsers</div></a><a href="/web/20210802015220/https://docs.looker.com/admin-options/supported-looker-versions" class="gtm-nav-link"><div class="option" data-page-id="9-0-2">Supported Looker versions</div></a></div><div class="menu-column pages 9-1"><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/looker-hosted-install" class="gtm-nav-link"><div class="option" data-page-id="9-1-0">Looker-hosted installation steps</div></a><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/on-prem-install" class="gtm-nav-link"><div class="option" data-page-id="9-1-1">Customer-hosted installation steps</div></a><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/on-prem-mgmt" class="gtm-nav-link"><div class="option" data-page-id="9-1-2">Managing a customer-hosted deployment</div></a><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/signin-options" class="gtm-nav-link"><div class="option" data-page-id="9-1-3">Getting started with users</div></a><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/on-prem-install/auto-provision-user" class="gtm-nav-link"><div class="option" data-page-id="9-1-4">Auto-provisioning a new Looker instance</div></a></div><div class="menu-column pages 9-2"><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/enabling-secure-db" class="gtm-nav-link"><div class="option" data-page-id="9-2-0">Enabling secure database access</div></a><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/database-config" class="gtm-nav-link"><div class="option" data-page-id="9-2-1">Database configuration instructions</div></a><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/connecting-to-db" class="gtm-nav-link"><div class="option" data-page-id="9-2-2">Connecting Looker to your database</div></a><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/connecting-to-db/testing-db-connectivity" class="gtm-nav-link"><div class="option" data-page-id="9-2-3">Testing database connectivity</div></a><a href="/web/20210802015220/https://docs.looker.com/video-library/data-modeling#setting_up_a_connection" class="gtm-nav-link"><div class="option" data-page-id="9-2-4">Video tutorials</div></a></div><div class="menu-column pages 9-3"><a href="/web/20210802015220/https://docs.looker.com/admin-options/tutorials/permissions" class="gtm-nav-link"><div class="option" data-page-id="9-3-0">Access control and permission management</div></a><a href="/web/20210802015220/https://docs.looker.com/admin-options/tutorials/access-controls" class="gtm-nav-link"><div class="option" data-page-id="9-3-1">Designing and configuring a system of access levels</div></a><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/tutorials/clustering" class="gtm-nav-link"><div class="option" data-page-id="9-3-2">Clustering Looker</div></a><a href="/web/20210802015220/https://docs.looker.com/admin-options/tutorials/connections" class="gtm-nav-link"><div class="option" data-page-id="9-3-3">Creating connections</div></a><a href="/web/20210802015220/https://docs.looker.com/admin-options/system-activity" class="gtm-nav-link"><div class="option" data-page-id="9-3-4">System Activity pages</div></a><a href="/web/20210802015220/https://docs.looker.com/admin-options/tutorials/system-activity" class="gtm-nav-link"><div class="option" data-page-id="9-3-5">Creating Looker usage reports with System Activity Explores</div></a><a href="/web/20210802015220/https://docs.looker.com/admin-options/tutorials/notify-users" class="gtm-nav-link"><div class="option" data-page-id="9-3-6">Making announcements to your users</div></a><a href="/web/20210802015220/https://docs.looker.com/admin-options/tutorials/managing-bizusers/bizuser-features" class="gtm-nav-link"><div class="option" data-page-id="9-3-7">Managing business user features</div></a><a href="/web/20210802015220/https://docs.looker.com/admin-options/tutorials/delete-user" class="gtm-nav-link"><div class="option" data-page-id="9-3-8">Deleting personal user information</div></a><a href="/web/20210802015220/https://docs.looker.com/admin-options/tutorials/timezones" class="gtm-nav-link"><div class="option" data-page-id="9-3-9">Using time zone settings</div></a><a href="/web/20210802015220/https://docs.looker.com/admin-options/tutorials/localizing-looker" class="gtm-nav-link"><div class="option" data-page-id="9-3-10">Supported user-interface languages</div></a><a href="/web/20210802015220/https://docs.looker.com/admin-options/tutorials/localizing-number-formatting" class="gtm-nav-link"><div class="option" data-page-id="9-3-11">Localizing number formatting</div></a></div><div class="menu-column pages 9-4"><a href="/web/20210802015220/https://docs.looker.com/admin-options/settings" class="gtm-nav-link"><div class="option" data-page-id="9-4-0">General pages</div></a><a href="/web/20210802015220/https://docs.looker.com/admin-options/system-activity/sa-dashboards" class="gtm-nav-link"><div class="option" data-page-id="9-4-1">System Activity dashboards</div></a><a href="/web/20210802015220/https://docs.looker.com/admin-options/settings/page-users" class="gtm-nav-link"><div class="option" data-page-id="9-4-2">Users pages</div></a><a href="/web/20210802015220/https://docs.looker.com/admin-options/database" class="gtm-nav-link"><div class="option" data-page-id="9-4-3">Database pages</div></a><a href="/web/20210802015220/https://docs.looker.com/admin-options/scheduler" class="gtm-nav-link"><div class="option" data-page-id="9-4-4">Alerts & Schedules pages</div></a><a href="/web/20210802015220/https://docs.looker.com/admin-options/platform" class="gtm-nav-link"><div class="option" data-page-id="9-4-5">Platform pages</div></a><a href="/web/20210802015220/https://docs.looker.com/admin-options/security" class="gtm-nav-link"><div class="option" data-page-id="9-4-6">Authentication pages</div></a><a href="/web/20210802015220/https://docs.looker.com/admin-options/server" class="gtm-nav-link"><div class="option" data-page-id="9-4-7">Server pages</div></a></div><div class="menu-column pages 10-0"><a href="/web/20210802015220/https://docs.looker.com/mobile-app" class="gtm-nav-link"><div class="option" data-page-id="10-0-0">Looker mobile application</div></a><a href="/web/20210802015220/https://docs.looker.com/mobile-app/enabling-mobile" class="gtm-nav-link"><div class="option" data-page-id="10-0-1">Enabling the Looker mobile application for your instance</div></a><a href="/web/20210802015220/https://docs.looker.com/mobile-app/installation" class="gtm-nav-link"><div class="option" data-page-id="10-0-2">Installing the Looker mobile application on your mobile device</div></a><a href="/web/20210802015220/https://docs.looker.com/mobile-app/signing-in" class="gtm-nav-link"><div class="option" data-page-id="10-0-3">Signing in to the Looker mobile application</div></a><a href="/web/20210802015220/https://docs.looker.com/mobile-app/navigating-mobile-app" class="gtm-nav-link"><div class="option" data-page-id="10-0-4">Navigating to content in the Looker mobile application</div></a><a href="/web/20210802015220/https://docs.looker.com/mobile-app/viewing-looks" class="gtm-nav-link"><div class="option" data-page-id="10-0-5">Viewing Looks in the Looker mobile application</div></a><a href="/web/20210802015220/https://docs.looker.com/mobile-app/viewing-dashboards" class="gtm-nav-link"><div class="option" data-page-id="10-0-6">Viewing dashboards in the Looker mobile application</div></a></div>   <div id="instructions"> <span>Hover over a category to see its contents</span> </div> </div> </section> <div id="release"> <a href="/web/20210802015220/https://docs.looker.com/relnotes/intro">Release</a> </div> </div> <div id="search"> <div style="position:relative;"> <form> <input type="text" class="st-default-search-input" placeholder="Search docs"></input> </form> <div id="search-tips">Hint: Press [Enter] or [Return] after typing a search term to see more results and spelling suggestions</div> </div> </div> <div id="reader-options"> <div id="mobile-search"> <form> <input type="text" class="st-default-search-input" placeholder="Search docs"></input> </form> </div> <div id="mobile-search-close"> <i class="material-icons">close</i> </div> <div id="mobile-options"> <i class="material-icons">settings</i> </div> <div class="version-container"> <div id="looker-picker"> Looker <span id="current-looker"></span> <i class="material-icons">keyboard_arrow_down</i> <div id="looker-choices"></div> </div> </div> <div class="version-container lang-container"> <div id="lang-picker"> <i class="material-icons globe-icon">language</i> <i class="material-icons">keyboard_arrow_down</i> <div id="lang-choices"> <div class="lang" data-lang-abbr="en">English</div> <div class="lang" data-lang-abbr="fr">Français</div> <div class="lang" data-lang-abbr="de">Deutsch</div> <div class="lang" data-lang-abbr="ja">日本語</div> </div> </div> </div> <div id="mobile-search-button"> <i class="material-icons">search</i> </div> <div id="print"> <i class="material-icons">print</i> </div> </div> </header> <main> <section id="mobile-menu"> <ul><li>Looker introduction<ul class="child-nav"><li>Quick start pages<ul class="child-nav"><li><a href="https://web.archive.org/web/20210802015220/https://vimeo.com/215917994" class="gtm-nav-link">Logging in video tutorial</a></li><li><a href="/web/20210802015220/https://docs.looker.com/intro" class="gtm-nav-link">Looker introduction</a></li><li><a href="/web/20210802015220/https://docs.looker.com/relnotes/intro" class="gtm-nav-link">Latest features</a></li><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing" class="gtm-nav-link">Find and organize content</a></li><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/send-share-intro" class="gtm-nav-link">Send and share content</a></li><li><a href="/web/20210802015220/https://docs.looker.com/exploring-data/retrieve-chart-intro" class="gtm-nav-link">Retrieve and chart data</a></li><li><a href="/web/20210802015220/https://docs.looker.com/dashboards/dashboards-reports-intro" class="gtm-nav-link">Create and edit dashboards and reports</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling" class="gtm-nav-link">Get ready for development</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/lookml-intro" class="gtm-nav-link">Write LookML</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/api-embedding-intro" class="gtm-nav-link">Use embedding and the API</a></li><li><a href="/web/20210802015220/https://docs.looker.com/admin-options" class="gtm-nav-link">Set up and administer Looker</a></li></ul></li><li>Personalizing Looker<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/user-menu" class="gtm-nav-link">Personalizing your user profile</a></li><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/user-account" class="gtm-nav-link">Personalizing user account settings</a></li><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/user-history" class="gtm-nav-link">Viewing your query history</a></li><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/user-schedules" class="gtm-nav-link">Viewing your scheduled data deliveries</a></li><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/user-alerts" class="gtm-nav-link">Viewing your conditional alert notifications</a></li><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/user-sessions" class="gtm-nav-link">Viewing information about your session</a></li></ul></li><li>Keyboard shortcuts<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/exploring-data/exploring-data/keyboard-shortcuts" class="gtm-nav-link">Keyboard shortcuts in Looker</a></li></ul></li><li>Video tutorials<ul class="child-nav"><li><a href="https://web.archive.org/web/20210802015220/https://vimeo.com/268498280" class="gtm-nav-link">Why use Looker?</a></li><li><a href="/web/20210802015220/https://docs.looker.com/video-library/exploring-data" class="gtm-nav-link">Business user tutorials</a></li><li><a href="/web/20210802015220/https://docs.looker.com/video-library/data-modeling" class="gtm-nav-link">Admin and developer tutorials</a></li></ul></li><li>Looker glossary<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/reference/glossary" class="gtm-nav-link">Looker glossary</a></li></ul></li><li>Looker error catalog<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/reference/looker-error-catalog" class="gtm-nav-link">Looker error catalog</a></li></ul></li></ul></li></ul><ul><li>Latest features<ul class="child-nav"><li>Latest features<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/relnotes" class="gtm-nav-link">Looker 21 release highlights</a></li><li><a href="/web/20210802015220/https://docs.looker.com/relnotes/v21-changelog" class="gtm-nav-link">Looker 21 changelog</a></li><li><a href="/web/20210802015220/https://docs.looker.com/relnotes/v7-release-notes" class="gtm-nav-link">Looker 7 release highlights</a></li><li><a href="/web/20210802015220/https://docs.looker.com/relnotes/v7-changelog" class="gtm-nav-link">Looker 7 changelog</a></li><li><a href="/web/20210802015220/https://docs.looker.com/relnotes/esr-notes" class="gtm-nav-link">Extended support release notes</a></li><li><a href="/web/20210802015220/https://docs.looker.com/relnotes/v6-release-notes" class="gtm-nav-link">Looker 6 release notes</a></li><li><a href="/web/20210802015220/https://docs.looker.com/relnotes/v5-release-notes" class="gtm-nav-link">Looker 5 release notes</a></li><li><a href="/web/20210802015220/https://docs.looker.com/relnotes/v4-release-notes" class="gtm-nav-link">Looker 4 release notes</a></li><li><a href="/web/20210802015220/https://docs.looker.com/relnotes/v3-release-notes" class="gtm-nav-link">Looker 3 release notes</a></li></ul></li></ul></li></ul><ul><li>Find and organize content<ul class="child-nav"><li>Finding and viewing content<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/finding-content" class="gtm-nav-link">Finding content in Looker</a></li><li><a href="/web/20210802015220/https://docs.looker.com/dashboards/new-dashboard-experience" class="gtm-nav-link">Viewing dashboards</a></li><li><a href="/web/20210802015220/https://docs.looker.com/dashboards/viewing-user-dashboards" class="gtm-nav-link">Viewing legacy dashboards in Looker</a></li><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/viewing-looks" class="gtm-nav-link">Viewing Looks in Looker</a></li><li><a href="/web/20210802015220/https://docs.looker.com/video-library/exploring-data#find_and_view_content" class="gtm-nav-link">Video tutorials</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/filter-expressions" class="gtm-nav-link">Looker filter expressions</a></li></ul></li><li>Organizing content<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/organizing-spaces" class="gtm-nav-link">Organizing and managing access to content</a></li><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/presenting-content" class="gtm-nav-link">Presenting content with boards</a></li></ul></li><li>For developers and admins<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/admin-spaces" class="gtm-nav-link">Deleted and unused content for admins</a></li></ul></li></ul></li></ul><ul><li>Send and share content<ul class="child-nav"><li>Sharing data overview<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/sharing-data" class="gtm-nav-link">Sharing data</a></li></ul></li><li>One-time sharing<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/downloading" class="gtm-nav-link">Downloading content</a></li><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/publishing-looks-with-public-urls" class="gtm-nav-link">Public sharing, importing, and embedding of Looks</a></li><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/sharing-urls" class="gtm-nav-link">Sharing data from URLs</a></li></ul></li><li>Periodic sharing<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/scheduling-and-sharing/scheduling" class="gtm-nav-link">Using the Looker Scheduler to Deliver Content</a></li><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/scheduling-and-sharing/scheduling-new-dashboards" class="gtm-nav-link">Scheduling and sending dashboards</a></li><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/scheduling-and-sharing/scheduling-slack" class="gtm-nav-link">Scheduling deliveries to the Slack integration</a></li><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/action-hub" class="gtm-nav-link">Sharing data through an action hub</a></li><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/scheduling-and-sharing/scheduling-for-admins" class="gtm-nav-link">Configuring content deliveries for Looker users (Looker admins)</a></li></ul></li><li>Conditional sharing<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/scheduling-and-sharing/delivering-looks-explores#send_this_schedule_if" class="gtm-nav-link">Conditionally delivering Looks and Explores</a></li><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/alerts" class="gtm-nav-link">Conditional alerts overview</a></li><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/alerts-for-admins" class="gtm-nav-link">Configuring conditional alerts for Looker users (Looker admins)</a></li></ul></li><li>Video tutorials<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/video-library/exploring-data#send_and_share_content" class="gtm-nav-link">Video tutorials</a></li></ul></li></ul></li></ul><ul><li>Retrieve and chart data<ul class="child-nav"><li>Retrieving data<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/exploring-data/exploring-data" class="gtm-nav-link">Exploring data in Looker</a></li><li><a href="/web/20210802015220/https://docs.looker.com/exploring-data/filtering-and-limiting" class="gtm-nav-link">Filtering and limiting data</a></li><li><a href="/web/20210802015220/https://docs.looker.com/exploring-data/exploring-data/merged-results" class="gtm-nav-link">Merging results from different Explores</a></li><li><a href="/web/20210802015220/https://docs.looker.com/video-library/exploring-data#how_to_retrieve_data" class="gtm-nav-link">Video tutorials</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/filter-expressions" class="gtm-nav-link">Looker filter expressions</a></li><li><a href="/web/20210802015220/https://docs.looker.com/exploring-data/creating-looker-expressions/looker-functions-and-operators" class="gtm-nav-link">Looker functions and operators</a></li><li><a href="/web/20210802015220/https://docs.looker.com/exploring-data/custom-formatting" class="gtm-nav-link">Adding custom formatting to numeric fields</a></li></ul></li><li>Creating your own fields<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/exploring-data/using-table-calculations" class="gtm-nav-link">Using table calculations</a></li><li><a href="/web/20210802015220/https://docs.looker.com/exploring-data/adding-fields/custom-measure" class="gtm-nav-link">Adding custom fields</a></li><li><a href="/web/20210802015220/https://docs.looker.com/exploring-data/creating-looker-expressions" class="gtm-nav-link">Creating Looker expressions</a></li><li><a href="/web/20210802015220/https://docs.looker.com/exploring-data/creating-looker-expressions/looker-functions-and-operators" class="gtm-nav-link">Looker functions and operators</a></li></ul></li><li>Creating charts<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/exploring-data/visualizing-query-results" class="gtm-nav-link">Creating visualizations and graphs</a></li><li><a href="/web/20210802015220/https://docs.looker.com/exploring-data/visualizing-query-results/visualization-types" class="gtm-nav-link">Visualization types</a></li><li><a href="/web/20210802015220/https://docs.looker.com/exploring-data/visualizing-query-results/color-collections" class="gtm-nav-link">Color collections</a></li><li><a href="/web/20210802015220/https://docs.looker.com/exploring-data/visualizing-query-results/time-formatting-for-charts" class="gtm-nav-link">Time formatting for charts</a></li><li><a href="/web/20210802015220/https://docs.looker.com/video-library/exploring-data#how_to_create_charts" class="gtm-nav-link">Video tutorials</a></li></ul></li></ul></li></ul><ul><li>Create dashboards and reports<ul class="child-nav"><li>Creating saved reports (Looks)<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/exploring-data/saving-and-editing-looks" class="gtm-nav-link">Saving and editing Looks</a></li></ul></li><li>Creating user-defined dashboards<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/dashboards/creating-dashboards-beta" class="gtm-nav-link">Creating user-defined dashboards</a></li><li><a href="/web/20210802015220/https://docs.looker.com/dashboards/editing-dashboards-beta" class="gtm-nav-link">Editing user-defined dashboards</a></li><li><a href="/web/20210802015220/https://docs.looker.com/dashboards/dashboard-beta-filters" class="gtm-nav-link">Adding and editing user-defined dashboard filters</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/filter-expressions" class="gtm-nav-link">Looker filter expressions</a></li><li><a href="/web/20210802015220/https://docs.looker.com/dashboards/cross-filtering" class="gtm-nav-link">Cross-filtering dashboards</a></li><li><a href="/web/20210802015220/https://docs.looker.com/dashboards/embedding-dashboards-beta" class="gtm-nav-link">Embedding dashboards</a></li><li><a href="/web/20210802015220/https://docs.looker.com/dashboards/legacy-dashboards-landing" class="gtm-nav-link">Legacy dashboards</a></li><li><a href="/web/20210802015220/https://docs.looker.com/video-library/exploring-data#creating_user-defined_dashboards" class="gtm-nav-link">Video tutorials</a></li></ul></li><li>Creating and managing LookML dashboards<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/dashboards/creating-lookml-dashboards" class="gtm-nav-link">Building LookML dashboards</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/lookml-dashboard-overview" class="gtm-nav-link">LookML dashboard reference</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/dashboard-reference/lookml-visualization-reference" class="gtm-nav-link">Dashboard element parameters</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/dashboard-reference/lookml-reference-lines-reference" class="gtm-nav-link">Dashboard reference line parameters</a></li><li><a href="/web/20210802015220/https://docs.looker.com/dashboards/lookml-to-user-dashboard" class="gtm-nav-link">Converting from LookML to user-defined dashboards</a></li><li><a href="/web/20210802015220/https://docs.looker.com/dashboards/creating-lookml-dashboards#create_a_lookml_copy_of_a_user-defined_dashboard" class="gtm-nav-link">Converting from user-defined to LookML dashboards</a></li></ul></li></ul></li></ul><ul><li>Get ready for development<ul class="child-nav"><li>Development basics<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling" class="gtm-nav-link">Get ready for development</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/how-project-works" class="gtm-nav-link">How a project works in Looker</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/dev-mode-prod-mode" class="gtm-nav-link">Development Mode and Production Mode</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project" class="gtm-nav-link">LookML project files</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/model-development" class="gtm-nav-link">Understanding model and view files</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/other-project-files" class="gtm-nav-link">Understanding other project files</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/ide-folders" class="gtm-nav-link">Working with folders in the IDE</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/object-browser" class="gtm-nav-link">Navigating projects with the object browser panel</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/lookml-metadata" class="gtm-nav-link">Metadata for LookML objects</a></li></ul></li><li>SQL in Looker<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/how-looker-generates-sql" class="gtm-nav-link">How Looker generates SQL</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/sql-runner" class="gtm-nav-link">SQL Runner basics</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/sql-runner-create-queries" class="gtm-nav-link">Using SQL Runner to create queries and Explores</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/sql-runner-create-dts" class="gtm-nav-link">Using SQL Runner to create derived tables</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/sql-runner-manage-db" class="gtm-nav-link">Managing database functions with SQL Runner</a></li></ul></li><li>Creating and editing projects<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/create-projects" class="gtm-nav-link">Creating a new LookML project</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/manage-projects" class="gtm-nav-link">Accessing and editing project information</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/connect-to-db-and-generate-model" class="gtm-nav-link">Generating a model</a></li></ul></li><li>Git and version control<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/setting-up-git-connection" class="gtm-nav-link">Setting up and testing a Git connection</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/git-options" class="gtm-nav-link">Configuring project version control settings</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/webhook-deploy-secret" class="gtm-nav-link">Configuring the webhook deploy secret</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/advanced-deploy-mode" class="gtm-nav-link">Advanced deploy mode</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/version-control-and-deploying-changes" class="gtm-nav-link">Using version control and deploying</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/git-command-reference" class="gtm-nav-link">Git command reference</a></li></ul></li><li>Setting up a database connection<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/enabling-secure-db" class="gtm-nav-link">Enabling secure database access</a></li><li><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/database-config" class="gtm-nav-link">Database configuration instructions</a></li><li><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/connecting-to-db" class="gtm-nav-link">Connecting Looker to your database</a></li><li><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/connecting-to-db/testing-db-connectivity" class="gtm-nav-link">Testing database connectivity</a></li></ul></li><li>Looker Marketplace<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/marketplace" class="gtm-nav-link">Using the Looker Marketplace</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/marketplace/customize-blocks" class="gtm-nav-link">Customizing Looker Marketplace Blocks</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/marketplace/adding-block-marketplace" class="gtm-nav-link">Developing a custom block for the Looker Marketplace</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/marketplace/adding-viz-marketplace" class="gtm-nav-link">Developing a custom visualization for the Looker Marketplace</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/extension-framework/data-dictionary" class="gtm-nav-link">Using the Looker Data Dictionary</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/extension-framework/lookml-diagram-admins" class="gtm-nav-link">Configuring the LookML Diagram</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/extension-framework/lookml-diagram" class="gtm-nav-link">Using the LookML Diagram</a></li></ul></li><li>Video tutorials<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/video-library/data-modeling" class="gtm-nav-link">Video tutorials</a></li></ul></li></ul></li></ul><ul><li>Write LookML<ul class="child-nav"><li>Getting started with LookML<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml" class="gtm-nav-link">Steps to learning LookML</a></li><li><a href="/web/20210802015220/https://docs.looker.com/video-library/data-modeling" class="gtm-nav-link">Video tutorials</a></li></ul></li><li>Basic concepts<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/what-is-lookml" class="gtm-nav-link">What is LookML?</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/lookml-terms-and-concepts" class="gtm-nav-link">LookML terms and concepts</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/lookml-validation" class="gtm-nav-link">Editing and validating LookML</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/look-validation" class="gtm-nav-link">Content validation</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/sql-and-referring-to-lookml" class="gtm-nav-link">Incorporating SQL and referring to LookML objects</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/advanced-lookml-concepts" class="gtm-nav-link">Additional LookML basics</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/working-with-joins" class="gtm-nav-link">Working with joins in LookML</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/derived-tables" class="gtm-nav-link">Derived tables in Looker</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/creating-ndts" class="gtm-nav-link">Creating native derived tables</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/incremental-pdts" class="gtm-nav-link">Incremental PDTs</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/explore-menu-and-field-picker" class="gtm-nav-link">Changing the Explore menu and field picker</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/filter-suggestions" class="gtm-nav-link">Changing filter suggestions</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/looker-blocks" class="gtm-nav-link">Looker Blocks</a></li></ul></li><li>Advanced concepts<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/caching" class="gtm-nav-link">Caching queries and rebuilding PDTs with datagroups</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/aggregate_awareness" class="gtm-nav-link">Aggregate awareness</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/extends" class="gtm-nav-link">Reusing code with extends</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/refinements" class="gtm-nav-link">LookML refinements</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/importing-projects" class="gtm-nav-link">Importing files from other projects</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/templated-filters" class="gtm-nav-link">Templated filters and Liquid parameters</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/liquid-variables" class="gtm-nav-link">Liquid variable reference</a></li><li><a href="/web/20210802015220/https://docs.looker.com/admin-options/security/html-sanitization" class="gtm-nav-link">HTML sanitization</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/model-localization" class="gtm-nav-link">Localizing your model</a></li></ul></li><li>LookML reference<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/reference/lookml" class="gtm-nav-link">LookML parameter reference by function</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/lookml-quick-reference" class="gtm-nav-link">LookML quick reference</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/manifest-reference" class="gtm-nav-link">Project manifest parameters</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/model-reference" class="gtm-nav-link">Model parameters</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/explore-reference" class="gtm-nav-link">Explore parameters</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/join-reference" class="gtm-nav-link">Join parameters</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/view-reference" class="gtm-nav-link">View parameters</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/field-reference" class="gtm-nav-link">Field parameters</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/field-reference/dimension-type-reference" class="gtm-nav-link">Dimension, filter, and parameter types</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/field-reference/measure-type-reference" class="gtm-nav-link">Measure types</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/filter-expressions" class="gtm-nav-link">Looker filter expressions</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/liquid-variables" class="gtm-nav-link">Liquid variable reference</a></li></ul></li></ul></li></ul><ul><li>Use embedding, the API, and the extension framework<ul class="child-nav"><li>Looker API<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/reference/api-and-integration/api-getting-started" class="gtm-nav-link">Getting started with the Looker API</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/api-and-integration/api-auth" class="gtm-nav-link">Looker API authentication</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/api-and-integration/api-cors" class="gtm-nav-link">Looker API authentication using OAuth</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/api-and-integration/api-versioning" class="gtm-nav-link">Looker API versioning</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/api-and-integration/api-explorer" class="gtm-nav-link">Using the API Explorer</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/api-and-integration/api-reference/v3.0" class="gtm-nav-link">Looker 3.0 API (legacy) reference</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/api-and-integration/api-reference/v3.1" class="gtm-nav-link">Looker 3.1 API reference</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/api-and-integration/api-reference/v4.0" class="gtm-nav-link">Looker 4.0 API reference (experimental)</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/api-and-integration/api-sdk" class="gtm-nav-link">Looker API SDKs</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/api-and-integration/api-troubleshooting" class="gtm-nav-link">Looker API troubleshooting</a></li></ul></li><li>Embedding<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/reference/embedding/security" class="gtm-nav-link">Security best practices for embedded analytics</a></li><li><a href="/web/20210802015220/https://docs.looker.com/sharing-and-publishing/embedding" class="gtm-nav-link">Private embedding</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/embedding/sso-embed" class="gtm-nav-link">Single sign-on (SSO) embedding</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/embedding/viewing" class="gtm-nav-link">Viewing embedded Looks, Explores, and dashboards</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/embedding/embed-javascript-events" class="gtm-nav-link">Embedded Javascript events</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/embedding/timezones" class="gtm-nav-link">SSO embedding time zone reference</a></li><li><a href="/web/20210802015220/https://docs.looker.com/admin-options/settings/themes" class="gtm-nav-link">Custom themes for embedded dashboards</a></li><li><a href="/web/20210802015220/https://docs.looker.com/reference/embed-sdk" class="gtm-nav-link">Embed SDK</a></li></ul></li><li>Extension framework and UI components<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/extension-framework" class="gtm-nav-link">Getting started with the Looker extension framework</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/extension-framework/permissions" class="gtm-nav-link">Setting permissions for Looker extensions</a></li><li><a href="/web/20210802015220/https://docs.looker.com/data-modeling/extension-framework/filter-components" class="gtm-nav-link">Looker filter components</a></li></ul></li></ul></li></ul><ul><li>Set up and administer Looker<ul class="child-nav"><li>Getting started with setup and admin<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/admin-options" class="gtm-nav-link">Set up and administer Looker overview</a></li><li><a href="/web/20210802015220/https://docs.looker.com/admin-options/supported-browsers" class="gtm-nav-link">Supported browsers</a></li><li><a href="/web/20210802015220/https://docs.looker.com/admin-options/supported-looker-versions" class="gtm-nav-link">Supported Looker versions</a></li></ul></li><li>Installation and maintenance<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/looker-hosted-install" class="gtm-nav-link">Looker-hosted installation steps</a></li><li><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/on-prem-install" class="gtm-nav-link">Customer-hosted installation steps</a></li><li><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/on-prem-mgmt" class="gtm-nav-link">Managing a customer-hosted deployment</a></li><li><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/signin-options" class="gtm-nav-link">Getting started with users</a></li><li><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/on-prem-install/auto-provision-user" class="gtm-nav-link">Auto-provisioning a new Looker instance</a></li></ul></li><li>Setting up a database connection<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/enabling-secure-db" class="gtm-nav-link">Enabling secure database access</a></li><li><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/database-config" class="gtm-nav-link">Database configuration instructions</a></li><li><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/connecting-to-db" class="gtm-nav-link">Connecting Looker to your database</a></li><li><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/connecting-to-db/testing-db-connectivity" class="gtm-nav-link">Testing database connectivity</a></li><li><a href="/web/20210802015220/https://docs.looker.com/video-library/data-modeling#setting_up_a_connection" class="gtm-nav-link">Video tutorials</a></li></ul></li><li>Admin tutorials<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/admin-options/tutorials/permissions" class="gtm-nav-link">Access control and permission management</a></li><li><a href="/web/20210802015220/https://docs.looker.com/admin-options/tutorials/access-controls" class="gtm-nav-link">Designing and configuring a system of access levels</a></li><li><a href="/web/20210802015220/https://docs.looker.com/setup-and-management/tutorials/clustering" class="gtm-nav-link">Clustering Looker</a></li><li><a href="/web/20210802015220/https://docs.looker.com/admin-options/tutorials/connections" class="gtm-nav-link">Creating connections</a></li><li><a href="/web/20210802015220/https://docs.looker.com/admin-options/system-activity" class="gtm-nav-link">System Activity pages</a></li><li><a href="/web/20210802015220/https://docs.looker.com/admin-options/tutorials/system-activity" class="gtm-nav-link">Creating Looker usage reports with System Activity Explores</a></li><li><a href="/web/20210802015220/https://docs.looker.com/admin-options/tutorials/notify-users" class="gtm-nav-link">Making announcements to your users</a></li><li><a href="/web/20210802015220/https://docs.looker.com/admin-options/tutorials/managing-bizusers/bizuser-features" class="gtm-nav-link">Managing business user features</a></li><li><a href="/web/20210802015220/https://docs.looker.com/admin-options/tutorials/delete-user" class="gtm-nav-link">Deleting personal user information</a></li><li><a href="/web/20210802015220/https://docs.looker.com/admin-options/tutorials/timezones" class="gtm-nav-link">Using time zone settings</a></li><li><a href="/web/20210802015220/https://docs.looker.com/admin-options/tutorials/localizing-looker" class="gtm-nav-link">Supported user-interface languages</a></li><li><a href="/web/20210802015220/https://docs.looker.com/admin-options/tutorials/localizing-number-formatting" class="gtm-nav-link">Localizing number formatting</a></li></ul></li><li>Admin panel reference<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/admin-options/settings" class="gtm-nav-link">General pages</a></li><li><a href="/web/20210802015220/https://docs.looker.com/admin-options/system-activity/sa-dashboards" class="gtm-nav-link">System Activity dashboards</a></li><li><a href="/web/20210802015220/https://docs.looker.com/admin-options/settings/page-users" class="gtm-nav-link">Users pages</a></li><li><a href="/web/20210802015220/https://docs.looker.com/admin-options/database" class="gtm-nav-link">Database pages</a></li><li><a href="/web/20210802015220/https://docs.looker.com/admin-options/scheduler" class="gtm-nav-link">Alerts & Schedules pages</a></li><li><a href="/web/20210802015220/https://docs.looker.com/admin-options/platform" class="gtm-nav-link">Platform pages</a></li><li><a href="/web/20210802015220/https://docs.looker.com/admin-options/security" class="gtm-nav-link">Authentication pages</a></li><li><a href="/web/20210802015220/https://docs.looker.com/admin-options/server" class="gtm-nav-link">Server pages</a></li></ul></li></ul></li></ul><ul><li>Looker mobile application<ul class="child-nav"><li>Looker mobile application<ul class="child-nav"><li><a href="/web/20210802015220/https://docs.looker.com/mobile-app" class="gtm-nav-link">Looker mobile application</a></li><li><a href="/web/20210802015220/https://docs.looker.com/mobile-app/enabling-mobile" class="gtm-nav-link">Enabling the Looker mobile application for your instance</a></li><li><a href="/web/20210802015220/https://docs.looker.com/mobile-app/installation" class="gtm-nav-link">Installing the Looker mobile application on your mobile device</a></li><li><a href="/web/20210802015220/https://docs.looker.com/mobile-app/signing-in" class="gtm-nav-link">Signing in to the Looker mobile application</a></li><li><a href="/web/20210802015220/https://docs.looker.com/mobile-app/navigating-mobile-app" class="gtm-nav-link">Navigating to content in the Looker mobile application</a></li><li><a href="/web/20210802015220/https://docs.looker.com/mobile-app/viewing-looks" class="gtm-nav-link">Viewing Looks in the Looker mobile application</a></li><li><a href="/web/20210802015220/https://docs.looker.com/mobile-app/viewing-dashboards" class="gtm-nav-link">Viewing dashboards in the Looker mobile application</a></li></ul></li></ul></li></ul>  </section> <section id="mobile-reader-options"></section> <nav> <div id="on-this-page" class="section-label">On this page</div> </nav> <article id="docs-content" data-swiftype-index="true"> <aside data-swiftype-index="false">   <div id="related-links"> <div class="section-label">Related content</div> <div id="related-links-container">  <a id="help-center-link" href="#" target="_blank"> <div class="related-box"> <div class="related-location"> <i class="material-icons">help_center</i> Help Center </div> <div class="related-search"> Search for <span class="related-page-title">Understanding other project files</span> </div> </div> </a>  <a id="community-link" href="#" target="_blank"> <div class="related-box"> <div class="related-location"> <i class="material-icons">forum</i> Community </div> <div class="related-search"> Search for <span class="related-page-title">Understanding other project files</span> </div> </div> </a> </div> </div> </aside> <div id="page-title">Understanding other project files</div> <div id="breadcrumbs" data-swiftype-index="false"><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project"><i class="material-icons">keyboard_arrow_left</i>Back to LookML Project Files</a></div> <p></p> <p></p> <p></p> <p><p></p> <p>A Looker project consists of one or more <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/model-development#model_files">model files</a>, one or more <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/model-development#view_files">view files</a>, and possibly the following types of files as well:</p> <ul> <li><a href="#dashboard_files">Dashboard files</a></li> <li><a href="#document_files">Document files</a></li> <li><a href="#data_files">Data files</a></li> <li><a href="#project_manifest_files">Project manifest files</a></li> <li><a href="#manifest_lock_files">Manifest lock files</a></li> <li><a href="#locale_strings_files">Locale strings files</a></li> <li><a href="#explore_files">Explore files</a></li> <li><a href="#data_test_files">Data test files</a></li> <li><a href="#refinements_files">Refinements files</a></li> <li><a href="#other_files">Other files</a></li> </ul> <p>An in-depth explanation of model and view files is given on the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/model-development">Understanding model and view files</a> documentation page. The rest of the file types are described in the sections below.</p> <p>For information on accessing a project’s files, see the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/manage-projects#accessing_project_files">Accessing and editing project information</a> documentation page.</p> <p>Project files are organized by your Looker developers using <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/ide-folders">folders in the IDE</a>.</p>  <p><a id="dashboard-file" class="anchor"></a> <a name="lookml_dashboard_files" class="anchor"></a> <a name="dashboard_files" class="anchor"></a></p> <h1>Dashboard files</h1> <p>Looker supports two types of dashboards:</p> <ul> <li><strong>User-defined dashboards</strong>, which can be created by non-developer users without using LookML. For details, see the <a href="/web/20210802015220/https://docs.looker.com/dashboards/creating-dashboards-beta">Creating user-defined dashboards</a> documentation page.</li> <li><strong>LookML dashboards</strong>, which are stored as version-controlled files associated with the project.</li> </ul> <p>If your project contains LookML dashboards, they will be defined in dedicated dashboard files in the IDE.</p> <p><img style=";border:none" src="/web/20210802015220im_/https://docs.looker.com/assets/images/dash-lookml-ui-612.png"/></p> <p>For more information on LookML dashboards, see the <a href="/web/20210802015220/https://docs.looker.com/dashboards/creating-lookml-dashboards">Creating LookML dashboards</a> documentation page.</p>  <p><a name="document_files" class="anchor"></a></p> <h1>Document files</h1> <p>Looker document files let you write documentation or other notes about your Looker data model using <a href="https://web.archive.org/web/20210802015220/https://help.github.com/categories/writing-on-github/">GitHub-flavored markdown</a>. This can be helpful for your users to become acquainted with how your organization uses Looker.</p>  <p><a name="creating_documentation_files" class="anchor"></a> <a name="creating_document_files" class="anchor"></a></p> <h2>Creating document files</h2> <p>To add a document file to your project:</p> <ul> <li>Use the <strong>Create Document</strong> option to create the file using the Looker IDE (see the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project#creating_files">Creating files</a> section on the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project">LookML project files</a> documentation page for the procedure).</li> <li>Use the drag-and-drop feature to upload the file from your computer (see the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project#uploading_files">Uploading files</a> section on the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project">LookML project files</a> documentation page for the procedure).</li> </ul> <p>After you create a file you can edit it by clicking <strong>Edit</strong> in the upper right. Then you can preview your changes by clicking <strong>Preview</strong>, or save your changes by clicking <strong>Save</strong>.</p>  <p><a name="viewing_the_document_outside_the_ide" class="anchor"></a></p> <h2>Viewing the document outside the IDE</h2> <p>To see a document outside the IDE, which you will need to do to take advantage of the <a href="#doc_nav">navigation features</a> described below, choose the <strong>View Document</strong> option from the drop-down menu in the upper left:</p> <p><img style="width:553px" src="/web/20210802015220im_/https://docs.looker.com/assets/images/dev-doc-view-doc-712.png"/></p> <p>You can distribute the URL of the resulting page to other users so that they don’t need to navigate through Looker’s developer section to reach it.</p>  <p><a name="doc_nav" class="anchor"></a> <a name="adding_a_navigation_structure_to_your_documentation" class="anchor"></a> <a name="adding_a_navigation_structure_to_your_document" class="anchor"></a></p> <h2>Adding a navigation structure to your document</h2> <p>You can add a sidebar to your document files so that users can easily see the structure of the information and navigate between documents:</p> <p><img style="width:738px" src="/web/20210802015220im_/https://docs.looker.com/assets/images/dev-doc-navigation-68.png"/></p> <p>To add sidebar navigation for a document, create a navigation section starting on the first line of the document. Mark the start and end of your navigation section with three dashes (<code>---</code>).</p> <p>You can use the following parameters in the navigation section:</p> <ul> <li><a href="#navigation"><code>navigation</code></a></li> <li><a href="#title"><code>title</code></a></li> <li><a href="#section"><code>section</code></a></li> <li><a href="#label"><code>label</code></a></li> </ul> <p><a name="navigation" class="anchor"></a></p> <h3><code>navigation</code></h3> <p>At the minimum, you can use <code>navigation: true</code> on a document to add the navigation sidebar to that document. Here’s how it looks in a markdown file:</p> <p><img style="width:599px" src="/web/20210802015220im_/https://docs.looker.com/assets/images/dev-doc-navigation-file-68.png"/></p> <p>This adds to the document a navigation sidebar with links to all of the project’s documentation pages. If you include only <code>navigation: true</code> in a document, the sidebar of that document lists all the project’s documentation pages in alphabetical order by filename.</p> <p>Also, you might find that organizing by alphabetical filename is not ideal, or you may have some documents you don’t want to show in a page’s navigation:</p> <p><img style="width:739px" src="/web/20210802015220im_/https://docs.looker.com/assets/images/dev-doc-navigation-no-68.png"/></p> <p>If you want to change the order of files in a document’s navigation sidebar, or if you want to show only a subset of your documents in the sidebar, you can use this format:</p> <pre><code>--- navigation: - document_one - document_two - document_three --- </code></pre> <p>So now the page will show only the files you want, and in an order that makes more sense:</p> <p><img style="width:759px" src="/web/20210802015220im_/https://docs.looker.com/assets/images/dev-doc-navigation-yes-68.png"/></p> <p><a name="title" class="anchor"></a></p> <h3><code>title</code></h3> <p>By default, the sidebar displays the document’s heading (if the document begins with a heading), or the document’s filename if there is no heading in the file. You can add a <code>title</code> parameter at the top of a document to change how the document is displayed in navigation sidebars:</p> <pre><code>--- title: New Title for Users --- </code></pre> <p>This title will be used as the link text in the navigation sidebars of all documents, unless you specify a different <a href="#label"><code>label</code></a> in the navigation section of document.</p> <p><a name="label" class="anchor"></a></p> <h3><code>label</code></h3> <p>If you want to change the way a page is listed in a document’s navigation sidebar, you can use the <code>document</code> and <code>label</code> parameters like this:</p> <pre><code>--- navigation: - document_one - document: document_two label: Customized Label for Document Two - section: My Section Name - document_three --- </code></pre> <blockquote> <p>To use the <code>label</code> parameter, you must add the <code>document:</code> before the document filename as shown in this example above. If you are not using a <code>label</code> for a document, do <em>not</em> include <code>document:</code> before the filename.</p> </blockquote> <p>The <code>label</code> value defines how a document is shown in the document’s sidebar navigation, even if the document to which it refers has its own <a href="#title"><code>title</code></a> parameter.</p> <p>The above example looks like this in the document’s sidebar:</p> <p><img style="width:735px" src="/web/20210802015220im_/https://docs.looker.com/assets/images/dev-doc-navigation-all-68.png"/></p> <p><a name="section" class="anchor"></a></p> <h3><code>section</code></h3> <p>If you want to break the navigation sidebar into sections, you can use the <code>section</code> parameter like this:</p> <pre><code>--- navigation: - document_one - document_two - section: My Section Name - document_three --- </code></pre> <p>The <code>section</code> parameter adds a section break and a text heading to the sidebar:</p> <p><img style="width:737px" src="/web/20210802015220im_/https://docs.looker.com/assets/images/dev-doc-navigation-section-68.png"/></p> <p>The text heading is not a link itself; it does not refer to any of your documentation files.</p>  <p><a name="data_files" class="anchor"></a></p> <h1>Data files</h1> <p>Data files are <a href="https://web.archive.org/web/20210802015220/https://en.wikipedia.org/wiki/JSON">JSON</a> files with file extension <code>.json</code>, <code>.topojson</code>, or <code>.geojson</code>.</p> <p>The <a href="/web/20210802015220/https://docs.looker.com/reference/model-params/map_layer">map_layer</a> parameter enables you to use a JSON file as a custom map that can then be used to plot your data in Looker:</p> <p><img style=";border:none" src="/web/20210802015220im_/https://docs.looker.com/assets/images/data-lookml-ui-612-v2.png"/></p> <p>You then use the <a href="/web/20210802015220/https://docs.looker.com/reference/field-params/map_layer_name">map_layer_name</a> parameter with a dimension so that you can associate a data value (like “Paris”) with a geographic region on your custom map.</p> <p>You can edit a JSON file in the LookML IDE and then click <strong>Save</strong>. For debugging, you can choose <strong>View Raw</strong> to view the file in raw format. If you have the proper extension to view JSON in your browser, you will also have the option to view the file in a <strong>Parsed</strong> format:</p> <p><img style="width:757.5px;border:none" src="/web/20210802015220im_/https://docs.looker.com/assets/images/dev-data-files-712.png"/></p> <p><a name="adding_data_files" class="anchor"></a></p> <h2>Adding data files</h2> <p>To add a JSON file to your project, use the drag-and-drop feature to upload the file from your computer (see the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project#uploading_files">Uploading files</a> section on the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project">LookML project files</a> documentation page for the procedure).</p>  <p><a name="manifest_files" class="anchor"></a> <a name="project_manifest_files" class="anchor"></a></p> <h1>Project manifest files</h1> <p>Your project may contain a project manifest file, which is used for the following:</p> <ul> <li>Specifying other projects to <a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/importing-projects">import into the current project</a></li> <li>Specifying <a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/model-localization">model localization settings</a></li> <li>Defining <a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/sql-and-referring-to-lookml#lookml_constants">LookML constants</a></li> <li>Adding an <a href="/web/20210802015220/https://docs.looker.com/data-modeling/extension-framework/extension-framework-intro#adding_an_extension_to_looker">extension</a> to your project </li> <li>Adding a <a href="/web/20210802015220/https://docs.looker.com/reference/manifest-params/visualization">custom visualization</a> to your project</li> </ul> <blockquote> <p><a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/model-localization">Model localization</a> is not currently compatible with <a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/importing-projects">project import</a>.</p> </blockquote> <p>Each project can only have one manifest file, and it must be named <code>manifest.lkml</code> and located at the root level of your project’s directory structure and in your Git repo.</p> <p><a name="creating_a_manifest_file" class="anchor"></a></p> <h2>Creating a manifest file</h2> <p>To add a project manifest file to your project, use the <strong>Create Project Manifest</strong> option from the <strong>+</strong> menu at the top of the Looker IDE file browser (see the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project#creating_files">Creating files</a> section on the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project">LookML project files</a> documentation page for the procedure). This will create a <code>manifest.lkml</code> file at the root level of your project’s directory structure. Do not move the manifest file; it needs to be stored at the root level of your directory structure.</p> <blockquote> <p>The <strong>Create Project Manifest</strong> option is available only from the <strong>+</strong> icon at the top of the file browser in the Looker IDE. It is not an option from the folder menus, since the manifest file must be located at the root level of your project’s directory structure.</p> <p>Also, the <strong>Create Project Manifest</strong> option is available only if your project doesn’t have a manifest file already, since a project can only have one manifest file.</p> </blockquote>  <p><a name="manifest_lock_files" class="anchor"></a></p> <h1>Manifest lock files</h1> <p>Manifest lock files are created automatically when a <a href="/web/20210802015220/https://docs.looker.com/reference/manifest-params/remote_dependency">remote dependency</a> is added to the <a href="#manifest_files">project manifest file</a>. Looker uses the manifest lock file to track the version of the remote project(s) specified in the manifest file:</p> <p><img style="width:923px" src="/web/20210802015220im_/https://docs.looker.com/assets/images/dev-manifest-lock-712.png"/></p> <p>Looker developers do not need to create or edit a manifest lock file, since lock files are managed automatically by Looker.</p> <p>For more information, see the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/importing-projects#manifest_lock_file">Importing files from other projects</a> documentation page.</p>  <p><a name="locale_strings_files" class="anchor"></a></p> <h1>Locale strings files</h1> <p>If you are <a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/model-localization">localizing your data model</a> you will need to create locale strings files for each locale you want to localize to, including your default locale (for example, often English in the USA).</p> <p>Locale strings files list key-value pairs for each label and description that you are localizing in your model. The strings file for each locale should provide that locale’s translation for each label or description. More information about creating locale strings files appears on the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/model-localization#creating_locale_strings_files">Localizing your LookML model</a> documentation page.</p> <p><a name="creating_locale_strings_files" class="anchor"></a></p> <h2>Creating locale strings files</h2> <blockquote> <p>If you are creating locale strings files to localize your model and would also like to take advantage of Looker’s native UI localization, you must name your strings files using specific locale codes that can be found in the Locale section of our <a href="/web/20210802015220/https://docs.looker.com/admin-options/settings/users#locale_(beta)">Users</a> documentation page.</p> </blockquote> <p>To create a locale strings file in your project:</p> <ul> <li>Use the <strong>Create Locale Strings File</strong> option to create the file using the Looker IDE (see the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project#creating_files">Creating files</a> section on the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project">LookML project files</a> documentation page for the procedure).</li> <li>Use the drag-and-drop feature to upload the file from your computer (see the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project#uploading_files">Uploading files</a> section on the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project">LookML project files</a> documentation page for the procedure).</li> </ul> <p><a name="explore_files" class="anchor"></a></p> <h1>Explore files</h1> <p>Explores are usually defined within a model file. However, sometimes you need a separate Explore file <a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/creating-ndts#using_includes_to_enable_referencing_fields">for a derived table</a>, or to <a href="/web/20210802015220/https://docs.looker.com/reference/explore-params/extends#extending_an_explore_across_models">extend</a> or <a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/refinements">refine</a> an Explore across models.</p> <p>Explore files have the file extension <code>.explore.lkml</code>.</p> <p><a name="creating_an_explore_file" class="anchor"></a> <a name="creating_explore_files" class="anchor"></a></p> <h2>Creating Explore files</h2> <p>To create an Explore file in your project:</p> <ul> <li>Use the <strong>Create Generic LookML File</strong> option to create the file using the Looker IDE (see the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project#creating_files">Creating files</a> section on the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project">LookML project files</a> documentation page for the procedure).</li> <li>Use the drag-and-drop feature to upload the file from your computer (see the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project#uploading_files">Uploading files</a> section on the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project">LookML project files</a> documentation page for the procedure).</li> </ul> <p>When creating Explore files:</p> <ul> <li>Be sure to use the file extension <code>.explore.lkml</code></li> <li>Once you create the file in your project, be sure to use the <a href="/web/20210802015220/https://docs.looker.com/reference/model-params/include"><code>include</code></a> parameter to make your new file available for referencing in other files in your project. Explore files can be included <a href="/web/20210802015220/https://docs.looker.com/reference/model-params/include#including_explores_in_a_view">in views</a>, <a href="/web/20210802015220/https://docs.looker.com/reference/model-params/include#including_explores_in_a_model">in models</a>, and <a href="/web/20210802015220/https://docs.looker.com/reference/model-params/include#including_explores_in_an_explore">in other Explore files</a>.</li> <li>Once you create an Explore file, you can view the objects and navigate to the Explore file using the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/object-browser">object browser</a> in the Looker IDE.</li> </ul> <p><a name="data_test_files" class="anchor"></a></p> <h1>Data test files</h1> <p>Your project may have <a href="/web/20210802015220/https://docs.looker.com/reference/model-params/test">data test</a> files used for verifying the logic of your LookML model. Data tests can be contained in model files or in view files, but if your developers want to use the same data tests across several different models, it may be helpful to keep the data tests in their own, dedicated file.</p> <p><a name="creating_data_test_files" class="anchor"></a></p> <h2>Creating data test files</h2> <p>To create a data test file in your project:</p> <ul> <li>Use the <strong>Create Generic LookML File</strong> option to create the file using the Looker IDE (see the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project#creating_files">Creating files</a> section on the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project">LookML project files</a> documentation page for the procedure).</li> <li>Use the drag-and-drop feature to upload the file from your computer (see the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project#uploading_files">Uploading files</a> section on the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project">LookML project files</a> documentation page for the procedure).</li> </ul> <p>When creating data test files:</p> <ul> <li>Data test files have the file extension <code>.lkml</code>.</li> <li>Once you create the file in your project, be sure to use the <a href="/web/20210802015220/https://docs.looker.com/reference/model-params/include"><code>include</code></a> parameter to make your new file available for referencing in other files in your project. Explore files can be included <a href="/web/20210802015220/https://docs.looker.com/reference/model-params/include#including_explores_in_a_view">in views</a>, <a href="/web/20210802015220/https://docs.looker.com/reference/model-params/include#including_explores_in_a_model">in models</a>, and <a href="/web/20210802015220/https://docs.looker.com/reference/model-params/include#including_explores_in_an_explore">in other Explore files</a>.</li> </ul> <p><a name="refinements_files" class="anchor"></a></p> <h1>Refinements files</h1> <p>Your project may have files used for <a href="/web/20210802015220/https://docs.looker.com/data-modeling/learning-lookml/refinements">LookML refinements</a>. LookML refinements can be contained in model, view, or explore files, or in their own, dedicated file.</p> <p><a name="creating_refinements_files" class="anchor"></a></p> <h2>Creating refinements files</h2> <p>To create a refinements file in your project:</p> <ul> <li>Use the <strong>Create Generic LookML File</strong> option to create the file using the Looker IDE (see the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project#creating_files">Creating files</a> section on the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project">LookML project files</a> documentation page for the procedure).</li> <li>Use the drag-and-drop feature to upload the file from your computer (see the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project#uploading_files">Uploading files</a> section on the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project">LookML project files</a> documentation page for the procedure).</li> </ul> <p>When creating refinements files:</p> <ul> <li>Refinements files have the file extension <code>.lkml</code>.</li> <li>Once you create the refinements in your project, be sure to use the <a href="/web/20210802015220/https://docs.looker.com/reference/model-params/include"><code>include</code></a> parameter to make your new file available for referencing in other files in your project.</li> </ul> <p><a name="other_files" class="anchor"></a></p> <h1>Other files</h1> <p>Many LookML elements can be housed in different files in your project, or in their own dedicated files. For example, <a href="/web/20210802015220/https://docs.looker.com/reference/model-params/test">data tests</a> can be housed in model files, view files, or their own dedicated <code>.lkml</code> files.</p> <p><a name="creating_generic_lookml_files" class="anchor"></a></p> <h2>Creating generic LookML files</h2> <p>To create a generic LookML file in your project:</p> <ul> <li>Use the <strong>Create Generic LookML File</strong> option to create the file using the Looker IDE (see the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project#creating_files">Creating files</a> section on the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project">LookML project files</a> documentation page for the procedure).</li> <li>Use the drag-and-drop feature to upload the file from your computer (see the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project#uploading_files">Uploading files</a> section on the <a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/file-types-in-project">LookML project files</a> documentation page for the procedure).</li> </ul> <p>Once you create the file, be sure to use the <a href="/web/20210802015220/https://docs.looker.com/reference/model-params/include"><code>include</code></a> parameter to make your new file available for referencing in other files in your project.</p> <p></p> <div class="prev-next"> <p class="prev"><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/model-development"><i class="material-icons">keyboard_arrow_left</i>Understanding Model and View Files</a></p> <p class="next"><a href="/web/20210802015220/https://docs.looker.com/data-modeling/getting-started/ide-folders">Working with Folders in the IDE<i class="material-icons">keyboard_arrow_right</i></a></p> </div> </article> </main> <footer> <h2>Other resources</h2> <div id="resource-container"> <div id="discourse" class="resource"> <h3><i class="material-icons">help_center</i> Help Center</h3> <p>Our Help Center contains additional, short articles on specific use cases and special situations.</p> <a href="https://web.archive.org/web/20210802015220/https://help.looker.com/"><button>Go to Help Center</button></a> </div> <div id="discourse" class="resource"> <h3><i class="material-icons">forum</i> Community</h3> <p>Looker’s Community forums are a great place to discuss best practices, troubleshoot unique issues, and communicate with other Looker customers.</p> <a href="https://web.archive.org/web/20210802015220/https://community.looker.com/" class="gtm-discourse-link"><button>Go to Community</button></a> </div> <div id="support" class="resource"> <h3><i class="material-icons">school</i> Learn</h3> <p>Learn is Looker’s sandbox environment, primarily for developers. It includes lessons linked to real datasets in a real Looker instance, so you can understand the impact of developer changes.</p> <a href="https://web.archive.org/web/20210802015220/https://learn.looker.com/" class="gtm-learn-link"><button>Go to Learn</button></a> </div> </div> <div id="legal"> Examples are based on hypothetical data.<br/> © 2012-<script>document.write(new Date().getFullYear())</script> Looker Data Sciences, Inc.<br/> <a href="https://web.archive.org/web/20210802015220/https://looker.com/privacy">Privacy Policy</a> | <a href="https://web.archive.org/web/20210802015220/https://looker.com/terms">Terms & Conditions</a> </div> </footer>  <a href="#0" class="cd-top">Top</a> </body> </html> <script> var selectedLooker = '21.12'; var lookerVersions = ['21.12','21.10','21.8','21.6','21.4']; var oldLookml = "New LookML rolled out in October of 2016 as part of Looker 4.0, so we've moved old LookML documentation to oldlookmldocs.looker.com. Click [OK] to go there or [Cancel] to stay here."; var browserLangSupport = false; var redirects = { }; </script> <script src="/web/20210802015220js_/https://docs.looker.com/_themes/docs/js/article.js?v=1"></script>