<!DOCTYPE html> <html lang=”en” data-color-mode=”light” data-light-theme=”light” data-dark-theme=”dark”> <head> <meta charset=”utf-8”> <link rel=”dns-prefetch” href=”https://github.githubassets.com”> <link rel=”dns-prefetch” href=”https://avatars.githubusercontent.com”> <link rel=”dns-prefetch” href=”https://github-cloud.s3.amazonaws.com”> <link rel=”dns-prefetch” href=”https://user-images.githubusercontent.com/”>

<title>Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/3-minilake.yaml at master · harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select</title> <meta name=”description” content=”Contribute to harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select development by creating an account on GitHub.”> <link rel=”search” type=”application/opensearchdescription+xml” href=”/opensearch.xml” title=”GitHub”> <link rel=”fluid-icon” href=”https://github.com/fluidicon.png” title=”GitHub”> <meta property=”fb:app_id” content=”1401488693436528”> <meta name=”apple-itunes-app” content=”app-id=1477376905” /> <meta name=”twitter:image:src” content=”https://avatars.githubusercontent.com/u/13639796?s=400&v=4” /><meta name=”twitter:site” content=”@github” /><meta name=”twitter:card” content=”summary” /><meta name=”twitter:title” content=”harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select” /><meta name=”twitter:description” content=”Contribute to harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select development by creating an account on GitHub.” /> <meta property=”og:image” content=”https://avatars.githubusercontent.com/u/13639796?s=400&v=4” /><meta property=”og:site_name” content=”GitHub” /><meta property=”og:type” content=”object” /><meta property=”og:title” content=”harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select” /><meta property=”og:url” content=”https://github.com/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select” /><meta property=”og:description” content=”Contribute to harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select development by creating an account on GitHub.” />

</head>

<div class=”position-relative js-header-wrapper “> <a href=”#start-of-content” class=”p-3 bg-blue text-white show-on-focus js-skip-to-content”>Skip to content</a> <span class=”progress-pjax-loader width-full js-pjax-loader-bar Progress position-fixed”> <span style=”background-color: #79b8ff;width: 0%;” class=”Progress-item progress-pjax-loader-bar “></span> </span>

</div>

<div class=”border rounded-1 flex-shrink-0 bg-gray px-1 text-gray-light ml-1 f6 d-none js-jump-to-badge-search”> <span class=”js-jump-to-badge-search-text-default d-none” aria-label=”in this repository”> In this repository </span> <span class=”js-jump-to-badge-search-text-global d-none” aria-label=”in all of GitHub”> All GitHub </span> <span aria-hidden=”true” class=”d-inline-block ml-1 v-align-middle”>↵</span> </div>

</ul>

<ul class=”d-none js-jump-to-no-results-template-container”> <li class=”d-flex flex-justify-center flex-items-center f5 d-none js-jump-to-suggestion p-2”> <span class=”text-gray”>No suggested jump to results</span> </li> </ul>

<div class=”border rounded-1 flex-shrink-0 bg-gray px-1 text-gray-light ml-1 f6 d-none js-jump-to-badge-search”> <span class=”js-jump-to-badge-search-text-default d-none” aria-label=”in this repository”> In this repository </span> <span class=”js-jump-to-badge-search-text-global d-none” aria-label=”in all of GitHub”> All GitHub </span> <span aria-hidden=”true” class=”d-inline-block ml-1 v-align-middle”>↵</span> </div>

<div class=”border rounded-1 flex-shrink-0 bg-gray px-1 text-gray-light ml-1 f6 d-none js-jump-to-badge-search”> <span class=”js-jump-to-badge-search-text-default d-none” aria-label=”in this user”> In this user </span> <span class=”js-jump-to-badge-search-text-global d-none” aria-label=”in all of GitHub”> All GitHub </span> <span aria-hidden=”true” class=”d-inline-block ml-1 v-align-middle”>↵</span> </div>

<div class=”border rounded-1 flex-shrink-0 bg-gray px-1 text-gray-light ml-1 f6 d-none js-jump-to-badge-search”> <span class=”js-jump-to-badge-search-text-default d-none” aria-label=”in this repository”> In this repository </span> <span class=”js-jump-to-badge-search-text-global d-none” aria-label=”in all of GitHub”> All GitHub </span> <span aria-hidden=”true” class=”d-inline-block ml-1 v-align-middle”>↵</span> </div>

</div> </label> </form> </div> </div>

<nav class=”d-flex flex-column flex-md-row flex-self-stretch flex-md-self-auto” aria-label=”Global”> <a class=”Header-link py-md-3 d-block d-md-none py-2 border-top border-md-top-0 border-white-fade-15” data-ga-click=”Header, click, Nav menu - item:dashboard:user” aria-label=”Dashboard” href=”/dashboard”> Dashboard </a> <a class=”js-selected-navigation-item Header-link mt-md-n3 mb-md-n3 py-2 py-md-3 mr-0 mr-md-3 border-top border-md-top-0 border-white-fade-15” data-hotkey=”g p” data-ga-click=”Header, click, Nav menu - item:pulls context:user” aria-label=”Pull requests you created” data-selected-links=”/pulls /pulls/assigned /pulls/mentioned /pulls” href=”/pulls”> Pull<span class=”d-inline d-md-none d-lg-inline”> request</span>s </a> <a class=”js-selected-navigation-item Header-link mt-md-n3 mb-md-n3 py-2 py-md-3 mr-0 mr-md-3 border-top border-md-top-0 border-white-fade-15” data-hotkey=”g i” data-ga-click=”Header, click, Nav menu - item:issues context:user” aria-label=”Issues you created” data-selected-links=”/issues /issues/assigned /issues/mentioned /issues” href=”/issues”> Issues </a>

<div class=”d-flex position-relative”> <a class=”js-selected-navigation-item Header-link flex-auto mt-md-n3 mb-md-n3 py-2 py-md-3 mr-0 mr-md-3 border-top border-md-top-0 border-white-fade-15” data-ga-click=”Header, click, Nav menu - item:marketplace context:user” data-octo-click=”marketplace_click” data-octo-dimensions=”location:nav_bar” data-selected-links=” /marketplace” href=”/marketplace”> Marketplace </a> </div>

<a class=”js-selected-navigation-item Header-link mt-md-n3 mb-md-n3 py-2 py-md-3 mr-0 mr-md-3 border-top border-md-top-0 border-white-fade-15” data-ga-click=”Header, click, Nav menu - item:explore” data-selected-links=”/explore /trending /trending/developers /integrations /integrations/feature/code /integrations/feature/collaborate /integrations/feature/ship showcases showcases_search showcases_landing /explore” href=”/explore”> Explore </a>

<a class=”Header-link d-block d-md-none mr-0 mr-md-3 py-2 py-md-3 border-top border-md-top-0 border-white-fade-15” href=”/settings/profile”> Settings </a> <a class=”Header-link d-block d-md-none mr-0 mr-md-3 py-2 py-md-3 border-top border-md-top-0 border-white-fade-15” href=”/harunobukameda”> <img class=”avatar avatar-user” src=”https://avatars.githubusercontent.com/u/13639796?s=40&v=4” width=”20” height=”20” alt=”@harunobukameda” /> harunobukameda </a> <!– ‘”` –><!– </textarea></xmp> –></option></form><form action=”/logout” accept-charset=”UTF-8” method=”post”><input type=”hidden” name=”authenticity_token” value=”kxV+XLMXeECLaLWBoxZyeJ3zw+30FtZoaWVq/DsBfjZ5+X9cOb0Up8WEEcX0avhD0iIzoMRCrr83q0urcjx4AQ==” /> <button type=”submit” class=”Header-link mr-0 mr-md-3 py-2 py-md-3 border-top border-md-top-0 border-white-fade-15 d-md-none btn-link d-block width-full text-left” data-ga-click=”Header, sign out, icon:logout” style=”padding-left: 2px;”> <svg class=”octicon octicon-sign-out v-align-middle” viewBox=”0 0 16 16” version=”1.1” width=”16” height=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M2 2.75C2 1.784 2.784 1 3.75 1h2.5a.75.75 0 010 1.5h-2.5a.25.25 0 00-.25.25v10.5c0 .138.112.25.25.25h2.5a.75.75 0 010 1.5h-2.5A1.75 1.75 0 012 13.25V2.75zm10.44 4.5H6.75a.75.75 0 000 1.5h5.69l-1.97 1.97a.75.75 0 101.06 1.06l3.25-3.25a.75.75 0 000-1.06l-3.25-3.25a.75.75 0 10-1.06 1.06l1.97 1.97z”></path></svg> Sign out </button> </form></nav>

</div>

</div>

<notification-indicator class=”js-socket-channel” data-channel=”eyJjIjoibm90aWZpY2F0aW9uLWNoYW5nZWQ6MTM2Mzk3OTYiLCJ0IjoxNjEzNzA3ODUwfQ==–6840a4b716e09d0630bdc72dead4e9c427f233d6e2ff6f4e792dfe3879c58595”> <a href=”/notifications” class=”Header-link notification-indicator position-relative tooltipped tooltipped-sw”

aria-label=”You have no unread notifications” data-hotkey=”g n” data-ga-click=”Header, go to notifications, icon:read” data-target=”notification-indicator.link”> <span class=”mail-status ” data-target=”notification-indicator.modifier”></span> <svg class=”octicon octicon-bell” viewBox=”0 0 16 16” version=”1.1” width=”16” height=”16” aria-hidden=”true”><path d=”M8 16a2 2 0 001.985-1.75c.017-.137-.097-.25-.235-.25h-3.5c-.138 0-.252.113-.235.25A2 2 0 008 16z”></path><path fill-rule=”evenodd” d=”M8 1.5A3.5 3.5 0 004.5 5v2.947c0 .346-.102.683-.294.97l-1.703 2.556a.018.018 0 00-.003.01l.001.006c0 .002.002.004.004.006a.017.017 0 00.006.004l.007.001h10.964l.007-.001a.016.016 0 00.006-.004.016.016 0 00.004-.006l.001-.007a.017.017 0 00-.003-.01l-1.703-2.554a1.75 1.75 0 01-.294-.97V5A3.5 3.5 0 008 1.5zM3 5a5 5 0 0110 0v2.947c0 .05.015.098.042.139l1.703 2.555A1.518 1.518 0 0113.482 13H2.518a1.518 1.518 0 01-1.263-2.36l1.703-2.554A.25.25 0 003 7.947V5z”></path></svg> </a> </notification-indicator>

</div>

<a role=”menuitem” class=”dropdown-item” href=”/new” data-ga-click=”Header, create new repository”> New repository </a>

<a role=”menuitem” class=”dropdown-item” href=”/new/import” data-ga-click=”Header, import a repository”> Import repository </a>

<a role=”menuitem” class=”dropdown-item” href=”/organizations/new” data-ga-click=”Header, create new organization”> New organization </a>

<div role=”none” class=”dropdown-divider”></div> <div class=”dropdown-header”> <span title=”harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select”>This repository</span> </div> <a role=”menuitem” class=”dropdown-item” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/issues/new/choose” data-ga-click=”Header, create new issue” data-skip-pjax> New issue </a>

</details-menu> </details>

</div>

<summary class=”Header-link” aria-label=”View profile and more” data-ga-click=”Header, show menu, icon:avatar”> <img src=”https://avatars.githubusercontent.com/u/13639796?s=60&v=4” alt=”@harunobukameda” size=”20” class=”avatar avatar-user avatar–small ” height=”20” width=”20”></img> <span class=”feature-preview-indicator js-feature-preview-indicator” style=”top: 1px;” hidden></span> <span class=”dropdown-caret”></span> </summary> <details-menu class=”dropdown-menu dropdown-menu-sw” style=”width: 180px” src=”/users/13639796/menu” preload> <include-fragment> <p class=”text-center mt-3” data-hide-on-error> <svg style=”box-sizing: content-box; color: var(–color-icon-primary);” viewBox=”0 0 16 16” fill=”none” width=”32” height=”32”> <circle cx=”8” cy=”8” r=”7” stroke=”currentColor” stroke-opacity=”0.25” stroke-width=”2” vector-effect=”non-scaling-stroke” /> <path d=”M15 8a7.002 7.002 0 00-7-7” stroke=”currentColor” stroke-width=”2” stroke-linecap=”round” vector-effect=”non-scaling-stroke”> <animateTransform attributeName=”transform” type=”rotate” from=”0 8 8” to=”360 8 8” dur=”1s” repeatCount=”indefinite” /> </path> </svg> </p> <p class=”ml-1 mb-2 mt-2 text-gray-dark” data-show-on-error> <svg class=”octicon octicon-alert” viewBox=”0 0 16 16” version=”1.1” width=”16” height=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M8.22 1.754a.25.25 0 00-.44 0L1.698 13.132a.25.25 0 00.22.368h12.164a.25.25 0 00.22-.368L8.22 1.754zm-1.763-.707c.659-1.234 2.427-1.234 3.086 0l6.082 11.378A1.75 1.75 0 0114.082 15H1.918a1.75 1.75 0 01-1.543-2.575L6.457 1.047zM9 11a1 1 0 11-2 0 1 1 0 012 0zm-.25-5.25a.75.75 0 00-1.5 0v2.5a.75.75 0 001.5 0v-2.5z”></path></svg> Sorry, something went wrong. </p> </include-fragment> </details-menu> </details>

</div> </header>

</div>

<div>{{ message }}</div>

</div> </div> </template> </div>

<include-fragment class=”js-notification-shelf-include-fragment” data-base-src=”https://github.com/notifications/beta/shelf”></include-fragment>

<div class=”flex-auto min-width-0 width-fit mr-3”> <h1 class=” d-flex flex-wrap flex-items-center break-word f3 text-normal”> <svg class=”octicon octicon-repo text-gray mr-2” viewBox=”0 0 16 16” version=”1.1” width=”16” height=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M2 2.5A2.5 2.5 0 014.5 0h8.75a.75.75 0 01.75.75v12.5a.75.75 0 01-.75.75h-2.5a.75.75 0 110-1.5h1.75v-2h-8a1 1 0 00-.714 1.7.75.75 0 01-1.072 1.05A2.495 2.495 0 012 11.5v-9zm10.5-1V9h-8c-.356 0-.694.074-1 .208V2.5a1 1 0 011-1h8zM5 12.25v3.25a.25.25 0 00.4.2l1.45-1.087a.25.25 0 01.3 0L8.6 15.7a.25.25 0 00.4-.2v-3.25a.25.25 0 00-.25-.25h-3.5a.25.25 0 00-.25.25z”></path></svg> <span class=”author flex-self-stretch” itemprop=”author”> <a class=”url fn” rel=”author” data-hovercard-type=”user” data-hovercard-url=”/users/harunobukameda/hovercard” data-octo-click=”hovercard-link-click” data-octo-dimensions=”link_type:self” href=”/harunobukameda”>harunobukameda</a> </span> <span class=”mx-1 flex-self-stretch color-text-secondary”>/</span> <strong itemprop=”name” class=”mr-2 flex-self-stretch”> <a data-pjax=”#js-repo-pjax-container” class=”” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select”>Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select</a> </strong>

</h1>

</div>

<summary class=”btn btn-sm rounded-right-0” data-hydro-click=”{"event_type":"repository.click","payload":{"target":"WATCH_BUTTON","repository_id":281273144,"originating_url":"https://github.com/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/blob/master/3-minilake.yaml","user_id":13639796}}” data-hydro-click-hmac=”8c02ae45e610cc001b9fea8a1a03bc944a6e52d084d6e2d520af74b3107e43de” data-ga-click=”Repository, click Watch settings, action:blob#show” aria-label=”Notifications settings”> <span data-menu-button> <span hidden

data-target=”notifications-list-subscription-form.unwatchButtonCopy” > <svg class=”octicon octicon-eye” height=”16” viewBox=”0 0 16 16” version=”1.1” width=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M1.679 7.932c.412-.621 1.242-1.75 2.366-2.717C5.175 4.242 6.527 3.5 8 3.5c1.473 0 2.824.742 3.955 1.715 1.124.967 1.954 2.096 2.366 2.717a.119.119 0 010 .136c-.412.621-1.242 1.75-2.366 2.717C10.825 11.758 9.473 12.5 8 12.5c-1.473 0-2.824-.742-3.955-1.715C2.92 9.818 2.09 8.69 1.679 8.068a.119.119 0 010-.136zM8 2c-1.981 0-3.67.992-4.933 2.078C1.797 5.169.88 6.423.43 7.1a1.619 1.619 0 000 1.798c.45.678 1.367 1.932 2.637 3.024C4.329 13.008 6.019 14 8 14c1.981 0 3.67-.992 4.933-2.078 1.27-1.091 2.187-2.345 2.637-3.023a1.619 1.619 0 000-1.798c-.45-.678-1.367-1.932-2.637-3.023C11.671 2.992 9.981 2 8 2zm0 8a2 2 0 100-4 2 2 0 000 4z”></path></svg> Unwatch </span> <span hidden

