CINXE.COM
Looker User Guide & Resources
<!DOCTYPE html> <!--[if IE 8]><html class="no-js lt-ie9"><![endif]--> <!--[if gt IE 8]><html class="no-js" prefix="og: http://ogp.me/ns#"><![endif]--> <html lang="en-US" prefix="og: http://ogp.me/ns#"> <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://looker.com/guide","20210812013851","https://web.archive.org/","web","/_static/", "1628732331"); </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" /> <!-- End Wayback Rewrite JS Include --> <!-- @@@@@@@@@@@@@ META TAGS @@@@@@@@@@@@@ --> <meta charset="utf-8"> <meta name="twitter:card" content="summary_large_image"/> <meta name="twitter:site" content="@LookerData"/> <meta name="twitter:title" content="User Guide"/> <meta name="twitter:description" content="Get the most out of Looker with our user guide. Find resources like support, documentation, training, frequently asked questions, community forums, and more."/> <meta name="twitter:image" content="https://web.archive.org/web/20210812013851im_/https://looker.com/"/> <meta property="og:site_name" content="Looker"> <meta property="og:type" content="article"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title> Looker User Guide & Resources </title> <meta class="swiftype" name="description" data-type="string" content="Get the most out of Looker with our user guide. Find resources like support, documentation, training, frequently asked questions, community forums, and more."> <meta property="og:image" content="https://web.archive.org/web/20210812013851im_/https://looker.com/"> <meta property="og:image" content="https://web.archive.org/web/20210812013851im_/https://looker.com/assets/img/images/homepage/looker_logo_meta_v0005.png"/> <meta property="og:description" content="Get the most out of Looker with our user guide. Find resources like support, documentation, training, frequently asked questions, community forums, and more."> <meta property="og:title" content="User Guide"> <!-- @@@@@@@@@@@@@ FAVICONS @@@@@@@@@@@@@ --> <link rel="apple-touch-icon" sizes="180x180" href="/web/20210812013851im_/https://looker.com/assets/img/images/favicons2/apple-touch-icon.png"> <link rel="icon" type="image/png" sizes="32x32" href="/web/20210812013851im_/https://looker.com/assets/img/images/favicons2/favicon-32x32.png"> <link rel="icon" type="image/png" sizes="16x16" href="/web/20210812013851im_/https://looker.com/assets/img/images/favicons2/favicon-16x16.png"> <link rel="manifest" href="/web/20210812013851/https://looker.com/assets/img/images/favicons2/site.webmanifest"> <link rel="mask-icon" href="/web/20210812013851im_/https://looker.com/assets/img/images/favicons2/safari-pinned-tab.svg" color="#1a73e8"> <meta name="msapplication-TileColor" content="#1a73e8"> <meta name="theme-color" content="#ffffff"> <!-- @@@@@@@@@@@@@ LINK TAGS @@@@@@@@@@@@@ --> <!-- feeds --> <link rel="alternate" type="application/rss+xml" href="https://web.archive.org/web/20210812013851/https://looker.com/feed" title="Looker RSS Feed"> <!--mp_linkcode_begins--> <script nonce="4AFT0RBUISNQJH7VZ" src="/web/20210812013851js_/https://looker.com/site/themes/surf_verve/js/mp/mp_linkcode.js"></script> <!--mp_linkcode_ends--> <!--– mp_snippet_begins --> <script nonce="4AFT0RBUISNQJH7VZ"> MP.UrlLang='mp_js_current_lang'; MP.SrcUrl=decodeURIComponent('mp_js_orgin_url'); MP.oSite=decodeURIComponent('mp_js_origin_baseUrl'); MP.tSite=decodeURIComponent('mp_js_translated_baseUrl'); MP.init(); </script> <!--– mp_snippet_ends --> <!-- intellimize --> <script nonce="4AFT0RBUISNQJH7VZ" src="//web.archive.org/web/20210812013851js_/https://api.intellimize.co/client/117259274.js"></script> <!-- styles --> <style> /*! normalize.css v3.0.2 | MIT License | git.io/normalize */img,legend{border:0}legend,td,th{padding:0}html{font-family:sans-serif;-ms-text-size-adjust:100%;-webkit-text-size-adjust:100%}body{margin:0}article,aside,details,figcaption,figure,footer,header,hgroup,main,menu,nav,section,summary{display:block}audio,canvas,progress,video{display:inline-block;vertical-align:baseline}audio:not([controls]){display:none;height:0}[hidden],template{display:none}a{background-color:transparent}a:active,a:hover{outline:0}abbr[title]{border-bottom:1px dotted}b,optgroup,strong{font-weight:700}dfn{font-style:italic}h1{font-size:2em;margin:.67em 0}mark{background:#ff0;color:#000}small{font-size:80%}sub,sup{font-size:75%;line-height:0;position:relative;vertical-align:baseline}sup{top:-.5em}sub{bottom:-.25em}svg:not(:root){overflow:hidden}figure{margin:1em 40px}hr{-moz-box-sizing:content-box;box-sizing:content-box;height:0}pre,textarea{overflow:auto}code,kbd,pre,samp{font-family:monospace,monospace;font-size:1em}button,input,optgroup,select,textarea{color:inherit;font:inherit;margin:0}button{overflow:visible}button,select{text-transform:none}button,html input[type=button],input[type=reset],input[type=submit]{-webkit-appearance:button;cursor:pointer}button[disabled],html input[disabled]{cursor:default}button::-moz-focus-inner,input::-moz-focus-inner{border:0;padding:0}input{line-height:normal}input[type=checkbox],input[type=radio]{box-sizing:border-box;padding:0}input[type=number]::-webkit-inner-spin-button,input[type=number]::-webkit-outer-spin-button{height:auto}input[type=search]{-webkit-appearance:textfield;-moz-box-sizing:content-box;-webkit-box-sizing:content-box;box-sizing:content-box}input[type=search]::-webkit-search-cancel-button,input[type=search]::-webkit-search-decoration{-webkit-appearance:none}fieldset{border:1px solid silver;margin:0 2px;padding:.35em .625em .75em}table{border-collapse:collapse;border-spacing:0} </style> <link rel="stylesheet" href="https://web.archive.org/web/20210812013851cs_/https://fonts.googleapis.com/css?family=Google+Sans:400,500|Roboto:400,400italic,500,500italic,700,700italic|Roboto+Mono:400,500,700|Material+Icons"> <link rel="stylesheet" href="/web/20210812013851cs_/https://looker.com/site/themes/surf_verve/css/surf_verve.css?v=1627526617"> <!-- blog social buttons --> <script nonce="4AFT0RBUISNQJH7VZ" type="text/javascript" src="//web.archive.org/web/20210812013851js_/https://platform-api.sharethis.com/js/sharethis.js#property=5966e9a457e5f5001295cffb&product=inline-share-buttons" async="async"></script> </head> <body class="site guide"> <div class="page-wrap"> <p><div class="user-guide-nav" data-swiftype-index="false"> <div class="container center-align"> <a href="/web/20210812013851/https://looker.com/" class="nav-logo"> <img src="/web/20210812013851im_/https://looker.com/assets/img/images/logos/looker.svg" alt="Looker"> </a> <div id="nav-icon3" class=""> <span></span> <span></span> <span></span> <span></span> </div> <nav> <ul> <li> <a class="custres-gtm-nav-link" href="/web/20210812013851/https://looker.com/guide"> User Guide </a> </li> <li> <a class="custres-gtm-nav-link" href="/web/20210812013851/https://looker.com/guide/getting-started"> Getting Started </a> </li> <li> <a href="https://web.archive.org/web/20210812013851/https://help.looker.com/" class="custres-gtm-nav-link"> Help Center </a> </li> <li> <a href="https://web.archive.org/web/20210812013851/https://docs.looker.com/" class="custres-gtm-nav-link"> Documentation </a> </li> <li> <a href="https://web.archive.org/web/20210812013851/https://community.looker.com/" class="custres-gtm-nav-link"> Community </a> </li> <li> <a href="https://web.archive.org/web/20210812013851/https://training.looker.com/" class="custres-gtm-nav-link"> Training </a> </li> <li> <a class="custres-gtm-nav-link" href="/web/20210812013851/https://looker.com/certification"> Certification </a> </li> </ul> </nav> <div class="mobile-nav left-align"> <p> <a href="/web/20210812013851/https://looker.com/guide" class="custres-gtm-nav-link"> User Guide </a> </p> <p> <a href="/web/20210812013851/https://looker.com/guide/getting-started" class="custres-gtm-nav-link"> Getting Started </a> </p> <p> <a href="https://web.archive.org/web/20210812013851/https://help.looker.com/" class="custres-gtm-nav-link"> Help Center </a> </p> <p> <a href="https://web.archive.org/web/20210812013851/https://docs.looker.com/" class="custres-gtm-nav-link"> Documentation </a> </p> <p> <a href="https://web.archive.org/web/20210812013851/https://community.looker.com/" class="custres-gtm-nav-link"> Community </a> </p> <p> <a href="https://web.archive.org/web/20210812013851/https://training.looker.com/" class="custres-gtm-nav-link"> Training </a> </p> <p> <a href="/web/20210812013851/https://looker.com/certification" class="custres-gtm-nav-link"> Certification </a> </p> </div> </div> </div></p> <header class="site-header user-guide border-bottom"> <div class="container center-align"> <h1 class="headline2"> User guide </h1> <p class="sub-title"> Your resource for getting the most out of Looker. </p> </div> </header> <section class="grey-50-bg padding-top--60 padding-bottom--90"> <div class="module-ug-main-page"> <div class="card-container center-align"> <a href="/web/20210812013851/https://looker.com/guide/getting-started" class="card shadow-hover border-full border-radius--8 custres-gtm-guide-link"> <h3> Getting started </h3> <p class="margin-top--10"> New to Looker?<br>Start here. </p> </a> <a href="https://web.archive.org/web/20210812013851/https://help.looker.com/" class="card shadow-hover border-full border-radius--8 middle custres-gtm-guide-link"> <h3> Help center </h3> <p> Your most commonly asked questions, answered. </p> </a> <a href="https://web.archive.org/web/20210812013851/https://docs.looker.com/" class="card shadow-hover border-full border-radius--8 custres-gtm-guide-link"> <h3> Documentation </h3> <p> Our authoritative reference for using Looker. </p> </a> <a href="https://web.archive.org/web/20210812013851/https://community.looker.com/" class="card shadow-hover border-full border-radius--8 bottom custres-gtm-guide-link"> <h3> Community </h3> <p> Connect with and learn from data peers. </p> </a> <a href="https://web.archive.org/web/20210812013851/https://training.looker.com/" class="card shadow-hover border-full border-radius--8 bottom custres-gtm-guide-link"> <h3> Training </h3> <p> Live and self-paced training. </p> </a> <a href="/web/20210812013851/https://looker.com/certification" class="card shadow-hover border-full border-radius--8 bottom custres-gtm-guide-link"> <h3> Certification </h3> <p> Validate your skills with Looker credentials. </p> </a> </div> </div> </section> <p><!-- @@@@@@@@@@@@@ SCRIPT TAGS @@@@@@@@@@@@@ --> <!-- scripts --> <script nonce="4AFT0RBUISNQJH7VZ" src="/web/20210812013851js_/https://looker.com/site/themes/surf_verve/js/all-scripts_v0003.js"></script> <script nonce="4AFT0RBUISNQJH7VZ"> $(".stick").stick_in_parent({ offset_top: 60, }); $(document).ready(function() { aaa(); }); $(window).on("hashchange", function() { aaa(); }); function aaa() { if (location.hash === "#viewing-data") { $('.section').hide(); $('#viewing-data').show(); $('.tab').removeClass('active'); $('.one').addClass('active'); } else if (location.hash === "#building-tools"){ $('.section').hide(); $('#building-tools').show(); $('.tab').removeClass('active'); $('.two').addClass('active'); } else if (location.hash === "#developing-models"){ $('.section').hide(); $('#developing-models').show(); $('.tab').removeClass('active'); $('.three').addClass('active'); } }; $('.tab').click(function(){ id = $(this).attr('data-name'); window.location.hash=id; aaa(); scroll(); }); function scroll() { $('html, body').animate({ scrollTop: $(".sticky-wrap").offset().top - 60 }, 100); }; </script> </p> </div> <div class="ug-bottom center-align padding-top--60 padding-bottom--60"> <div class="container"> <h3 class="headline3 white-t margin-bottom--15"> Still have questions? </h3> <a class="btn primary margin--15" href="https://web.archive.org/web/20210812013851/https://help.looker.com/"> Help center </a> </div> </div> <footer class="new-site-footer" data-swiftype-index="false"> <div class="footer-meta center-align white"> <div class="container"> <div class="left"> <p class="">© <script nonce="4AFT0RBUISNQJH7VZ">document.write(new Date().getFullYear())</script> Looker Data Sciences, Inc.</p> </div> <div class="right"> <p> <a href="/web/20210812013851/https://looker.com/privacy">Privacy</a> | <a href="/web/20210812013851/https://looker.com/terms">Terms</a> | <a href="/web/20210812013851/https://looker.com/trust-center/privacy/cookies">Cookies</a> </p> </div> </div> </div> </footer> <script nonce="4AFT0RBUISNQJH7VZ"> $(document).ready(function(){ $('#nav-icon3').click(function(e){ $(this).toggleClass('open'); $('.user-guide-nav').toggleClass('borderless'); $('.mobile-nav').slideToggle(300); e.preventDefault(); }); $(window).bind('resize orientationchange', function() { ww = window.innerWidth; adjustMenu(); }); var adjustMenu = function() { if (ww > 1199) { $('#nav-icon3').removeClass('open'); $('.mobile-nav').hide(); } }; }); </script> <script nonce="4AFT0RBUISNQJH7VZ"> $(document).ready(function() { // show/hide function $('.toggle-button').click(function(e){ id = $(this).attr('data-name'); if ($(this).find('span').hasClass('fa-chevron-down')){ $(this).find('span').removeClass('fa-chevron-down'); $(this).find('span').addClass('fa-chevron-up'); }else{ $(this).find('span').removeClass('fa-chevron-up'); $(this).find('span').addClass('fa-chevron-down'); } $("#"+id).slideToggle('200'); e.preventDefault(); }); // show/hide function $('.toggle-button2').click(function(e){ id = $(this).attr('data-name'); if ($(this).find('span').hasClass('fa-chevron-down')){ $(this).find('span').removeClass('fa-chevron-down'); $(this).find('span').addClass('fa-chevron-up'); }else{ $(this).find('span').removeClass('fa-chevron-up'); $(this).find('span').addClass('fa-chevron-down'); } $("#"+id).slideToggle('200'); e.preventDefault(); }); // button toggle function $('.button-toggle').click(function() { $('.button-toggle-div').slideToggle(); $('.button-toggle-text').toggle(); $('.button-toggle-text2').toggle(); }); // text toggle function $('.text-toggle').click(function() { $('.text-toggle-div').toggleClass('visible'); $('.text-toggle-text').toggle(); $('.text-toggle-text2').toggle(); }); $('.text-toggle-2').click(function() { $('.text-toggle-div-2').toggleClass('visible'); $('.text-toggle-text-2').toggle(); $('.text-toggle-text2-2').toggle(); }); $('.text-toggle-3').click(function() { $('.text-toggle-div-3').toggleClass('visible'); $('.text-toggle-text-3').toggle(); $('.text-toggle-text2-3').toggle(); }); //add superscript to all registered copyright $('body :not(script)').contents().filter(function() { return this.nodeType === 3; }).replaceWith(function() { return this.nodeValue.replace(/[™®©]/g, '<sup>$&</sup>'); }); }); </script> <!-- Google Tag Manager --> <script nonce="4AFT0RBUISNQJH7VZ">(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= '//web.archive.org/web/20210812013851/https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-NWWX6K');</script> <!-- End Google Tag Manager --> <!-- Google Tag Manager noscript--> <noscript><iframe src="//web.archive.org/web/20210812013851if_/https://www.googletagmanager.com/ns.html?id=GTM-NWWX6K" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript> <!-- End Google Tag Manager noscript--> </body> </html> <!-- FILE ARCHIVED ON 01:38:51 Aug 12, 2021 AND RETRIEVED FROM THE INTERNET ARCHIVE ON 00:35:23 Dec 03, 2024. JAVASCRIPT APPENDED BY WAYBACK MACHINE, COPYRIGHT INTERNET ARCHIVE. ALL OTHER CONTENT MAY ALSO BE PROTECTED BY COPYRIGHT (17 U.S.C. SECTION 108(a)(3)). --> <!-- playback timings (ms): captures_list: 0.453 exclusion.robots: 0.022 exclusion.robots.policy: 0.013 esindex: 0.009 cdx.remote: 33.081 LoadShardBlock: 315.328 (3) PetaboxLoader3.datanode: 185.246 (4) PetaboxLoader3.resolve: 328.291 (3) load_resource: 206.59 -->