Amazon Redshift Analytics & Business Intelligence

<!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/solutions/amazon-redshift","20210726161416","https://web.archive.org/","web","/_static/", "1627316056"); </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="Amazon Redshift"/> <meta name="twitter:description" content="Amazon Redshift and Looker make a powerful pair. Connect Looker to Redshift to optimize usage and allow users to easily create complex queries."/> <meta name="twitter:image" content="https://web.archive.org/web/20210726161416im_/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> Amazon Redshift Analytics & Business Intelligence </title> <meta class="swiftype" name="description" data-type="string" content="Amazon Redshift and Looker make a powerful pair. Connect Looker to Redshift to optimize usage and allow users to easily create complex queries."> <meta property="og:image" content="https://web.archive.org/web/20210726161416im_/https://looker.com/"> <meta property="og:image" content="https://web.archive.org/web/20210726161416im_/https://looker.com/assets/img/images/homepage/looker_logo_meta_v0005.png"/> <meta property="og:description" content="Amazon Redshift and Looker make a powerful pair. Connect Looker to Redshift to optimize usage and allow users to easily create complex queries."> <meta property="og:title" content="Amazon Redshift">  <link rel="apple-touch-icon" sizes="180x180" href="/web/20210726161416im_/https://looker.com/assets/img/images/favicons2/apple-touch-icon.png"> <link rel="icon" type="image/png" sizes="32x32" href="/web/20210726161416im_/https://looker.com/assets/img/images/favicons2/favicon-32x32.png"> <link rel="icon" type="image/png" sizes="16x16" href="/web/20210726161416im_/https://looker.com/assets/img/images/favicons2/favicon-16x16.png"> <link rel="manifest" href="/web/20210726161416/https://looker.com/assets/img/images/favicons2/site.webmanifest"> <link rel="mask-icon" href="/web/20210726161416im_/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/20210726161416/https://looker.com/feed" title="Looker RSS Feed">  <script nonce="3MB8RFP7SXLV6D5JA" src="/web/20210726161416js_/https://looker.com/site/themes/surf_verve/js/mp/mp_linkcode.js"></script>   <script nonce="3MB8RFP7SXLV6D5JA"> 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="3MB8RFP7SXLV6D5JA" src="//web.archive.org/web/20210726161416js_/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/20210726161416cs_/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/20210726161416cs_/https://looker.com/site/themes/surf_verve/css/surf_verve.css?v=1626997035">  <script nonce="3MB8RFP7SXLV6D5JA" type="text/javascript" src="//web.archive.org/web/20210726161416js_/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/20210726161416/https://looker.com/" class="nav-logo"> <img src="/web/20210726161416im_/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/20210726161416/https://looker.com/product/business-intelligence"> <p class="alt secondary-nav-gtm">Business Intelligence</p> </a> <a href="/web/20210726161416/https://looker.com/product/embedded-analytics"> <p class="alt secondary-nav-gtm">Embedded Analytics</p> </a> <a href="/web/20210726161416/https://looker.com/product/applications"> <p class="alt secondary-nav-gtm">Applications</p> </a> <a href="/web/20210726161416/https://looker.com/product/looker-difference"> <p class="alt secondary-nav-gtm">The Looker Difference</p> </a> <a href="/web/20210726161416/https://looker.com/product/new-features"> <p class="alt secondary-nav-gtm">New Features</p> </a> <a href="/web/20210726161416/https://looker.com/product/visualizations"> <p class="alt secondary-nav-gtm">Visualizations</p> </a> <a href="/web/20210726161416/https://looker.com/professional-services"> <p class="alt secondary-nav-gtm">Professional Services</p> </a> <a href="/web/20210726161416/https://looker.com/product/security"> <p class="alt secondary-nav-gtm">Security</p> </a> <a href="/web/20210726161416/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/20210726161416/https://looker.com/platform/overview"> <p class="alt secondary-nav-gtm">Data Platform</p> </a> <a href="/web/20210726161416/https://looker.com/platform/data-modeling"> <p class="alt secondary-nav-gtm">Data Modeling</p> </a> <a href="/web/20210726161416/https://looker.com/platform/actions"> <p class="alt secondary-nav-gtm">Data Actions</p> </a> <a href="/web/20210726161416/https://looker.com/platform/directory/home"> <p class="alt secondary-nav-gtm">Looker Blocks</p> </a> <a href="/web/20210726161416/https://looker.com/platform/data-connections"> <p class="alt secondary-nav-gtm">Data Connections</p> </a> <a href="/web/20210726161416/https://looker.com/partner-network"> <p class="alt secondary-nav-gtm">Partner Ecosystem</p> </a> <a href="/web/20210726161416/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/20210726161416/https://looker.com/solutions/ecommerce"> <p class="alt secondary-nav-gtm">eCommerce</p> </a> <a href="/web/20210726161416/https://looker.com/solutions/media"> <p class="alt secondary-nav-gtm">Media</p> </a> <a href="/web/20210726161416/https://looker.com/solutions/ad-tech"> <p class="alt secondary-nav-gtm">Ad Tech</p> </a> <a href="/web/20210726161416/https://looker.com/solutions/saas"> <p class="alt secondary-nav-gtm">SaaS</p> </a> <a href="/web/20210726161416/https://looker.com/solutions/healthcare"> <p class="alt secondary-nav-gtm">Healthcare</p> </a> <a href="/web/20210726161416/https://looker.com/solutions/gaming"> <p class="alt secondary-nav-gtm">Gaming</p> </a> <a href="/web/20210726161416/https://looker.com/solutions/fintech"> <p class="alt secondary-nav-gtm">FinTech</p> </a> <a href="/web/20210726161416/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/20210726161416/https://looker.com/solutions/marketing-analytics"> <p class="alt secondary-nav-gtm">Marketing</p> </a> <a href="/web/20210726161416/https://looker.com/solutions/sales-analytics"> <p class="alt secondary-nav-gtm">Sales</p> </a> <a href="/web/20210726161416/https://looker.com/solutions/account-management"> <p class="alt secondary-nav-gtm">Account Management</p> </a> <a href="/web/20210726161416/https://looker.com/solutions/support-analytics"> <p class="alt secondary-nav-gtm">Customer Support</p> </a> <a href="/web/20210726161416/https://looker.com/solutions/data-science"> <p class="alt secondary-nav-gtm">Data Science</p> </a> <a href="/web/20210726161416/https://looker.com/solutions/product-analytics"> <p class="alt secondary-nav-gtm">Product</p> </a> <a href="/web/20210726161416/https://looker.com/solutions/operation-logistics"> <p class="alt secondary-nav-gtm">Operations and Logistics</p> </a> <a href="/web/20210726161416/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/20210726161416/https://looker.com/solutions/amazon-redshift"> <p class="alt secondary-nav-gtm">Amazon Redshift</p> </a> <a href="/web/20210726161416/https://looker.com/solutions/google-bigquery"> <p class="alt secondary-nav-gtm">Google BigQuery</p> </a> <a href="/web/20210726161416/https://looker.com/solutions/snowflake"> <p class="alt secondary-nav-gtm">Snowflake</p> </a> <a href="/web/20210726161416/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/20210726161416/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/20210726161416/https://looker.com/guide"> <p class="alt secondary-nav-gtm">User Guide</p> </a> <a href="/web/20210726161416/https://looker.com/guide/getting-started"> <p class="alt secondary-nav-gtm">Getting Started</p> </a> <a href="https://web.archive.org/web/20210726161416/https://help.looker.com/"> <p class="alt secondary-nav-gtm">Help Center</p> </a> <a href="https://web.archive.org/web/20210726161416/https://docs.looker.com/"> <p class="alt secondary-nav-gtm">Documentation</p> </a> <a href="https://web.archive.org/web/20210726161416/https://community.looker.com/"> <p class="alt secondary-nav-gtm">Community</p> </a> <a href="https://web.archive.org/web/20210726161416/https://training.looker.com/"> <p class="alt secondary-nav-gtm">Training</p> </a> <a href="/web/20210726161416/https://looker.com/certification"> <p class="alt secondary-nav-gtm">Certification</p> </a> <a href="https://web.archive.org/web/20210726161416/https://info.looker.com/whitepapers"> <p class="alt secondary-nav-gtm">Whitepapers</p> </a> <a href="https://web.archive.org/web/20210726161416/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/20210726161416im_/https://looker.com/assets/img/images/icons/globe_grey.png"> </a>  <a href="/web/20210726161416/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/20210726161416/https://looker.com/"> <img id="m-menu-logo" src="/web/20210726161416im_/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/20210726161416/https://looker.com/product/business-intelligence">Business Intelligence</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/product/embedded-analytics">Embedded Analytics</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/product/applications">Applications</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/product/looker-difference">The Looker Difference</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/product/new-features">New Features</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/product/visualizations">Visualizations</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/professional-services">Professional Services</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/product/security">Security</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/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/20210726161416/https://looker.com/platform/overview">Data Platform</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/platform/data-modeling">Data Modeling</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/platform/actions">Data Actions</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/platform/directory/home">Looker Blocks</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/platform/data-connections">Data Connections</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/partner-network">Partner Ecosystem</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/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/20210726161416/https://looker.com/solutions/ecommerce">eCommerce</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/solutions/media">Media</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/solutions/ad-tech">Ad Tech</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/solutions/saas">SaaS</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/solutions/healthcare">Healthcare</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/solutions/gaming">Gaming</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/solutions/fintech">FinTech</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/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/20210726161416/https://looker.com/solutions/marketing-analytics">Marketing</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/solutions/sales-analytics">Sales</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/solutions/account-management">Account Management</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/solutions/support-analytics">Customer Support</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/solutions/data-science">Data Science</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/solutions/product-analytics">Product</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/solutions/operation-logistics">Operations and Logistics</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/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/20210726161416/https://looker.com/solutions/amazon-redshift">Amazon Redshift</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/solutions/google-bigquery">Google BigQuery</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/solutions/snowflake">Snowflake</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/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/20210726161416/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/20210726161416/https://looker.com/guide">User Guide</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/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/20210726161416/https://help.looker.com/">Help Center</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="https://web.archive.org/web/20210726161416/https://docs.looker.com/">Documentation</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="https://web.archive.org/web/20210726161416/https://community.looker.com/">Community</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="https://web.archive.org/web/20210726161416/https://training.looker.com/">Training</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="/web/20210726161416/https://looker.com/certification">Certification</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="https://web.archive.org/web/20210726161416/https://info.looker.com/whitepapers">Whitepapers</a> </li> <li class="c-menu__item"> <a class="c-menu__link" href="https://web.archive.org/web/20210726161416/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/20210726161416im_/https://looker.com/assets/img/images/icons/globe_grey.png" style="width:20px"> </a>  </div> <div class="center-align"> <a href="/web/20210726161416/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="3MB8RFP7SXLV6D5JA" type="text/javascript" id="mpelid" src="//web.archive.org/web/20210726161416js_/https://lookercom.mpeasylink.com/mpel/mpel.js" async></script>  <style> body {margin-top: 60px;} </style> <script nonce="3MB8RFP7SXLV6D5JA"> 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/20210726161416/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-800 center-align"> <h1 class="headline2"> Amazon Redshift analytics & business intelligence with Looker </h1> <div class="margin-top--15"> <a href="/web/20210726161416/https://looker.com/demo/looker-for-aws" class="btn primary margin--7-5"> Request a demo </a> <a href="/web/20210726161416/https://looker.com/demo/aws-redshift-trial" class="btn secondary margin--7-5"> Free trial </a> </div> </div> </header> <section class="responsive-padding"> <div class="container-900 center-align"> <h2 class="headline3"> A match made in SQL heaven </h2> <p class="margin-bottom--45"> A powerful database deserves a powerful data platform. </p> <div class="module-image-left"> <div class="left"> <img src="/web/20210726161416im_/https://looker.com/assets/img/images/solutions/logos/large/redshift_v0005.png" style="width:400px"> </div> <div class="right"> <ul> <li> Store, manage, and process petabytes of data in seconds </li> <li> Access a vast library of advanced analytical functions </li> <li> Control distribution patterns, storage architecture, and auto-scale at the push of a button </li> </ul> </div> </div> </div> <div class="container center-align"> <h2 class="margin-top--60 margin-bottom--45"> Leveraging Looker </h2> <div class="module-three-section"> <div class="left"> <h3> Powerful </h3> <p style="max-width:360px; margin: 10px auto 0"> Easily issue multiple concurrent queries that run directly against your database. </p> </div> <div class="middle"> <h3> Mature SQL dialect </h3> <p style="max-width:360px; margin: 10px auto 0"> Make it easy for your business users to build complex queries to answer their questions. </p> </div> <div class="right"> <h3> Flexible </h3> <p style="max-width:360px; margin: 10px auto 0"> Build a centralized data model from your unique business metrics that lives in Redshift. </p> </div> </div> </div> </section> <section class="responsive-padding grey-800-bg"> <div class="container-900 center-align"> <h2 class="headline3 white-t"> Experience the benefits of Looker + Redshift </h2> <a class="btn reversed margin-top--30" href="/web/20210726161416/https://looker.com/demo/aws-redshift-trial"> Free trial </a> </div> </section> <section class="responsive-padding"> <div class="container-900 center-align"> <h2 class="headline3"> Powerful features on Amazon Redshift </h2> <p class="margin-bottom--45"> Amazon Redshift strikes a balance between the customizability and enterprise support of legacy databases, and the ease-of-use and automation that’s standard with modern cloud architecture. </p> </div> <div class="container"> <div class="module-three-section"> <div class="left"> <h3> (Near) Infinitely scalable </h3> <p> Automatically scale Redshift performance and issue queries that run on exabytes of data stored in S3. Use Looker to seamlessly drill from aggregated data residing in your Redshift cluster all the way down to individual events stored in S3, via Redshift’s Spectrum feature. </p> </div> <div class="middle"> <h3> Industry-leading integrations </h3> <p> Looker has partnered with Amazon Web Services (AWS) to provide market-leading tools to help you understand cluster utilization and relieve bottlenecks, and so you know when it’s time to upsize. </p> </div> <div class="right"> <h3> An enterprise-grade ecosystem </h3> <p> Redshift is part of a much broader ecosystem of AWS products and solutions. Looker integrates natively with the entire AWS data ecosystem, from Amazon Aurora to Amazon Athena to EMR. </p> </div> </div> </div> </section> <section class="responsive-padding"> <div class="container"> <div class="customer-module"> <div class="flex-box left"> <p class="quote-box"> The best thing about Looker has been really empowering people to go out and find their own answers. </p> <cite class="quoter"> Caitlin Moorman, Director of Insights & Analytics </cite> </div> <div class="flex-box right"> <div class="flex-box small one"> <img src="/web/20210726161416im_/https://looker.com/assets/img/images/logos/external/bricks/indiegogo.png" alt=""> </div> <a href="https://web.archive.org/web/20210726161416/https://www.youtube.com/embed/k2FkLiqY4Ls?rel=0" class="html5lightbox flex-box small two"> <div> <span class="btn flat reversed" tabindex="0"> 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> </span> </div> </a> </div> </div> </div> </section> <section class="responsive-padding"> <div class="container-900 center-align"> <h2 class="headline3"> Optimize Redshift performance </h2> <p class="margin-bottom--45"> Looker can help you optimize your Redshift usage immediately. </p> </div> <div class="container"> <div class="module-image-left"> <div class="left"> <img src="/web/20210726161416im_/https://looker.com/assets/img/images/solutions/screenshots/amazon_redshift/2.png" class="border-full"> </div> <div class="right"> <ul> <li> Redshift Administration and Redshift Optimization solutions can be deployed in seconds on your Looker instance to help you start tuning your database performance immediately </li> <li> Built by the database experts at Amazon and Looker and available for all Looker users at no additional cost </li> <li> Optimize cluster performance down to the query level, reduce bottlenecks, and get a bird’s eye view of your ETL processes, all for free with Looker </li> <li> Optimize AWS consumption with the AWS Optimization Suite </li> </ul> </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/20210726161416/https://looker.com/demo"> Request a demo </a> </div> </section></p> <p>  <script nonce="3MB8RFP7SXLV6D5JA" src="/web/20210726161416js_/https://looker.com/site/themes/surf_verve/js/all-scripts_v0003.js"></script> </p> </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/20210726161416/https://www.facebook.com/LookerData/"></a> <a class="fa fa-lg fa-twitter" target="_blank" rel="noreferer noopener" href="https://web.archive.org/web/20210726161416/https://twitter.com/LookerData"></a> <a class="fa fa-lg fa-linkedin" target="_blank" rel="noreferer noopener" href="https://web.archive.org/web/20210726161416/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/20210726161416/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/20210726161416/https://looker.com/product/business-intelligence" class="footer-nav-gtm">Business Intelligence</a></p> <p><a href="/web/20210726161416/https://looker.com/product/embedded-analytics" class="footer-nav-gtm">Embedded Analytics</a></p> <p><a href="/web/20210726161416/https://looker.com/product/applications" class="footer-nav-gtm">Applications</a></p> <p><a href="/web/20210726161416/https://looker.com/product/looker-difference" class="footer-nav-gtm">The Looker Difference</a></p> <p><a href="/web/20210726161416/https://looker.com/product/new-features" class="footer-nav-gtm">New Features</a></p> <p><a href="/web/20210726161416/https://looker.com/product/visualizations" class="footer-nav-gtm">Visualizations</a></p> <p><a href="/web/20210726161416/https://looker.com/professional-services" class="footer-nav-gtm">Professional Services</a></p> <p><a href="/web/20210726161416/https://looker.com/product/security" class="footer-nav-gtm">Security</a></p> <p><a href="/web/20210726161416/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/20210726161416/https://looker.com/platform/overview" class="footer-nav-gtm">Data Platform</a></p> <p><a href="/web/20210726161416/https://looker.com/platform/data-modeling" class="footer-nav-gtm">Data Modeling</a></p> <p><a href="/web/20210726161416/https://looker.com/platform/actions" class="footer-nav-gtm">Data Actions</a></p> <p><a href="/web/20210726161416/https://looker.com/platform/directory/home" class="footer-nav-gtm">Looker Blocks</a></p> <p><a href="/web/20210726161416/https://looker.com/platform/data-connections" class="footer-nav-gtm">Data Connections</a></p> <p><a href="/web/20210726161416/https://looker.com/solutions" class="footer-nav-gtm">Solutions</a></p> <p><a href="/web/20210726161416/https://looker.com/partner-network" class="footer-nav-gtm">Partner Ecosystem</a></p> <p><a href="/web/20210726161416/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/20210726161416/https://looker.com/guide">User Guide</a></p> <p><a href="/web/20210726161416/https://looker.com/guide/getting-started" class="footer-nav-gtm">Getting Started</a></p> <p><a href="https://web.archive.org/web/20210726161416/https://help.looker.com/" class="footer-nav-gtm">Help Center</a></p> <p><a href="https://web.archive.org/web/20210726161416/https://docs.looker.com/" class="footer-nav-gtm">Documentation</a></p> <p><a href="https://web.archive.org/web/20210726161416/https://community.looker.com/" class="footer-nav-gtm">Community</a></p> <p><a href="https://web.archive.org/web/20210726161416/https://training.looker.com/" class="footer-nav-gtm">Training</a></p> <p><a href="/web/20210726161416/https://looker.com/certification" class="footer-nav-gtm">Certification</a></p> <p><a href="https://web.archive.org/web/20210726161416/https://info.looker.com/whitepapers" class="footer-nav-gtm">Whitepapers</a></p> <p><a href="https://web.archive.org/web/20210726161416/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/20210726161416/https://looker.com/blog">Blog</a></p> <p><a href="/web/20210726161416/https://looker.com/events" class="footer-nav-gtm">Events</a></p> <p><a href="/web/20210726161416/https://looker.com/customers" class="footer-nav-gtm">Customers</a></p> <p><a href="https://web.archive.org/web/20210726161416/https://info.looker.com/webinars" class="footer-nav-gtm">On-demand Webinars</a></p> <p><a href="https://web.archive.org/web/20210726161416/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/20210726161416/https://looker.com/trust-center" class="footer-nav-gtm">Trust Center</a></p> <p><a href="/web/20210726161416/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="3MB8RFP7SXLV6D5JA">document.write(new Date().getFullYear())</script> Looker Data Sciences, Inc.</p> </div> <div class="right"> <p> <a href="/web/20210726161416/https://looker.com/privacy">Privacy</a> | <a href="/web/20210726161416/https://looker.com/terms">Terms</a> | <a href="/web/20210726161416/https://looker.com/trust-center/privacy/cookies">Cookies</a> </p> </div> </div> </div> </footer>   <script nonce="3MB8RFP7SXLV6D5JA"> $(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/20210726161416/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="3MB8RFP7SXLV6D5JA"> $(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="3MB8RFP7SXLV6D5JA"> $(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="3MB8RFP7SXLV6D5JA">(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/20210726161416/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/20210726161416if_/https://www.googletagmanager.com/ns.html?id=GTM-NWWX6K" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>  </body> </html>

CINXE.COM

Amazon Redshift Analytics & Business Intelligence