data-target=”notifications-list-subscription-form.stopIgnoringButtonCopy” > <svg class=”octicon octicon-bell-slash” height=”16” viewBox=”0 0 16 16” version=”1.1” width=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M8 1.5c-.997 0-1.895.416-2.534 1.086A.75.75 0 014.38 1.55 5 5 0 0113 5v2.373a.75.75 0 01-1.5 0V5A3.5 3.5 0 008 1.5zM4.182 4.31L1.19 2.143a.75.75 0 10-.88 1.214L3 5.305v2.642a.25.25 0 01-.042.139L1.255 10.64A1.518 1.518 0 002.518 13h11.108l1.184.857a.75.75 0 10.88-1.214l-1.375-.996a1.196 1.196 0 00-.013-.01L4.198 4.321a.733.733 0 00-.016-.011zm7.373 7.19L4.5 6.391v1.556c0 .346-.102.683-.294.97l-1.703 2.556a.018.018 0 00-.003.01.015.015 0 00.005.012.017.017 0 00.006.004l.007.001h9.037zM8 16a2 2 0 001.985-1.75c.017-.137-.097-.25-.235-.25h-3.5c-.138 0-.252.113-.235.25A2 2 0 008 16z”></path></svg> Stop ignoring </span> <span

data-target=”notifications-list-subscription-form.watchButtonCopy” > <svg class=”octicon octicon-eye” height=”16” viewBox=”0 0 16 16” version=”1.1” width=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M1.679 7.932c.412-.621 1.242-1.75 2.366-2.717C5.175 4.242 6.527 3.5 8 3.5c1.473 0 2.824.742 3.955 1.715 1.124.967 1.954 2.096 2.366 2.717a.119.119 0 010 .136c-.412.621-1.242 1.75-2.366 2.717C10.825 11.758 9.473 12.5 8 12.5c-1.473 0-2.824-.742-3.955-1.715C2.92 9.818 2.09 8.69 1.679 8.068a.119.119 0 010-.136zM8 2c-1.981 0-3.67.992-4.933 2.078C1.797 5.169.88 6.423.43 7.1a1.619 1.619 0 000 1.798c.45.678 1.367 1.932 2.637 3.024C4.329 13.008 6.019 14 8 14c1.981 0 3.67-.992 4.933-2.078 1.27-1.091 2.187-2.345 2.637-3.023a1.619 1.619 0 000-1.798c-.45-.678-1.367-1.932-2.637-3.023C11.671 2.992 9.981 2 8 2zm0 8a2 2 0 100-4 2 2 0 000 4z”></path></svg> Watch </span> </span> <span class=”dropdown-caret”></span> </summary> <details-menu class=”SelectMenu ” role=”menu” data-target=”notifications-list-subscription-form.menu”

> <div class=”SelectMenu-modal notifications-component-menu-modal”> <header class=”SelectMenu-header”> <h3 class=”SelectMenu-title”>Notifications</h3> <button class=”SelectMenu-closeButton” type=”button” aria-label=”Close menu” data-action=”click:notifications-list-subscription-form#closeMenu”> <svg class=”octicon octicon-x” viewBox=”0 0 16 16” version=”1.1” width=”16” height=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M3.72 3.72a.75.75 0 011.06 0L8 6.94l3.22-3.22a.75.75 0 111.06 1.06L9.06 8l3.22 3.22a.75.75 0 11-1.06 1.06L8 9.06l-3.22 3.22a.75.75 0 01-1.06-1.06L6.94 8 3.72 4.78a.75.75 0 010-1.06z”></path></svg> </button> </header>

<button type=”submit” name=”do” value=”included” class=”SelectMenu-item flex-items-start” role=”menuitemradio” aria-checked=”true” data-targets=”notifications-list-subscription-form.subscriptionButtons”

> <span class=”f5”> <svg class=”octicon octicon-check SelectMenu-icon SelectMenu-icon–check” height=”16” viewBox=”0 0 16 16” version=”1.1” width=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M13.78 4.22a.75.75 0 010 1.06l-7.25 7.25a.75.75 0 01-1.06 0L2.22 9.28a.75.75 0 011.06-1.06L6 10.94l6.72-6.72a.75.75 0 011.06 0z”></path></svg> </span> <div> <div class=”f5 text-bold”> Participating and @mentions </div> <div class=”text-small text-gray text-normal pb-1”> Only receive notifications from this repository when participating or @mentioned. </div> </div> </button>

<button type=”submit” name=”do” value=”subscribed” class=”SelectMenu-item flex-items-start” role=”menuitemradio” aria-checked=”false” data-targets=”notifications-list-subscription-form.subscriptionButtons” > <span class=”f5”> <svg class=”octicon octicon-check SelectMenu-icon SelectMenu-icon–check” height=”16” viewBox=”0 0 16 16” version=”1.1” width=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M13.78 4.22a.75.75 0 010 1.06l-7.25 7.25a.75.75 0 01-1.06 0L2.22 9.28a.75.75 0 011.06-1.06L6 10.94l6.72-6.72a.75.75 0 011.06 0z”></path></svg> </span> <div> <div class=”f5 text-bold”> All Activity </div> <div class=”text-small text-gray text-normal pb-1”> Notified of all notifications on this repository. </div> </div> </button>

<button type=”submit” name=”do” value=”ignore” class=”SelectMenu-item flex-items-start” role=”menuitemradio” aria-checked=”false” data-targets=”notifications-list-subscription-form.subscriptionButtons” > <span class=”f5”> <svg class=”octicon octicon-check SelectMenu-icon SelectMenu-icon–check” height=”16” viewBox=”0 0 16 16” version=”1.1” width=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M13.78 4.22a.75.75 0 010 1.06l-7.25 7.25a.75.75 0 01-1.06 0L2.22 9.28a.75.75 0 011.06-1.06L6 10.94l6.72-6.72a.75.75 0 011.06 0z”></path></svg> </span> <div> <div class=”f5 text-bold”> Ignore </div> <div class=”text-small text-gray text-normal pb-1”> Never be notified. </div> </div> </button> </form> <button class=”SelectMenu-item flex-items-start pr-3” type=”button” role=”menuitemradio” data-target=”notifications-list-subscription-form.customButton” data-action=”click:notifications-list-subscription-form#openCustomDialog” aria-haspopup=”true” aria-checked=”false”

> <span class=”f5”> <svg class=”octicon octicon-check SelectMenu-icon SelectMenu-icon–check” height=”16” viewBox=”0 0 16 16” version=”1.1” width=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M13.78 4.22a.75.75 0 010 1.06l-7.25 7.25a.75.75 0 01-1.06 0L2.22 9.28a.75.75 0 011.06-1.06L6 10.94l6.72-6.72a.75.75 0 011.06 0z”></path></svg> </span> <div> <div class=”d-flex flex-items-start flex-justify-between”> <div class=”f5 text-bold”>Custom</div> <div class=”f5 pr-1”> <svg class=”octicon octicon-arrow-right” height=”16” viewBox=”0 0 16 16” version=”1.1” width=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M8.22 2.97a.75.75 0 011.06 0l4.25 4.25a.75.75 0 010 1.06l-4.25 4.25a.75.75 0 01-1.06-1.06l2.97-2.97H3.75a.75.75 0 010-1.5h7.44L8.22 4.03a.75.75 0 010-1.06z”></path></svg> </div> </div> <div class=”text-small text-gray text-normal pb-1”> Select events you want to be notified of in addition to participating and @mentions. </div> </div> </button> </div> </div> </details-menu>

<details-dialog class=”notifications-component-dialog ” data-target=”notifications-list-subscription-form.customDialog” hidden> <div class=”SelectMenu-modal notifications-component-dialog-modal overflow-visible”> <form data-target=”notifications-list-subscription-form.customform” data-action=”submit:notifications-list-subscription-form#submitCustomForm” action=”/notifications/subscribe” accept-charset=”UTF-8” method=”post”><input type=”hidden” name=”authenticity_token” value=”jEZPz+vc1MB9I1j8LrJCR70Fg3z4lSYlHWEHyXffs6o4RI0TWBI4tYEDZNyy+gL9UoPjYJSp5TS6kua0hFZ+5Q==” />

<header class=”d-sm-none SelectMenu-header pb-0 border-bottom-0 px-2 px-sm-3”> <h1 class=”f3 SelectMenu-title d-inline-flex”> <button class=”bg-white border-0 px-2 py-0 m-0 link-gray f5” aria-label=”Return to menu” type=”button” data-action=”click:notifications-list-subscription-form#closeCustomDialog” > <svg style=”” class=”octicon octicon-arrow-left” height=”16” viewBox=”0 0 16 16” version=”1.1” width=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M7.78 12.53a.75.75 0 01-1.06 0L2.47 8.28a.75.75 0 010-1.06l4.25-4.25a.75.75 0 011.06 1.06L4.81 7h7.44a.75.75 0 010 1.5H4.81l2.97 2.97a.75.75 0 010 1.06z”></path></svg> </button> Custom </h3> </header>

<h1 class=”pt-1 pr-4 pb-0 pl-0 f5 text-bold”> Custom </h1> </header>

<fieldset> <legend> <div class=”text-small text-gray pt-0 pr-3 pb-3 pl-6 pl-sm-5 border-bottom mb-3”> Select events you want to be notified of in addition to participating and @mentions. </div> </legend> <div class=”form-checkbox mr-3 ml-6 ml-sm-5 mb-2 mt-0”> <label class=”f5 text-normal”> <input type=”checkbox” name=”thread_types[]” value=”Issue” data-targets=”notifications-list-subscription-form.threadTypeCheckboxes” data-action=”change:notifications-list-subscription-form#threadTypeCheckboxesUpdated”

> Issues </label>

</div> <div class=”form-checkbox mr-3 ml-6 ml-sm-5 mb-2 mt-0”> <label class=”f5 text-normal”> <input type=”checkbox” name=”thread_types[]” value=”PullRequest” data-targets=”notifications-list-subscription-form.threadTypeCheckboxes” data-action=”change:notifications-list-subscription-form#threadTypeCheckboxesUpdated”

> Pull requests </label>

</div> <div class=”form-checkbox mr-3 ml-6 ml-sm-5 mb-2 mt-0”> <label class=”f5 text-normal”> <input type=”checkbox” name=”thread_types[]” value=”Release” data-targets=”notifications-list-subscription-form.threadTypeCheckboxes” data-action=”change:notifications-list-subscription-form#threadTypeCheckboxesUpdated”

> Releases </label>

</div> <div class=”form-checkbox mr-3 ml-6 ml-sm-5 mb-2 mt-0”> <label class=”f5 text-normal”> <input type=”checkbox” name=”thread_types[]” value=”Discussion” data-targets=”notifications-list-subscription-form.threadTypeCheckboxes” data-action=”change:notifications-list-subscription-form#threadTypeCheckboxesUpdated”

> Discussions </label>

<span class=”tooltipped tooltipped-nw mr-2 p-1 float-right”

aria-label=”Discussions are not enabled for this repo”> <svg style=”fill: var(–color-icon-tertiary)” class=”octicon octicon-info” viewBox=”0 0 16 16” version=”1.1” width=”16” height=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M8 1.5a6.5 6.5 0 100 13 6.5 6.5 0 000-13zM0 8a8 8 0 1116 0A8 8 0 010 8zm6.5-.25A.75.75 0 017.25 7h1a.75.75 0 01.75.75v2.75h.25a.75.75 0 010 1.5h-2a.75.75 0 010-1.5h.25v-2h-.25a.75.75 0 01-.75-.75zM8 6a1 1 0 100-2 1 1 0 000 2z”></path></svg> </span> </div> </fieldset> <div class=”pt-2 pb-3 px-3 d-flex flex-justify-start flex-row-reverse”> <button type=”submit” name=”do” value=”custom” class=”btn btn-sm btn-primary ml-2” data-target=”notifications-list-subscription-form.customSubmit” disabled >Apply</button>

<button class=”btn btn-sm” type=”button” data-action=”click:notifications-list-subscription-form#resetForm” data-close-dialog=”“>Cancel</button> </div> </form> </div> </details-dialog> <div class=”notifications-component-dialog-overlay”></div> </details> <a class=”social-count” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/watchers” aria-label=”1 user is watching this repository” data-target=”notifications-list-subscription-form.socialCount” > 1 </a> </notifications-list-subscription-form>

</li>

<li> <div class=”d-block js-toggler-container js-social-container starring-container “> <form class=”starred js-social-form” action=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/unstar” accept-charset=”UTF-8” method=”post”><input type=”hidden” name=”authenticity_token” value=”F4cDLy7MP0mqjtPkOKgm9eXobqKsbDn8CFFwgm/4MA0JsTSnt68KsqQsx7JuMhjhxKRtE3ZWlrLqtKj/z0CGSQ==” /> <input type=”hidden” name=”context” value=”repository”> <button type=”submit” class=”btn btn-sm btn-with-count js-toggler-target” aria-label=”Unstar this repository” title=”Unstar harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select” data-hydro-click=”{"event_type":"repository.click","payload":{"target":"UNSTAR_BUTTON","repository_id":281273144,"originating_url":"https://github.com/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/blob/master/3-minilake.yaml","user_id":13639796}}” data-hydro-click-hmac=”b6048eeafe72daef2925498e5a97485e6592e811e0334f8394503408af700528” data-ga-click=”Repository, click unstar button, action:blob#show; text:Unstar”> <svg class=”octicon octicon-star-fill mr-1” height=”16” viewBox=”0 0 16 16” version=”1.1” width=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M8 .25a.75.75 0 01.673.418l1.882 3.815 4.21.612a.75.75 0 01.416 1.279l-3.046 2.97.719 4.192a.75.75 0 01-1.088.791L8 12.347l-3.766 1.98a.75.75 0 01-1.088-.79l.72-4.194L.818 6.374a.75.75 0 01.416-1.28l4.21-.611L7.327.668A.75.75 0 018 .25z”></path></svg> <span> Unstar </span></button> <a class=”social-count js-social-count” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/stargazers” aria-label=”12 users starred this repository”> 12 </a> </form> <form class=”unstarred js-social-form” action=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/star” accept-charset=”UTF-8” method=”post”><input type=”hidden” name=”authenticity_token” value=”24RovRfj/1z0JLw+UCt6355mEC4C0zVgUn8tulh+gFHuWDAoSuhfdQwAe7/2d+cV4gLUj3NWnNEG0E3+oV8Nqg==” /> <input type=”hidden” name=”context” value=”repository”> <button type=”submit” class=”btn btn-sm btn-with-count js-toggler-target” aria-label=”Unstar this repository” title=”Star harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select” data-hydro-click=”{"event_type":"repository.click","payload":{"target":"STAR_BUTTON","repository_id":281273144,"originating_url":"https://github.com/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/blob/master/3-minilake.yaml","user_id":13639796}}” data-hydro-click-hmac=”8f9fe94584ec864cb47c38d7af7f0093a635005a4685f2c2f50a781786ea2fff” data-ga-click=”Repository, click star button, action:blob#show; text:Star”> <svg class=”octicon octicon-star mr-1” height=”16” viewBox=”0 0 16 16” version=”1.1” width=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M8 .25a.75.75 0 01.673.418l1.882 3.815 4.21.612a.75.75 0 01.416 1.279l-3.046 2.97.719 4.192a.75.75 0 01-1.088.791L8 12.347l-3.766 1.98a.75.75 0 01-1.088-.79l.72-4.194L.818 6.374a.75.75 0 01.416-1.28l4.21-.611L7.327.668A.75.75 0 018 .25zm0 2.445L6.615 5.5a.75.75 0 01-.564.41l-3.097.45 2.24 2.184a.75.75 0 01.216.664l-.528 3.084 2.769-1.456a.75.75 0 01.698 0l2.77 1.456-.53-3.084a.75.75 0 01.216-.664l2.24-2.183-3.096-.45a.75.75 0 01-.564-.41L8 2.694v.001z”></path></svg> <span> Star </span></button> <a class=”social-count js-social-count” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/stargazers” aria-label=”12 users starred this repository”> 12 </a> </form> </div>

</li>

</div>

