Data Modeling Made Easy with SQL and LookML

<!DOCTYPE html>   <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/platform/data-modeling","20210812014731","https://web.archive.org/","web","/_static/", "1628732851"); </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" />   <meta charset="utf-8"> <meta name="twitter:card" content="summary_large_image"/> <meta name="twitter:site" content="@LookerData"/> <meta name="twitter:title" content="Data Modeling - LookML"/> <meta name="twitter:description" content="A reusable data modeling language that harnesses the power of SQL so you don't have to write the same code ever again. Define metrics once and move on."/> <meta name="twitter:image" content="https://web.archive.org/web/20210812014731im_/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> Data Modeling Made Easy with SQL and LookML </title> <meta class="swiftype" name="description" data-type="string" content="A reusable data modeling language that harnesses the power of SQL so you don't have to write the same code ever again. Define metrics once and move on."> <meta property="og:image" content="https://web.archive.org/web/20210812014731im_/https://looker.com/"> <meta property="og:image" content="https://web.archive.org/web/20210812014731im_/https://looker.com/assets/img/images/homepage/looker_logo_meta_v0005.png"/> <meta property="og:description" content="A reusable data modeling language that harnesses the power of SQL so you don't have to write the same code ever again. Define metrics once and move on."> <meta property="og:title" content="Data Modeling - LookML">  <link rel="apple-touch-icon" sizes="180x180" href="/web/20210812014731im_/https://looker.com/assets/img/images/favicons2/apple-touch-icon.png"> <link rel="icon" type="image/png" sizes="32x32" href="/web/20210812014731im_/https://looker.com/assets/img/images/favicons2/favicon-32x32.png"> <link rel="icon" type="image/png" sizes="16x16" href="/web/20210812014731im_/https://looker.com/assets/img/images/favicons2/favicon-16x16.png"> <link rel="manifest" href="/web/20210812014731/https://looker.com/assets/img/images/favicons2/site.webmanifest"> <link rel="mask-icon" href="/web/20210812014731im_/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 rel="alternate" type="application/rss+xml" href="https://web.archive.org/web/20210812014731/https://looker.com/feed" title="Looker RSS Feed">  <script nonce="430SJTAQ6UWIHC75X" src="/web/20210812014731js_/https://looker.com/site/themes/surf_verve/js/mp/mp_linkcode.js"></script>   <script nonce="430SJTAQ6UWIHC75X"> 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>   <script nonce="430SJTAQ6UWIHC75X" src="//web.archive.org/web/20210812014731js_/https://api.intellimize.co/client/117259274.js"></script>  <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/20210812014731cs_/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/20210812014731cs_/https://looker.com/site/themes/surf_verve/css/surf_verve.css?v=1627526617">  <script nonce="430SJTAQ6UWIHC75X" type="text/javascript" src="//web.archive.org/web/20210812014731js_/https://platform-api.sharethis.com/js/sharethis.js#property=5966e9a457e5f5001295cffb&product=inline-share-buttons" async="async"></script> </head> <body class="site"> <div class="page-wrap"> <p><div id="pattern" class="pattern new-nav" data-swiftype-index="false"> <div class="container"> <div class="logo-nav"> <a href="/web/20210812014731/https://looker.com/" class="nav-logo"> <img src="/web/20210812014731im_/https://looker.com/assets/img/images/logos/looker.svg" alt="Looker"> </a> </div> <div id="o-wrapper" class="o-wrapper"> <span id="c-button--push-right" class="c-button hamburger"> <i class="material-icons m-menu-menu" aria-hidden="true">menu</i> </span> </div> <div class="nav"> <nav id="menu" class=""> <ul class="main-nav no-style"> <li id="mm-link1" class="mm-link"> <a> product </a> <div class="m-menu" id="mega-menu1"> <div class="mm-inner"> <a href="/web/20210812014731/https://looker.com/product/business-intelligence"> <p class="alt secondary-nav-gtm">Business Intelligence</p> </a> <a href="/web/20210812014731/https://looker.com/product/embedded-analytics"> <p class="alt secondary-nav-gtm">Embedded Analytics</p> </a> <a href="/web/20210812014731/https://looker.com/product/applications"> <p class="alt secondary-nav-gtm">Applications</p> </a> <a href="/web/20210812014731/https://looker.com/product/looker-difference"> <p class="alt secondary-nav-gtm">The Looker Difference</p> </a> <a href="/web/20210812014731/https://looker.com/product/new-features"> <p class="alt secondary-nav-gtm">New Features</p> </a> <a href="/web/20210812014731/https://looker.com/product/visualizations"> <p class="alt secondary-nav-gtm">Visualizations</p> </a> <a href="/web/20210812014731/https://looker.com/professional-services"> <p class="alt secondary-nav-gtm">Professional Services</p> </a> <a href="/web/20210812014731/https://looker.com/product/security"> <p class="alt secondary-nav-gtm">Security</p> </a> <a href="/web/20210812014731/https://looker.com/product/pricing"> <p class="alt secondary-nav-gtm">Pricing</p> </a> </div> </div> </li> <li id="mm-link2" class="mm-link"> <a> platform </a> <div class="m-menu" id="mega-menu2"> <div class="mm-inner"> <a href="/web/20210812014731/https://looker.com/platform/overview"> <p class="alt secondary-nav-gtm">Data Platform</p> </a> <a href="/web/20210812014731/https://looker.com/platform/data-modeling"> <p class="alt secondary-nav-gtm">Data Modeling</p> </a> <a href="/web/20210812014731/https://looker.com/platform/actions"> <p class="alt secondary-nav-gtm">Data Actions</p> </a> <a href="/web/20210812014731/https://looker.com/platform/directory/home"> <p class="alt secondary-nav-gtm">Looker Blocks</p> </a> <a href="/web/20210812014731/https://looker.com/platform/data-connections"> <p class="alt secondary-nav-gtm">Data Connections</p> </a> <a href="/web/20210812014731/https://looker.com/partner-network"> <p class="alt secondary-nav-gtm">Partner Ecosystem</p> </a> <a href="/web/20210812014731/https://looker.com/platform/enterprise"> <p class="alt secondary-nav-gtm">Looker for Enterprise</p> </a> </div> </div> </li> <li id="mm-link3" class="mm-link"> <a> solutions </a> <div class="m-menu" id="mega-menu3"> <div class="mm-inner"> <p class="title no-margin"> industries </p> <a href="/web/20210812014731/https://looker.com/solutions/ecommerce"> <p class="alt secondary-nav-gtm">eCommerce</p> </a> <a href="/web/20210812014731/https://looker.com/solutions/media"> <p class="alt secondary-nav-gtm">Media</p> </a> <a href="/web/20210812014731/https://looker.com/solutions/ad-tech"> <p class="alt secondary-nav-gtm">Ad Tech</p> </a> <a href="/web/20210812014731/https://looker.com/solutions/saas"> <p class="alt secondary-nav-gtm">SaaS</p> </a> <a href="/web/20210812014731/https://looker.com/solutions/healthcare"> <p class="alt secondary-nav-gtm">Healthcare</p> </a> <a href="/web/20210812014731/https://looker.com/solutions/gaming"> <p class="alt secondary-nav-gtm">Gaming</p> </a> <a href="/web/20210812014731/https://looker.com/solutions/fintech"> <p class="alt secondary-nav-gtm">FinTech</p> </a> <a href="/web/20210812014731/https://looker.com/solutions/retail"> <p class="alt secondary-nav-gtm">Retail</p> </a> </div> <div class="mm-inner"> <p class="title no-margin"> departments </p> <a href="/web/20210812014731/https://looker.com/solutions/marketing-analytics"> <p class="alt secondary-nav-gtm">Marketing</p> </a> <a href="/web/20210812014731/https://looker.com/solutions/sales-analytics"> <p class="alt secondary-nav-gtm">Sales</p> </a> <a href="/web/20210812014731/https://looker.com/solutions/account-management"> <p class="alt secondary-nav-gtm">Account Management</p> </a> <a href="/web/20210812014731/https://looker.com/solutions/support-analytics"> <p class="alt secondary-nav-gtm">Customer Support</p> </a> <a href="/web/20210812014731/https://looker.com/solutions/data-science"> <p class="alt secondary-nav-gtm">Data Science</p> </a> <a href="/web/20210812014731/https://looker.com/solutions/product-analytics"> <p class="alt secondary-nav-gtm">Product</p> </a> <a href="/web/20210812014731/https://looker.com/solutions/operation-logistics"> <p class="alt secondary-nav-gtm">Operations and Logistics</p> </a> <a href="/web/20210812014731/https://looker.com/solutions/web-analytics"> <p class="alt secondary-nav-gtm">Web Analytics</p> </a> </div> <div class="mm-inner"> <p class="title no-margin"> databases </p> <a href="/web/20210812014731/https://looker.com/solutions/amazon-redshift"> <p class="alt secondary-nav-gtm">Amazon Redshift</p> </a> <a href="/web/20210812014731/https://looker.com/solutions/google-bigquery"> <p class="alt secondary-nav-gtm">Google BigQuery</p> </a> <a href="/web/20210812014731/https://looker.com/solutions/snowflake"> <p class="alt secondary-nav-gtm">Snowflake</p> </a> <a href="/web/20210812014731/https://looker.com/solutions/ibm-db2-warehouse-on-cloud"> <p class="alt secondary-nav-gtm">IBM Db2 Warehouse on Cloud</p> </a> <a href="/web/20210812014731/https://looker.com/solutions/databases"> <p class="alt secondary-nav-gtm">All Databases</p> </a> </div> </div> </li> <li id="mm-link5" class="mm-link"> <a> learn </a> <div class="m-menu" id="mega-menu5"> <div class="mm-inner"> <a href="/web/20210812014731/https://looker.com/guide"> <p class="alt secondary-nav-gtm">User Guide</p> </a> <a href="/web/20210812014731/https://looker.com/guide/getting-started"> <p class="alt secondary-nav-gtm">Getting Started</p> </a> <a href="https://web.archive.org/web/20210812014731/https://help.looker.com/"> <p class="alt secondary-nav-gtm">Help Center</p> </a> <a href="https://web.archive.org/web/20210812014731/https://docs.looker.com/"> <p class="alt secondary-nav-gtm">Documentation</p> </a> <a href="https://web.archive.org/web/20210812014731/https://community.looker.com/"> <p class="alt secondary-nav-gtm">Community</p> </a> <a href="https://web.archive.org/web/20210812014731/https://training.looker.com/"> <p class="alt secondary-nav-gtm">Training</p> </a> <a href="/web/20210812014731/https://looker.com/certification"> <p class="alt secondary-nav-gtm">Certification</p> </a> <a href="https://web.archive.org/web/20210812014731/https://info.looker.com/whitepapers"> <p class="alt secondary-nav-gtm">Whitepapers</p> </a> <a href="https://web.archive.org/web/20210812014731/https://info.looker.com/analyst-reports"> <p class="alt secondary-nav-gtm">Analyst Reports</p> </a> </div> </div> </li> </ul> </nav> </div> <div class="nav2">  <a mporgnav id="mp" class="user-locale" title="Global Switch" style="padding: 0; cursor:pointer !important"> <img class="globe" src="/web/20210812014731im_/https://looker.com/assets/img/images/icons/globe_grey.png"> </a>  <a href="/web/20210812014731/https://looker.com/demo" class="btn primary"> Request a demo </a> </div> </div> </div>  <div id="c-menu--push-right" class="c-menu c-menu--push-right gsans padding-bottom--20" data-swiftype-index="false"> <div id="m-menu-top-container"> <a href="/web/20210812014731/https://looker.com/"> <img id="m-menu-logo" src="/web/20210812014731im_/https://looker.com/assets/img/images/logos/looker.svg"> </a> <button class="c-menu__close">×</button> </div> <ul class="no-style c-menu__items"> <li class="c-menu__item"> <a class="toggle-button c-menu__link" data-name="mobile-dd1">product <span class="mobile-icon fa fa-chevron-down"></span></a> <ul class="c-menu__items mobile-dd no-margin" id="mobile-dd1"> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/product/business-intelligence">Business Intelligence</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/product/embedded-analytics">Embedded Analytics</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/product/applications">Applications</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/product/looker-difference">The Looker Difference</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/product/new-features">New Features</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/product/visualizations">Visualizations</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/professional-services">Professional Services</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/product/security">Security</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/product/pricing">Pricing</a> </li> </ul> </li> <li class="c-menu__item"> <a class="toggle-button c-menu__link" data-name="mobile-dd2">platform <span class="mobile-icon fa fa-chevron-down"></span></a> <ul class="c-menu__items mobile-dd no-margin" id="mobile-dd2"> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/platform/overview">Data Platform</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/platform/data-modeling">Data Modeling</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/platform/actions">Data Actions</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/platform/directory/home">Looker Blocks</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/platform/data-connections">Data Connections</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/partner-network">Partner Ecosystem</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/platform/enterprise">Looker for Enterprise</a> </li> </ul> </li> <li class="c-menu__item"> <a class="toggle-button c-menu__link" data-name="mobile-dd4">solutions <span class="mobile-icon fa fa-chevron-down"></span></a> <ul class="c-menu__items mobile-dd no-margin" id="mobile-dd4"> <li class="c-menu__item"> <a class="toggle-button c-menu__link" data-name="mobile-dd4-1">industries <span class="mobile-icon fa fa-chevron-down"></span></a> <ul class="c-menu__items mobile-ddd no-margin" id="mobile-dd4-1"> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/solutions/ecommerce">eCommerce</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/solutions/media">Media</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/solutions/ad-tech">Ad Tech</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/solutions/saas">SaaS</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/solutions/healthcare">Healthcare</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/solutions/gaming">Gaming</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/solutions/fintech">FinTech</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/solutions/retail">Retail</a> </li> </ul> </li> <li class="c-menu__item"> <a class="toggle-button c-menu__link" data-name="mobile-dd4-2">departments <span class="mobile-icon fa fa-chevron-down"></span></a> <ul class="c-menu__items mobile-ddd no-margin" id="mobile-dd4-2"> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/solutions/marketing-analytics">Marketing</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/solutions/sales-analytics">Sales</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/solutions/account-management">Account Management</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/solutions/support-analytics">Customer Support</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/solutions/data-science">Data Science</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/solutions/product-analytics">Product</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/solutions/operation-logistics">Operations and Logistics</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/solutions/web-analytics">Web Analytics</a> </li> </ul> </li> <li class="c-menu__item"> <a class="toggle-button c-menu__link" data-name="mobile-dd4-3">databases <span class="mobile-icon fa fa-chevron-down"></span></a> <ul class="c-menu__items mobile-ddd no-margin" id="mobile-dd4-3"> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/solutions/amazon-redshift">Amazon Redshift</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/solutions/google-bigquery">Google BigQuery</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/solutions/snowflake">Snowflake</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/solutions/ibm-db2-warehouse-on-cloud">IBM Db2 Warehouse on Cloud</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/solutions/databases">All Databases</a> </li> </ul> </li> </ul> </li> <li class="c-menu__item"> <a class="toggle-button c-menu__link" data-name="mobile-dd6">learn <span class="mobile-icon fa fa-chevron-down"></span></a> <ul class="c-menu__items mobile-dd no-margin" id="mobile-dd6"> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/guide">User Guide</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/guide/getting-started">Getting Started</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="https://web.archive.org/web/20210812014731/https://help.looker.com/">Help Center</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="https://web.archive.org/web/20210812014731/https://docs.looker.com/">Documentation</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="https://web.archive.org/web/20210812014731/https://community.looker.com/">Community</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="https://web.archive.org/web/20210812014731/https://training.looker.com/">Training</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210812014731/https://looker.com/certification">Certification</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="https://web.archive.org/web/20210812014731/https://info.looker.com/whitepapers">Whitepapers</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="https://web.archive.org/web/20210812014731/https://info.looker.com/analyst-reports">Analyst Reports</a> </li> </ul> </li> <div class="mobile-mp">  <a mporgnav id="mp-m" class="user-locale toggle-button c-menu__link" title="Global Switch" style="padding: 15px"> <img src="/web/20210812014731im_/https://looker.com/assets/img/images/icons/globe_grey.png" style="width:20px"> </a>  </div> <div class="center-align"> <a href="/web/20210812014731/https://looker.com/demo" class="btn primary margin-top--20"> Request a demo </a> </div> </ul> </div> <div id="c-mask" class="c-mask"></div>  <script nonce="430SJTAQ6UWIHC75X" type="text/javascript" id="mpelid" src="//web.archive.org/web/20210812014731js_/https://lookercom.mpeasylink.com/mpel/mpel.js" async></script>  <style> body {margin-top: 60px;} </style> <script nonce="430SJTAQ6UWIHC75X"> document.getElementById('mp').onclick = function(){ chooser(); } document.getElementById('mp-m').onclick = function(){ chooser(); } function chooser(){ var script=document.createElement('SCRIPT'); script.src='https://web.archive.org/web/20210812014731/https://lookercom.mpeasylink.com/mpel/mpel_chooser.js'; document.body.appendChild(script); return false; } </script></p> <header class="site-header border-bottom"> <div class="container split"> <div class="left"> <h1 class="headline2 margin-top--0 margin-bottom--20"> Welcome to the next stage of SQL </h1> <p class="sub-title"> Data modeling made easier. </p> <a href="/web/20210812014731/https://looker.com/demo" class="btn primary margin-top--30"> Request a demo </a> </div> <div class="right"> <div class="youtube-player" data-id="XG4ytmgqSpU"></div> </div> </div> </header> <section class="responsive-padding center-align"> <div class="container"> <h2 class="headline3 margin-bottom--45"> Looker data modeling in three steps </h2> </div> <div class="container five-steps-container"> <div class="five-steps-flex-container"> <div class="one"> <p class="large-label text-one">Step 1</p> <p> Connect Looker to any database that supports SQL queries and automatically generate a basic LookML model. </p> </div> <div class="two"> <img src="/web/20210812014731im_/https://looker.com/assets/img/images/homepage/laptop_product_v0002.png"> </div> <div class="three"> <p class="large-label text-two">Step 2</p> <p> Collaborate with your team to build on your model, or deploy any one of our 100+ pre-built LookML modeling patterns (Looker Blocks) to accelerate development. </p> </div> </div> <div class="four"> <p class="large-label">Step 3</p> <p> Customize your model to reflect your company’s unique metrics and easily update and manage your reports from one place. </p> </div> </div> </section> <hr class="seperator"> <section class="responsive-padding"> <div class="container"> <div class="module-three-section"> <div class="left"> <h3> Data modeling that works for you </h3> <p> Define your company’s business logic in Looker so it can be used by the entire company. Define your data model once and reference any piece of it anywhere else to avoid writing the same SQL queries over and over again. As your business changes, updated metrics keep everyone aligned around fresh data. </p> </div> <div class="middle"> <h3> A basic model, instantly </h3> <p> Looker intelligently scans your data and infers relationships between tables in your schema to build a basic model for you. This basic model uses the relationships already defined within your <a href="/web/20210812014731/https://looker.com/solutions/databases">database</a> to get you up to speed. </p> </div> <div class="right"> <h3> We’re prepared for you </h3> <p> Looker provides pre-built analytical templates (Looker Blocks®) to move you from data to dashboard in minutes when building on common data sources (e.g., <a href="/web/20210812014731/https://looker.com/platform/blocks/source/google-analytics-premium-360-by-google">Google Analytics</a> or <a href="/web/20210812014731/https://looker.com/platform/blocks/source/campaign-attribution-for-salesforce">Salesforce</a>). Browse over 100 Looker Blocks on <a href="/web/20210812014731/https://looker.com/platform/directory/home">Looker’s Block directory</a> to help you accelerate the pace of your data modeling. </p> </div> </div> </div> </section> <section class="grey-50-bg responsive-padding"> <div class="container-solutions"> <div class="customer_module four"> <div class="white cust-box filtered-box shadow-hover border-full border-radius--8 us-and-canada technology healthcare"> <div class="top"> <img src="/web/20210812014731im_/https://looker.com/assets/img/images/logos/external/customers/counsyl.png" class="cust-box-logo"> </div> <p class="small-text margin-top--30 margin-bottom--20"> Counsyl streamlines results and boosts impact with data. </p> <div class="bottom"> <a href="/web/20210812014731/https://looker.com/customers/counsyl" class=" btn flat"> Learn more </a> </div> </div> <div class="white cust-box filtered-box shadow-hover border-full border-radius--8 europe-and-middle-east-and-africa real-estate-and-construction technology"> <div class="top"> <img src="/web/20210812014731im_/https://looker.com/assets/img/images/logos/external/customers/deliveroo.png" class="cust-box-logo"> </div> <p class="small-text margin-top--30 margin-bottom--20"> Deliveroo uses data to transport delicious meals faster. </p> <div class="bottom"> <a href="/web/20210812014731/https://looker.com/customers/deliveroo" class=" btn flat"> Learn more </a> </div> </div> <div class="white cust-box filtered-box shadow-hover border-full border-radius--8 us-and-canada retail-and-consumer-goods"> <div class="top"> <img src="/web/20210812014731im_/https://looker.com/assets/img/images/logos/external/customers/glossier.png" class="cust-box-logo"> </div> <p class="small-text margin-top--30 margin-bottom--20"> Glossier makes data beautiful. </p> <div class="bottom"> <a href="https://web.archive.org/web/20210812014731/https://youtu.be/rug9xTdaLNg" class="html5lightbox btn flat"> Watch video <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewbox="0 0 24 24" class="material-icons"> <path fill="none" d="M0 0h24v24H0V0z"></path> <path d="M21.58 7.19c-.23-.86-.91-1.54-1.77-1.77C18.25 5 12 5 12 5s-6.25 0-7.81.42c-.86.23-1.54.91-1.77 1.77C2 8.75 2 12 2 12s0 3.25.42 4.81c.23.86.91 1.54 1.77 1.77C5.75 19 12 19 12 19s6.25 0 7.81-.42c.86-.23 1.54-.91 1.77-1.77C22 15.25 22 12 22 12s0-3.25-.42-4.81zM10 15V9l5.2 3-5.2 3z"> </path> </svg> </a> </div> </div> <div class="white cust-box filtered-box shadow-hover border-full border-radius--8 us-and-canada technology"> <div class="top"> <img src="/web/20210812014731im_/https://looker.com/assets/img/images/logos/external/customers/stackoverflow.png" class="cust-box-logo"> </div> <p class="small-text margin-top--30 margin-bottom--20"> Stack Overflow improves the data science workflow. </p> <div class="bottom"> <a href="https://web.archive.org/web/20210812014731/https://youtu.be/QdeOO-ITn4c" class="html5lightbox btn flat"> Watch video <svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewbox="0 0 24 24" class="material-icons"> <path fill="none" d="M0 0h24v24H0V0z"></path> <path d="M21.58 7.19c-.23-.86-.91-1.54-1.77-1.77C18.25 5 12 5 12 5s-6.25 0-7.81.42c-.86.23-1.54.91-1.77 1.77C2 8.75 2 12 2 12s0 3.25.42 4.81c.23.86.91 1.54 1.77 1.77C5.75 19 12 19 12 19s6.25 0 7.81-.42c.86-.23 1.54-.91 1.77-1.77C22 15.25 22 12 22 12s0-3.25-.42-4.81zM10 15V9l5.2 3-5.2 3z"> </path> </svg> </a> </div> </div> </div> <style> .slick-track { display: flex !important; display: -webkit-flex !important; } .slick-slide { display: flex !important; display: -webkit-flex !important; height: auto !important; align-items: flex-start; -webkit-align-items: flex-start; flex-direction: column; -webkit-flex-direction: column; padding: 20px; margin: 10px; } .cust-box-logo { max-height: 30px; } .top { max-height: 30px; max-width: 125px; } .bottom { margin-top: auto; } </style> </div> </section> <section class="responsive-padding"> <div class="container center-align"> <h2 class="headline3"> We’re here to help—every step of the way </h2> <p class="margin-bottom--45"> Lean on Looker’s professional services to accelerate your deployment. </p> </div> <div class="container center-align mobile-left"> <div class="module-three-section"> <div class="left"> <h3> Professional services </h3> <p> Drive maximum returns from your BI investment by partnering with <a href="/web/20210812014731/https://looker.com/professional-services">Looker Professional Services</a> and our partner ecosystem. </p> </div> <div class="middle"> <h3> Training </h3> <p> Take your Looker skills to the next level by participating in dedicated <a href="https://web.archive.org/web/20210812014731/https://training.looker.com/">training</a> sessions. </p> </div> <div class="right"> <h3> Ongoing support </h3> <p> Dedicated online technical assistance from Looker analysts ensures that you get help in context—when you need it. </p> </div> </div> </div> </section> <p><section class="responsive-padding center-align grey-800-bg"> <div class="container-900"> <h2 class="headline3 white-t"> Love your analytics </h2> <p class="padding-top--15 white-t" style="max-width:595px; margin:0 auto"> Business intelligence, big data analytics, or a 360° view of your customers. Whatever you need, Looker can help. Talk to our data experts. </p> <a class="btn primary margin-top--30" href="/web/20210812014731/https://looker.com/demo"> Request a demo </a> </div> </section></p> <p>  <script nonce="430SJTAQ6UWIHC75X" src="/web/20210812014731js_/https://looker.com/site/themes/surf_verve/js/all-scripts_v0003.js"></script> </p> <p><style> .slick-list,.slick-slider,.slick-track{position:relative;display:block}.slick-loading .slick-slide,.slick-loading .slick-track{visibility:hidden}.slick-slider{box-sizing:border-box;-webkit-user-select:none;-moz-user-select:none;-ms-user-select:none;user-select:none;-webkit-touch-callout:none;-khtml-user-select:none;-ms-touch-action:pan-y;touch-action:pan-y;-webkit-tap-highlight-color:transparent}.slick-list{overflow:hidden;margin:0;padding:0}.slick-list:focus{outline:0}.slick-list.dragging{cursor:pointer}.slick-slider .slick-list,.slick-slider .slick-track{-webkit-transform:translate3d(0,0,0);-moz-transform:translate3d(0,0,0);-ms-transform:translate3d(0,0,0);-o-transform:translate3d(0,0,0);transform:translate3d(0,0,0)}.slick-track{top:0;left:0}.slick-track:after,.slick-track:before{display:table;content:''}.slick-track:after{clear:both}.slick-slide{display:none;float:left;height:100%;min-height:1px}[dir=rtl] .slick-slide{float:right}.slick-slide img{display:block}.slick-slide.slick-loading img{display:none}.slick-slide.dragging img{pointer-events:none}.slick-initialized .slick-slide{display:block}.slick-vertical .slick-slide{display:block;height:auto;border:1px solid transparent}.slick-arrow.slick-hidden{display:none} .slick-dots,.slick-next,.slick-prev{position:absolute;display:block;padding:0}.slick-dots li button:before,.slick-next:before,.slick-prev:before{font-family:slick;-webkit-font-smoothing:antialiased;-moz-osx-font-smoothing:grayscale}.slick-loading .slick-list{background:url(/web/20210812014731im_/https://looker.com/platform/ajax-loader.gif) center center no-repeat #fff}@font-face{font-family:slick;font-weight:400;font-style:normal;src:url(/web/20210812014731im_/https://looker.com/platform/fonts/slick.eot);src:url(/web/20210812014731im_/https://looker.com/platform/fonts/slick.eot#iefix) format('embedded-opentype'),url(/web/20210812014731im_/https://looker.com/platform/fonts/slick.woff) format('woff'),url(/web/20210812014731im_/https://looker.com/platform/fonts/slick.ttf) format('truetype'),url(/web/20210812014731im_/https://looker.com/platform/fonts/slick.svg#slick) format('svg')}.slick-next,.slick-prev{font-size:0;line-height:0;top:50%;width:20px;height:20px;-webkit-transform:translate(0,-50%);-ms-transform:translate(0,-50%);transform:translate(0,-50%);cursor:pointer;color:transparent;border:none;outline:0;background:0 0}.slick-next:focus,.slick-next:hover,.slick-prev:focus,.slick-prev:hover{color:transparent;outline:0;background:0 0}.slick-next:focus:before,.slick-next:hover:before,.slick-prev:focus:before,.slick-prev:hover:before{opacity:1}.slick-next.slick-disabled:before,.slick-prev.slick-disabled:before{opacity:.25}.slick-next:before,.slick-prev:before{font-size:20px;line-height:1;opacity:.75;color:#fff}.slick-prev{left:-25px}[dir=rtl] .slick-prev{right:-25px;left:auto}.slick-next:before,[dir=rtl] .slick-next{right:-25px}[dir=rtl] .slick-next{right:auto;left:-25px}[dir=rtl] .slick-dotted.slick-slider{margin-bottom:30px}.slick-dots{bottom:-35px;width:100%;margin:0;list-style:none;text-align:center}.slick-dots li{position:relative;display:inline-block;width:20px;height:20px;margin:0 5px;padding:0;cursor:pointer}.slick-dots li button{font-size:0;line-height:0;display:block;width:20px;height:20px;padding:5px;cursor:pointer;color:transparent;border:0;outline:0;background:0 0}.slick-dots li button:focus,.slick-dots li button:hover{outline:0}.slick-dots li button:focus:before,.slick-dots li button:hover:before{opacity:1}.slick-dots li button:before{font-size:6px;line-height:20px;position:absolute;top:0;left:0;width:20px;height:20px;text-align:center;opacity:.25;color:#000}.slick-dots li.slick-active button:before{opacity:.75;color:#000} .slick-prev:before { content: url(/web/20210812014731im_/https://looker.com/assets/img/images/system/keyboard_arrow_left_grey.svg); } .slick-next:before { content: url(/web/20210812014731im_/https://looker.com/assets/img/images/system/keyboard_arrow_right_grey.svg); } .responsive { width: 88%; margin: 0 auto 30px; text-align: center; } .slick-slide { outline: 0; } .slick-slide img { display: inline-block !important; } @media all and (max-width:960px){ .responsive { width: 100%; } .slick-arrow { display: none !important; } } .slick-prev, .slick-next { top: 50%; padding: 5px; width: 50px; height: 50px; min-width: 5px; border-radius: 50%; border: 1px solid transparent; } .slick-prev:hover, .slick-next:hover { background: white; box-shadow: 0 1px 2px 0 rgba(60,64,67,0.05), 0 1px 3px 1px rgba(60,64,67,0.15); border: 1px solid #dadce0; } .slick-next:focus, .slick-prev:focus { color: inherit; outline: 0; } .slick-prev { left: -70px; } .slick-next { right: -70px; } .slick-disabled { pointer-events: none; } .slick-dots li { margin: 0 1.5px !important; } .slick-dots { margin: 0 !important; padding: 0; overflow: hidden; position: static; } .slick-dots li button:before { font-size: 35px !important; content: '•'; } </style> <script nonce="430SJTAQ6UWIHC75X"> $('.customer_module.four').slick({ dots: true, infinite: false, speed: 300, slidesToShow: 4, slidesToScroll: 4, responsive: [ { breakpoint: 1050, settings: { slidesToShow: 3, slidesToScroll: 3, } }, { breakpoint: 750, settings: { slidesToShow: 2, slidesToScroll: 2, } }, { breakpoint: 500, settings: { slidesToShow: 1, slidesToScroll: 1, } } // You can unslick at a given breakpoint now by adding: // settings: "unslick" // instead of a settings object ] }); $('.customer_module.three').slick({ dots: true, infinite: false, speed: 300, slidesToShow: 3, slidesToScroll: 3, responsive: [ { breakpoint: 750, settings: { slidesToShow: 2, slidesToScroll: 2, } }, { breakpoint: 500, settings: { slidesToShow: 1, slidesToScroll: 1, } } // You can unslick at a given breakpoint now by adding: // settings: "unslick" // instead of a settings object ] }); $('.customer_module.two').slick({ dots: true, infinite: false, speed: 300, slidesToShow: 2, slidesToScroll: 2, responsive: [ { breakpoint: 500, settings: { slidesToShow: 1, slidesToScroll: 1, } } // You can unslick at a given breakpoint now by adding: // settings: "unslick" // instead of a settings object ] }); </script></p> <script nonce="430SJTAQ6UWIHC75X" type="application/ld+json"> { "@context": "https://web.archive.org/web/20210812014731/http://schema.org", "@type": "VideoObject", "name": "Defining the Language of Your Business with LookML", "description": "Looker helps businesses get all the knowledge about what their data means out of analysts’ heads and into software, where everyone can access it. That means everyone, in any department, can get reliable answers from data.", "thumbnailUrl": "https://web.archive.org/web/20210812014731/https://i.ytimg.com/vi/XG4ytmgqSpU/maxresdefault.jpg", "uploadDate": "2018-01-15", "duration": "PT2M19S", "embedUrl": "https://web.archive.org/web/20210812014731/https://youtu.be/XG4ytmgqSpU" } </script> </div>  <footer class="new-site-footer border-top" data-swiftype-index="false"> <div class=""> <div class="social-icons container border-bottom"> <p class="small-text inline"> Follow us on: </p> <div class="inline"> <a class="fa fa-lg fa-facebook" target="_blank" rel="noreferer noopener" href="https://web.archive.org/web/20210812014731/https://www.facebook.com/LookerData/"></a> <a class="fa fa-lg fa-twitter" target="_blank" rel="noreferer noopener" href="https://web.archive.org/web/20210812014731/https://twitter.com/LookerData"></a> <a class="fa fa-lg fa-linkedin" target="_blank" rel="noreferer noopener" href="https://web.archive.org/web/20210812014731/https://www.linkedin.com/company/looker"></a> <a class="fa fa-lg fa-youtube-play" target="_blank" rel="noreferer noopener" href="https://web.archive.org/web/20210812014731/https://www.youtube.com/user/LookerData"></a> </div> </div> <div class="container footer-link-section"> <div class="footer-sections container-full-width"> <div class="f-one"> <p class="toggle-button h7" data-name="footer-one"> Product<span class="fa fa-chevron-down"></span> </p> <div class="links" id="footer-one"> <p><a href="/web/20210812014731/https://looker.com/product/business-intelligence" class="footer-nav-gtm">Business Intelligence</a></p> <p><a href="/web/20210812014731/https://looker.com/product/embedded-analytics" class="footer-nav-gtm">Embedded Analytics</a></p> <p><a href="/web/20210812014731/https://looker.com/product/applications" class="footer-nav-gtm">Applications</a></p> <p><a href="/web/20210812014731/https://looker.com/product/looker-difference" class="footer-nav-gtm">The Looker Difference</a></p> <p><a href="/web/20210812014731/https://looker.com/product/new-features" class="footer-nav-gtm">New Features</a></p> <p><a href="/web/20210812014731/https://looker.com/product/visualizations" class="footer-nav-gtm">Visualizations</a></p> <p><a href="/web/20210812014731/https://looker.com/professional-services" class="footer-nav-gtm">Professional Services</a></p> <p><a href="/web/20210812014731/https://looker.com/product/security" class="footer-nav-gtm">Security</a></p> <p><a href="/web/20210812014731/https://looker.com/product/pricing" class="footer-nav-gtm">Pricing</a></p> </div> </div> <div class="f-two"> <p class="toggle-button h7" data-name="footer-two"> Platform<span class="fa fa-chevron-down"></span> </p> <div class="links" id="footer-two"> <p><a href="/web/20210812014731/https://looker.com/platform/overview" class="footer-nav-gtm">Data Platform</a></p> <p><a href="/web/20210812014731/https://looker.com/platform/data-modeling" class="footer-nav-gtm">Data Modeling</a></p> <p><a href="/web/20210812014731/https://looker.com/platform/actions" class="footer-nav-gtm">Data Actions</a></p> <p><a href="/web/20210812014731/https://looker.com/platform/directory/home" class="footer-nav-gtm">Looker Blocks</a></p> <p><a href="/web/20210812014731/https://looker.com/platform/data-connections" class="footer-nav-gtm">Data Connections</a></p> <p><a href="/web/20210812014731/https://looker.com/solutions" class="footer-nav-gtm">Solutions</a></p> <p><a href="/web/20210812014731/https://looker.com/partner-network" class="footer-nav-gtm">Partner Ecosystem</a></p> <p><a href="/web/20210812014731/https://looker.com/platform/enterprise" class="footer-nav-gtm">Looker for Enterprise</a></p> </div> </div> <div class="f-four"> <p class="toggle-button h7" data-name="footer-four"> Learn<span class="fa fa-chevron-down"></span> </p> <div class="links" id="footer-four"> <p><a href="/web/20210812014731/https://looker.com/guide">User Guide</a></p> <p><a href="/web/20210812014731/https://looker.com/guide/getting-started" class="footer-nav-gtm">Getting Started</a></p> <p><a href="https://web.archive.org/web/20210812014731/https://help.looker.com/" class="footer-nav-gtm">Help Center</a></p> <p><a href="https://web.archive.org/web/20210812014731/https://docs.looker.com/" class="footer-nav-gtm">Documentation</a></p> <p><a href="https://web.archive.org/web/20210812014731/https://community.looker.com/" class="footer-nav-gtm">Community</a></p> <p><a href="https://web.archive.org/web/20210812014731/https://training.looker.com/" class="footer-nav-gtm">Training</a></p> <p><a href="/web/20210812014731/https://looker.com/certification" class="footer-nav-gtm">Certification</a></p> <p><a href="https://web.archive.org/web/20210812014731/https://info.looker.com/whitepapers" class="footer-nav-gtm">Whitepapers</a></p> <p><a href="https://web.archive.org/web/20210812014731/https://info.looker.com/analyst-reports" class="footer-nav-gtm">Analyst Reports</a></p> </div> </div> <div class="f-five"> <p class="toggle-button h7" data-name="footer-five"> Engage<span class="fa fa-chevron-down"></span> </p> <div class="links" id="footer-five"> <p><a href="/web/20210812014731/https://looker.com/blog">Blog</a></p> <p><a href="/web/20210812014731/https://looker.com/events" class="footer-nav-gtm">Events</a></p> <p><a href="/web/20210812014731/https://looker.com/customers" class="footer-nav-gtm">Customers</a></p> <p><a href="https://web.archive.org/web/20210812014731/https://info.looker.com/webinars" class="footer-nav-gtm">On-demand Webinars</a></p> <p><a href="https://web.archive.org/web/20210812014731/https://careers.google.com/jobs/results/?company=Google&hl=en_US&jlo=en_US&q=looker,%20google%20cloud&sort_by=relevance" target="_blank" rel="noreferer noopener" class="footer-nav-gtm">Careers</a></p> <p><a href="/web/20210812014731/https://looker.com/trust-center" class="footer-nav-gtm">Trust Center</a></p> <p><a href="/web/20210812014731/https://looker.com/contact" class="footer-nav-gtm">Contact</a></p> </div> </div> </div> </div> </div> <div class="footer-meta center-align white"> <div class="container"> <div class="left"> <p class="">© <script nonce="430SJTAQ6UWIHC75X">document.write(new Date().getFullYear())</script> Looker Data Sciences, Inc.</p> </div> <div class="right"> <p> <a href="/web/20210812014731/https://looker.com/privacy">Privacy</a> | <a href="/web/20210812014731/https://looker.com/terms">Terms</a> | <a href="/web/20210812014731/https://looker.com/trust-center/privacy/cookies">Cookies</a> </p> </div> </div> </div> </footer>   <script nonce="430SJTAQ6UWIHC75X"> $(document).ready(function() { ww = window.innerWidth; adjustFooterNav(); }); $(window).bind('resize orientationchange', function() { ww = window.innerWidth; adjustFooterNav(); }); var adjustFooterNav = function() { if ( ww > 960 ) { $('.links').show(); $('.footer-link-section .fa').removeClass('fa-chevron-up').addClass('fa-chevron-down'); } else { if ($('.f-one .fa').hasClass('fa-chevron-up')) { $('.f-one .links').show(); } else if ($('.f-two .fa').hasClass('fa-chevron-up')) { $('.f-two .links').show(); } else if ($('.f-three .fa').hasClass('fa-chevron-up')) { $('.f-three .links').show(); } else if ($('.f-four .fa').hasClass('fa-chevron-up')) { $('.f-four .links').show(); } else if ($('.f-five .fa').hasClass('fa-chevron-up')) { $('.f-five .links').show(); } else { $('.links').hide(); } } }; </script>  <div class="exit-popup" id="intellimize-exit-popup" style="display:none"> <a href="#exit-popup" class="html5lightbox lb-trigger" data-width="600" data-height="500"></a> <div id="exit-popup" style="display:none"> <div class="exit-intent-image-left-module"> <div class="inner center-align"> <h2 class="headline3"> You can afford to stay </h2> <p> Get more value out of your data. Looker has the features your business needs at a price that fits. Request a quote today. </p> <div> <a href="/web/20210812014731/https://looker.com/product/pricing" class="btn primary margin-top--30"> Request a quote </a> </div> </div> </div> </div> </div>  <style> .exit-intent-image-left-module .inner { padding: 30px; } @media all and (max-width:768px){ .exit-intent-image-left-module .inner { padding: 30px 15px; } } </style> <script nonce="430SJTAQ6UWIHC75X"> $(document).ready(function() { if (navigator.userAgent.match(/(iPad)/)) { // main menu hover function $('#mm-link1').click(function(){ $(".m-menu").hide(); $("#mega-menu1").toggle(); }); $('#mm-link2').click(function(){ $(".m-menu").hide(); $("#mega-menu2").toggle(); }); $('#mm-link3').click(function(){ $(".m-menu").hide(); $("#mega-menu3").toggle(); }); $('#mm-link4').click(function(){ $(".m-menu").hide(); $("#mega-menu4").toggle(); }); $('#mm-link5').click(function(){ $(".m-menu").hide(); $("#mega-menu5").toggle(); }); $('#mm-link6').click(function(){ $(".m-menu").hide(); $("#mega-menu6").toggle(); }); } else { $('#mm-link1').hover(function(e){ $(".m-menu").hide(); $("#mega-menu1").show(); }, function(e){ $(".m-menu").hide(); e.preventDefault(); }); $('#mm-link2').hover(function(e){ $(".m-menu").hide(); $("#mega-menu2").show(); }, function(e){ $(".m-menu").hide(); e.preventDefault(); }); $('#mm-link3').hover(function(e){ $(".m-menu").hide(); $("#mega-menu3").show(); }, function(e){ $(".m-menu").hide(); e.preventDefault(); }); $('#mm-link4').hover(function(e){ $(".m-menu").hide(); $("#mega-menu4").show(); }, function(e){ $(".m-menu").hide(); e.preventDefault(); }); $('#mm-link5').hover(function(e){ $(".m-menu").hide(); $("#mega-menu5").show(); }, function(e){ $(".m-menu").hide(); e.preventDefault(); }); $('#mm-link6').hover(function(e){ $(".m-menu").hide(); $("#mega-menu6").show(); }, function(e){ $(".m-menu").hide(); e.preventDefault(); }); } }); (function(window) { 'use strict'; /** * Extend Object helper function. */ function extend(a, b) { for(var key in b) { if(b.hasOwnProperty(key)) { a[key] = b[key]; } } return a; } /** * Each helper function. */ function each(collection, callback) { for (var i = 0; i < collection.length; i++) { var item = collection[i]; callback(item); } } /** * Menu Constructor. */ function Menu(options) { this.options = extend({}, this.options); extend(this.options, options); this._init(); } /** * Menu Options. */ Menu.prototype.options = { wrapper: '#o-wrapper', // The content wrapper type: 'slide-left', // The menu type menuOpenerClass: '.c-button', // The menu opener class names (i.e. the buttons) maskId: '#c-mask' // The ID of the mask }; /** * Initialise Menu. */ Menu.prototype._init = function() { this.body = document.body; this.wrapper = document.querySelector(this.options.wrapper); this.mask = document.querySelector(this.options.maskId); this.menu = document.querySelector('#c-menu--' + this.options.type); this.closeBtn = this.menu.querySelector('.c-menu__close'); this.menuOpeners = document.querySelectorAll(this.options.menuOpenerClass); this._initEvents(); }; /** * Initialise Menu Events. */ Menu.prototype._initEvents = function() { // Event for clicks on the close button inside the menu. this.closeBtn.addEventListener('click', function(e) { e.preventDefault(); this.close(); }.bind(this)); // Event for clicks on the mask. this.mask.addEventListener('click', function(e) { e.preventDefault(); this.close(); }.bind(this)); }; /** * Open Menu. */ Menu.prototype.open = function() { this.body.classList.add('has-active-menu'); this.wrapper.classList.add('has-' + this.options.type); this.menu.classList.add('is-active'); this.mask.classList.add('is-active'); this.disableMenuOpeners(); }; /** * Close Menu. */ Menu.prototype.close = function() { this.body.classList.remove('has-active-menu'); this.wrapper.classList.remove('has-' + this.options.type); this.menu.classList.remove('is-active'); this.mask.classList.remove('is-active'); this.enableMenuOpeners(); }; /** * Disable Menu Openers. */ Menu.prototype.disableMenuOpeners = function() { each(this.menuOpeners, function(item) { item.disabled = true; }); }; /** * Enable Menu Openers. */ Menu.prototype.enableMenuOpeners = function() { each(this.menuOpeners, function(item) { item.disabled = false; }); }; /** * Add to global namespace. */ window.Menu = Menu; })(window); /* Push right instantiation and action. */ var pushRight = new Menu({ wrapper: '#o-wrapper', type: 'push-right', menuOpenerClass: '.menu-link', maskId: '#c-mask' }); var pushRightBtn = document.querySelector('#c-button--push-right'); pushRightBtn.addEventListener('click', function(e) { e.preventDefault; pushRight.open(); }); $(document).ready(function() { $('.new-nav').addClass('box-shadow'); }); // disable mobile menu at 1199px width $(window).on('resize', function(){ var win = $(this); //this = window if (win.width() >= 1199) { $('.c-menu--push-right, .c-mask').removeClass('is-active'); $('.o-wrapper').removeClass('has-push-right'); $('.site').removeClass('has-active-menu'); } }); $(".mobile-mp .user-locale").click(function(){ window.scrollTo(0, 0); }); </script> <script nonce="430SJTAQ6UWIHC75X"> $(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>  <script nonce="430SJTAQ6UWIHC75X">(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/20210812014731/https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-NWWX6K');</script>   <noscript><iframe src="//web.archive.org/web/20210812014731if_/https://www.googletagmanager.com/ns.html?id=GTM-NWWX6K" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>  </body> </html>

CINXE.COM

Data Modeling Made Easy with SQL and LookML