</li> <li class=”d-flex”> <a class=”js-selected-navigation-item UnderlineNav-item hx_underlinenav-item no-wrap js-responsive-underlinenav-item” data-tab-item=”i1issues-tab” data-hotkey=”g i” data-ga-click=”Repository, Navigation click, Issues tab” data-selected-links=”repo_issues repo_labels repo_milestones /harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/issues” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/issues”> <svg class=”octicon octicon-issue-opened UnderlineNav-octicon d-none d-sm-inline” height=”16” viewBox=”0 0 16 16” version=”1.1” width=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M8 1.5a6.5 6.5 0 100 13 6.5 6.5 0 000-13zM0 8a8 8 0 1116 0A8 8 0 010 8zm9 3a1 1 0 11-2 0 1 1 0 012 0zm-.25-6.25a.75.75 0 00-1.5 0v3.5a.75.75 0 001.5 0v-3.5z”></path></svg> <span data-content=”Issues”>Issues</span> <span title=”1” class=”Counter “>1</span> </a>

</li> <li class=”d-flex”> <a class=”js-selected-navigation-item UnderlineNav-item hx_underlinenav-item no-wrap js-responsive-underlinenav-item” data-tab-item=”i2pull-requests-tab” data-hotkey=”g p” data-ga-click=”Repository, Navigation click, Pull requests tab” data-selected-links=”repo_pulls checks /harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/pulls” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/pulls”> <svg class=”octicon octicon-git-pull-request UnderlineNav-octicon d-none d-sm-inline” height=”16” viewBox=”0 0 16 16” version=”1.1” width=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M7.177 3.073L9.573.677A.25.25 0 0110 .854v4.792a.25.25 0 01-.427.177L7.177 3.427a.25.25 0 010-.354zM3.75 2.5a.75.75 0 100 1.5.75.75 0 000-1.5zm-2.25.75a2.25 2.25 0 113 2.122v5.256a2.251 2.251 0 11-1.5 0V5.372A2.25 2.25 0 011.5 3.25zM11 2.5h-1V4h1a1 1 0 011 1v5.628a2.251 2.251 0 101.5 0V5A2.5 2.5 0 0011 2.5zm1 10.25a.75.75 0 111.5 0 .75.75 0 01-1.5 0zM3.75 12a.75.75 0 100 1.5.75.75 0 000-1.5z”></path></svg> <span data-content=”Pull requests”>Pull requests</span> <span title=”0” hidden=”hidden” class=”Counter “>0</span> </a>

</li> <li class=”d-flex”> <a class=”js-selected-navigation-item UnderlineNav-item hx_underlinenav-item no-wrap js-responsive-underlinenav-item” data-tab-item=”i3actions-tab” data-hotkey=”g a” data-ga-click=”Repository, Navigation click, Actions tab” data-selected-links=”repo_actions /harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/actions” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/actions”> <svg class=”octicon octicon-play UnderlineNav-octicon d-none d-sm-inline” height=”16” viewBox=”0 0 16 16” version=”1.1” width=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M1.5 8a6.5 6.5 0 1113 0 6.5 6.5 0 01-13 0zM8 0a8 8 0 100 16A8 8 0 008 0zM6.379 5.227A.25.25 0 006 5.442v5.117a.25.25 0 00.379.214l4.264-2.559a.25.25 0 000-.428L6.379 5.227z”></path></svg> <span data-content=”Actions”>Actions</span> <span title=”Not available” class=”Counter “></span> </a>

</li> <li class=”d-flex”> <a class=”js-selected-navigation-item UnderlineNav-item hx_underlinenav-item no-wrap js-responsive-underlinenav-item” data-tab-item=”i4projects-tab” data-hotkey=”g b” data-ga-click=”Repository, Navigation click, Projects tab” data-selected-links=”repo_projects new_repo_project repo_project /harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/projects” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/projects”> <svg class=”octicon octicon-project UnderlineNav-octicon d-none d-sm-inline” height=”16” viewBox=”0 0 16 16” version=”1.1” width=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M1.75 0A1.75 1.75 0 000 1.75v12.5C0 15.216.784 16 1.75 16h12.5A1.75 1.75 0 0016 14.25V1.75A1.75 1.75 0 0014.25 0H1.75zM1.5 1.75a.25.25 0 01.25-.25h12.5a.25.25 0 01.25.25v12.5a.25.25 0 01-.25.25H1.75a.25.25 0 01-.25-.25V1.75zM11.75 3a.75.75 0 00-.75.75v7.5a.75.75 0 001.5 0v-7.5a.75.75 0 00-.75-.75zm-8.25.75a.75.75 0 011.5 0v5.5a.75.75 0 01-1.5 0v-5.5zM8 3a.75.75 0 00-.75.75v3.5a.75.75 0 001.5 0v-3.5A.75.75 0 008 3z”></path></svg> <span data-content=”Projects”>Projects</span> <span title=”0” hidden=”hidden” class=”Counter “>0</span> </a>

</li> <li class=”d-flex”> <a class=”js-selected-navigation-item UnderlineNav-item hx_underlinenav-item no-wrap js-responsive-underlinenav-item” data-tab-item=”i5wiki-tab” data-hotkey=”g w” data-ga-click=”Repository, Navigation click, Wikis tab” data-selected-links=”repo_wiki /harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/wiki” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/wiki”> <svg class=”octicon octicon-book UnderlineNav-octicon d-none d-sm-inline” height=”16” viewBox=”0 0 16 16” version=”1.1” width=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M0 1.75A.75.75 0 01.75 1h4.253c1.227 0 2.317.59 3 1.501A3.744 3.744 0 0111.006 1h4.245a.75.75 0 01.75.75v10.5a.75.75 0 01-.75.75h-4.507a2.25 2.25 0 00-1.591.659l-.622.621a.75.75 0 01-1.06 0l-.622-.621A2.25 2.25 0 005.258 13H.75a.75.75 0 01-.75-.75V1.75zm8.755 3a2.25 2.25 0 012.25-2.25H14.5v9h-3.757c-.71 0-1.4.201-1.992.572l.004-7.322zm-1.504 7.324l.004-5.073-.002-2.253A2.25 2.25 0 005.003 2.5H1.5v9h3.757a3.75 3.75 0 011.994.574z”></path></svg> <span data-content=”Wiki”>Wiki</span> <span title=”Not available” class=”Counter “></span> </a>

</li> <li class=”d-flex”> <a class=”js-selected-navigation-item UnderlineNav-item hx_underlinenav-item no-wrap js-responsive-underlinenav-item” data-tab-item=”i6security-tab” data-hotkey=”g s” data-ga-click=”Repository, Navigation click, Security tab” data-selected-links=”security overview alerts policy token_scanning code_scanning /harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/security” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/security”> <svg class=”octicon octicon-shield UnderlineNav-octicon d-none d-sm-inline” height=”16” viewBox=”0 0 16 16” version=”1.1” width=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M7.467.133a1.75 1.75 0 011.066 0l5.25 1.68A1.75 1.75 0 0115 3.48V7c0 1.566-.32 3.182-1.303 4.682-.983 1.498-2.585 2.813-5.032 3.855a1.7 1.7 0 01-1.33 0c-2.447-1.042-4.049-2.357-5.032-3.855C1.32 10.182 1 8.566 1 7V3.48a1.75 1.75 0 011.217-1.667l5.25-1.68zm.61 1.429a.25.25 0 00-.153 0l-5.25 1.68a.25.25 0 00-.174.238V7c0 1.358.275 2.666 1.057 3.86.784 1.194 2.121 2.34 4.366 3.297a.2.2 0 00.154 0c2.245-.956 3.582-2.104 4.366-3.298C13.225 9.666 13.5 8.36 13.5 7V3.48a.25.25 0 00-.174-.237l-5.25-1.68zM9 10.5a1 1 0 11-2 0 1 1 0 012 0zm-.25-5.75a.75.75 0 10-1.5 0v3a.75.75 0 001.5 0v-3z”></path></svg> <span data-content=”Security”>Security</span> <include-fragment src=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/security/overall-count” accept=”text/fragment+html”></include-fragment> </a>

</li> <li class=”d-flex”> <a class=”js-selected-navigation-item UnderlineNav-item hx_underlinenav-item no-wrap js-responsive-underlinenav-item” data-tab-item=”i7insights-tab” data-ga-click=”Repository, Navigation click, Insights tab” data-selected-links=”repo_graphs repo_contributors dependency_graph dependabot_updates pulse people /harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/pulse” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/pulse”> <svg class=”octicon octicon-graph UnderlineNav-octicon d-none d-sm-inline” height=”16” viewBox=”0 0 16 16” version=”1.1” width=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M1.5 1.75a.75.75 0 00-1.5 0v12.5c0 .414.336.75.75.75h14.5a.75.75 0 000-1.5H1.5V1.75zm14.28 2.53a.75.75 0 00-1.06-1.06L10 7.94 7.53 5.47a.75.75 0 00-1.06 0L3.22 8.72a.75.75 0 001.06 1.06L7 7.06l2.47 2.47a.75.75 0 001.06 0l5.25-5.25z”></path></svg> <span data-content=”Insights”>Insights</span> <span title=”Not available” class=”Counter “></span> </a>

</li> <li class=”d-flex”> <a class=”js-selected-navigation-item UnderlineNav-item hx_underlinenav-item no-wrap js-responsive-underlinenav-item” data-tab-item=”i8settings-tab” data-ga-click=”Repository, Navigation click, Settings tab” data-selected-links=”repo_settings repo_branch_settings hooks integration_installations repo_keys_settings issue_template_editor secrets_settings key_links_settings repo_actions_settings notifications repository_environments /harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/settings” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/settings”> <svg class=”octicon octicon-gear UnderlineNav-octicon d-none d-sm-inline” height=”16” viewBox=”0 0 16 16” version=”1.1” width=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M7.429 1.525a6.593 6.593 0 011.142 0c.036.003.108.036.137.146l.289 1.105c.147.56.55.967.997 1.189.174.086.341.183.501.29.417.278.97.423 1.53.27l1.102-.303c.11-.03.175.016.195.046.219.31.41.641.573.989.014.031.022.11-.059.19l-.815.806c-.411.406-.562.957-.53 1.456a4.588 4.588 0 010 .582c-.032.499.119 1.05.53 1.456l.815.806c.08.08.073.159.059.19a6.494 6.494 0 01-.573.99c-.02.029-.086.074-.195.045l-1.103-.303c-.559-.153-1.112-.008-1.529.27-.16.107-.327.204-.5.29-.449.222-.851.628-.998 1.189l-.289 1.105c-.029.11-.101.143-.137.146a6.613 6.613 0 01-1.142 0c-.036-.003-.108-.037-.137-.146l-.289-1.105c-.147-.56-.55-.967-.997-1.189a4.502 4.502 0 01-.501-.29c-.417-.278-.97-.423-1.53-.27l-1.102.303c-.11.03-.175-.016-.195-.046a6.492 6.492 0 01-.573-.989c-.014-.031-.022-.11.059-.19l.815-.806c.411-.406.562-.957.53-1.456a4.587 4.587 0 010-.582c.032-.499-.119-1.05-.53-1.456l-.815-.806c-.08-.08-.073-.159-.059-.19a6.44 6.44 0 01.573-.99c.02-.029.086-.075.195-.045l1.103.303c.559.153 1.112.008 1.529-.27.16-.107.327-.204.5-.29.449-.222.851-.628.998-1.189l.289-1.105c.029-.11.101-.143.137-.146zM8 0c-.236 0-.47.01-.701.03-.743.065-1.29.615-1.458 1.261l-.29 1.106c-.017.066-.078.158-.211.224a5.994 5.994 0 00-.668.386c-.123.082-.233.09-.3.071L3.27 2.776c-.644-.177-1.392.02-1.82.63a7.977 7.977 0 00-.704 1.217c-.315.675-.111 1.422.363 1.891l.815.806c.05.048.098.147.088.294a6.084 6.084 0 000 .772c.01.147-.038.246-.088.294l-.815.806c-.474.469-.678 1.216-.363 1.891.2.428.436.835.704 1.218.428.609 1.176.806 1.82.63l1.103-.303c.066-.019.176-.011.299.071.213.143.436.272.668.386.133.066.194.158.212.224l.289 1.106c.169.646.715 1.196 1.458 1.26a8.094 8.094 0 001.402 0c.743-.064 1.29-.614 1.458-1.26l.29-1.106c.017-.066.078-.158.211-.224a5.98 5.98 0 00.668-.386c.123-.082.233-.09.3-.071l1.102.302c.644.177 1.392-.02 1.82-.63.268-.382.505-.789.704-1.217.315-.675.111-1.422-.364-1.891l-.814-.806c-.05-.048-.098-.147-.088-.294a6.1 6.1 0 000-.772c-.01-.147.039-.246.088-.294l.814-.806c.475-.469.679-1.216.364-1.891a7.992 7.992 0 00-.704-1.218c-.428-.609-1.176-.806-1.82-.63l-1.103.303c-.066.019-.176.011-.299-.071a5.991 5.991 0 00-.668-.386c-.133-.066-.194-.158-.212-.224L10.16 1.29C9.99.645 9.444.095 8.701.031A8.094 8.094 0 008 0zm1.5 8a1.5 1.5 0 11-3 0 1.5 1.5 0 013 0zM11 8a3 3 0 11-6 0 3 3 0 016 0z”></path></svg> <span data-content=”Settings”>Settings</span> <span title=”Not available” class=”Counter “></span> </a>

</li>

</ul> <div class=”position-absolute right-0 pr-3 pr-md-4 pr-lg-5 js-responsive-underlinenav-overflow” style=”visibility:hidden;”> <details class=”details-overlay details-reset position-relative”> <summary role=”button”> <div class=”UnderlineNav-item mr-0 border-0”> <svg class=”octicon octicon-kebab-horizontal” viewBox=”0 0 16 16” version=”1.1” width=”16” height=”16” aria-hidden=”true”><path d=”M8 9a1.5 1.5 0 100-3 1.5 1.5 0 000 3zM1.5 9a1.5 1.5 0 100-3 1.5 1.5 0 000 3zm13 0a1.5 1.5 0 100-3 1.5 1.5 0 000 3z”></path></svg> <span class=”sr-only”>More</span> </div> </summary> <div> <details-menu role=”menu” class=”dropdown-menu dropdown-menu-sw “>

<ul> <li data-menu-item=”i0code-tab” hidden> <a role=”menuitem” class=”js-selected-navigation-item dropdown-item” data-selected-links=” /harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select”> Code </a> </li> <li data-menu-item=”i1issues-tab” hidden> <a role=”menuitem” class=”js-selected-navigation-item dropdown-item” data-selected-links=” /harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/issues” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/issues”> Issues </a> </li> <li data-menu-item=”i2pull-requests-tab” hidden> <a role=”menuitem” class=”js-selected-navigation-item dropdown-item” data-selected-links=” /harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/pulls” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/pulls”> Pull requests </a> </li> <li data-menu-item=”i3actions-tab” hidden> <a role=”menuitem” class=”js-selected-navigation-item dropdown-item” data-selected-links=” /harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/actions” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/actions”> Actions </a> </li> <li data-menu-item=”i4projects-tab” hidden> <a role=”menuitem” class=”js-selected-navigation-item dropdown-item” data-selected-links=” /harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/projects” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/projects”> Projects </a> </li> <li data-menu-item=”i5wiki-tab” hidden> <a role=”menuitem” class=”js-selected-navigation-item dropdown-item” data-selected-links=” /harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/wiki” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/wiki”> Wiki </a> </li> <li data-menu-item=”i6security-tab” hidden> <a role=”menuitem” class=”js-selected-navigation-item dropdown-item” data-selected-links=” /harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/security” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/security”> Security </a> </li> <li data-menu-item=”i7insights-tab” hidden> <a role=”menuitem” class=”js-selected-navigation-item dropdown-item” data-selected-links=” /harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/pulse” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/pulse”> Insights </a> </li> <li data-menu-item=”i8settings-tab” hidden> <a role=”menuitem” class=”js-selected-navigation-item dropdown-item” data-selected-links=” /harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/settings” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/settings”> Settings </a> </li> </ul>

</details-menu> </div></details> </div>

</nav> </div>

<div>

<a class=”d-none js-permalink-shortcut” data-hotkey=”y” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/blob/e64fc860b51963d3ed71481e7807deb2a42f910a/3-minilake.yaml”>Permalink</a>

<!– blob contrib key: blob_contributors:v22:e4e7757a173356be8bd671039c6311cb316955ae1328abbe7db6adab0df9ea9b –>

<div class=”position-relative”> <details class=”details-reset details-overlay mr-0 mb-0 ” id=”branch-select-menu”> <summary class=”btn css-truncate” data-hotkey=”w” title=”Switch branches or tags”> <svg class=”octicon octicon-git-branch text-gray” height=”16” viewBox=”0 0 16 16” version=”1.1” width=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M11.75 2.5a.75.75 0 100 1.5.75.75 0 000-1.5zm-2.25.75a2.25 2.25 0 113 2.122V6A2.5 2.5 0 0110 8.5H6a1 1 0 00-1 1v1.128a2.251 2.251 0 11-1.5 0V5.372a2.25 2.25 0 111.5 0v1.836A2.492 2.492 0 016 7h4a1 1 0 001-1v-.628A2.25 2.25 0 019.5 3.25zM4.25 12a.75.75 0 100 1.5.75.75 0 000-1.5zM3.5 3.25a.75.75 0 111.5 0 .75.75 0 01-1.5 0z”></path></svg> <span class=”css-truncate-target” data-menu-button>master</span> <span class=”dropdown-caret”></span> </summary>

<div class=”SelectMenu”> <div class=”SelectMenu-modal”> <header class=”SelectMenu-header”> <span class=”SelectMenu-title”>Switch branches/tags</span> <button class=”SelectMenu-closeButton” type=”button” data-toggle-for=”branch-select-menu”><svg aria-label=”Close menu” aria-hidden=”false” class=”octicon octicon-x” height=”16” viewBox=”0 0 16 16” version=”1.1” width=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M3.72 3.72a.75.75 0 011.06 0L8 6.94l3.22-3.22a.75.75 0 111.06 1.06L9.06 8l3.22 3.22a.75.75 0 11-1.06 1.06L8 9.06l-3.22 3.22a.75.75 0 01-1.06-1.06L6.94 8 3.72 4.78a.75.75 0 010-1.06z”></path></svg></button> </header>

<input-demux data-action=”tab-container-change:input-demux#storeInput tab-container-changed:input-demux#updateInput”> <tab-container class=”d-flex flex-column js-branches-tags-tabs” style=”min-height: 0;”> <div class=”SelectMenu-filter”> <input data-target=”input-demux.source” id=”context-commitish-filter-field” class=”SelectMenu-input form-control” aria-owns=”ref-list-branches” data-controls-ref-menu-id=”ref-list-branches” autofocus autocomplete=”off” aria-label=”Find or create a branch…” placeholder=”Find or create a branch…” type=”text” > </div>

<div class=”SelectMenu-tabs” role=”tablist” data-target=”input-demux.control”> <button class=”SelectMenu-tab” type=”button” role=”tab” aria-selected=”true”>Branches</button> <button class=”SelectMenu-tab” type=”button” role=”tab”>Tags</button> </div>

<button class=”SelectMenu-item break-word” type=”submit” role=”menuitem” data-index=”{{ index }}”> <svg class=”octicon octicon-git-branch SelectMenu-icon flex-self-baseline” viewBox=”0 0 16 16” version=”1.1” width=”16” height=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M11.75 2.5a.75.75 0 100 1.5.75.75 0 000-1.5zm-2.25.75a2.25 2.25 0 113 2.122V6A2.5 2.5 0 0110 8.5H6a1 1 0 00-1 1v1.128a2.251 2.251 0 11-1.5 0V5.372a2.25 2.25 0 111.5 0v1.836A2.492 2.492 0 016 7h4a1 1 0 001-1v-.628A2.25 2.25 0 019.5 3.25zM4.25 12a.75.75 0 100 1.5.75.75 0 000-1.5zM3.5 3.25a.75.75 0 111.5 0 .75.75 0 01-1.5 0z”></path></svg> <div> <span class=”text-bold”>Create branch: {{ refName }}</span> <span class=”text-gray-light”>from ‘master’</span> </div> </button> </form> </template>

<!– TODO: this max-height is necessary or else the branch list won’t scroll. why? –> <div data-target=”ref-selector.listContainer” role=”menu” class=”SelectMenu-list” style=”max-height: 330px”> <div class=”SelectMenu-loading pt-3 pb-0” aria-label=”Menu is loading”> <svg style=”box-sizing: content-box; color: var(–color-icon-primary);” viewBox=”0 0 16 16” fill=”none” width=”32” height=”32”> <circle cx=”8” cy=”8” r=”7” stroke=”currentColor” stroke-opacity=”0.25” stroke-width=”2” vector-effect=”non-scaling-stroke” /> <path d=”M15 8a7.002 7.002 0 00-7-7” stroke=”currentColor” stroke-width=”2” stroke-linecap=”round” vector-effect=”non-scaling-stroke”> <animateTransform attributeName=”transform” type=”rotate” from=”0 8 8” to=”360 8 8” dur=”1s” repeatCount=”indefinite” /> </path> </svg> </div> </div>

<template data-target=”ref-selector.itemTemplate”> <a href=”https://github.com/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/blob/{{ urlEncodedRefName }}/3-minilake.yaml” class=”SelectMenu-item” role=”menuitemradio” rel=”nofollow” aria-checked=”{{ isCurrent }}” data-index=”{{ index }}”> <svg class=”octicon octicon-check SelectMenu-icon SelectMenu-icon–check” viewBox=”0 0 16 16” version=”1.1” width=”16” height=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M13.78 4.22a.75.75 0 010 1.06l-7.25 7.25a.75.75 0 01-1.06 0L2.22 9.28a.75.75 0 011.06-1.06L6 10.94l6.72-6.72a.75.75 0 011.06 0z”></path></svg> <span class=”flex-1 css-truncate css-truncate-overflow {{ isFilteringClass }}”>{{ refName }}</span> <span hidden=”{{ isNotDefault }}” class=”Label Label–secondary flex-self-start”>default</span> </a> </template> <footer class=”SelectMenu-footer”><a href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/branches”>View all branches</a></footer> </ref-selector>

</div>

<template data-target=”ref-selector.noMatchTemplate”> <div class=”SelectMenu-message” data-index=”{{ index }}”>Nothing to show</div> </template>

<template data-target=”ref-selector.itemTemplate”> <a href=”https://github.com/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/blob/{{ urlEncodedRefName }}/3-minilake.yaml” class=”SelectMenu-item” role=”menuitemradio” rel=”nofollow” aria-checked=”{{ isCurrent }}” data-index=”{{ index }}”> <svg class=”octicon octicon-check SelectMenu-icon SelectMenu-icon–check” viewBox=”0 0 16 16” version=”1.1” width=”16” height=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M13.78 4.22a.75.75 0 010 1.06l-7.25 7.25a.75.75 0 01-1.06 0L2.22 9.28a.75.75 0 011.06-1.06L6 10.94l6.72-6.72a.75.75 0 011.06 0z”></path></svg> <span class=”flex-1 css-truncate css-truncate-overflow {{ isFilteringClass }}”>{{ refName }}</span> <span hidden=”{{ isNotDefault }}” class=”Label Label–secondary flex-self-start”>default</span> </a> </template> <div data-target=”ref-selector.listContainer” role=”menu” class=”SelectMenu-list” style=”max-height: 330px”> <div class=”SelectMenu-loading pt-3 pb-0” aria-label=”Menu is loading”> <svg style=”box-sizing: content-box; color: var(–color-icon-primary);” viewBox=”0 0 16 16” fill=”none” width=”32” height=”32”> <circle cx=”8” cy=”8” r=”7” stroke=”currentColor” stroke-opacity=”0.25” stroke-width=”2” vector-effect=”non-scaling-stroke” /> <path d=”M15 8a7.002 7.002 0 00-7-7” stroke=”currentColor” stroke-width=”2” stroke-linecap=”round” vector-effect=”non-scaling-stroke”> <animateTransform attributeName=”transform” type=”rotate” from=”0 8 8” to=”360 8 8” dur=”1s” repeatCount=”indefinite” /> </path> </svg> </div> </div> <footer class=”SelectMenu-footer”><a href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/tags”>View all tags</a></footer> </ref-selector> </div> </tab-container> </input-demux> </div> </div>

</details>

</div>

<h2 id=”blob-path” class=”breadcrumb flex-auto min-width-0 text-normal mx-0 mx-md-3 width-full width-md-auto flex-order-1 flex-md-order-none mt-3 mt-md-0”> <span class=”js-repo-root text-bold”><span class=”js-path-segment d-inline-block wb-break-all”><a data-pjax=”true” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select”><span>Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select</span></a></span></span><span class=”separator”>/</span><strong class=”final-path”>3-minilake.yaml</strong> </h2> <a href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/find/master” class=”js-pjax-capture-input btn mr-2 d-none d-md-block” data-pjax data-hotkey=”t”> Go to file </a>

<div class=”Box-header Box-header–blue Details js-details-container”> <div class=”d-flex flex-items-center”> <span class=”flex-shrink-0 ml-n1 mr-n1 mt-n1 mb-n1”> <a rel=”author” data-skip-pjax=”true” data-hovercard-type=”user” data-hovercard-url=”/users/harunobukameda/hovercard” data-octo-click=”hovercard-link-click” data-octo-dimensions=”link_type:self” href=”/harunobukameda”><img class=”avatar avatar-user” src=”https://avatars.githubusercontent.com/u/13639796?s=48&v=4” width=”24” height=”24” alt=”@harunobukameda” /></a> </span> <div class=”flex-1 d-flex flex-items-center ml-3 min-width-0”> <div class=”css-truncate css-truncate-overflow”> <a class=”text-bold link-gray-dark” rel=”author” data-hovercard-type=”user” data-hovercard-url=”/users/harunobukameda/hovercard” data-octo-click=”hovercard-link-click” data-octo-dimensions=”link_type:self” href=”/harunobukameda”>harunobukameda</a>

<span> <a data-pjax=”true” title=”Add files via upload” class=”link-gray” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/commit/95a97326d140fdd7184bab770c519db381f31051”>Add files via upload</a> </span> </div>

<span class=”ml-2”> <include-fragment accept=”text/fragment+html” src=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/commit/95a97326d140fdd7184bab770c519db381f31051/rollup?direction=e” class=”d-inline”></include-fragment> </span> </div> <div class=”ml-3 d-flex flex-shrink-0 flex-items-center flex-justify-end text-gray no-wrap”> <span class=”d-none d-md-inline”> <span>Latest commit</span> <a class=”text-small text-mono link-gray” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/commit/95a97326d140fdd7184bab770c519db381f31051” data-pjax>95a9732</a> <span itemprop=”dateModified”><relative-time datetime=”2020-07-21T02:19:17Z” class=”no-wrap”>Jul 21, 2020</relative-time></span> </span>

<a data-pjax href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/commits/master/3-minilake.yaml” class=”ml-3 no-wrap link-gray-dark no-underline”> <svg class=”octicon octicon-history text-gray” height=”16” viewBox=”0 0 16 16” version=”1.1” width=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M1.643 3.143L.427 1.927A.25.25 0 000 2.104V5.75c0 .138.112.25.25.25h3.646a.25.25 0 00.177-.427L2.715 4.215a6.5 6.5 0 11-1.18 4.458.75.75 0 10-1.493.154 8.001 8.001 0 101.6-5.684zM7.75 4a.75.75 0 01.75.75v2.992l2.028.812a.75.75 0 01-.557 1.392l-2.5-1A.75.75 0 017 8.25v-3.5A.75.75 0 017.75 4z”></path></svg> <span class=”d-none d-sm-inline”> <strong>History</strong> </span> </a> </div> </div>

</div>

contributor </summary> <details-dialog class=”Box Box–overlay d-flex flex-column anim-fade-in fast” aria-label=”Users who have contributed to this file” src=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/contributors-list/master/3-minilake.yaml” preload> <div class=”Box-header”> <button class=”Box-btn-octicon btn-octicon float-right” type=”button” aria-label=”Close dialog” data-close-dialog> <svg class=”octicon octicon-x” viewBox=”0 0 16 16” version=”1.1” width=”16” height=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M3.72 3.72a.75.75 0 011.06 0L8 6.94l3.22-3.22a.75.75 0 111.06 1.06L9.06 8l3.22 3.22a.75.75 0 11-1.06 1.06L8 9.06l-3.22 3.22a.75.75 0 01-1.06-1.06L6.94 8 3.72 4.78a.75.75 0 010-1.06z”></path></svg> </button> <h3 class=”Box-title”> Users who have contributed to this file </h3> </div> <include-fragment> <svg style=”box-sizing: content-box; color: var(–color-icon-primary);” viewBox=”0 0 16 16” fill=”none” class=”my-3 mx-auto d-block” width=”32” height=”32”> <circle cx=”8” cy=”8” r=”7” stroke=”currentColor” stroke-opacity=”0.25” stroke-width=”2” vector-effect=”non-scaling-stroke” /> <path d=”M15 8a7.002 7.002 0 00-7-7” stroke=”currentColor” stroke-width=”2” stroke-linecap=”round” vector-effect=”non-scaling-stroke”> <animateTransform attributeName=”transform” type=”rotate” from=”0 8 8” to=”360 8 8” dur=”1s” repeatCount=”indefinite” /> </path> </svg> </include-fragment> </details-dialog> </details> </div> </div>

301 lines (300 sloc) <span class=”file-info-divider”></span> 8.12 KB </div>

<div class=”BtnGroup”> <a href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/raw/master/3-minilake.yaml” id=”raw-url” role=”button” class=”btn btn-sm BtnGroup-item “>Raw</a> <a href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/blame/master/3-minilake.yaml” data-hotkey=”b” role=”button” class=”btn js-update-url-with-hash btn-sm BtnGroup-item “>Blame</a> </div>

<!– ‘”` –><!– </textarea></xmp> –></option></form><form class=”inline-form js-update-url-with-hash” action=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/edit/master/3-minilake.yaml” accept-charset=”UTF-8” method=”post”><input type=”hidden” name=”authenticity_token” value=”Vb/jTc4U5wbUQmw7ve9po0m/l7PlEB7+d7VVXb7lGHOjvSOpdepid/2cLq9cshrOYqgD+E69aIcZO36EI3+MsA==” /> <button class=”btn-octicon tooltipped tooltipped-nw” type=”submit” aria-label=”Edit this file” data-hotkey=”e” data-disable-with> <svg class=”octicon octicon-pencil” height=”16” viewBox=”0 0 16 16” version=”1.1” width=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M11.013 1.427a1.75 1.75 0 012.474 0l1.086 1.086a1.75 1.75 0 010 2.474l-8.61 8.61c-.21.21-.47.364-.756.445l-3.251.93a.75.75 0 01-.927-.928l.929-3.25a1.75 1.75 0 01.445-.758l8.61-8.61zm1.414 1.06a.25.25 0 00-.354 0L10.811 3.75l1.439 1.44 1.263-1.263a.25.25 0 000-.354l-1.086-1.086zM11.189 6.25L9.75 4.81l-6.286 6.287a.25.25 0 00-.064.108l-.558 1.953 1.953-.558a.249.249 0 00.108-.064l6.286-6.286z”></path></svg> </button> </form> <!– ‘”` –><!– </textarea></xmp> –></option></form><form class=”inline-form” action=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/delete/master/3-minilake.yaml” accept-charset=”UTF-8” method=”post”><input type=”hidden” name=”authenticity_token” value=”GozD9jtnklfpYqGDxDXM4RS7yHE+iYAR0QQ8b94QKoqFuWU8K16NPQ4na2KzPO3NFlgGvQufFVH1UfmURqXgHA==” /> <button class=”btn-octicon btn-octicon-danger tooltipped tooltipped-nw” type=”submit” aria-label=”Delete this file” data-disable-with> <svg class=”octicon octicon-trashcan” viewBox=”0 0 16 16” version=”1.1” width=”16” height=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M6.5 1.75a.25.25 0 01.25-.25h2.5a.25.25 0 01.25.25V3h-3V1.75zm4.5 0V3h2.25a.75.75 0 010 1.5H2.75a.75.75 0 010-1.5H5V1.75C5 .784 5.784 0 6.75 0h2.5C10.216 0 11 .784 11 1.75zM4.496 6.675a.75.75 0 10-1.492.15l.66 6.6A1.75 1.75 0 005.405 15h5.19c.9 0 1.652-.681 1.741-1.576l.66-6.6a.75.75 0 00-1.492-.149l-.66 6.6a.25.25 0 01-.249.225h-5.19a.25.25 0 01-.249-.225l-.66-6.6z”></path></svg> </button> </form> </div> </div> </div>

<table class=”highlight tab-size js-file-line-container” data-tab-size=”8” data-paste-markdown-skip> <tr> <td id=”L1” class=”blob-num js-line-number” data-line-number=”1”></td> <td id=”LC1” class=”blob-code blob-code-inner js-file-line”><span class=”pl-ent”>Parameters</span>:</td> </tr> <tr> <td id=”L2” class=”blob-num js-line-number” data-line-number=”2”></td> <td id=”LC2” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>InstanceType</span>:</td> </tr> <tr> <td id=”L3” class=”blob-num js-line-number” data-line-number=”3”></td> <td id=”LC3” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Description</span>: <span class=”pl-s”>EC2 instance type</span></td> </tr> <tr> <td id=”L4” class=”blob-num js-line-number” data-line-number=”4”></td> <td id=”LC4” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”>String</span></td> </tr> <tr> <td id=”L5” class=”blob-num js-line-number” data-line-number=”5”></td> <td id=”LC5” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Default</span>: <span class=”pl-s”>t2.micro</span></td> </tr> <tr> <td id=”L6” class=”blob-num js-line-number” data-line-number=”6”></td> <td id=”LC6” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>AllowedValues</span>:</td> </tr> <tr> <td id=”L7” class=”blob-num js-line-number” data-line-number=”7”></td> <td id=”LC7” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-s”>t1.micro</span></td> </tr> <tr> <td id=”L8” class=”blob-num js-line-number” data-line-number=”8”></td> <td id=”LC8” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-s”>t2.micro</span></td> </tr> <tr> <td id=”L9” class=”blob-num js-line-number” data-line-number=”9”></td> <td id=”LC9” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>ConstraintDescription</span>: <span class=”pl-s”>must be a valid EC2 instance type.</span></td> </tr> <tr> <td id=”L10” class=”blob-num js-line-number” data-line-number=”10”></td> <td id=”LC10” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>KeyPair</span>:</td> </tr> <tr> <td id=”L11” class=”blob-num js-line-number” data-line-number=”11”></td> <td id=”LC11” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Description</span>: <span class=”pl-s”>Name of an existing EC2 KeyPair to enable SSH access to the instance</span></td> </tr> <tr> <td id=”L12” class=”blob-num js-line-number” data-line-number=”12”></td> <td id=”LC12” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”><span class=”pl-pds”>"</span>AWS::EC2::KeyPair::KeyName<span class=”pl-pds”>"</span></span></td> </tr> <tr> <td id=”L13” class=”blob-num js-line-number” data-line-number=”13”></td> <td id=”LC13” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>MinLength</span>: <span class=”pl-s”><span class=”pl-pds”>'</span>1<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L14” class=”blob-num js-line-number” data-line-number=”14”></td> <td id=”LC14” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>MaxLength</span>: <span class=”pl-s”><span class=”pl-pds”>'</span>255<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L15” class=”blob-num js-line-number” data-line-number=”15”></td> <td id=”LC15” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>AllowedPattern</span>: <span class=”pl-s”><span class=”pl-pds”>'</span>[\x20-\x7E]*<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L16” class=”blob-num js-line-number” data-line-number=”16”></td> <td id=”LC16” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>ConstraintDescription</span>: <span class=”pl-s”>can contain only ASCII characters.</span></td> </tr> <tr> <td id=”L17” class=”blob-num js-line-number” data-line-number=”17”></td> <td id=”LC17” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>S3BucketName</span>:</td> </tr> <tr> <td id=”L18” class=”blob-num js-line-number” data-line-number=”18”></td> <td id=”LC18” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Description</span>: <span class=”pl-s”>S3 Bucket Name</span></td> </tr> <tr> <td id=”L19” class=”blob-num js-line-number” data-line-number=”19”></td> <td id=”LC19” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”>String</span></td> </tr> <tr> <td id=”L20” class=”blob-num js-line-number” data-line-number=”20”></td> <td id=”LC20” class=”blob-code blob-code-inner js-file-line”><span class=”pl-ent”>Mappings</span>: </td> </tr> <tr> <td id=”L21” class=”blob-num js-line-number” data-line-number=”21”></td> <td id=”LC21” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>RegionMap</span>: </td> </tr> <tr> <td id=”L22” class=”blob-num js-line-number” data-line-number=”22”></td> <td id=”LC22” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>us-east-1</span>:</td> </tr> <tr> <td id=”L23” class=”blob-num js-line-number” data-line-number=”23”></td> <td id=”LC23” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>EC2IMG</span>: <span class=”pl-s”>ami-002a7eaa5b5b40ec9</span></td> </tr> <tr> <td id=”L24” class=”blob-num js-line-number” data-line-number=”24”></td> <td id=”LC24” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>us-west-2</span>:</td> </tr> <tr> <td id=”L25” class=”blob-num js-line-number” data-line-number=”25”></td> <td id=”LC25” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>EC2IMG</span>: <span class=”pl-s”>ami-056d8838c69d1843f</span></td> </tr> <tr> <td id=”L26” class=”blob-num js-line-number” data-line-number=”26”></td> <td id=”LC26” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>ap-northeast-1</span>:</td> </tr> <tr> <td id=”L27” class=”blob-num js-line-number” data-line-number=”27”></td> <td id=”LC27” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>EC2IMG</span>: <span class=”pl-s”>ami-08e0224e71f409f5f</span></td> </tr> <tr> <td id=”L28” class=”blob-num js-line-number” data-line-number=”28”></td> <td id=”LC28” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>ap-southeast-1</span>:</td> </tr> <tr> <td id=”L29” class=”blob-num js-line-number” data-line-number=”29”></td> <td id=”LC29” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>EC2IMG</span>: <span class=”pl-s”>ami-0a0ba6c16aff9f0cc</span></td> </tr> <tr> <td id=”L30” class=”blob-num js-line-number” data-line-number=”30”></td> <td id=”LC30” class=”blob-code blob-code-inner js-file-line”><span class=”pl-ent”>Resources</span>:</td> </tr> <tr> <td id=”L31” class=”blob-num js-line-number” data-line-number=”31”></td> <td id=”LC31” class=”blob-code blob-code-inner js-file-line”><span class=”pl-c”><span class=”pl-c”>#</span> Create VPC</span></td> </tr> <tr> <td id=”L32” class=”blob-num js-line-number” data-line-number=”32”></td> <td id=”LC32” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>MyVPC</span>:</td> </tr> <tr> <td id=”L33” class=”blob-num js-line-number” data-line-number=”33”></td> <td id=”LC33” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”>AWS::EC2::VPC</span></td> </tr> <tr> <td id=”L34” class=”blob-num js-line-number” data-line-number=”34”></td> <td id=”LC34” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>:</td> </tr> <tr> <td id=”L35” class=”blob-num js-line-number” data-line-number=”35”></td> <td id=”LC35” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>CidrBlock</span>: <span class=”pl-s”>10.0.0.0/24</span></td> </tr> <tr> <td id=”L36” class=”blob-num js-line-number” data-line-number=”36”></td> <td id=”LC36” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>EnableDnsSupport</span>: <span class=”pl-s”><span class=”pl-pds”>'</span>true<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L37” class=”blob-num js-line-number” data-line-number=”37”></td> <td id=”LC37” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>EnableDnsHostnames</span>: <span class=”pl-s”><span class=”pl-pds”>'</span>true<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L38” class=”blob-num js-line-number” data-line-number=”38”></td> <td id=”LC38” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>InstanceTenancy</span>: <span class=”pl-s”>default</span></td> </tr> <tr> <td id=”L39” class=”blob-num js-line-number” data-line-number=”39”></td> <td id=”LC39” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Tags</span>:</td> </tr> <tr> <td id=”L40” class=”blob-num js-line-number” data-line-number=”40”></td> <td id=”LC40” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-ent”>Key</span>: <span class=”pl-s”>Name</span></td> </tr> <tr> <td id=”L41” class=”blob-num js-line-number” data-line-number=”41”></td> <td id=”LC41” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Value</span>: <span class=”pl-s”>handson-minilake</span></td> </tr> <tr> <td id=”L42” class=”blob-num js-line-number” data-line-number=”42”></td> <td id=”LC42” class=”blob-code blob-code-inner js-file-line”><span class=”pl-c”><span class=”pl-c”>#</span> Create Public RouteTable</span></td> </tr> <tr> <td id=”L43” class=”blob-num js-line-number” data-line-number=”43”></td> <td id=”LC43” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>PublicRouteTable</span>:</td> </tr> <tr> <td id=”L44” class=”blob-num js-line-number” data-line-number=”44”></td> <td id=”LC44” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”>AWS::EC2::RouteTable</span></td> </tr> <tr> <td id=”L45” class=”blob-num js-line-number” data-line-number=”45”></td> <td id=”LC45” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>:</td> </tr> <tr> <td id=”L46” class=”blob-num js-line-number” data-line-number=”46”></td> <td id=”LC46” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>VpcId</span>: <span class=”pl-s”>!Ref MyVPC</span></td> </tr> <tr> <td id=”L47” class=”blob-num js-line-number” data-line-number=”47”></td> <td id=”LC47” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Tags</span>:</td> </tr> <tr> <td id=”L48” class=”blob-num js-line-number” data-line-number=”48”></td> <td id=”LC48” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-ent”>Key</span>: <span class=”pl-s”>Name</span></td> </tr> <tr> <td id=”L49” class=”blob-num js-line-number” data-line-number=”49”></td> <td id=”LC49” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Value</span>: <span class=”pl-s”>handson-minilake</span></td> </tr> <tr> <td id=”L50” class=”blob-num js-line-number” data-line-number=”50”></td> <td id=”LC50” class=”blob-code blob-code-inner js-file-line”><span class=”pl-c”><span class=”pl-c”>#</span> Create Private RouteTable</span></td> </tr> <tr> <td id=”L51” class=”blob-num js-line-number” data-line-number=”51”></td> <td id=”LC51” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>PrivateRouteTable</span>:</td> </tr> <tr> <td id=”L52” class=”blob-num js-line-number” data-line-number=”52”></td> <td id=”LC52” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”>AWS::EC2::RouteTable</span></td> </tr> <tr> <td id=”L53” class=”blob-num js-line-number” data-line-number=”53”></td> <td id=”LC53” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>:</td> </tr> <tr> <td id=”L54” class=”blob-num js-line-number” data-line-number=”54”></td> <td id=”LC54” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>VpcId</span>: <span class=”pl-s”>!Ref MyVPC</span></td> </tr> <tr> <td id=”L55” class=”blob-num js-line-number” data-line-number=”55”></td> <td id=”LC55” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Tags</span>:</td> </tr> <tr> <td id=”L56” class=”blob-num js-line-number” data-line-number=”56”></td> <td id=”LC56” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-ent”>Key</span>: <span class=”pl-s”>Name</span></td> </tr> <tr> <td id=”L57” class=”blob-num js-line-number” data-line-number=”57”></td> <td id=”LC57” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Value</span>: <span class=”pl-s”>handson-minilake-private-rt</span></td> </tr> <tr> <td id=”L58” class=”blob-num js-line-number” data-line-number=”58”></td> <td id=”LC58” class=”blob-code blob-code-inner js-file-line”><span class=”pl-c”><span class=”pl-c”>#</span> Create Public Subnet</span></td> </tr> <tr> <td id=”L59” class=”blob-num js-line-number” data-line-number=”59”></td> <td id=”LC59” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>PublicSubnet</span>:</td> </tr> <tr> <td id=”L60” class=”blob-num js-line-number” data-line-number=”60”></td> <td id=”LC60” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”>AWS::EC2::Subnet</span></td> </tr> <tr> <td id=”L61” class=”blob-num js-line-number” data-line-number=”61”></td> <td id=”LC61” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>:</td> </tr> <tr> <td id=”L62” class=”blob-num js-line-number” data-line-number=”62”></td> <td id=”LC62” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>VpcId</span>: <span class=”pl-s”>!Ref MyVPC</span></td> </tr> <tr> <td id=”L63” class=”blob-num js-line-number” data-line-number=”63”></td> <td id=”LC63” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>CidrBlock</span>: <span class=”pl-s”>10.0.0.0/27</span></td> </tr> <tr> <td id=”L64” class=”blob-num js-line-number” data-line-number=”64”></td> <td id=”LC64” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>AvailabilityZone</span>: </td> </tr> <tr> <td id=”L65” class=”blob-num js-line-number” data-line-number=”65”></td> <td id=”LC65” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Fn::Select</span>: </td> </tr> <tr> <td id=”L66” class=”blob-num js-line-number” data-line-number=”66”></td> <td id=”LC66” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-c1”>0</span></td> </tr> <tr> <td id=”L67” class=”blob-num js-line-number” data-line-number=”67”></td> <td id=”LC67” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-ent”>Fn::GetAZs</span>: <span class=”pl-s”><span class=”pl-pds”>"</span><span class=”pl-pds”>"</span></span></td> </tr> <tr> <td id=”L68” class=”blob-num js-line-number” data-line-number=”68”></td> <td id=”LC68” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Tags</span>:</td> </tr> <tr> <td id=”L69” class=”blob-num js-line-number” data-line-number=”69”></td> <td id=”LC69” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-ent”>Key</span>: <span class=”pl-s”>Name</span></td> </tr> <tr> <td id=”L70” class=”blob-num js-line-number” data-line-number=”70”></td> <td id=”LC70” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Value</span>: <span class=”pl-s”>handson-minilake-public-sub</span></td> </tr> <tr> <td id=”L71” class=”blob-num js-line-number” data-line-number=”71”></td> <td id=”LC71” class=”blob-code blob-code-inner js-file-line”><span class=”pl-c”><span class=”pl-c”>#</span> Create Private Subnet A</span></td> </tr> <tr> <td id=”L72” class=”blob-num js-line-number” data-line-number=”72”></td> <td id=”LC72” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>PrivateSubnet</span>:</td> </tr> <tr> <td id=”L73” class=”blob-num js-line-number” data-line-number=”73”></td> <td id=”LC73” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”>AWS::EC2::Subnet</span></td> </tr> <tr> <td id=”L74” class=”blob-num js-line-number” data-line-number=”74”></td> <td id=”LC74” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>:</td> </tr> <tr> <td id=”L75” class=”blob-num js-line-number” data-line-number=”75”></td> <td id=”LC75” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>VpcId</span>: <span class=”pl-s”>!Ref MyVPC</span></td> </tr> <tr> <td id=”L76” class=”blob-num js-line-number” data-line-number=”76”></td> <td id=”LC76” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>CidrBlock</span>: <span class=”pl-s”>10.0.0.32/27</span></td> </tr> <tr> <td id=”L77” class=”blob-num js-line-number” data-line-number=”77”></td> <td id=”LC77” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>AvailabilityZone</span>: </td> </tr> <tr> <td id=”L78” class=”blob-num js-line-number” data-line-number=”78”></td> <td id=”LC78” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Fn::Select</span>: </td> </tr> <tr> <td id=”L79” class=”blob-num js-line-number” data-line-number=”79”></td> <td id=”LC79” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-c1”>0</span></td> </tr> <tr> <td id=”L80” class=”blob-num js-line-number” data-line-number=”80”></td> <td id=”LC80” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-ent”>Fn::GetAZs</span>: <span class=”pl-s”><span class=”pl-pds”>"</span><span class=”pl-pds”>"</span></span></td> </tr> <tr> <td id=”L81” class=”blob-num js-line-number” data-line-number=”81”></td> <td id=”LC81” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Tags</span>:</td> </tr> <tr> <td id=”L82” class=”blob-num js-line-number” data-line-number=”82”></td> <td id=”LC82” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-ent”>Key</span>: <span class=”pl-s”>Name</span></td> </tr> <tr> <td id=”L83” class=”blob-num js-line-number” data-line-number=”83”></td> <td id=”LC83” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Value</span>: <span class=”pl-s”>handson-minilake-private-sub</span></td> </tr> <tr> <td id=”L84” class=”blob-num js-line-number” data-line-number=”84”></td> <td id=”LC84” class=”blob-code blob-code-inner js-file-line”><span class=”pl-c”><span class=”pl-c”>#</span> Associate with Public subnet and route table for private subnet</span></td> </tr> <tr> <td id=”L85” class=”blob-num js-line-number” data-line-number=”85”></td> <td id=”LC85” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>PubSubnetRouteTableAssociation</span>:</td> </tr> <tr> <td id=”L86” class=”blob-num js-line-number” data-line-number=”86”></td> <td id=”LC86” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”>AWS::EC2::SubnetRouteTableAssociation</span></td> </tr> <tr> <td id=”L87” class=”blob-num js-line-number” data-line-number=”87”></td> <td id=”LC87” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>:</td> </tr> <tr> <td id=”L88” class=”blob-num js-line-number” data-line-number=”88”></td> <td id=”LC88” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>SubnetId</span>: <span class=”pl-s”>!Ref PublicSubnet</span></td> </tr> <tr> <td id=”L89” class=”blob-num js-line-number” data-line-number=”89”></td> <td id=”LC89” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>RouteTableId</span>: <span class=”pl-s”>!Ref PublicRouteTable</span></td> </tr> <tr> <td id=”L90” class=”blob-num js-line-number” data-line-number=”90”></td> <td id=”LC90” class=”blob-code blob-code-inner js-file-line”><span class=”pl-c”><span class=”pl-c”>#</span> Associate with Private subnet and route table for private subnet</span></td> </tr> <tr> <td id=”L91” class=”blob-num js-line-number” data-line-number=”91”></td> <td id=”LC91” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>PriSubnetRouteTableAssociation</span>:</td> </tr> <tr> <td id=”L92” class=”blob-num js-line-number” data-line-number=”92”></td> <td id=”LC92” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”>AWS::EC2::SubnetRouteTableAssociation</span></td> </tr> <tr> <td id=”L93” class=”blob-num js-line-number” data-line-number=”93”></td> <td id=”LC93” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>:</td> </tr> <tr> <td id=”L94” class=”blob-num js-line-number” data-line-number=”94”></td> <td id=”LC94” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>SubnetId</span>: <span class=”pl-s”>!Ref PrivateSubnet</span></td> </tr> <tr> <td id=”L95” class=”blob-num js-line-number” data-line-number=”95”></td> <td id=”LC95” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>RouteTableId</span>: <span class=”pl-s”>!Ref PrivateRouteTable</span></td> </tr> <tr> <td id=”L96” class=”blob-num js-line-number” data-line-number=”96”></td> <td id=”LC96” class=”blob-code blob-code-inner js-file-line”><span class=”pl-c”><span class=”pl-c”>#</span> Create InternetGateway</span></td> </tr> <tr> <td id=”L97” class=”blob-num js-line-number” data-line-number=”97”></td> <td id=”LC97” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>MyInternetGateway</span>:</td> </tr> <tr> <td id=”L98” class=”blob-num js-line-number” data-line-number=”98”></td> <td id=”LC98” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”><span class=”pl-pds”>"</span>AWS::EC2::InternetGateway<span class=”pl-pds”>"</span></span></td> </tr> <tr> <td id=”L99” class=”blob-num js-line-number” data-line-number=”99”></td> <td id=”LC99” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>:</td> </tr> <tr> <td id=”L100” class=”blob-num js-line-number” data-line-number=”100”></td> <td id=”LC100” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Tags</span>:</td> </tr> <tr> <td id=”L101” class=”blob-num js-line-number” data-line-number=”101”></td> <td id=”LC101” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-ent”>Key</span>: <span class=”pl-s”>Name</span></td> </tr> <tr> <td id=”L102” class=”blob-num js-line-number” data-line-number=”102”></td> <td id=”LC102” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Value</span>: <span class=”pl-s”>handson-minilake</span></td> </tr> <tr> <td id=”L103” class=”blob-num js-line-number” data-line-number=”103”></td> <td id=”LC103” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>AttachGateway</span>:</td> </tr> <tr> <td id=”L104” class=”blob-num js-line-number” data-line-number=”104”></td> <td id=”LC104” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”>AWS::EC2::VPCGatewayAttachment</span></td> </tr> <tr> <td id=”L105” class=”blob-num js-line-number” data-line-number=”105”></td> <td id=”LC105” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>:</td> </tr> <tr> <td id=”L106” class=”blob-num js-line-number” data-line-number=”106”></td> <td id=”LC106” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>VpcId</span>: <span class=”pl-s”>!Ref MyVPC</span></td> </tr> <tr> <td id=”L107” class=”blob-num js-line-number” data-line-number=”107”></td> <td id=”LC107” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>InternetGatewayId</span>: <span class=”pl-s”>!Ref MyInternetGateway</span></td> </tr> <tr> <td id=”L108” class=”blob-num js-line-number” data-line-number=”108”></td> <td id=”LC108” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>MyPublicRoute</span>:</td> </tr> <tr> <td id=”L109” class=”blob-num js-line-number” data-line-number=”109”></td> <td id=”LC109” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”>AWS::EC2::Route</span></td> </tr> <tr> <td id=”L110” class=”blob-num js-line-number” data-line-number=”110”></td> <td id=”LC110” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>DependsOn</span>: <span class=”pl-s”>MyInternetGateway</span></td> </tr> <tr> <td id=”L111” class=”blob-num js-line-number” data-line-number=”111”></td> <td id=”LC111” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>:</td> </tr> <tr> <td id=”L112” class=”blob-num js-line-number” data-line-number=”112”></td> <td id=”LC112” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>RouteTableId</span>: <span class=”pl-s”>!Ref PublicRouteTable</span></td> </tr> <tr> <td id=”L113” class=”blob-num js-line-number” data-line-number=”113”></td> <td id=”LC113” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>DestinationCidrBlock</span>: <span class=”pl-s”>0.0.0.0/0</span></td> </tr> <tr> <td id=”L114” class=”blob-num js-line-number” data-line-number=”114”></td> <td id=”LC114” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>GatewayId</span>: <span class=”pl-s”>!Ref MyInternetGateway</span></td> </tr> <tr> <td id=”L115” class=”blob-num js-line-number” data-line-number=”115”></td> <td id=”LC115” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>MyEIP</span>:</td> </tr> <tr> <td id=”L116” class=”blob-num js-line-number” data-line-number=”116”></td> <td id=”LC116” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”><span class=”pl-pds”>"</span>AWS::EC2::EIP<span class=”pl-pds”>"</span></span></td> </tr> <tr> <td id=”L117” class=”blob-num js-line-number” data-line-number=”117”></td> <td id=”LC117” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>:</td> </tr> <tr> <td id=”L118” class=”blob-num js-line-number” data-line-number=”118”></td> <td id=”LC118” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Domain</span>: <span class=”pl-s”>vpc</span></td> </tr> <tr> <td id=”L119” class=”blob-num js-line-number” data-line-number=”119”></td> <td id=”LC119” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>ElasticIPAssociate</span>:</td> </tr> <tr> <td id=”L120” class=”blob-num js-line-number” data-line-number=”120”></td> <td id=”LC120” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>DependsOn</span>: <span class=”pl-s”>MyEC2Instance</span></td> </tr> <tr> <td id=”L121” class=”blob-num js-line-number” data-line-number=”121”></td> <td id=”LC121” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”>AWS::EC2::EIPAssociation</span></td> </tr> <tr> <td id=”L122” class=”blob-num js-line-number” data-line-number=”122”></td> <td id=”LC122” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>:</td> </tr> <tr> <td id=”L123” class=”blob-num js-line-number” data-line-number=”123”></td> <td id=”LC123” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>AllocationId</span>: <span class=”pl-s”>!GetAtt MyEIP.AllocationId</span></td> </tr> <tr> <td id=”L124” class=”blob-num js-line-number” data-line-number=”124”></td> <td id=”LC124” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>InstanceId</span>: <span class=”pl-s”>!Ref MyEC2Instance</span></td> </tr> <tr> <td id=”L125” class=”blob-num js-line-number” data-line-number=”125”></td> <td id=”LC125” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>MinilakeRole</span>: </td> </tr> <tr> <td id=”L126” class=”blob-num js-line-number” data-line-number=”126”></td> <td id=”LC126” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”><span class=”pl-pds”>"</span>AWS::IAM::Role<span class=”pl-pds”>"</span></span></td> </tr> <tr> <td id=”L127” class=”blob-num js-line-number” data-line-number=”127”></td> <td id=”LC127” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>: </td> </tr> <tr> <td id=”L128” class=”blob-num js-line-number” data-line-number=”128”></td> <td id=”LC128” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>AssumeRolePolicyDocument</span>: </td> </tr> <tr> <td id=”L129” class=”blob-num js-line-number” data-line-number=”129”></td> <td id=”LC129” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Version</span>: <span class=”pl-s”><span class=”pl-pds”>"</span>2012-10-17<span class=”pl-pds”>"</span></span></td> </tr> <tr> <td id=”L130” class=”blob-num js-line-number” data-line-number=”130”></td> <td id=”LC130” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Statement</span>: </td> </tr> <tr> <td id=”L131” class=”blob-num js-line-number” data-line-number=”131”></td> <td id=”LC131” class=”blob-code blob-code-inner js-file-line”> - </td> </tr> <tr> <td id=”L132” class=”blob-num js-line-number” data-line-number=”132”></td> <td id=”LC132” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Effect</span>: <span class=”pl-s”><span class=”pl-pds”>"</span>Allow<span class=”pl-pds”>"</span></span></td> </tr> <tr> <td id=”L133” class=”blob-num js-line-number” data-line-number=”133”></td> <td id=”LC133” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Principal</span>: </td> </tr> <tr> <td id=”L134” class=”blob-num js-line-number” data-line-number=”134”></td> <td id=”LC134” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Service</span>: </td> </tr> <tr> <td id=”L135” class=”blob-num js-line-number” data-line-number=”135”></td> <td id=”LC135” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-s”><span class=”pl-pds”>"</span>ec2.amazonaws.com<span class=”pl-pds”>"</span></span></td> </tr> <tr> <td id=”L136” class=”blob-num js-line-number” data-line-number=”136”></td> <td id=”LC136” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Action</span>: </td> </tr> <tr> <td id=”L137” class=”blob-num js-line-number” data-line-number=”137”></td> <td id=”LC137” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-s”><span class=”pl-pds”>"</span>sts:AssumeRole<span class=”pl-pds”>"</span></span></td> </tr> <tr> <td id=”L138” class=”blob-num js-line-number” data-line-number=”138”></td> <td id=”LC138” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Path</span>: <span class=”pl-s”><span class=”pl-pds”>"</span>/<span class=”pl-pds”>"</span></span></td> </tr> <tr> <td id=”L139” class=”blob-num js-line-number” data-line-number=”139”></td> <td id=”LC139” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>ManagedPolicyArns</span>:</td> </tr> <tr> <td id=”L140” class=”blob-num js-line-number” data-line-number=”140”></td> <td id=”LC140” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-s”>arn:aws:iam::aws:policy/AmazonKinesisFirehoseFullAccess</span></td> </tr> <tr> <td id=”L141” class=”blob-num js-line-number” data-line-number=”141”></td> <td id=”LC141” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>RoleName</span>: <span class=”pl-s”><span class=”pl-pds”>"</span>handson-minilake<span class=”pl-pds”>"</span></span></td> </tr> <tr> <td id=”L142” class=”blob-num js-line-number” data-line-number=”142”></td> <td id=”LC142” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>MinilakeInstanceProfile</span>: </td> </tr> <tr> <td id=”L143” class=”blob-num js-line-number” data-line-number=”143”></td> <td id=”LC143” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”><span class=”pl-pds”>"</span>AWS::IAM::InstanceProfile<span class=”pl-pds”>"</span></span></td> </tr> <tr> <td id=”L144” class=”blob-num js-line-number” data-line-number=”144”></td> <td id=”LC144” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>: </td> </tr> <tr> <td id=”L145” class=”blob-num js-line-number” data-line-number=”145”></td> <td id=”LC145” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Path</span>: <span class=”pl-s”><span class=”pl-pds”>"</span>/<span class=”pl-pds”>"</span></span></td> </tr> <tr> <td id=”L146” class=”blob-num js-line-number” data-line-number=”146”></td> <td id=”LC146” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Roles</span>: </td> </tr> <tr> <td id=”L147” class=”blob-num js-line-number” data-line-number=”147”></td> <td id=”LC147” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-ent”>Ref</span>: <span class=”pl-s”><span class=”pl-pds”>"</span>MinilakeRole<span class=”pl-pds”>"</span></span></td> </tr> <tr> <td id=”L148” class=”blob-num js-line-number” data-line-number=”148”></td> <td id=”LC148” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>MyEC2Instance</span>:</td> </tr> <tr> <td id=”L149” class=”blob-num js-line-number” data-line-number=”149”></td> <td id=”LC149” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”><span class=”pl-pds”>'</span>AWS::EC2::Instance<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L150” class=”blob-num js-line-number” data-line-number=”150”></td> <td id=”LC150” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>:</td> </tr> <tr> <td id=”L151” class=”blob-num js-line-number” data-line-number=”151”></td> <td id=”LC151” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>ImageId</span>: <span class=”pl-s”>!FindInMap [RegionMap, !Ref "AWS::Region", EC2IMG]</span></td> </tr> <tr> <td id=”L152” class=”blob-num js-line-number” data-line-number=”152”></td> <td id=”LC152” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>InstanceType</span>: <span class=”pl-s”>t2.micro</span></td> </tr> <tr> <td id=”L153” class=”blob-num js-line-number” data-line-number=”153”></td> <td id=”LC153” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>SubnetId</span>: <span class=”pl-s”>!Ref PublicSubnet</span></td> </tr> <tr> <td id=”L154” class=”blob-num js-line-number” data-line-number=”154”></td> <td id=”LC154” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>KeyName </span>:</td> </tr> <tr> <td id=”L155” class=”blob-num js-line-number” data-line-number=”155”></td> <td id=”LC155” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Ref</span>: <span class=”pl-s”>KeyPair</span></td> </tr> <tr> <td id=”L156” class=”blob-num js-line-number” data-line-number=”156”></td> <td id=”LC156” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>SecurityGroupIds</span>:</td> </tr> <tr> <td id=”L157” class=”blob-num js-line-number” data-line-number=”157”></td> <td id=”LC157” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-ent”>Ref</span>: <span class=”pl-s”>MyEC2SecurityGroup</span></td> </tr> <tr> <td id=”L158” class=”blob-num js-line-number” data-line-number=”158”></td> <td id=”LC158” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Tags</span>:</td> </tr> <tr> <td id=”L159” class=”blob-num js-line-number” data-line-number=”159”></td> <td id=”LC159” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-ent”>Key</span>: <span class=”pl-s”>Name</span></td> </tr> <tr> <td id=”L160” class=”blob-num js-line-number” data-line-number=”160”></td> <td id=”LC160” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Value</span>: <span class=”pl-s”>handson-minilake</span></td> </tr> <tr> <td id=”L161” class=”blob-num js-line-number” data-line-number=”161”></td> <td id=”LC161” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>IamInstanceProfile</span>: </td> </tr> <tr> <td id=”L162” class=”blob-num js-line-number” data-line-number=”162”></td> <td id=”LC162” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Ref</span>: <span class=”pl-s”>MinilakeInstanceProfile</span></td> </tr> <tr> <td id=”L163” class=”blob-num js-line-number” data-line-number=”163”></td> <td id=”LC163” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>MyEC2SecurityGroup</span>:</td> </tr> <tr> <td id=”L164” class=”blob-num js-line-number” data-line-number=”164”></td> <td id=”LC164” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”><span class=”pl-pds”>'</span>AWS::EC2::SecurityGroup<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L165” class=”blob-num js-line-number” data-line-number=”165”></td> <td id=”LC165” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>:</td> </tr> <tr> <td id=”L166” class=”blob-num js-line-number” data-line-number=”166”></td> <td id=”LC166” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>GroupName</span>: <span class=”pl-s”>handson-minilake-sg</span></td> </tr> <tr> <td id=”L167” class=”blob-num js-line-number” data-line-number=”167”></td> <td id=”LC167” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>GroupDescription</span>: <span class=”pl-s”>Enable SSH access via port 22</span></td> </tr> <tr> <td id=”L168” class=”blob-num js-line-number” data-line-number=”168”></td> <td id=”LC168” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>VpcId</span>: <span class=”pl-s”>!Ref MyVPC</span></td> </tr> <tr> <td id=”L169” class=”blob-num js-line-number” data-line-number=”169”></td> <td id=”LC169” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>SecurityGroupIngress</span>:</td> </tr> <tr> <td id=”L170” class=”blob-num js-line-number” data-line-number=”170”></td> <td id=”LC170” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-ent”>IpProtocol</span>: <span class=”pl-s”>tcp</span></td> </tr> <tr> <td id=”L171” class=”blob-num js-line-number” data-line-number=”171”></td> <td id=”LC171” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>FromPort</span>: <span class=”pl-s”><span class=”pl-pds”>'</span>22<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L172” class=”blob-num js-line-number” data-line-number=”172”></td> <td id=”LC172” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>ToPort</span>: <span class=”pl-s”><span class=”pl-pds”>'</span>22<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L173” class=”blob-num js-line-number” data-line-number=”173”></td> <td id=”LC173” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>CidrIp</span>:</td> </tr> <tr> <td id=”L174” class=”blob-num js-line-number” data-line-number=”174”></td> <td id=”LC174” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-s”><span class=”pl-pds”>'</span>0.0.0.0/0<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L175” class=”blob-num js-line-number” data-line-number=”175”></td> <td id=”LC175” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Tags</span>:</td> </tr> <tr> <td id=”L176” class=”blob-num js-line-number” data-line-number=”176”></td> <td id=”LC176” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-ent”>Key</span>: <span class=”pl-s”>Name</span></td> </tr> <tr> <td id=”L177” class=”blob-num js-line-number” data-line-number=”177”></td> <td id=”LC177” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Value</span>: <span class=”pl-s”>handson-minilake-sg</span></td> </tr> <tr> <td id=”L178” class=”blob-num js-line-number” data-line-number=”178”></td> <td id=”LC178” class=”blob-code blob-code-inner js-file-line”><span class=”pl-c”><span class=”pl-c”>#</span> Create EIP</span></td> </tr> <tr> <td id=”L179” class=”blob-num js-line-number” data-line-number=”179”></td> <td id=”LC179” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>MyEIP2</span>:</td> </tr> <tr> <td id=”L180” class=”blob-num js-line-number” data-line-number=”180”></td> <td id=”LC180” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”><span class=”pl-pds”>"</span>AWS::EC2::EIP<span class=”pl-pds”>"</span></span></td> </tr> <tr> <td id=”L181” class=”blob-num js-line-number” data-line-number=”181”></td> <td id=”LC181” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>:</td> </tr> <tr> <td id=”L182” class=”blob-num js-line-number” data-line-number=”182”></td> <td id=”LC182” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Domain</span>: <span class=”pl-s”>vpc</span></td> </tr> <tr> <td id=”L183” class=”blob-num js-line-number” data-line-number=”183”></td> <td id=”LC183” class=”blob-code blob-code-inner js-file-line”><span class=”pl-c”><span class=”pl-c”>#</span> Create NATGateway</span></td> </tr> <tr> <td id=”L184” class=”blob-num js-line-number” data-line-number=”184”></td> <td id=”LC184” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>MyNATGateway</span>:</td> </tr> <tr> <td id=”L185” class=”blob-num js-line-number” data-line-number=”185”></td> <td id=”LC185” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”><span class=”pl-pds”>"</span>AWS::EC2::NatGateway<span class=”pl-pds”>"</span></span></td> </tr> <tr> <td id=”L186” class=”blob-num js-line-number” data-line-number=”186”></td> <td id=”LC186” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>DependsOn</span>: </td> </tr> <tr> <td id=”L187” class=”blob-num js-line-number” data-line-number=”187”></td> <td id=”LC187” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-s”>MyEIP2</span></td> </tr> <tr> <td id=”L188” class=”blob-num js-line-number” data-line-number=”188”></td> <td id=”LC188” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-s”>PrivateSubnet</span></td> </tr> <tr> <td id=”L189” class=”blob-num js-line-number” data-line-number=”189”></td> <td id=”LC189” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>:</td> </tr> <tr> <td id=”L190” class=”blob-num js-line-number” data-line-number=”190”></td> <td id=”LC190” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>AllocationId</span>: <span class=”pl-s”>!GetAtt MyEIP2.AllocationId</span></td> </tr> <tr> <td id=”L191” class=”blob-num js-line-number” data-line-number=”191”></td> <td id=”LC191” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>SubnetId</span>: <span class=”pl-s”>!Ref PrivateSubnet</span></td> </tr> <tr> <td id=”L192” class=”blob-num js-line-number” data-line-number=”192”></td> <td id=”LC192” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Tags</span>:</td> </tr> <tr> <td id=”L193” class=”blob-num js-line-number” data-line-number=”193”></td> <td id=”LC193” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-ent”>Key</span>: <span class=”pl-s”>Name</span></td> </tr> <tr> <td id=”L194” class=”blob-num js-line-number” data-line-number=”194”></td> <td id=”LC194” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Value</span>: <span class=”pl-s”>handson-minilake-nat</span></td> </tr> <tr> <td id=”L195” class=”blob-num js-line-number” data-line-number=”195”></td> <td id=”LC195” class=”blob-code blob-code-inner js-file-line”><span class=”pl-c”><span class=”pl-c”>#</span> set NAT as default gateway on route table for private subnet</span></td> </tr> <tr> <td id=”L196” class=”blob-num js-line-number” data-line-number=”196”></td> <td id=”LC196” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>MyPrivateRoute</span>:</td> </tr> <tr> <td id=”L197” class=”blob-num js-line-number” data-line-number=”197”></td> <td id=”LC197” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”>AWS::EC2::Route</span></td> </tr> <tr> <td id=”L198” class=”blob-num js-line-number” data-line-number=”198”></td> <td id=”LC198” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>DependsOn</span>: <span class=”pl-s”>MyNATGateway</span></td> </tr> <tr> <td id=”L199” class=”blob-num js-line-number” data-line-number=”199”></td> <td id=”LC199” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>:</td> </tr> <tr> <td id=”L200” class=”blob-num js-line-number” data-line-number=”200”></td> <td id=”LC200” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>RouteTableId</span>: <span class=”pl-s”>!Ref PrivateRouteTable</span></td> </tr> <tr> <td id=”L201” class=”blob-num js-line-number” data-line-number=”201”></td> <td id=”LC201” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>DestinationCidrBlock</span>: <span class=”pl-s”>0.0.0.0/0</span></td> </tr> <tr> <td id=”L202” class=”blob-num js-line-number” data-line-number=”202”></td> <td id=”LC202” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>NatGatewayId</span>: <span class=”pl-s”>!Ref MyNATGateway</span></td> </tr> <tr> <td id=”L203” class=”blob-num js-line-number” data-line-number=”203”></td> <td id=”LC203” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>MyRedShiftSecurityGroup</span>:</td> </tr> <tr> <td id=”L204” class=”blob-num js-line-number” data-line-number=”204”></td> <td id=”LC204” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”><span class=”pl-pds”>'</span>AWS::EC2::SecurityGroup<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L205” class=”blob-num js-line-number” data-line-number=”205”></td> <td id=”LC205” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>:</td> </tr> <tr> <td id=”L206” class=”blob-num js-line-number” data-line-number=”206”></td> <td id=”LC206” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>GroupName</span>: <span class=”pl-s”>handson-minilake-private-sg</span></td> </tr> <tr> <td id=”L207” class=”blob-num js-line-number” data-line-number=”207”></td> <td id=”LC207” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>GroupDescription</span>: <span class=”pl-s”>Enable SSH access via port 5439</span></td> </tr> <tr> <td id=”L208” class=”blob-num js-line-number” data-line-number=”208”></td> <td id=”LC208” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>VpcId</span>: <span class=”pl-s”>!Ref MyVPC</span></td> </tr> <tr> <td id=”L209” class=”blob-num js-line-number” data-line-number=”209”></td> <td id=”LC209” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>SecurityGroupIngress</span>:</td> </tr> <tr> <td id=”L210” class=”blob-num js-line-number” data-line-number=”210”></td> <td id=”LC210” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-ent”>IpProtocol</span>: <span class=”pl-s”>tcp</span></td> </tr> <tr> <td id=”L211” class=”blob-num js-line-number” data-line-number=”211”></td> <td id=”LC211” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>FromPort</span>: <span class=”pl-s”><span class=”pl-pds”>'</span>5439<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L212” class=”blob-num js-line-number” data-line-number=”212”></td> <td id=”LC212” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>ToPort</span>: <span class=”pl-s”><span class=”pl-pds”>'</span>5439<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L213” class=”blob-num js-line-number” data-line-number=”213”></td> <td id=”LC213” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>SourceSecurityGroupId</span>: <span class=”pl-s”>!Ref MyEC2SecurityGroup</span></td> </tr> <tr> <td id=”L214” class=”blob-num js-line-number” data-line-number=”214”></td> <td id=”LC214” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Tags</span>:</td> </tr> <tr> <td id=”L215” class=”blob-num js-line-number” data-line-number=”215”></td> <td id=”LC215” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-ent”>Key</span>: <span class=”pl-s”>Name</span></td> </tr> <tr> <td id=”L216” class=”blob-num js-line-number” data-line-number=”216”></td> <td id=”LC216” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Value</span>: <span class=”pl-s”>handson-minilake-private-sg</span></td> </tr> <tr> <td id=”L217” class=”blob-num js-line-number” data-line-number=”217”></td> <td id=”LC217” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>LogGroupFirehose</span>:</td> </tr> <tr> <td id=”L218” class=”blob-num js-line-number” data-line-number=”218”></td> <td id=”LC218” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”>AWS::Logs::LogGroup</span></td> </tr> <tr> <td id=”L219” class=”blob-num js-line-number” data-line-number=”219”></td> <td id=”LC219” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>:</td> </tr> <tr> <td id=”L220” class=”blob-num js-line-number” data-line-number=”220”></td> <td id=”LC220” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>LogGroupName</span>: <span class=”pl-s”><span class=”pl-pds”>"</span>/aws/kinesisfirehose/minilake1<span class=”pl-pds”>"</span></span></td> </tr> <tr> <td id=”L221” class=”blob-num js-line-number” data-line-number=”221”></td> <td id=”LC221” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>RetentionInDays</span>: <span class=”pl-c1”>7</span></td> </tr> <tr> <td id=”L222” class=”blob-num js-line-number” data-line-number=”222”></td> <td id=”LC222” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Myminilakestream</span>:</td> </tr> <tr> <td id=”L223” class=”blob-num js-line-number” data-line-number=”223”></td> <td id=”LC223” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”>AWS::KinesisFirehose::DeliveryStream</span></td> </tr> <tr> <td id=”L224” class=”blob-num js-line-number” data-line-number=”224”></td> <td id=”LC224” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>:</td> </tr> <tr> <td id=”L225” class=”blob-num js-line-number” data-line-number=”225”></td> <td id=”LC225” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>DeliveryStreamName</span>: <span class=”pl-s”>minilake1</span></td> </tr> <tr> <td id=”L226” class=”blob-num js-line-number” data-line-number=”226”></td> <td id=”LC226” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>DeliveryStreamType</span>: <span class=”pl-s”>DirectPut</span></td> </tr> <tr> <td id=”L227” class=”blob-num js-line-number” data-line-number=”227”></td> <td id=”LC227” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>ExtendedS3DestinationConfiguration</span>:</td> </tr> <tr> <td id=”L228” class=”blob-num js-line-number” data-line-number=”228”></td> <td id=”LC228” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>BucketARN</span>: <span class=”pl-s”>!Sub 'arn:aws:s3:::${S3BucketName}'</span></td> </tr> <tr> <td id=”L229” class=”blob-num js-line-number” data-line-number=”229”></td> <td id=”LC229” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>RoleARN</span>: <span class=”pl-s”>!GetAtt deliveryRole.Arn</span></td> </tr> <tr> <td id=”L230” class=”blob-num js-line-number” data-line-number=”230”></td> <td id=”LC230” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>BufferingHints</span>:</td> </tr> <tr> <td id=”L231” class=”blob-num js-line-number” data-line-number=”231”></td> <td id=”LC231” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>IntervalInSeconds</span>: <span class=”pl-s”><span class=”pl-pds”>'</span>60<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L232” class=”blob-num js-line-number” data-line-number=”232”></td> <td id=”LC232” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>SizeInMBs</span>: <span class=”pl-s”><span class=”pl-pds”>'</span>5<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L233” class=”blob-num js-line-number” data-line-number=”233”></td> <td id=”LC233” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Prefix</span>: <span class=”pl-s”><span class=”pl-pds”>"</span>minilake-in1/<span class=”pl-pds”>"</span></span></td> </tr> <tr> <td id=”L234” class=”blob-num js-line-number” data-line-number=”234”></td> <td id=”LC234” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>ProcessingConfiguration</span>:</td> </tr> <tr> <td id=”L235” class=”blob-num js-line-number” data-line-number=”235”></td> <td id=”LC235” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Enabled</span>: <span class=”pl-s”><span class=”pl-pds”>'</span>false<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L236” class=”blob-num js-line-number” data-line-number=”236”></td> <td id=”LC236” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>CloudWatchLoggingOptions</span>:</td> </tr> <tr> <td id=”L237” class=”blob-num js-line-number” data-line-number=”237”></td> <td id=”LC237” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Enabled</span>: <span class=”pl-s”><span class=”pl-pds”>'</span>true<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L238” class=”blob-num js-line-number” data-line-number=”238”></td> <td id=”LC238” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>LogGroupName</span>: <span class=”pl-s”>!Ref 'LogGroupFirehose'</span></td> </tr> <tr> <td id=”L239” class=”blob-num js-line-number” data-line-number=”239”></td> <td id=”LC239” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>LogStreamName</span>: <span class=”pl-s”><span class=”pl-pds”>'</span>S3Delivery<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L240” class=”blob-num js-line-number” data-line-number=”240”></td> <td id=”LC240” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Myminilakestreamlogstream</span>:</td> </tr> <tr> <td id=”L241” class=”blob-num js-line-number” data-line-number=”241”></td> <td id=”LC241” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”>AWS::Logs::LogStream</span></td> </tr> <tr> <td id=”L242” class=”blob-num js-line-number” data-line-number=”242”></td> <td id=”LC242” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>:</td> </tr> <tr> <td id=”L243” class=”blob-num js-line-number” data-line-number=”243”></td> <td id=”LC243” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>LogGroupName</span>: <span class=”pl-s”>!Ref 'LogGroupFirehose'</span></td> </tr> <tr> <td id=”L244” class=”blob-num js-line-number” data-line-number=”244”></td> <td id=”LC244” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>LogStreamName</span>: <span class=”pl-s”><span class=”pl-pds”>'</span>S3Delivery<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L245” class=”blob-num js-line-number” data-line-number=”245”></td> <td id=”LC245” class=”blob-code blob-code-inner js-file-line”> </td> </tr> <tr> <td id=”L246” class=”blob-num js-line-number” data-line-number=”246”></td> <td id=”LC246” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>deliveryRole</span>:</td> </tr> <tr> <td id=”L247” class=”blob-num js-line-number” data-line-number=”247”></td> <td id=”LC247” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Type</span>: <span class=”pl-s”>AWS::IAM::Role</span></td> </tr> <tr> <td id=”L248” class=”blob-num js-line-number” data-line-number=”248”></td> <td id=”LC248” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Properties</span>:</td> </tr> <tr> <td id=”L249” class=”blob-num js-line-number” data-line-number=”249”></td> <td id=”LC249” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>AssumeRolePolicyDocument</span>:</td> </tr> <tr> <td id=”L250” class=”blob-num js-line-number” data-line-number=”250”></td> <td id=”LC250” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Version</span>: <span class=”pl-c1”>2012-10-17</span></td> </tr> <tr> <td id=”L251” class=”blob-num js-line-number” data-line-number=”251”></td> <td id=”LC251” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Statement</span>:</td> </tr> <tr> <td id=”L252” class=”blob-num js-line-number” data-line-number=”252”></td> <td id=”LC252” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-ent”>Sid</span>: <span class=”pl-s”><span class=”pl-pds”>'</span><span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L253” class=”blob-num js-line-number” data-line-number=”253”></td> <td id=”LC253” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Effect</span>: <span class=”pl-s”>Allow</span></td> </tr> <tr> <td id=”L254” class=”blob-num js-line-number” data-line-number=”254”></td> <td id=”LC254” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Principal</span>:</td> </tr> <tr> <td id=”L255” class=”blob-num js-line-number” data-line-number=”255”></td> <td id=”LC255” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Service</span>: <span class=”pl-s”>firehose.amazonaws.com</span></td> </tr> <tr> <td id=”L256” class=”blob-num js-line-number” data-line-number=”256”></td> <td id=”LC256” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Action</span>: <span class=”pl-s”><span class=”pl-pds”>'</span>sts:AssumeRole<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L257” class=”blob-num js-line-number” data-line-number=”257”></td> <td id=”LC257” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Condition</span>:</td> </tr> <tr> <td id=”L258” class=”blob-num js-line-number” data-line-number=”258”></td> <td id=”LC258” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>StringEquals</span>:</td> </tr> <tr> <td id=”L259” class=”blob-num js-line-number” data-line-number=”259”></td> <td id=”LC259” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-s”><span class=”pl-pds”>'</span><span class=”pl-ent”>sts:ExternalId</span><span class=”pl-pds”>'</span></span>: <span class=”pl-s”>!Ref 'AWS::AccountId'</span></td> </tr> <tr> <td id=”L260” class=”blob-num js-line-number” data-line-number=”260”></td> <td id=”LC260” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Path</span>: <span class=”pl-s”><span class=”pl-pds”>"</span>/<span class=”pl-pds”>"</span></span></td> </tr> <tr> <td id=”L261” class=”blob-num js-line-number” data-line-number=”261”></td> <td id=”LC261” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Policies</span>:</td> </tr> <tr> <td id=”L262” class=”blob-num js-line-number” data-line-number=”262”></td> <td id=”LC262” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-ent”>PolicyName</span>: <span class=”pl-s”>firehose_delivery_policy</span></td> </tr> <tr> <td id=”L263” class=”blob-num js-line-number” data-line-number=”263”></td> <td id=”LC263” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>PolicyDocument</span>:</td> </tr> <tr> <td id=”L264” class=”blob-num js-line-number” data-line-number=”264”></td> <td id=”LC264” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Version</span>: <span class=”pl-c1”>2012-10-17</span></td> </tr> <tr> <td id=”L265” class=”blob-num js-line-number” data-line-number=”265”></td> <td id=”LC265” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Statement</span>:</td> </tr> <tr> <td id=”L266” class=”blob-num js-line-number” data-line-number=”266”></td> <td id=”LC266” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-ent”>Effect</span>: <span class=”pl-s”>Allow</span></td> </tr> <tr> <td id=”L267” class=”blob-num js-line-number” data-line-number=”267”></td> <td id=”LC267” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Action</span>:</td> </tr> <tr> <td id=”L268” class=”blob-num js-line-number” data-line-number=”268”></td> <td id=”LC268” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-s”><span class=”pl-pds”>'</span>s3:AbortMultipartUpload<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L269” class=”blob-num js-line-number” data-line-number=”269”></td> <td id=”LC269” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-s”><span class=”pl-pds”>'</span>s3:GetBucketLocation<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L270” class=”blob-num js-line-number” data-line-number=”270”></td> <td id=”LC270” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-s”><span class=”pl-pds”>'</span>s3:GetObject<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L271” class=”blob-num js-line-number” data-line-number=”271”></td> <td id=”LC271” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-s”><span class=”pl-pds”>'</span>s3:ListBucket<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L272” class=”blob-num js-line-number” data-line-number=”272”></td> <td id=”LC272” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-s”><span class=”pl-pds”>'</span>s3:ListBucketMultipartUploads<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L273” class=”blob-num js-line-number” data-line-number=”273”></td> <td id=”LC273” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-s”><span class=”pl-pds”>'</span>s3:PutObject<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L274” class=”blob-num js-line-number” data-line-number=”274”></td> <td id=”LC274” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Resource</span>:</td> </tr> <tr> <td id=”L275” class=”blob-num js-line-number” data-line-number=”275”></td> <td id=”LC275” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-k”>!Sub</span> <span class=”pl-s”><span class=”pl-pds”>'</span>arn:aws:s3:::${S3BucketName}<span class=”pl-pds”>'</span></span> </td> </tr> <tr> <td id=”L276” class=”blob-num js-line-number” data-line-number=”276”></td> <td id=”LC276” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-k”>!Sub</span> <span class=”pl-s”><span class=”pl-pds”>'</span>arn:aws:s3:::${S3BucketName}/*<span class=”pl-pds”>'</span></span> </td> </tr> <tr> <td id=”L277” class=”blob-num js-line-number” data-line-number=”277”></td> <td id=”LC277” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-ent”>Effect</span>: <span class=”pl-s”>Allow</span></td> </tr> <tr> <td id=”L278” class=”blob-num js-line-number” data-line-number=”278”></td> <td id=”LC278” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Action</span>: <span class=”pl-s”><span class=”pl-pds”>'</span>logs:PutLogEvents<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L279” class=”blob-num js-line-number” data-line-number=”279”></td> <td id=”LC279” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Resource</span>: <span class=”pl-s”><span class=”pl-pds”>'</span>*<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L280” class=”blob-num js-line-number” data-line-number=”280”></td> <td id=”LC280” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-ent”>Effect</span>: <span class=”pl-s”>Allow</span></td> </tr> <tr> <td id=”L281” class=”blob-num js-line-number” data-line-number=”281”></td> <td id=”LC281” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Action</span>:</td> </tr> <tr> <td id=”L282” class=”blob-num js-line-number” data-line-number=”282”></td> <td id=”LC282” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-s”><span class=”pl-pds”>'</span>glue:GetTable<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L283” class=”blob-num js-line-number” data-line-number=”283”></td> <td id=”LC283” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-s”><span class=”pl-pds”>'</span>glue:GetTableVersion<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L284” class=”blob-num js-line-number” data-line-number=”284”></td> <td id=”LC284” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-s”><span class=”pl-pds”>'</span>glue:GetTableVersions<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L285” class=”blob-num js-line-number” data-line-number=”285”></td> <td id=”LC285” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Resource</span>: <span class=”pl-s”><span class=”pl-pds”>'</span>*<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L286” class=”blob-num js-line-number” data-line-number=”286”></td> <td id=”LC286” class=”blob-code blob-code-inner js-file-line”><span class=”pl-ent”>Outputs</span>:</td> </tr> <tr> <td id=”L287” class=”blob-num js-line-number” data-line-number=”287”></td> <td id=”LC287” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>AllowIPAddress</span>:</td> </tr> <tr> <td id=”L288” class=”blob-num js-line-number” data-line-number=”288”></td> <td id=”LC288” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Description</span>: <span class=”pl-s”>EC2 PublicIP</span></td> </tr> <tr> <td id=”L289” class=”blob-num js-line-number” data-line-number=”289”></td> <td id=”LC289” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Value</span>: <span class=”pl-s”>!Join</span></td> </tr> <tr> <td id=”L290” class=”blob-num js-line-number” data-line-number=”290”></td> <td id=”LC290” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-s”><span class=”pl-pds”>'</span>,<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L291” class=”blob-num js-line-number” data-line-number=”291”></td> <td id=”LC291” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-s”>- !Ref MyEIP</span></td> </tr> <tr> <td id=”L292” class=”blob-num js-line-number” data-line-number=”292”></td> <td id=”LC292” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>VPCID</span>:</td> </tr> <tr> <td id=”L293” class=”blob-num js-line-number” data-line-number=”293”></td> <td id=”LC293” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Description</span>: <span class=”pl-s”>VPC ID</span></td> </tr> <tr> <td id=”L294” class=”blob-num js-line-number” data-line-number=”294”></td> <td id=”LC294” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Value</span>: <span class=”pl-s”>!Join</span></td> </tr> <tr> <td id=”L295” class=”blob-num js-line-number” data-line-number=”295”></td> <td id=”LC295” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-s”><span class=”pl-pds”>'</span>,<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L296” class=”blob-num js-line-number” data-line-number=”296”></td> <td id=”LC296” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-s”>- !Ref MyVPC</span></td> </tr> <tr> <td id=”L297” class=”blob-num js-line-number” data-line-number=”297”></td> <td id=”LC297” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>PrivateSunetID</span>:</td> </tr> <tr> <td id=”L298” class=”blob-num js-line-number” data-line-number=”298”></td> <td id=”LC298” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Description</span>: <span class=”pl-s”>Private Subnet ID</span></td> </tr> <tr> <td id=”L299” class=”blob-num js-line-number” data-line-number=”299”></td> <td id=”LC299” class=”blob-code blob-code-inner js-file-line”> <span class=”pl-ent”>Value</span>: <span class=”pl-s”>!Join</span></td> </tr> <tr> <td id=”L300” class=”blob-num js-line-number” data-line-number=”300”></td> <td id=”LC300” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-s”><span class=”pl-pds”>'</span>,<span class=”pl-pds”>'</span></span></td> </tr> <tr> <td id=”L301” class=”blob-num js-line-number” data-line-number=”301”></td> <td id=”LC301” class=”blob-code blob-code-inner js-file-line”> - <span class=”pl-s”>- !Ref PrivateSubnet</span></td> </tr> </table>

<details class=”details-reset details-overlay BlobToolbar position-absolute js-file-line-actions dropdown d-none” aria-hidden=”true”> <summary class=”btn-octicon ml-0 px-2 p-0 bg-white border color-border-tertiary rounded-1” aria-label=”Inline file action toolbar”> <svg class=”octicon octicon-kebab-horizontal” viewBox=”0 0 16 16” version=”1.1” width=”16” height=”16” aria-hidden=”true”><path d=”M8 9a1.5 1.5 0 100-3 1.5 1.5 0 000 3zM1.5 9a1.5 1.5 0 100-3 1.5 1.5 0 000 3zm13 0a1.5 1.5 0 100-3 1.5 1.5 0 000 3z”></path></svg> </summary> <details-menu> <ul class=”BlobToolbar-dropdown dropdown-menu dropdown-menu-se mt-2” style=”width:185px”> <li> <clipboard-copy role=”menuitem” class=”dropdown-item” id=”js-copy-lines” style=”cursor:pointer;”> Copy lines </clipboard-copy> </li> <li> <clipboard-copy role=”menuitem” class=”dropdown-item” id=”js-copy-permalink” style=”cursor:pointer;”> Copy permalink </clipboard-copy> </li> <li><a class=”dropdown-item js-update-url-with-hash” id=”js-view-git-blame” role=”menuitem” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/blame/e64fc860b51963d3ed71481e7807deb2a42f910a/3-minilake.yaml”>View git blame</a></li> <li><a class=”dropdown-item” id=”js-new-issue” role=”menuitem” href=”/harunobukameda/Amazon-Redshift-Spectrum-AWS-Glue-Amazon-Athena-Amazon-S3-Select/issues/new”>Reference in new issue</a></li> </ul> </details-menu> </details>

</div>

</div>

</div> </div>

</main> </div>

</div>

<div class=”footer container-xl width-full p-responsive” role=”contentinfo”> <div class=”position-relative d-flex flex-row-reverse flex-lg-row flex-wrap flex-lg-nowrap flex-justify-center flex-lg-justify-between pt-6 pb-2 mt-6 f6 text-gray border-top color-border-secondary “> <ul class=”list-style-none d-flex flex-wrap col-12 col-lg-5 flex-justify-center flex-lg-justify-between mb-2 mb-lg-0”> <li class=”mr-3 mr-lg-0”>© 2021 GitHub, Inc.</li> <li class=”mr-3 mr-lg-0”><a data-ga-click=”Footer, go to terms, text:terms” href=”https://github.com/site/terms”>Terms</a></li> <li class=”mr-3 mr-lg-0”><a data-ga-click=”Footer, go to privacy, text:privacy” href=”https://github.com/site/privacy”>Privacy</a></li> <li class=”mr-3 mr-lg-0”><a data-ga-click=”Footer, go to security, text:security” href=”https://github.com/security”>Security</a></li> <li class=”mr-3 mr-lg-0”><a href=”https://www.githubstatus.com/” data-ga-click=”Footer, go to status, text:status”>Status</a></li> <li><a data-ga-click=”Footer, go to help, text:Docs” href=”https://docs.github.com”>Docs</a></li> </ul>

<a aria-label=”Homepage” title=”GitHub” class=”footer-octicon d-none d-lg-block mx-lg-4” href=”https://github.com”> <svg height=”24” class=”octicon octicon-mark-github” viewBox=”0 0 16 16” version=”1.1” width=”24” aria-hidden=”true”><path fill-rule=”evenodd” d=”M8 0C3.58 0 0 3.58 0 8c0 3.54 2.29 6.53 5.47 7.59.4.07.55-.17.55-.38 0-.19-.01-.82-.01-1.49-2.01.37-2.53-.49-2.69-.94-.09-.23-.48-.94-.82-1.13-.28-.15-.68-.52-.01-.53.63-.01 1.08.58 1.23.82.72 1.21 1.87.87 2.33.66.07-.52.28-.87.51-1.07-1.78-.2-3.64-.89-3.64-3.95 0-.87.31-1.59.82-2.15-.08-.2-.36-1.02.08-2.12 0 0 .67-.21 2.2.82.64-.18 1.32-.27 2-.27.68 0 1.36.09 2 .27 1.53-1.04 2.2-.82 2.2-.82.44 1.1.16 1.92.08 2.12.51.56.82 1.27.82 2.15 0 3.07-1.87 3.75-3.65 3.95.29.25.54.73.54 1.48 0 1.07-.01 1.93-.01 2.2 0 .21.15.46.55.38A8.013 8.013 0 0016 8c0-4.42-3.58-8-8-8z”></path></svg> </a> <ul class=”list-style-none d-flex flex-wrap col-12 col-lg-5 flex-justify-center flex-lg-justify-between mb-2 mb-lg-0”> <li class=”mr-3 mr-lg-0”><a data-ga-click=”Footer, go to contact, text:contact” href=”https://github.com/contact”>Contact GitHub</a></li> <li class=”mr-3 mr-lg-0”><a href=”https://github.com/pricing” data-ga-click=”Footer, go to Pricing, text:Pricing”>Pricing</a></li> <li class=”mr-3 mr-lg-0”><a href=”https://docs.github.com” data-ga-click=”Footer, go to api, text:api”>API</a></li> <li class=”mr-3 mr-lg-0”><a href=”https://services.github.com” data-ga-click=”Footer, go to training, text:training”>Training</a></li> <li class=”mr-3 mr-lg-0”><a href=”https://github.blog” data-ga-click=”Footer, go to blog, text:blog”>Blog</a></li> <li><a data-ga-click=”Footer, go to about, text:about” href=”https://github.com/about”>About</a></li> </ul> </div> <div class=”d-flex flex-justify-center pb-6”> <span class=”f6 text-gray-light”></span> </div>

</div>

<div id=”ajax-error-message” class=”ajax-error-message flash flash-error” hidden> <svg class=”octicon octicon-alert” viewBox=”0 0 16 16” version=”1.1” width=”16” height=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M8.22 1.754a.25.25 0 00-.44 0L1.698 13.132a.25.25 0 00.22.368h12.164a.25.25 0 00.22-.368L8.22 1.754zm-1.763-.707c.659-1.234 2.427-1.234 3.086 0l6.082 11.378A1.75 1.75 0 0114.082 15H1.918a1.75 1.75 0 01-1.543-2.575L6.457 1.047zM9 11a1 1 0 11-2 0 1 1 0 012 0zm-.25-5.25a.75.75 0 00-1.5 0v2.5a.75.75 0 001.5 0v-2.5z”></path></svg> <button type=”button” class=”flash-close js-ajax-error-dismiss” aria-label=”Dismiss error”> <svg class=”octicon octicon-x” viewBox=”0 0 16 16” version=”1.1” width=”16” height=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M3.72 3.72a.75.75 0 011.06 0L8 6.94l3.22-3.22a.75.75 0 111.06 1.06L9.06 8l3.22 3.22a.75.75 0 11-1.06 1.06L8 9.06l-3.22 3.22a.75.75 0 01-1.06-1.06L6.94 8 3.72 4.78a.75.75 0 010-1.06z”></path></svg> </button> You can’t perform that action at this time. </div>

<div class=”js-stale-session-flash flash flash-warn flash-banner” hidden > <svg class=”octicon octicon-alert” viewBox=”0 0 16 16” version=”1.1” width=”16” height=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M8.22 1.754a.25.25 0 00-.44 0L1.698 13.132a.25.25 0 00.22.368h12.164a.25.25 0 00.22-.368L8.22 1.754zm-1.763-.707c.659-1.234 2.427-1.234 3.086 0l6.082 11.378A1.75 1.75 0 0114.082 15H1.918a1.75 1.75 0 01-1.543-2.575L6.457 1.047zM9 11a1 1 0 11-2 0 1 1 0 012 0zm-.25-5.25a.75.75 0 00-1.5 0v2.5a.75.75 0 001.5 0v-2.5z”></path></svg> <span class=”js-stale-session-flash-signed-in” hidden>You signed in with another tab or window. <a href=”“>Reload</a> to refresh your session.</span> <span class=”js-stale-session-flash-signed-out” hidden>You signed out in another tab or window. <a href=”“>Reload</a> to refresh your session.</span> </div> <template id=”site-details-dialog”> <details class=”details-reset details-overlay details-overlay-dark lh-default text-gray-dark hx_rsm” open> <summary role=”button” aria-label=”Close dialog”></summary> <details-dialog class=”Box Box–overlay d-flex flex-column anim-fade-in fast hx_rsm-dialog hx_rsm-modal”> <button class=”Box-btn-octicon m-0 btn-octicon position-absolute right-0 top-0” type=”button” aria-label=”Close dialog” data-close-dialog> <svg class=”octicon octicon-x” viewBox=”0 0 16 16” version=”1.1” width=”16” height=”16” aria-hidden=”true”><path fill-rule=”evenodd” d=”M3.72 3.72a.75.75 0 011.06 0L8 6.94l3.22-3.22a.75.75 0 111.06 1.06L9.06 8l3.22 3.22a.75.75 0 11-1.06 1.06L8 9.06l-3.22 3.22a.75.75 0 01-1.06-1.06L6.94 8 3.72 4.78a.75.75 0 010-1.06z”></path></svg> </button> <div class=”octocat-spinner my-6 js-details-dialog-spinner”></div> </details-dialog> </details> </template>

</body> </html>

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

3-minilake.yaml.org

3-minilake.yaml.org

Files

3-minilake.yaml.org

Latest commit

History

3-minilake.yaml.org

File metadata and controls