CINXE.COM
<!doctype html><html lang="en"><head><title data-rh="true">Use Google Cloud Spanner with the Online Boutique sample | by Mathieu Benoit | Google Cloud - Community | Medium</title><meta data-rh="true" charset="utf-8"/><meta data-rh="true" name="viewport" content="width=device-width,minimum-scale=1,initial-scale=1,maximum-scale=1"/><meta data-rh="true" name="theme-color" content="#000000"/><meta data-rh="true" name="twitter:app:name:iphone" content="Medium"/><meta data-rh="true" name="twitter:app:id:iphone" content="828256236"/><meta data-rh="true" property="al:ios:app_name" content="Medium"/><meta data-rh="true" property="al:ios:app_store_id" content="828256236"/><meta data-rh="true" property="al:android:package" content="com.medium.reader"/><meta data-rh="true" property="fb:app_id" content="542599432471018"/><meta data-rh="true" property="og:site_name" content="Medium"/><meta data-rh="true" property="og:type" content="article"/><meta data-rh="true" property="article:published_time" content="2024-04-01T22:13:34.260Z"/><meta data-rh="true" name="title" content="Use Google Cloud Spanner with the Online Boutique sample | by Mathieu Benoit | Google Cloud - Community | Medium"/><meta data-rh="true" property="og:title" content="Use Google Cloud Spanner with the Online Boutique sample"/><meta data-rh="true" property="al:android:url" content="medium://p/f7248e077339"/><meta data-rh="true" property="al:ios:url" content="medium://p/f7248e077339"/><meta data-rh="true" property="al:android:app_name" content="Medium"/><meta data-rh="true" name="description" content="By default the cartservice of the Online Boutique sample stores its data in an in-cluster Redis database. However, using a fully managed database service outside your Google Kubernetes Engine (GKE)…"/><meta data-rh="true" property="og:description" content="Updated on April 1st, 2024 with the new way to configure Workload Identity with GKE workload."/><meta data-rh="true" property="og:url" content="https://medium.com/google-cloud/use-google-cloud-spanner-with-the-online-boutique-sample-apps-f7248e077339"/><meta data-rh="true" property="al:web:url" content="https://medium.com/google-cloud/use-google-cloud-spanner-with-the-online-boutique-sample-apps-f7248e077339"/><meta data-rh="true" property="og:image" content="https://miro.medium.com/v2/resize:fit:1200/0*A8lG1q1M29P72YWY.png"/><meta data-rh="true" property="article:author" content="https://medium.com/@mabenoit"/><meta data-rh="true" name="author" content="Mathieu Benoit"/><meta data-rh="true" name="robots" content="index,noarchive,follow,max-image-preview:large"/><meta data-rh="true" name="referrer" content="unsafe-url"/><meta data-rh="true" property="twitter:title" content="Use Google Cloud Spanner with the Online Boutique sample"/><meta data-rh="true" name="twitter:site" content="@googlecloudtech"/><meta data-rh="true" name="twitter:app:url:iphone" content="medium://p/f7248e077339"/><meta data-rh="true" property="twitter:description" content="Updated on April 1st, 2024 with the new way to configure Workload Identity with GKE workload."/><meta data-rh="true" name="twitter:image:src" content="https://miro.medium.com/v2/resize:fit:1200/0*A8lG1q1M29P72YWY.png"/><meta data-rh="true" name="twitter:card" content="summary_large_image"/><meta data-rh="true" name="twitter:label1" content="Reading time"/><meta data-rh="true" name="twitter:data1" content="4 min read"/><link data-rh="true" rel="icon" href="https://miro.medium.com/v2/5d8de952517e8160e40ef9841c781cdc14a5db313057fa3c3de41c6f5b494b19"/><link data-rh="true" rel="search" type="application/opensearchdescription+xml" title="Medium" href="/osd.xml"/><link data-rh="true" rel="apple-touch-icon" sizes="152x152" href="https://miro.medium.com/v2/resize:fill:304:304/10fd5c419ac61637245384e7099e131627900034828f4f386bdaa47a74eae156"/><link data-rh="true" rel="apple-touch-icon" sizes="120x120" href="https://miro.medium.com/v2/resize:fill:240:240/10fd5c419ac61637245384e7099e131627900034828f4f386bdaa47a74eae156"/><link data-rh="true" rel="apple-touch-icon" sizes="76x76" href="https://miro.medium.com/v2/resize:fill:152:152/10fd5c419ac61637245384e7099e131627900034828f4f386bdaa47a74eae156"/><link data-rh="true" rel="apple-touch-icon" sizes="60x60" href="https://miro.medium.com/v2/resize:fill:120:120/10fd5c419ac61637245384e7099e131627900034828f4f386bdaa47a74eae156"/><link data-rh="true" rel="mask-icon" href="https://miro.medium.com/v2/resize:fill:1000:1000/7*GAOKVe--MXbEJmV9230oOQ.png" color="#171717"/><link data-rh="true" rel="preconnect" href="https://glyph.medium.com" crossOrigin=""/><link data-rh="true" id="glyph_preload_link" rel="preload" as="style" type="text/css" href="https://glyph.medium.com/css/unbound.css"/><link data-rh="true" id="glyph_link" rel="stylesheet" type="text/css" href="https://glyph.medium.com/css/unbound.css"/><link data-rh="true" rel="author" href="https://medium.com/@mabenoit"/><link data-rh="true" rel="canonical" href="https://medium.com/google-cloud/use-google-cloud-spanner-with-the-online-boutique-sample-apps-f7248e077339"/><link data-rh="true" rel="alternate" href="android-app://com.medium.reader/https/medium.com/p/f7248e077339"/><script data-rh="true" type="application/ld+json">{"@context":"http:\u002F\u002Fschema.org","@type":"NewsArticle","image":["https:\u002F\u002Fmiro.medium.com\u002Fv2\u002Fresize:fit:1200\u002F0*A8lG1q1M29P72YWY.png"],"url":"https:\u002F\u002Fmedium.com\u002Fgoogle-cloud\u002Fuse-google-cloud-spanner-with-the-online-boutique-sample-apps-f7248e077339","dateCreated":"2022-10-18T12:59:46.538Z","datePublished":"2022-10-18T12:59:46.538Z","dateModified":"2024-04-01T22:13:34.260Z","headline":"Use Google Cloud Spanner with the Online Boutique sample","name":"Use Google Cloud Spanner with the Online Boutique sample","description":"By default the cartservice of the Online Boutique sample stores its data in an in-cluster Redis database. However, using a fully managed database service outside your Google Kubernetes Engine (GKE)…","identifier":"f7248e077339","author":{"@type":"Person","name":"Mathieu Benoit","url":"https:\u002F\u002Fmedium.com\u002F@mabenoit"},"creator":["Mathieu Benoit"],"publisher":{"@type":"Organization","name":"Google Cloud - Community","url":"https:\u002F\u002Fmedium.com\u002Fgoogle-cloud","logo":{"@type":"ImageObject","width":60,"height":60,"url":"https:\u002F\u002Fmiro.medium.com\u002Fv2\u002Fresize:fit:120\u002F1*FUjLiCANvATKeaJEeg20Rw.png"}},"mainEntityOfPage":"https:\u002F\u002Fmedium.com\u002Fgoogle-cloud\u002Fuse-google-cloud-spanner-with-the-online-boutique-sample-apps-f7248e077339"}</script><style type="text/css" data-fela-rehydration="590" data-fela-type="STATIC">html{box-sizing:border-box;-webkit-text-size-adjust:100%}*, *:before, *:after{box-sizing:inherit}body{margin:0;padding:0;text-rendering:optimizeLegibility;-webkit-font-smoothing:antialiased;color:rgba(0,0,0,0.8);position:relative;min-height:100vh}h1, h2, h3, h4, h5, h6, dl, dd, ol, ul, menu, figure, blockquote, p, pre, form{margin:0}menu, ol, ul{padding:0;list-style:none;list-style-image:none}main{display:block}a{color:inherit;text-decoration:none}a, button, input{-webkit-tap-highlight-color:transparent}img, svg{vertical-align:middle}button{background:transparent;overflow:visible}button, input, optgroup, select, textarea{margin:0}:root{--reach-tabs:1;--reach-menu-button:1}#speechify-root{font-family:Sohne, sans-serif}div[data-popper-reference-hidden="true"]{visibility:hidden;pointer-events:none}.grecaptcha-badge{visibility:hidden} /*XCode style (c) Angel Garcia <angelgarcia.mail@gmail.com>*/.hljs {background: #fff;color: black; }/* Gray DOCTYPE selectors like WebKit */ .xml .hljs-meta {color: #c0c0c0; }.hljs-comment, .hljs-quote {color: #007400; }.hljs-tag, .hljs-attribute, .hljs-keyword, .hljs-selector-tag, .hljs-literal, .hljs-name {color: #aa0d91; }.hljs-variable, .hljs-template-variable {color: #3F6E74; }.hljs-code, .hljs-string, .hljs-meta .hljs-string {color: #c41a16; }.hljs-regexp, .hljs-link {color: #0E0EFF; }.hljs-title, .hljs-symbol, .hljs-bullet, .hljs-number {color: #1c00cf; }.hljs-section, .hljs-meta {color: #643820; }.hljs-title.class_, .hljs-class .hljs-title, .hljs-type, .hljs-built_in, .hljs-params {color: #5c2699; }.hljs-attr {color: #836C28; }.hljs-subst {color: #000; }.hljs-formula {background-color: #eee;font-style: italic; }.hljs-addition {background-color: #baeeba; }.hljs-deletion {background-color: #ffc8bd; }.hljs-selector-id, .hljs-selector-class {color: #9b703f; }.hljs-doctag, .hljs-strong {font-weight: bold; }.hljs-emphasis {font-style: italic; } </style><style type="text/css" data-fela-rehydration="590" data-fela-type="KEYFRAME">@-webkit-keyframes k1{0%{opacity:0.8}50%{opacity:0.5}100%{opacity:0.8}}@-moz-keyframes k1{0%{opacity:0.8}50%{opacity:0.5}100%{opacity:0.8}}@keyframes k1{0%{opacity:0.8}50%{opacity:0.5}100%{opacity:0.8}}</style><style type="text/css" data-fela-rehydration="590" data-fela-type="RULE">.a{font-family:medium-content-sans-serif-font, -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen, Ubuntu, Cantarell, "Open Sans", "Helvetica Neue", sans-serif}.b{font-weight:400}.c{background-color:rgba(255, 255, 255, 1)}.l{display:block}.m{position:sticky}.n{top:0}.o{z-index:500}.p{padding:0 24px}.q{align-items:center}.r{border-bottom:solid 1px #F2F2F2}.y{height:41px}.z{line-height:20px}.ab{display:flex}.ac{height:57px}.ae{flex:1 0 auto}.af{gap:16px}.ag{color:inherit}.ah{fill:inherit}.ai{font-size:inherit}.aj{border:inherit}.ak{font-family:inherit}.al{letter-spacing:inherit}.am{font-weight:inherit}.an{padding:0}.ao{margin:0}.ap{cursor:pointer}.aq:disabled{cursor:not-allowed}.ar:disabled{color:#6B6B6B}.as:disabled{fill:#6B6B6B}.av{width:auto}.aw path{fill:#242424}.ax{height:25px}.ay{border:none}.az{border-radius:20px}.ba{width:240px}.bb{background:#F9F9F9}.bc path{fill:#6B6B6B}.be{outline:none}.bf{font-family:sohne, "Helvetica Neue", Helvetica, Arial, sans-serif}.bg{font-size:14px}.bh{width:100%}.bi{padding:10px 20px 10px 0}.bj{background-color:transparent}.bk{color:#242424}.bl::placeholder{color:#6B6B6B}.bm{display:inline-block}.bn{margin-left:12px}.bo{margin-right:12px}.bp{border-radius:4px}.bq{margin-left:24px}.br{height:24px}.bx{background-color:#F9F9F9}.by{border-radius:50%}.bz{height:32px}.ca{width:32px}.cb{flex:0 0 auto}.cc{flex:1 1 auto}.cd{justify-content:center}.cj{max-width:680px}.ck{min-width:0}.cl{animation:k1 1.2s ease-in-out infinite}.cm{height:100vh}.cn{margin-bottom:16px}.co{margin-top:48px}.cp{align-items:flex-start}.cq{flex-direction:column}.cr{justify-content:space-between}.cs{margin-bottom:24px}.cy{width:80%}.cz{background-color:#F2F2F2}.df{height:44px}.dg{width:44px}.dh{margin:auto 0}.di{margin-bottom:4px}.dj{height:16px}.dk{width:120px}.dl{width:80px}.dr{margin-bottom:8px}.ds{width:96%}.dt{width:98%}.du{width:81%}.dv{margin-left:8px}.dw{color:#6B6B6B}.dx{font-size:13px}.dy{height:100%}.er{color:#FFFFFF}.es{fill:#FFFFFF}.et{background:rgba(26, 137, 23, 1)}.eu{border-color:rgba(26, 137, 23, 1)}.ey:disabled{cursor:inherit !important}.ez:disabled{opacity:0.3}.fa:disabled:hover{background:rgba(26, 137, 23, 1)}.fb:disabled:hover{border-color:rgba(26, 137, 23, 1)}.fc{border-radius:99em}.fd{border-width:1px}.fe{border-style:solid}.ff{box-sizing:border-box}.fg{text-decoration:none}.fh{text-align:center}.fi{margin-left:16px}.fl{margin-right:32px}.fm{position:relative}.fn{fill:#6B6B6B}.fq{background:transparent}.fr svg{margin-left:4px}.fs svg{fill:#6B6B6B}.fu{box-shadow:inset 0 0 0 1px rgba(0, 0, 0, 0.05)}.fv{position:absolute}.fx{max-width:100%}.fy{overflow:hidden}.fz{text-overflow:ellipsis}.ga{white-space:nowrap}.gb{border-bottom:1px solid #F2F2F2}.gc{height:3px}.gd{max-width:1192px}.gj{font-weight:500}.gx{margin:0 8px}.gy{display:inline}.gz{font-size:16px}.ha{line-height:24px}.hb{pointer-events:none}.hc{will-change:opacity, transform}.hf{opacity:0}.hg{transform:translateY(89px)}.hh{width:148px}.hi{border-radius:2px}.hj{height:38px}.hk{width:38px}.hm{margin-top:16px}.hn{word-break:break-word}.ht{margin:0 24px}.hx{background:rgba(255, 255, 255, 1)}.hy{border:1px solid #F2F2F2}.hz{box-shadow:0 1px 4px #F2F2F2}.ia{max-height:100vh}.ib{overflow-y:auto}.ic{left:0}.id{top:calc(100vh + 100px)}.ie{bottom:calc(100vh + 100px)}.if{width:10px}.ig{word-wrap:break-word}.ih:after{display:block}.ii:after{content:""}.ij:after{clear:both}.ik{line-height:1.23}.il{letter-spacing:0}.im{font-style:normal}.in{font-weight:700}.js{align-items:baseline}.jt{width:48px}.ju{height:48px}.jv{border:2px solid rgba(255, 255, 255, 1)}.jw{z-index:0}.jx{box-shadow:none}.jy{border:1px solid rgba(0, 0, 0, 0.05)}.jz{margin-left:-12px}.ka{width:28px}.kb{height:28px}.kc{z-index:1}.kd{width:24px}.ke{margin-bottom:2px}.kf{flex-wrap:nowrap}.kh{text-decoration:underline}.kk{flex-wrap:wrap}.kl{white-space:pre-wrap}.km{margin-right:4px}.kn{max-height:20px}.ko{display:-webkit-box}.kp{-webkit-line-clamp:1}.kq{-webkit-box-orient:vertical}.kr{word-break:break-all}.kt{padding-left:8px}.ku{padding-right:8px}.lv> *{flex-shrink:0}.lw{overflow-x:scroll}.lx::-webkit-scrollbar{display:none}.ly{scrollbar-width:none}.lz{-ms-overflow-style:none}.ma{width:74px}.mb{flex-direction:row}.mc{z-index:2}.mf{-webkit-user-select:none}.mg{border:0}.mh{fill:rgba(117, 117, 117, 1)}.mk{outline:0}.ml{user-select:none}.mm> svg{pointer-events:none}.mv{cursor:progress}.mw{margin-left:4px}.mx{margin-top:0px}.my{opacity:1}.mz{padding:4px 0}.nc{width:16px}.ne{display:inline-flex}.nk{padding:8px 2px}.nl svg{color:#6B6B6B}.oc{line-height:1.58}.od{letter-spacing:-0.004em}.oe{font-family:source-serif-pro, Georgia, Cambria, "Times New Roman", Times, serif}.ow{margin-bottom:-0.46em}.ox{font-style:italic}.oy{padding:2px 4px}.oz{font-size:75%}.pa> strong{font-family:inherit}.pb{font-family:source-code-pro, Menlo, Monaco, "Courier New", Courier, monospace}.pc{padding-left:30px}.pd{line-height:40px}.pe{letter-spacing:-0.009em}.pf{font-weight:300}.pg{font-size:28px}.pm{font-style:inherit}.pn{margin-top:32px}.po{margin-bottom:14px}.pp{padding-top:24px}.pq{padding-bottom:10px}.pr{background-color:#000000}.ps{width:3px}.pt{margin-right:20px}.pu{margin-left:auto}.pv{margin-right:auto}.pw{max-width:2354px}.qc{clear:both}.qe{cursor:zoom-in}.qf{z-index:auto}.qh{height:auto}.qi{line-height:1.12}.qj{letter-spacing:-0.022em}.qk{font-weight:600}.rd{margin-bottom:-0.28em}.rj{list-style-type:disc}.rk{margin-left:30px}.rl{padding-left:0px}.rr{list-style-type:decimal}.rs{overflow-x:auto}.rt{padding:20px}.ru{border-radius:0}.rv{background:#F2F2F2}.rw{line-height:1.18}.rx{margin-top:-0.09em}.ry{margin-bottom:-0.09em}.rz{min-width:fit-content}.sa{margin-top:0.91em}.sb{margin-bottom:26px}.sc{margin-top:6px}.sd{margin-top:8px}.se{margin-right:8px}.sf{padding:8px 16px}.sg{border-radius:100px}.sh{transition:background 300ms ease}.sj{border-top:none}.sk{margin-bottom:50px}.sl{height:52px}.sm{max-height:52px}.sn{box-sizing:content-box}.so{position:static}.sq{max-width:155px}.sw{margin-bottom:64px}.sx{margin-bottom:48px}.tl{height:64px}.tm{width:64px}.tn{align-self:flex-end}.tt{padding-right:4px}.ua{color:rgba(255, 255, 255, 1)}.ub{fill:rgba(255, 255, 255, 1)}.uc{background:rgba(25, 25, 25, 1)}.ud{border-color:rgba(25, 25, 25, 1)}.ug:disabled{opacity:0.1}.uh:disabled:hover{background:rgba(25, 25, 25, 1)}.ui:disabled:hover{border-color:rgba(25, 25, 25, 1)}.uo{height:0px}.up{gap:18px}.uq{fill:rgba(61, 61, 61, 1)}.us{padding-bottom:20px}.uy{fill:#242424}.uz{background:0}.va{border-color:#242424}.vb:disabled:hover{color:#242424}.vc:disabled:hover{fill:#242424}.vd:disabled:hover{border-color:#242424}.vo{border-bottom:solid 1px #E5E5E5}.vp{margin-top:72px}.vq{padding:24px 0}.vr{margin-bottom:0px}.vs{margin-right:16px}.at:hover:not(:disabled){color:rgba(25, 25, 25, 1)}.au:hover:not(:disabled){fill:rgba(25, 25, 25, 1)}.ev:hover{background:rgba(15, 115, 12, 1)}.ew:hover{border-color:rgba(15, 115, 12, 1)}.ex:hover{cursor:pointer}.fo:hover{color:#242424}.fp:hover{fill:#242424}.ft:hover svg{fill:#242424}.fw:hover{background-color:rgba(0, 0, 0, 0.1)}.hl:hover{background-color:none}.kg:hover{text-decoration:underline}.mj:hover{fill:rgba(8, 8, 8, 1)}.na:hover{fill:#000000}.nb:hover p{color:#000000}.nd:hover{color:#000000}.nm:hover svg{color:#000000}.si:hover{background-color:#F2F2F2}.ue:hover{background:#000000}.uf:hover{border-color:#242424}.ur:hover{fill:rgba(25, 25, 25, 1)}.bd:focus-within path{fill:#242424}.mi:focus{fill:rgba(8, 8, 8, 1)}.nn:focus svg{color:#000000}.qg:focus{transform:scale(1.01)}.mn:active{border-style:none}</style><style type="text/css" data-fela-rehydration="590" data-fela-type="RULE" media="all and (min-width: 1080px)">.d{display:none}.bw{width:64px}.ci{margin:0 64px}.cx{height:48px}.de{margin-bottom:52px}.dq{margin-bottom:48px}.eh{font-size:14px}.ei{line-height:20px}.ep{font-size:13px}.eq{padding:5px 12px}.fk{display:flex}.gi{max-width:250px}.gu{font-size:20px}.gv{line-height:24px}.gw{letter-spacing:0}.hs{margin-bottom:50px}.hw{max-width:680px}.ji{font-size:42px}.jj{margin-top:1.19em}.jk{margin-bottom:32px}.jl{line-height:52px}.jm{letter-spacing:-0.011em}.jr{align-items:center}.lh{border-top:solid 1px #F2F2F2}.li{border-bottom:solid 1px #F2F2F2}.lj{margin:32px 0 0}.lk{padding:3px 8px}.lt> *{margin-right:24px}.lu> :last-child{margin-right:0}.mu{margin-top:0px}.nj{margin:0}.ot{margin-top:2.14em}.ou{line-height:32px}.ov{letter-spacing:-0.003em}.pl{margin-top:1.75em}.qb{margin-top:56px}.qz{font-size:24px}.ra{margin-top:1.25em}.rb{line-height:30px}.rc{letter-spacing:-0.016em}.ri{margin-top:0.94em}.rq{margin-top:1.14em}.sv{display:inline-block}.sy{flex-direction:row}.tb{margin-bottom:0}.tc{margin-right:20px}.to{max-width:500px}.un{margin-bottom:88px}.ux{margin:40px 0 16px}.vi{width:min-width}.vn{padding-top:72px}</style><style type="text/css" data-fela-rehydration="590" data-fela-type="RULE" media="all and (max-width: 1079.98px)">.e{display:none}.mt{margin-top:0px}.su{display:inline-block}</style><style type="text/css" data-fela-rehydration="590" data-fela-type="RULE" media="all and (max-width: 903.98px)">.f{display:none}.ms{margin-top:0px}.st{display:inline-block}</style><style type="text/css" data-fela-rehydration="590" data-fela-type="RULE" media="all and (max-width: 727.98px)">.g{display:none}.mq{margin-top:0px}.mr{margin-right:0px}.ss{display:inline-block}</style><style type="text/css" data-fela-rehydration="590" data-fela-type="RULE" media="all and (max-width: 551.98px)">.h{display:none}.s{display:flex}.t{justify-content:space-between}.bs{width:24px}.ce{margin:0 24px}.ct{height:40px}.da{margin-bottom:44px}.dm{margin-bottom:32px}.dz{font-size:13px}.ea{line-height:20px}.ej{padding:0px 8px 1px}.ge{max-width:150px}.gk{font-size:16px}.gl{letter-spacing:0}.ho{margin-bottom:2px}.io{font-size:32px}.ip{margin-top:1.01em}.iq{margin-bottom:24px}.ir{line-height:38px}.is{letter-spacing:-0.014em}.jn{align-items:flex-start}.ki{flex-direction:column}.kv{margin:24px -24px 0}.kw{padding:0}.ll> *{margin-right:8px}.lm> :last-child{margin-right:24px}.md{margin-left:0px}.mo{margin-top:0px}.mp{margin-right:0px}.nf{margin:0}.no{border:1px solid #F2F2F2}.np{border-radius:99em}.nq{padding:0px 16px 0px 12px}.nr{height:38px}.ns{align-items:center}.nu svg{margin-right:8px}.of{font-size:18px}.og{margin-top:1.56em}.oh{line-height:28px}.oi{letter-spacing:-0.003em}.ph{margin-top:1.08em}.px{margin-top:40px}.ql{font-size:20px}.qm{margin-top:0.93em}.qn{line-height:24px}.re{margin-top:0.67em}.rm{margin-top:1.34em}.sr{display:inline-block}.tj{margin-bottom:20px}.tk{margin-right:0}.ts{max-width:100%}.tu{font-size:24px}.tv{line-height:30px}.tw{letter-spacing:-0.016em}.uj{margin-bottom:64px}.ut{margin:32px 0 16px}.ve{width:100%}.vj{padding-top:48px}.nt:hover{border-color:#E5E5E5}</style><style type="text/css" data-fela-rehydration="590" data-fela-type="RULE" media="all and (min-width: 904px) and (max-width: 1079.98px)">.i{display:none}.bv{width:64px}.ch{margin:0 64px}.cw{height:48px}.dd{margin-bottom:52px}.dp{margin-bottom:48px}.ef{font-size:14px}.eg{line-height:20px}.em{font-size:13px}.eo{padding:5px 12px}.fj{display:flex}.gh{max-width:250px}.gr{font-size:20px}.gs{line-height:24px}.gt{letter-spacing:0}.hr{margin-bottom:50px}.hv{max-width:680px}.jd{font-size:42px}.je{margin-top:1.19em}.jf{margin-bottom:32px}.jg{line-height:52px}.jh{letter-spacing:-0.011em}.jq{align-items:center}.ld{border-top:solid 1px #F2F2F2}.le{border-bottom:solid 1px #F2F2F2}.lf{margin:32px 0 0}.lg{padding:3px 8px}.lr> *{margin-right:24px}.ls> :last-child{margin-right:0}.ni{margin:0}.oq{margin-top:2.14em}.or{line-height:32px}.os{letter-spacing:-0.003em}.pk{margin-top:1.75em}.qa{margin-top:56px}.qv{font-size:24px}.qw{margin-top:1.25em}.qx{line-height:30px}.qy{letter-spacing:-0.016em}.rh{margin-top:0.94em}.rp{margin-top:1.14em}.sz{flex-direction:row}.td{margin-bottom:0}.te{margin-right:20px}.tp{max-width:500px}.um{margin-bottom:88px}.uw{margin:40px 0 16px}.vh{width:min-width}.vm{padding-top:72px}</style><style type="text/css" data-fela-rehydration="590" data-fela-type="RULE" media="all and (min-width: 728px) and (max-width: 903.98px)">.j{display:none}.w{display:flex}.x{justify-content:space-between}.bu{width:64px}.cg{margin:0 48px}.cv{height:48px}.dc{margin-bottom:52px}.do{margin-bottom:48px}.ed{font-size:13px}.ee{line-height:20px}.el{padding:0px 8px 1px}.gg{max-width:250px}.go{font-size:20px}.gp{line-height:24px}.gq{letter-spacing:0}.hq{margin-bottom:50px}.hu{max-width:680px}.iy{font-size:42px}.iz{margin-top:1.19em}.ja{margin-bottom:32px}.jb{line-height:52px}.jc{letter-spacing:-0.011em}.jp{align-items:center}.kz{border-top:solid 1px #F2F2F2}.la{border-bottom:solid 1px #F2F2F2}.lb{margin:32px 0 0}.lc{padding:3px 8px}.lp> *{margin-right:24px}.lq> :last-child{margin-right:0}.nh{margin:0}.on{margin-top:2.14em}.oo{line-height:32px}.op{letter-spacing:-0.003em}.pj{margin-top:1.75em}.pz{margin-top:56px}.qr{font-size:24px}.qs{margin-top:1.25em}.qt{line-height:30px}.qu{letter-spacing:-0.016em}.rg{margin-top:0.94em}.ro{margin-top:1.14em}.ta{flex-direction:row}.tf{margin-bottom:0}.tg{margin-right:20px}.tq{max-width:500px}.ul{margin-bottom:88px}.uv{margin:40px 0 16px}.vg{width:min-width}.vl{padding-top:72px}</style><style type="text/css" data-fela-rehydration="590" data-fela-type="RULE" media="all and (min-width: 552px) and (max-width: 727.98px)">.k{display:none}.u{display:flex}.v{justify-content:space-between}.bt{width:24px}.cf{margin:0 24px}.cu{height:40px}.db{margin-bottom:44px}.dn{margin-bottom:32px}.eb{font-size:13px}.ec{line-height:20px}.ek{padding:0px 8px 1px}.gf{max-width:150px}.gm{font-size:16px}.gn{letter-spacing:0}.hp{margin-bottom:2px}.it{font-size:32px}.iu{margin-top:1.01em}.iv{margin-bottom:24px}.iw{line-height:38px}.ix{letter-spacing:-0.014em}.jo{align-items:flex-start}.kj{flex-direction:column}.kx{margin:24px 0 0}.ky{padding:0}.ln> *{margin-right:8px}.lo> :last-child{margin-right:8px}.me{margin-left:0px}.ng{margin:0}.nv{border:1px solid #F2F2F2}.nw{border-radius:99em}.nx{padding:0px 16px 0px 12px}.ny{height:38px}.nz{align-items:center}.ob svg{margin-right:8px}.oj{font-size:18px}.ok{margin-top:1.56em}.ol{line-height:28px}.om{letter-spacing:-0.003em}.pi{margin-top:1.08em}.py{margin-top:40px}.qo{font-size:20px}.qp{margin-top:0.93em}.qq{line-height:24px}.rf{margin-top:0.67em}.rn{margin-top:1.34em}.th{margin-bottom:20px}.ti{margin-right:0}.tr{max-width:100%}.tx{font-size:24px}.ty{line-height:30px}.tz{letter-spacing:-0.016em}.uk{margin-bottom:64px}.uu{margin:32px 0 16px}.vf{width:100%}.vk{padding-top:48px}.oa:hover{border-color:#E5E5E5}</style><style type="text/css" data-fela-rehydration="590" data-fela-type="RULE" media="print">.sp{display:none}</style><style type="text/css" data-fela-rehydration="590" data-fela-type="RULE" media="(prefers-reduced-motion: no-preference)">.hd{transition:opacity 200ms}.qd{transition:transform 300ms cubic-bezier(0.2, 0, 0.2, 1)}</style><style type="text/css" data-fela-rehydration="590" data-fela-type="RULE" media="all and (max-width: 1232px)">.he{display:none}</style><style type="text/css" data-fela-rehydration="590" data-fela-type="RULE" media="(orientation: landscape) and (max-width: 903.98px)">.ks{max-height:none}</style></head><body><div id="root"><div class="a b c"><div class="d e f g h i j k"></div><script>document.domain = document.domain;</script><div class="l c"><div class="l m n o c"><div class="p q r s t u v w x i d y z"><a class="dw ah dx bf al b an ao ap aq ar as at au s u w i d q dy z" href="https://rsci.app.link/?%24canonical_url=https%3A%2F%2Fmedium.com%2Fp%2Ff7248e077339&%7Efeature=LoOpenInAppButton&%7Echannel=ShowPostUnderCollection&source=post_page---top_nav_layout_nav-----------------------------------------" rel="noopener follow">Open in app<svg xmlns="http://www.w3.org/2000/svg" width="10" height="10" fill="none" viewBox="0 0 10 10" class="dv"><path fill="currentColor" d="M.985 8.485a.375.375 0 1 0 .53.53zM8.75 1.25h.375A.375.375 0 0 0 8.75.875zM8.375 6.5a.375.375 0 1 0 .75 0zM3.5.875a.375.375 0 1 0 0 .75zm-1.985 8.14 7.5-7.5-.53-.53-7.5 7.5zm6.86-7.765V6.5h.75V1.25zM3.5 1.625h5.25v-.75H3.5z"></path></svg></a><div class="ab q"><p class="bf b dz ea eb ec ed ee ef eg eh ei dw"><span><button class="bf b dz ea ej eb ec ek ed ee el em eg eo ep ei eq er es et eu ev ew ex ey ez fa fb fc fd fe ff bm fg fh" data-testid="headerSignUpButton">Sign up</button></span></p><div class="fi l"><p class="bf b dz ea eb ec ed ee ef eg eh ei dw"><span><a class="ag ah ai aj ak al am an ao ap aq ar as at au" data-testid="headerSignInButton" rel="noopener follow" href="/m/signin?operation=login&redirect=https%3A%2F%2Fmedium.com%2Fgoogle-cloud%2Fuse-google-cloud-spanner-with-the-online-boutique-sample-apps-f7248e077339&source=post_page---top_nav_layout_nav-----------------------global_nav------------------">Sign in</a></span></p></div></div></div><div class="p q r ab ac"><div class="ab q ae af"><a class="ag ah ai aj ak al am an ao ap aq ar as at au ab" aria-label="Homepage" data-testid="headerMediumLogo" rel="noopener follow" href="/?source=post_page---top_nav_layout_nav-----------------------------------------"><svg xmlns="http://www.w3.org/2000/svg" width="719" height="160" fill="none" viewBox="0 0 719 160" class="av aw ax"><path fill="#242424" d="m174.104 9.734.215-.047V8.02H130.39L89.6 103.89 48.81 8.021H1.472v1.666l.212.047c8.018 1.81 12.09 4.509 12.09 14.242V137.93c0 9.734-4.087 12.433-12.106 14.243l-.212.047v1.671h32.118v-1.665l-.213-.048c-8.018-1.809-12.089-4.509-12.089-14.242V30.586l52.399 123.305h2.972l53.925-126.743V140.75c-.687 7.688-4.721 10.062-11.982 11.701l-.215.05v1.652h55.948v-1.652l-.215-.05c-7.269-1.639-11.4-4.013-12.087-11.701l-.037-116.774h.037c0-9.733 4.071-12.432 12.087-14.242m25.555 75.488c.915-20.474 8.268-35.252 20.606-35.507 3.806.063 6.998 1.312 9.479 3.714 5.272 5.118 7.751 15.812 7.368 31.793zm-.553 5.77h65.573v-.275c-.186-15.656-4.721-27.834-13.466-36.196-7.559-7.227-18.751-11.203-30.507-11.203h-.263c-6.101 0-13.584 1.48-18.909 4.16-6.061 2.807-11.407 7.003-15.855 12.511-7.161 8.874-11.499 20.866-12.554 34.343q-.05.606-.092 1.212a50 50 0 0 0-.065 1.151 85.807 85.807 0 0 0-.094 5.689c.71 30.524 17.198 54.917 46.483 54.917 25.705 0 40.675-18.791 44.407-44.013l-1.886-.664c-6.557 13.556-18.334 21.771-31.738 20.769-18.297-1.369-32.314-19.922-31.042-42.395m139.722 41.359c-2.151 5.101-6.639 7.908-12.653 7.908s-11.513-4.129-15.418-11.63c-4.197-8.053-6.405-19.436-6.405-32.92 0-28.067 8.729-46.22 22.24-46.22 5.657 0 10.111 2.807 12.236 7.704zm43.499 20.008c-8.019-1.897-12.089-4.722-12.089-14.951V1.309l-48.716 14.353v1.757l.299-.024c6.72-.543 11.278.386 13.925 2.83 2.072 1.915 3.082 4.853 3.082 8.987v18.66c-4.803-3.067-10.516-4.56-17.448-4.56-14.059 0-26.909 5.92-36.176 16.672-9.66 11.205-14.767 26.518-14.767 44.278-.003 31.72 15.612 53.039 38.851 53.039 13.595 0 24.533-7.449 29.54-20.013v16.865h43.711v-1.746zM424.1 19.819c0-9.904-7.468-17.374-17.375-17.374-9.859 0-17.573 7.632-17.573 17.374s7.721 17.374 17.573 17.374c9.907 0 17.375-7.47 17.375-17.374m11.499 132.546c-8.019-1.897-12.089-4.722-12.089-14.951h-.035V43.635l-43.714 12.551v1.705l.263.024c9.458.842 12.047 4.1 12.047 15.152v81.086h43.751v-1.746zm112.013 0c-8.018-1.897-12.089-4.722-12.089-14.951V43.635l-41.621 12.137v1.71l.246.026c7.733.813 9.967 4.257 9.967 15.36v59.279c-2.578 5.102-7.415 8.131-13.274 8.336-9.503 0-14.736-6.419-14.736-18.073V43.638l-43.714 12.55v1.703l.262.024c9.459.84 12.05 4.097 12.05 15.152v50.17a56.3 56.3 0 0 0 .91 10.444l.787 3.423c3.701 13.262 13.398 20.197 28.59 20.197 12.868 0 24.147-7.966 29.115-20.43v17.311h43.714v-1.747zm169.818 1.788v-1.749l-.213-.05c-8.7-2.006-12.089-5.789-12.089-13.49v-63.79c0-19.89-11.171-31.761-29.883-31.761-13.64 0-25.141 7.882-29.569 20.16-3.517-13.01-13.639-20.16-28.606-20.16-13.146 0-23.449 6.938-27.869 18.657V43.643L545.487 55.68v1.715l.263.024c9.345.829 12.047 4.181 12.047 14.95v81.784h40.787v-1.746l-.215-.053c-6.941-1.631-9.181-4.606-9.181-12.239V66.998c1.836-4.289 5.537-9.37 12.853-9.37 9.086 0 13.692 6.296 13.692 18.697v77.828h40.797v-1.746l-.215-.053c-6.94-1.631-9.18-4.606-9.18-12.239V75.066a42 42 0 0 0-.578-7.26c1.947-4.661 5.86-10.177 13.475-10.177 9.214 0 13.691 6.114 13.691 18.696v77.828z"></path></svg></a><div class="h"><div class="ab ay az ba bb q bc bd"><div class="bm" aria-hidden="false" aria-describedby="searchResults" aria-labelledby="searchResults"></div><div class="bn bo ab"><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" fill="none" viewBox="0 0 24 24"><path fill="currentColor" fill-rule="evenodd" d="M4.092 11.06a6.95 6.95 0 1 1 13.9 0 6.95 6.95 0 0 1-13.9 0m6.95-8.05a8.05 8.05 0 1 0 5.13 14.26l3.75 3.75a.56.56 0 1 0 .79-.79l-3.73-3.73A8.05 8.05 0 0 0 11.042 3z" clip-rule="evenodd"></path></svg></div><input role="combobox" aria-controls="searchResults" aria-expanded="false" aria-label="search" data-testid="headerSearchInput" tabindex="0" class="ay be bf bg z bh bi bj bk bl" placeholder="Search" value=""/></div></div></div><div class="h k w fj fk"><div class="fl ab"><span><a class="ag ah ai aj ak al am an ao ap aq ar as at au" data-testid="headerWriteButton" rel="noopener follow" href="/m/signin?operation=register&redirect=https%3A%2F%2Fmedium.com%2Fnew-story&source=---top_nav_layout_nav-----------------------new_post_topnav------------------"><div class="bf b bg z dw fm fn ab q fo fp"><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" fill="none" viewBox="0 0 24 24" aria-label="Write"><path fill="currentColor" d="M14 4a.5.5 0 0 0 0-1zm7 6a.5.5 0 0 0-1 0zm-7-7H4v1h10zM3 4v16h1V4zm1 17h16v-1H4zm17-1V10h-1v10zm-1 1a1 1 0 0 0 1-1h-1zM3 20a1 1 0 0 0 1 1v-1zM4 3a1 1 0 0 0-1 1h1z"></path><path stroke="currentColor" d="m17.5 4.5-8.458 8.458a.25.25 0 0 0-.06.098l-.824 2.47a.25.25 0 0 0 .316.316l2.47-.823a.25.25 0 0 0 .098-.06L19.5 6.5m-2-2 2.323-2.323a.25.25 0 0 1 .354 0l1.646 1.646a.25.25 0 0 1 0 .354L19.5 6.5m-2-2 2 2"></path></svg><div class="dv l">Write</div></div></a></span></div></div><div class="k j i d"><div class="fl ab"><a class="ag ah ai aj ak al am an ao ap aq ar as at au" data-testid="headerSearchButton" rel="noopener follow" href="/search?source=post_page---top_nav_layout_nav-----------------------------------------"><div class="bf b bg z dw fm fn ab q fo fp"><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" fill="none" viewBox="0 0 24 24" aria-label="Search"><path fill="currentColor" fill-rule="evenodd" d="M4.092 11.06a6.95 6.95 0 1 1 13.9 0 6.95 6.95 0 0 1-13.9 0m6.95-8.05a8.05 8.05 0 1 0 5.13 14.26l3.75 3.75a.56.56 0 1 0 .79-.79l-3.73-3.73A8.05 8.05 0 0 0 11.042 3z" clip-rule="evenodd"></path></svg></div></a></div></div><div class="fl h k j"><div class="ab q"><p class="bf b dz ea eb ec ed ee ef eg eh ei dw"><span><button class="bf b dz ea ej eb ec ek ed ee el em eg eo ep ei eq er es et eu ev ew ex ey ez fa fb fc fd fe ff bm fg fh" data-testid="headerSignUpButton">Sign up</button></span></p><div class="fi l"><p class="bf b dz ea eb ec ed ee ef eg eh ei dw"><span><a class="ag ah ai aj ak al am an ao ap aq ar as at au" data-testid="headerSignInButton" rel="noopener follow" href="/m/signin?operation=login&redirect=https%3A%2F%2Fmedium.com%2Fgoogle-cloud%2Fuse-google-cloud-spanner-with-the-online-boutique-sample-apps-f7248e077339&source=post_page---top_nav_layout_nav-----------------------global_nav------------------">Sign in</a></span></p></div></div></div><div class="l" aria-hidden="false"><button class="ay fq an ab q ap fr fs ft" aria-label="user options menu" data-testid="headerUserIcon"><div class="l fm"><img alt="" class="l ff by bz ca cz" src="https://miro.medium.com/v2/resize:fill:64:64/1*dmbNkD5D-u45r44go_cf0g.png" width="32" height="32" loading="lazy" role="presentation"/><div class="fu by l bz ca fv n ay fw"></div></div></button></div></div></div><div class="ab"><div class="cb" style="width:0"></div><div class="cc" style="width:100%"><div class="l"><div><div class="gb bh l"><div class="gc bh bj"></div><div class="ab cd"><div class="ce cf cg ch ci gd ck bh"><div class="ac ab q"><div class="ge gf gg gh gi l"><a class="ag ah ai aj ak al am an ao ap aq ar as at au" href="https://medium.com/google-cloud?source=post_page---publication_nav-e52cf94d98af-f7248e077339---------------------------------------" rel="noopener follow"><h2 class="bf gj gk ea gl gm ec gn go gp gq gr gs gt gu gv gw bk"><div class="fx fy fz ga">Google Cloud - Community</div></h2></a></div><div class="s u j i d"><span class="gx gy" aria-hidden="true"><span class="bf b gz ha bk">·</span></span><p class="bf b gz ha bk"></p></div></div></div></div></div></div><div class="hb fv hc bh n hd he hf hg"><div class="ab cd"><div class="ce cf cg ch ci gd ck bh"><div class="hh l"><div class="hb"><div class="ab cp cq"><a href="https://medium.com/google-cloud?source=post_page---post_publication_sidebar-e52cf94d98af-f7248e077339---------------------------------------" rel="noopener follow"><div class="fm"><img alt="Google Cloud - Community" class="cz hi l hk hj" src="https://miro.medium.com/v2/resize:fill:76:76/1*FUjLiCANvATKeaJEeg20Rw.png" width="38" height="38" loading="lazy"/><div class="hi l hj hk fv n fu hl"></div></div></a><div class="hm l"></div><p class="bf b bg z dw"><span class="hn">A collection of technical articles and blogs published or curated by Google Cloud Developer Advocates. The views expressed are those of the authors and don't necessarily reflect those of Google.</span></p><div class="hm l"></div><p class="bf b bg z bk"></p></div></div></div></div></div></div><div class="ho hp hq hr hs l"><div class="ab cd"><div class="ck bh ht hu hv hw"></div></div><article><div class="l"><div class="l"><span class="l"></span><section><div><div class="fv ic id ie if hb"></div><div class="hn ig ih ii ij"><div class="ab cd"><div class="ck bh ht hu hv hw"><div><h1 id="77a6" class="pw-post-title ik il im bf in io ip iq ir is it iu iv iw ix iy iz ja jb jc jd je jf jg jh ji jj jk jl jm bk" data-testid="storyTitle">Use Google Cloud Spanner with the Online Boutique sample</h1><div><div class="speechify-ignore ab cr"><div class="speechify-ignore bh l"><div class="jn jo jp jq jr ab"><div><div class="ab js"><div><div class="bm" aria-hidden="false"><a rel="noopener follow" href="/@mabenoit?source=post_page---byline--f7248e077339---------------------------------------"><div class="l jt ju by jv jw"><div class="l fm"><img alt="Mathieu Benoit" class="l ff by df dg cz" src="https://miro.medium.com/v2/resize:fill:88:88/1*Z8X9oPsrq9JgBRWHTKZNyA.jpeg" width="44" height="44" loading="lazy" data-testid="authorPhoto"/><div class="jx by l df dg fv n jy fw"></div></div></div></a></div></div><div class="jz ab fm"><div><div class="bm" aria-hidden="false"><a href="https://medium.com/google-cloud?source=post_page---byline--f7248e077339---------------------------------------" rel="noopener follow"><div class="l ka kb by jv kc"><div class="l fm"><img alt="Google Cloud - Community" class="l ff by br kd cz" src="https://miro.medium.com/v2/resize:fill:48:48/1*FUjLiCANvATKeaJEeg20Rw.png" width="24" height="24" loading="lazy" data-testid="publicationPhoto"/><div class="jx by l br kd fv n jy fw"></div></div></div></a></div></div></div></div></div><div class="bn bh l"><div class="ab"><div style="flex:1"><span class="bf b bg z bk"><div class="ke ab q"><div class="ab q kf"><div class="ab q"><div><div class="bm" aria-hidden="false"><p class="bf b gz ha bk"><a class="ag ah ai aj ak al am an ao ap aq ar as kg" data-testid="authorName" rel="noopener follow" href="/@mabenoit?source=post_page---byline--f7248e077339---------------------------------------">Mathieu Benoit</a></p></div></div></div><span class="gx gy" aria-hidden="true"><span class="bf b bg z bk">·</span></span><p class="bf b gz ha bk"><span><a class="ag ah ai aj ak al am an ao ap aq ar as kh" rel="noopener follow" href="/m/signin?actionUrl=https%3A%2F%2Fmedium.com%2F_%2Fsubscribe%2Fuser%2F1c5a91945323%2Ff7248e077339&operation=register&redirect=https%3A%2F%2Fmedium.com%2Fgoogle-cloud%2Fuse-google-cloud-spanner-with-the-online-boutique-sample-apps-f7248e077339&user=Mathieu+Benoit&userId=1c5a91945323&source=post_page-1c5a91945323--byline--f7248e077339---------------------post_header------------------">Follow</a></span></p></div></div></span></div></div><div class="l cb"><span class="bf b bg z dw"><div class="ab cp ki kj kk"><div class="ho hp ab"><div class="bf b bg z dw ab kl"><span class="km l cb">Published in</span><div><div class="l" aria-hidden="false"><a class="ag ah ai aj ak al am an ao ap aq ar as kg ab q" data-testid="publicationName" href="https://medium.com/google-cloud?source=post_page---byline--f7248e077339---------------------------------------" rel="noopener follow"><p class="bf b bg z fy kn fz ko kp kq kr ks bk">Google Cloud - Community</p></a></div></div></div><div class="h k"><span class="gx gy" aria-hidden="true"><span class="bf b bg z dw">·</span></span></div></div><span class="bf b bg z dw"><div class="ab ae"><span data-testid="storyReadTime">4 min read</span><div class="kt ku l" aria-hidden="true"><span class="l" aria-hidden="true"><span class="bf b bg z dw">·</span></span></div><span data-testid="storyPublishDate">Oct 18, 2022</span></div></span></div></span></div></div></div><div class="ab cr kv kw kx ky kz la lb lc ld le lf lg lh li lj lk"><div class="h k w fj fk q"><div class="ma l"><div class="ab q mb mc"><div class="pw-multi-vote-icon fm km md me mf"><span><a class="ag ah ai aj ak al am an ao ap aq ar as at au" data-testid="headerClapButton" rel="noopener follow" href="/m/signin?actionUrl=https%3A%2F%2Fmedium.com%2F_%2Fvote%2Fgoogle-cloud%2Ff7248e077339&operation=register&redirect=https%3A%2F%2Fmedium.com%2Fgoogle-cloud%2Fuse-google-cloud-spanner-with-the-online-boutique-sample-apps-f7248e077339&user=Mathieu+Benoit&userId=1c5a91945323&source=---header_actions--f7248e077339---------------------clap_footer------------------"><div><div class="bm" aria-hidden="false"><div class="mg ap mh mi mj mk an ml mm mn mf"><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" aria-label="clap"><path fill-rule="evenodd" d="M11.37.828 12 3.282l.63-2.454zM13.916 3.953l1.523-2.112-1.184-.39zM8.589 1.84l1.522 2.112-.337-2.501zM18.523 18.92c-.86.86-1.75 1.246-2.62 1.33a6 6 0 0 0 .407-.372c2.388-2.389 2.86-4.951 1.399-7.623l-.912-1.603-.79-1.672c-.26-.56-.194-.98.203-1.288a.7.7 0 0 1 .546-.132c.283.046.546.231.728.5l2.363 4.157c.976 1.624 1.141 4.237-1.324 6.702m-10.999-.438L3.37 14.328a.828.828 0 0 1 .585-1.408.83.83 0 0 1 .585.242l2.158 2.157a.365.365 0 0 0 .516-.516l-2.157-2.158-1.449-1.449a.826.826 0 0 1 1.167-1.17l3.438 3.44a.363.363 0 0 0 .516 0 .364.364 0 0 0 0-.516L5.293 9.513l-.97-.97a.826.826 0 0 1 0-1.166.84.84 0 0 1 1.167 0l.97.968 3.437 3.436a.36.36 0 0 0 .517 0 .366.366 0 0 0 0-.516L6.977 7.83a.82.82 0 0 1-.241-.584.82.82 0 0 1 .824-.826c.219 0 .43.087.584.242l5.787 5.787a.366.366 0 0 0 .587-.415l-1.117-2.363c-.26-.56-.194-.98.204-1.289a.7.7 0 0 1 .546-.132c.283.046.545.232.727.501l2.193 3.86c1.302 2.38.883 4.59-1.277 6.75-1.156 1.156-2.602 1.627-4.19 1.367-1.418-.236-2.866-1.033-4.079-2.246M10.75 5.971l2.12 2.12c-.41.502-.465 1.17-.128 1.89l.22.465-3.523-3.523a.8.8 0 0 1-.097-.368c0-.22.086-.428.241-.584a.847.847 0 0 1 1.167 0m7.355 1.705c-.31-.461-.746-.758-1.23-.837a1.44 1.44 0 0 0-1.11.275c-.312.24-.505.543-.59.881a1.74 1.74 0 0 0-.906-.465 1.47 1.47 0 0 0-.82.106l-2.182-2.182a1.56 1.56 0 0 0-2.2 0 1.54 1.54 0 0 0-.396.701 1.56 1.56 0 0 0-2.21-.01 1.55 1.55 0 0 0-.416.753c-.624-.624-1.649-.624-2.237-.037a1.557 1.557 0 0 0 0 2.2c-.239.1-.501.238-.715.453a1.56 1.56 0 0 0 0 2.2l.516.515a1.556 1.556 0 0 0-.753 2.615L7.01 19c1.32 1.319 2.909 2.189 4.475 2.449q.482.08.971.08c.85 0 1.653-.198 2.393-.579.231.033.46.054.686.054 1.266 0 2.457-.52 3.505-1.567 2.763-2.763 2.552-5.734 1.439-7.586z" clip-rule="evenodd"></path></svg></div></div></div></a></span></div><div class="pw-multi-vote-count l mo mp mq mr ms mt mu"><p class="bf b dx z dw"><span class="mv">--</span></p></div></div></div><div><div class="bm" aria-hidden="false"><button class="ap mg my mz ab q fn na nb" aria-label="responses"><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" class="mx"><path d="M18.006 16.803c1.533-1.456 2.234-3.325 2.234-5.321C20.24 7.357 16.709 4 12.191 4S4 7.357 4 11.482c0 4.126 3.674 7.482 8.191 7.482.817 0 1.622-.111 2.393-.327.231.2.48.391.744.559 1.06.693 2.203 1.044 3.399 1.044.224-.008.4-.112.486-.287a.49.49 0 0 0-.042-.518c-.495-.67-.845-1.364-1.04-2.057a4 4 0 0 1-.125-.598zm-3.122 1.055-.067-.223-.315.096a8 8 0 0 1-2.311.338c-4.023 0-7.292-2.955-7.292-6.587 0-3.633 3.269-6.588 7.292-6.588 4.014 0 7.112 2.958 7.112 6.593 0 1.794-.608 3.469-2.027 4.72l-.195.168v.255c0 .056 0 .151.016.295.025.231.081.478.154.733.154.558.398 1.117.722 1.659a5.3 5.3 0 0 1-2.165-.845c-.276-.176-.714-.383-.941-.59z"></path></svg><p class="bf b dx z dw"><span class="pw-responses-count mw mx">2</span></p></button></div></div></div><div class="ab q ll lm ln lo lp lq lr ls lt lu lv lw lx ly lz"><div class="nc k j i d"></div><div class="h k"><div><div class="bm" aria-hidden="false"><span><a class="ag ah ai aj ak al am an ao ap aq ar as at au" data-testid="headerBookmarkButton" rel="noopener follow" href="/m/signin?actionUrl=https%3A%2F%2Fmedium.com%2F_%2Fbookmark%2Fp%2Ff7248e077339&operation=register&redirect=https%3A%2F%2Fmedium.com%2Fgoogle-cloud%2Fuse-google-cloud-spanner-with-the-online-boutique-sample-apps-f7248e077339&source=---header_actions--f7248e077339---------------------bookmark_footer------------------"><svg xmlns="http://www.w3.org/2000/svg" width="25" height="25" fill="none" viewBox="0 0 25 25" class="dw nd" aria-label="Add to list bookmark button"><path fill="currentColor" d="M18 2.5a.5.5 0 0 1 1 0V5h2.5a.5.5 0 0 1 0 1H19v2.5a.5.5 0 1 1-1 0V6h-2.5a.5.5 0 0 1 0-1H18zM7 7a1 1 0 0 1 1-1h3.5a.5.5 0 0 0 0-1H8a2 2 0 0 0-2 2v14a.5.5 0 0 0 .805.396L12.5 17l5.695 4.396A.5.5 0 0 0 19 21v-8.5a.5.5 0 0 0-1 0v7.485l-5.195-4.012a.5.5 0 0 0-.61 0L7 19.985z"></path></svg></a></span></div></div></div><div class="ff ne cp"><div class="l ae"><div class="ab cd"><div class="nf ng nh ni nj fx ck bh"><div class="ab"><div class="bm" aria-hidden="false"><div><div class="bm" aria-hidden="false"><button aria-label="Listen" data-testid="audioPlayButton" class="ag fn ai aj ak al am nk ao ap aq ez nl nm nb nn no np nq nr s ns nt nu nv nw nx ny u nz oa ob"><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" fill="none" viewBox="0 0 24 24"><path fill="currentColor" fill-rule="evenodd" d="M3 12a9 9 0 1 1 18 0 9 9 0 0 1-18 0m9-10C6.477 2 2 6.477 2 12s4.477 10 10 10 10-4.477 10-10S17.523 2 12 2m3.376 10.416-4.599 3.066a.5.5 0 0 1-.777-.416V8.934a.5.5 0 0 1 .777-.416l4.599 3.066a.5.5 0 0 1 0 .832" clip-rule="evenodd"></path></svg><div class="j i d"><p class="bf b bg z dw">Listen</p></div></button></div></div></div></div></div></div></div></div><div class="bm" aria-hidden="false" aria-describedby="postFooterSocialMenu" aria-labelledby="postFooterSocialMenu"><div><div class="bm" aria-hidden="false"><button aria-controls="postFooterSocialMenu" aria-expanded="false" aria-label="Share Post" data-testid="headerSocialShareButton" class="ag fn ai aj ak al am nk ao ap aq ez nl nm nb nn no np nq nr s ns nt nu nv nw nx ny u nz oa ob"><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" fill="none" viewBox="0 0 24 24"><path fill="currentColor" fill-rule="evenodd" d="M15.218 4.931a.4.4 0 0 1-.118.132l.012.006a.45.45 0 0 1-.292.074.5.5 0 0 1-.3-.13l-2.02-2.02v7.07c0 .28-.23.5-.5.5s-.5-.22-.5-.5v-7.04l-2 2a.45.45 0 0 1-.57.04h-.02a.4.4 0 0 1-.16-.3.4.4 0 0 1 .1-.32l2.8-2.8a.5.5 0 0 1 .7 0l2.8 2.79a.42.42 0 0 1 .068.498m-.106.138.008.004v-.01zM16 7.063h1.5a2 2 0 0 1 2 2v10a2 2 0 0 1-2 2h-11c-1.1 0-2-.9-2-2v-10a2 2 0 0 1 2-2H8a.5.5 0 0 1 .35.15.5.5 0 0 1 .15.35.5.5 0 0 1-.15.35.5.5 0 0 1-.35.15H6.4c-.5 0-.9.4-.9.9v10.2a.9.9 0 0 0 .9.9h11.2c.5 0 .9-.4.9-.9v-10.2c0-.5-.4-.9-.9-.9H16a.5.5 0 0 1 0-1" clip-rule="evenodd"></path></svg><div class="j i d"><p class="bf b bg z dw">Share</p></div></button></div></div></div></div></div></div></div></div></div><p id="3dc8" class="pw-post-body-paragraph oc od im oe b of og oh oi oj ok ol om go on oo op gr oq or os gu ot ou ov ow hn bk"><em class="ox">Updated on April 1st, 2024 with the </em><a class="ag kh" href="https://www.linkedin.com/posts/cynthia-thomas_k8s-iampolicy-gke-activity-7179636281755258880-m9gy" rel="noopener ugc nofollow" target="_blank"><em class="ox">new way to configure Workload Identity with GKE workload</em></a><em class="ox">.</em></p><p id="198a" class="pw-post-body-paragraph oc od im oe b of og oh oi oj ok ol om go on oo op gr oq or os gu ot ou ov ow hn bk"><em class="ox">Updated on December 8th, 2022 with the deployment of Online Boutique via its </em><a class="ag kh" rel="noopener" href="/google-cloud/246119e46d53"><em class="ox">Helm chart</em></a><em class="ox">.</em></p><p id="e988" class="pw-post-body-paragraph oc od im oe b of og oh oi oj ok ol om go on oo op gr oq or os gu ot ou ov ow hn bk">By default the <code class="cz oy oz pa pb b">cartservice</code> of the <a class="ag kh" href="https://github.com/GoogleCloudPlatform/microservices-demo" rel="noopener ugc nofollow" target="_blank">Online Boutique sample</a> stores its data in an in-cluster Redis database. However, using a fully managed database service outside your Google Kubernetes Engine (GKE) cluster such as <a class="ag kh" rel="noopener" href="/google-cloud/64b71969318d">Memorystore (Redis)</a> could bring more resiliency and more security.</p><p id="052e" class="pw-post-body-paragraph oc od im oe b of og oh oi oj ok ol om go on oo op gr oq or os gu ot ou ov ow hn bk">Since the recent <a class="ag kh" href="https://github.com/GoogleCloudPlatform/microservices-demo/releases/tag/v0.4.0" rel="noopener ugc nofollow" target="_blank">v0.4.0 version</a>, the Online Boutique sample can now store its data in <a class="ag kh" href="https://cloud.google.com/spanner" rel="noopener ugc nofollow" target="_blank">Google Cloud Spanner</a>.</p><blockquote class="pc"><p id="b71d" class="pd pe im bf pf pg ph pi pj pk pl ow dw"><em class="pm">Cloud Spanner is a fully managed relational database with unlimited scale, strong consistency, and up to 99.999% availability.</em></p></blockquote></div></div></div><div class="ab cd pn po pp pq" role="separator"><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps"></span></div><div class="hn ig ih ii ij"><div class="ab cd"><div class="ck bh ht hu hv hw"><p id="02bb" class="pw-post-body-paragraph oc od im oe b of og oh oi oj ok ol om go on oo op gr oq or os gu ot ou ov ow hn bk">In this tutorial, let’s see how you can connect the Online Boutique sample to Google Cloud Spanner.</p><figure class="px py pz qa qb qc pu pv paragraph-image"><div role="button" tabindex="0" class="qd qe fm qf bh qg"><div class="pu pv pw"><picture><source srcSet="https://miro.medium.com/v2/resize:fit:640/format:webp/0*A8lG1q1M29P72YWY.png 640w, https://miro.medium.com/v2/resize:fit:720/format:webp/0*A8lG1q1M29P72YWY.png 720w, https://miro.medium.com/v2/resize:fit:750/format:webp/0*A8lG1q1M29P72YWY.png 750w, https://miro.medium.com/v2/resize:fit:786/format:webp/0*A8lG1q1M29P72YWY.png 786w, https://miro.medium.com/v2/resize:fit:828/format:webp/0*A8lG1q1M29P72YWY.png 828w, https://miro.medium.com/v2/resize:fit:1100/format:webp/0*A8lG1q1M29P72YWY.png 1100w, https://miro.medium.com/v2/resize:fit:1400/format:webp/0*A8lG1q1M29P72YWY.png 1400w" sizes="(min-resolution: 4dppx) and (max-width: 700px) 50vw, (-webkit-min-device-pixel-ratio: 4) and (max-width: 700px) 50vw, (min-resolution: 3dppx) and (max-width: 700px) 67vw, (-webkit-min-device-pixel-ratio: 3) and (max-width: 700px) 65vw, (min-resolution: 2.5dppx) and (max-width: 700px) 80vw, (-webkit-min-device-pixel-ratio: 2.5) and (max-width: 700px) 80vw, (min-resolution: 2dppx) and (max-width: 700px) 100vw, (-webkit-min-device-pixel-ratio: 2) and (max-width: 700px) 100vw, 700px" type="image/webp"/><source data-testid="og" srcSet="https://miro.medium.com/v2/resize:fit:640/0*A8lG1q1M29P72YWY.png 640w, https://miro.medium.com/v2/resize:fit:720/0*A8lG1q1M29P72YWY.png 720w, https://miro.medium.com/v2/resize:fit:750/0*A8lG1q1M29P72YWY.png 750w, https://miro.medium.com/v2/resize:fit:786/0*A8lG1q1M29P72YWY.png 786w, https://miro.medium.com/v2/resize:fit:828/0*A8lG1q1M29P72YWY.png 828w, https://miro.medium.com/v2/resize:fit:1100/0*A8lG1q1M29P72YWY.png 1100w, https://miro.medium.com/v2/resize:fit:1400/0*A8lG1q1M29P72YWY.png 1400w" sizes="(min-resolution: 4dppx) and (max-width: 700px) 50vw, (-webkit-min-device-pixel-ratio: 4) and (max-width: 700px) 50vw, (min-resolution: 3dppx) and (max-width: 700px) 67vw, (-webkit-min-device-pixel-ratio: 3) and (max-width: 700px) 65vw, (min-resolution: 2.5dppx) and (max-width: 700px) 80vw, (-webkit-min-device-pixel-ratio: 2.5) and (max-width: 700px) 80vw, (min-resolution: 2dppx) and (max-width: 700px) 100vw, (-webkit-min-device-pixel-ratio: 2) and (max-width: 700px) 100vw, 700px"/><img alt="" class="bh fx qh c" width="700" height="342" loading="eager" role="presentation"/></picture></div></div></figure></div></div></div><div class="ab cd pn po pp pq" role="separator"><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps"></span></div><div class="hn ig ih ii ij"><div class="ab cd"><div class="ck bh ht hu hv hw"><h1 id="6c3e" class="qi qj im bf qk ql qm qn gl qo qp qq gn qr qs qt qu qv qw qx qy qz ra rb rc rd bk">Objectives</h1><ul class=""><li id="c096" class="oc od im oe b of re oh oi oj rf ol om go rg oo op gr rh or os gu ri ou ov ow rj rk rl bk">Create a Google Kubernetes Engine (GKE) cluster with Workload Identity</li><li id="50d6" class="oc od im oe b of rm oh oi oj rn ol om go ro oo op gr rp or os gu rq ou ov ow rj rk rl bk">Provision a Spanner database with a <a class="ag kh" href="https://cloud.google.com/blog/products/spanner/try-cloud-spanner-databases" rel="noopener ugc nofollow" target="_blank">free Spanner instance</a></li><li id="40b0" class="oc od im oe b of rm oh oi oj rn ol om go ro oo op gr rp or os gu rq ou ov ow rj rk rl bk">Grant the <code class="cz oy oz pa pb b">cartservice</code>’s service account access to the Spanner database with a least privilege role assignment via Workload Identity</li><li id="bb61" class="oc od im oe b of rm oh oi oj rn ol om go ro oo op gr rp or os gu rq ou ov ow rj rk rl bk">Deploy the Online Boutique sample connected to the Spanner database with its Helm chart</li></ul></div></div></div><div class="ab cd pn po pp pq" role="separator"><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps"></span></div><div class="hn ig ih ii ij"><div class="ab cd"><div class="ck bh ht hu hv hw"><h1 id="bea8" class="qi qj im bf qk ql qm qn gl qo qp qq gn qr qs qt qu qv qw qx qy qz ra rb rc rd bk">Costs</h1><p id="e3f1" class="pw-post-body-paragraph oc od im oe b of re oh oi oj rf ol om go rg oo op gr rh or os gu ri ou ov ow hn bk">This tutorial uses billable components of Google Cloud, including the following:</p><ul class=""><li id="4894" class="oc od im oe b of og oh oi oj ok ol om go on oo op gr oq or os gu ot ou ov ow rj rk rl bk"><a class="ag kh" href="https://cloud.google.com/kubernetes-engine/pricing" rel="noopener ugc nofollow" target="_blank">Kubernetes Engine</a></li><li id="ff0d" class="oc od im oe b of rm oh oi oj rn ol om go ro oo op gr rp or os gu rq ou ov ow rj rk rl bk"><a class="ag kh" href="https://cloud.google.com/spanner/pricing" rel="noopener ugc nofollow" target="_blank">Spanner</a> (in this tutorial we will leverage the <a class="ag kh" href="https://cloud.google.com/blog/products/spanner/try-cloud-spanner-databases" rel="noopener ugc nofollow" target="_blank">free Spanner instance</a>).</li></ul><p id="3b6d" class="pw-post-body-paragraph oc od im oe b of og oh oi oj ok ol om go on oo op gr oq or os gu ot ou ov ow hn bk">Use the <a class="ag kh" href="https://cloud.google.com/products/calculator" rel="noopener ugc nofollow" target="_blank">pricing calculator</a> to generate a cost estimate based on your projected usage.</p></div></div></div><div class="ab cd pn po pp pq" role="separator"><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps"></span></div><div class="hn ig ih ii ij"><div class="ab cd"><div class="ck bh ht hu hv hw"><h1 id="76d9" class="qi qj im bf qk ql qm qn gl qo qp qq gn qr qs qt qu qv qw qx qy qz ra rb rc rd bk">Before you begin</h1><p id="9726" class="pw-post-body-paragraph oc od im oe b of re oh oi oj rf ol om go rg oo op gr rh or os gu ri ou ov ow hn bk">This guide assumes that you have owner IAM permissions for your Google Cloud project. In production, you do not require owner permission.</p><ol class=""><li id="01b0" class="oc od im oe b of og oh oi oj ok ol om go on oo op gr oq or os gu ot ou ov ow rr rk rl bk"><a class="ag kh" href="https://console.cloud.google.com/projectselector2" rel="noopener ugc nofollow" target="_blank">Select or create a Google Cloud project</a>.</li><li id="074a" class="oc od im oe b of rm oh oi oj rn ol om go ro oo op gr rp or os gu rq ou ov ow rr rk rl bk"><a class="ag kh" href="https://cloud.google.com/billing/docs/how-to/modify-project" rel="noopener ugc nofollow" target="_blank">Verify that billing is enabled</a> for your project.</li></ol></div></div></div><div class="ab cd pn po pp pq" role="separator"><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps"></span></div><div class="hn ig ih ii ij"><div class="ab cd"><div class="ck bh ht hu hv hw"><h1 id="1aeb" class="qi qj im bf qk ql qm qn gl qo qp qq gn qr qs qt qu qv qw qx qy qz ra rb rc rd bk">Set up your environment</h1><p id="f6aa" class="pw-post-body-paragraph oc od im oe b of re oh oi oj rf ol om go rg oo op gr rh or os gu ri ou ov ow hn bk">Initialize the common variables used throughout this tutorial:</p><pre class="px py pz qa qb rs pb rt ru ay rv bk"><span id="4569" class="rw qj im pb b gz rx ry l kl rz">PROJECT_ID=FIXME-WITH-YOUR-PROJECT-ID<br/>REGION=us-east5<br/>ZONE=us-east5-a</span></pre><p id="94cf" class="pw-post-body-paragraph oc od im oe b of og oh oi oj ok ol om go on oo op gr oq or os gu ot ou ov ow hn bk">To avoid repeating the <code class="cz oy oz pa pb b">--project</code> in the commands throughout this tutorial, let’s set the current project and get the associated project number:</p><pre class="px py pz qa qb rs pb rt ru ay rv bk"><span id="690d" class="rw qj im pb b gz rx ry l kl rz">gcloud config set project ${PROJECT_ID}</span><span id="80eb" class="rw qj im pb b gz sa ry l kl rz">PROJECT_NUMBER=$(gcloud projects describe ${PROJECT_ID} \<br/> --format='get(projectNumber)')</span></pre></div></div></div><div class="ab cd pn po pp pq" role="separator"><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps"></span></div><div class="hn ig ih ii ij"><div class="ab cd"><div class="ck bh ht hu hv hw"><h1 id="381a" class="qi qj im bf qk ql qm qn gl qo qp qq gn qr qs qt qu qv qw qx qy qz ra rb rc rd bk">Enable the required APIs in your project</h1><p id="9606" class="pw-post-body-paragraph oc od im oe b of re oh oi oj rf ol om go rg oo op gr rh or os gu ri ou ov ow hn bk">Enable the required APIs in your project:</p><pre class="px py pz qa qb rs pb rt ru ay rv bk"><span id="4527" class="rw qj im pb b gz rx ry l kl rz">gcloud services enable \<br/> spanner.googleapis.com \<br/> container.googleapis.com</span></pre></div></div></div><div class="ab cd pn po pp pq" role="separator"><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps"></span></div><div class="hn ig ih ii ij"><div class="ab cd"><div class="ck bh ht hu hv hw"><h1 id="71d4" class="qi qj im bf qk ql qm qn gl qo qp qq gn qr qs qt qu qv qw qx qy qz ra rb rc rd bk">Create a GKE cluster</h1><p id="29be" class="pw-post-body-paragraph oc od im oe b of re oh oi oj rf ol om go rg oo op gr rh or os gu ri ou ov ow hn bk">Create a GKE cluster with Workload Identity enabled:</p><pre class="px py pz qa qb rs pb rt ru ay rv bk"><span id="e4cb" class="rw qj im pb b gz rx ry l kl rz">CLUSTER=spanner-with-onlineboutique<br/>gcloud container clusters create ${CLUSTER} \<br/> --zone ${ZONE} \<br/> --machine-type=e2-standard-4 \<br/> --num-nodes 4 \<br/> --workload-pool ${PROJECT_ID}.svc.id.goog</span></pre></div></div></div><div class="ab cd pn po pp pq" role="separator"><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps"></span></div><div class="hn ig ih ii ij"><div class="ab cd"><div class="ck bh ht hu hv hw"><h1 id="8bb5" class="qi qj im bf qk ql qm qn gl qo qp qq gn qr qs qt qu qv qw qx qy qz ra rb rc rd bk">Provision a Spanner database</h1><p id="6b3c" class="pw-post-body-paragraph oc od im oe b of re oh oi oj rf ol om go rg oo op gr rh or os gu ri ou ov ow hn bk">Provision the Spanner instance:</p><pre class="px py pz qa qb rs pb rt ru ay rv bk"><span id="f290" class="rw qj im pb b gz rx ry l kl rz">SPANNER_REGION_CONFIG=regional-${REGION}<br/>SPANNER_INSTANCE_NAME=onlineboutique</span><span id="999a" class="rw qj im pb b gz sa ry l kl rz">gcloud spanner instances create ${SPANNER_INSTANCE_NAME} \<br/> --description="online boutique shopping cart" \<br/> --instance-type free-instance \<br/> --config ${SPANNER_REGION_CONFIG}</span></pre><p id="f903" class="pw-post-body-paragraph oc od im oe b of og oh oi oj ok ol om go on oo op gr oq or os gu ot ou ov ow hn bk"><em class="ox">Notes: with the latest version of gcloud we are able to provision a </em><a class="ag kh" href="https://cloud.google.com/blog/products/spanner/try-cloud-spanner-databases" rel="noopener ugc nofollow" target="_blank"><em class="ox">free Spanner instance</em></a><em class="ox">.</em></p><p id="4f97" class="pw-post-body-paragraph oc od im oe b of og oh oi oj ok ol om go on oo op gr oq or os gu ot ou ov ow hn bk">Provision the Spanner database:</p><pre class="px py pz qa qb rs pb rt ru ay rv bk"><span id="a442" class="rw qj im pb b gz rx ry l kl rz">SPANNER_DATABASE_NAME=carts</span><span id="d549" class="rw qj im pb b gz sa ry l kl rz">gcloud spanner databases create ${SPANNER_DATABASE_NAME} \<br/> --instance ${SPANNER_INSTANCE_NAME} \<br/> --database-dialect GOOGLE_STANDARD_SQL \<br/> --ddl "CREATE TABLE CartItems (userId STRING(1024), productId STRING(1024), quantity INT64) PRIMARY KEY (userId, productId); CREATE INDEX CartItemsByUserId ON CartItems(userId);"</span></pre></div></div></div><div class="ab cd pn po pp pq" role="separator"><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps"></span></div><div class="hn ig ih ii ij"><div class="ab cd"><div class="ck bh ht hu hv hw"><h1 id="abf8" class="qi qj im bf qk ql qm qn gl qo qp qq gn qr qs qt qu qv qw qx qy qz ra rb rc rd bk">Grant the <code class="cz oy oz pa pb b">cartservice</code>’s service account access to the Spanner database</h1><p id="f36f" class="pw-post-body-paragraph oc od im oe b of re oh oi oj rf ol om go rg oo op gr rh or os gu ri ou ov ow hn bk">Grant access to the <code class="cz oy oz pa pb b">cartservice</code>’s Kubernetes Service Account to communicate with the Spanner database:</p><pre class="px py pz qa qb rs pb rt ru ay rv bk"><span id="0169" class="rw qj im pb b gz rx ry l kl rz">ONLINEBOUTIQUE_NAMESPACE=onlineboutique<br/>CARTSERVICE_KSA_NAME=cartservice</span><span id="fe15" class="rw qj im pb b gz sa ry l kl rz">gcloud spanner databases add-iam-policy-binding ${SPANNER_DATABASE_NAME} \<br/> --instance ${SPANNER_INSTANCE_NAME} \<br/> --member "principal://iam.googleapis.com/projects/${PROJECT_NUMBER}/locations/global/workloadIdentityPools/${PROJECT_ID}.svc.id.goog/subject/ns/${ONLINEBOUTIQUE_NAMESPACE}/sa/${CARTSERVICE_KSA_NAME}" \<br/> --role roles/spanner.databaseUser</span></pre><p id="46d9" class="pw-post-body-paragraph oc od im oe b of og oh oi oj ok ol om go on oo op gr oq or os gu ot ou ov ow hn bk"><em class="ox">Note: no need anymore to create a dedicated Google Service Account nor annotate the Kubernetes Service Account automatically, </em><a class="ag kh" href="https://www.linkedin.com/posts/cynthia-thomas_k8s-iampolicy-gke-activity-7179636281755258880-m9gy" rel="noopener ugc nofollow" target="_blank"><em class="ox">this is now simplified</em></a><em class="ox">.</em></p></div></div></div><div class="ab cd pn po pp pq" role="separator"><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps"></span></div><div class="hn ig ih ii ij"><div class="ab cd"><div class="ck bh ht hu hv hw"><h1 id="7893" class="qi qj im bf qk ql qm qn gl qo qp qq gn qr qs qt qu qv qw qx qy qz ra rb rc rd bk">Deploy Online Boutique connected to the Spanner database</h1><p id="efb9" class="pw-post-body-paragraph oc od im oe b of re oh oi oj rf ol om go rg oo op gr rh or os gu ri ou ov ow hn bk">To automate the deployment of Online Boutique integrated with Spanner we will leverage its associated Helm chart:</p><pre class="px py pz qa qb rs pb rt ru ay rv bk"><span id="a35f" class="rw qj im pb b gz rx ry l kl rz">SPANNER_CONNECTION_STRING=projects/<!-- -->${PROJECT_ID}<!-- -->/instances/<!-- -->${SPANNER_INSTANCE_NAME}<!-- -->/databases/<!-- -->${SPANNER_DATABASE_NAME}</span><span id="e045" class="rw qj im pb b gz sa ry l kl rz">helm upgrade onlineboutique oci://us-docker.pkg.dev/online-boutique-ci/charts/onlineboutique \<br/> --install \<br/> --create-namespace \<br/> -n onlineboutique \<br/> --set cartDatabase.inClusterRedis.create=false \<br/> --set cartDatabase.type=spanner \<br/> --set cartDatabase.connectionString=${SPANNER_CONNECTION_STRING} \<br/> --set serviceAccounts.create=true</span></pre><p id="ca0c" class="pw-post-body-paragraph oc od im oe b of og oh oi oj ok ol om go on oo op gr oq or os gu ot ou ov ow hn bk">After that all the apps have successfully been deployed, you could navigate to the Online Boutique website by clicking on the link below:</p><pre class="px py pz qa qb rs pb rt ru ay rv bk"><span id="5039" class="rw qj im pb b gz rx ry l kl rz">echo -n "http://" && kubectl get svc frontend-external -n ${ONLINEBOUTIQUE_NAMESPACE} -o json | jq -r '.status.loadBalancer.ingress[0].ip'</span></pre><p id="9b17" class="pw-post-body-paragraph oc od im oe b of og oh oi oj ok ol om go on oo op gr oq or os gu ot ou ov ow hn bk">From the Online Boutique website, you can add some products in your shopping cart and then you can click on the link below to see all the data serialized in the Spanner database by you and the <code class="cz oy oz pa pb b">loadgenerator</code> app:</p><pre class="px py pz qa qb rs pb rt ru ay rv bk"><span id="57db" class="rw qj im pb b gz rx ry l kl rz">echo -e "https://console.cloud.google.com/spanner/instances/${SPANNER_INSTANCE_NAME}/databases/${SPANNER_DATABASE_NAME}/tables/CartItems/details/data?project=${PROJECT_ID}"</span></pre><p id="e932" class="pw-post-body-paragraph oc od im oe b of og oh oi oj ok ol om go on oo op gr oq or os gu ot ou ov ow hn bk">And voilà! That’s how easy you can connect your Online Boutique sample to a Spanner database, congrats!</p></div></div></div><div class="ab cd pn po pp pq" role="separator"><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps"></span></div><div class="hn ig ih ii ij"><div class="ab cd"><div class="ck bh ht hu hv hw"><h1 id="6ffe" class="qi qj im bf qk ql qm qn gl qo qp qq gn qr qs qt qu qv qw qx qy qz ra rb rc rd bk">Cleaning up</h1><p id="b248" class="pw-post-body-paragraph oc od im oe b of re oh oi oj rf ol om go rg oo op gr rh or os gu ri ou ov ow hn bk">To avoid incurring charges to your Google Cloud account, you can delete the resources used in this tutorial.</p><p id="1a47" class="pw-post-body-paragraph oc od im oe b of og oh oi oj ok ol om go on oo op gr oq or os gu ot ou ov ow hn bk">Delete the GKE cluster:</p><pre class="px py pz qa qb rs pb rt ru ay rv bk"><span id="2518" class="rw qj im pb b gz rx ry l kl rz">gcloud container clusters delete ${CLUSTER} \<br/> --zone ${ZONE}</span></pre><p id="a16a" class="pw-post-body-paragraph oc od im oe b of og oh oi oj ok ol om go on oo op gr oq or os gu ot ou ov ow hn bk">Delete the Spanner database:</p><pre class="px py pz qa qb rs pb rt ru ay rv bk"><span id="98ae" class="rw qj im pb b gz rx ry l kl rz">gcloud spanner instances delete ${SPANNER_INSTANCE_NAME}</span></pre></div></div></div><div class="ab cd pn po pp pq" role="separator"><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps"></span></div><div class="hn ig ih ii ij"><div class="ab cd"><div class="ck bh ht hu hv hw"><h1 id="cea8" class="qi qj im bf qk ql qm qn gl qo qp qq gn qr qs qt qu qv qw qx qy qz ra rb rc rd bk">Conclusion</h1><p id="c440" class="pw-post-body-paragraph oc od im oe b of re oh oi oj rf ol om go rg oo op gr rh or os gu ri ou ov ow hn bk">Having the database outside of your GKE cluster with a managed service can bring you more resiliency and security, and with this new Cloud Spanner option the Online Boutique will become more highly available. This setup allows complex scenarios like having your apps spread across multiple clusters, etc.</p><p id="5ffe" class="pw-post-body-paragraph oc od im oe b of og oh oi oj ok ol om go on oo op gr oq or os gu ot ou ov ow hn bk">Thanks to the original implementation of <a class="ag kh" href="https://www.linkedin.com/in/%F0%9F%8C%8Ddaniel-quinlan-51126016/" rel="noopener ugc nofollow" target="_blank">Daniel Quinlan</a>, this new Spanner option is now available to everyone in the Online Boutique GitHub repository, feel free to either give the <a class="ag kh" href="https://github.com/GoogleCloudPlatform/microservices-demo/blob/main/helm-chart/values.yaml#L109" rel="noopener ugc nofollow" target="_blank">Helm chart</a> or the <a class="ag kh" href="https://github.com/GoogleCloudPlatform/microservices-demo/tree/main/kustomize/components/spanner" rel="noopener ugc nofollow" target="_blank">Kustomize overlay</a> a try!</p><p id="3726" class="pw-post-body-paragraph oc od im oe b of og oh oi oj ok ol om go on oo op gr oq or os gu ot ou ov ow hn bk">Happy sailing, cheers!</p></div></div></div><div class="ab cd pn po pp pq" role="separator"><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps pt"></span><span class="pr by bm gc ps"></span></div><div class="hn ig ih ii ij"><div class="ab cd"><div class="ck bh ht hu hv hw"><p id="1e8b" class="pw-post-body-paragraph oc od im oe b of og oh oi oj ok ol om go on oo op gr oq or os gu ot ou ov ow hn bk"><em class="ox">Originally posted at </em><a class="ag kh" href="https://mathieu-benoit.github.io/" rel="noopener ugc nofollow" target="_blank"><em class="ox">mathieu-benoit.github.io</em></a><em class="ox">.</em></p></div></div></div></div></section></div></div></article></div><div class="ab cd"><div class="ck bh ht hu hv hw"><div class="sb sc ab kk"><div class="sd ab"><a class="se ay an ap" rel="noopener follow" href="/tag/kubernetes?source=post_page-----f7248e077339---------------------------------------"><div class="sf fm cz sg hy sh si bf b bg z bk ga">Kubernetes</div></a></div><div class="sd ab"><a class="se ay an ap" rel="noopener follow" href="/tag/cloud-spanner?source=post_page-----f7248e077339---------------------------------------"><div class="sf fm cz sg hy sh si bf b bg z bk ga">Cloud Spanner</div></a></div><div class="sd ab"><a class="se ay an ap" rel="noopener follow" href="/tag/dotnet-core?source=post_page-----f7248e077339---------------------------------------"><div class="sf fm cz sg hy sh si bf b bg z bk ga">Dotnet Core</div></a></div><div class="sd ab"><a class="se ay an ap" rel="noopener follow" href="/tag/google-cloud-platform?source=post_page-----f7248e077339---------------------------------------"><div class="sf fm cz sg hy sh si bf b bg z bk ga">Google Cloud Platform</div></a></div><div class="sd ab"><a class="se ay an ap" rel="noopener follow" href="/tag/gcp-app-dev?source=post_page-----f7248e077339---------------------------------------"><div class="sf fm cz sg hy sh si bf b bg z bk ga">Gcp App Dev</div></a></div></div></div></div><div class="l"></div><footer class="sj sk sl sm sn ab q so kc c"><div class="l ae"><div class="ab cd"><div class="ck bh ht hu hv hw"><div class="ab cr sp"><div class="ab q mb"><div class="sq l"><span class="l sr ss st e d"><div class="ab q mb mc"><div class="pw-multi-vote-icon fm km md me mf"><span><a class="ag ah ai aj ak al am an ao ap aq ar as at au" data-testid="footerClapButton" rel="noopener follow" href="/m/signin?actionUrl=https%3A%2F%2Fmedium.com%2F_%2Fvote%2Fgoogle-cloud%2Ff7248e077339&operation=register&redirect=https%3A%2F%2Fmedium.com%2Fgoogle-cloud%2Fuse-google-cloud-spanner-with-the-online-boutique-sample-apps-f7248e077339&user=Mathieu+Benoit&userId=1c5a91945323&source=---footer_actions--f7248e077339---------------------clap_footer------------------"><div><div class="bm" aria-hidden="false"><div class="mg ap mh mi mj mk an ml mm mn mf"><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" aria-label="clap"><path fill-rule="evenodd" d="M11.37.828 12 3.282l.63-2.454zM13.916 3.953l1.523-2.112-1.184-.39zM8.589 1.84l1.522 2.112-.337-2.501zM18.523 18.92c-.86.86-1.75 1.246-2.62 1.33a6 6 0 0 0 .407-.372c2.388-2.389 2.86-4.951 1.399-7.623l-.912-1.603-.79-1.672c-.26-.56-.194-.98.203-1.288a.7.7 0 0 1 .546-.132c.283.046.546.231.728.5l2.363 4.157c.976 1.624 1.141 4.237-1.324 6.702m-10.999-.438L3.37 14.328a.828.828 0 0 1 .585-1.408.83.83 0 0 1 .585.242l2.158 2.157a.365.365 0 0 0 .516-.516l-2.157-2.158-1.449-1.449a.826.826 0 0 1 1.167-1.17l3.438 3.44a.363.363 0 0 0 .516 0 .364.364 0 0 0 0-.516L5.293 9.513l-.97-.97a.826.826 0 0 1 0-1.166.84.84 0 0 1 1.167 0l.97.968 3.437 3.436a.36.36 0 0 0 .517 0 .366.366 0 0 0 0-.516L6.977 7.83a.82.82 0 0 1-.241-.584.82.82 0 0 1 .824-.826c.219 0 .43.087.584.242l5.787 5.787a.366.366 0 0 0 .587-.415l-1.117-2.363c-.26-.56-.194-.98.204-1.289a.7.7 0 0 1 .546-.132c.283.046.545.232.727.501l2.193 3.86c1.302 2.38.883 4.59-1.277 6.75-1.156 1.156-2.602 1.627-4.19 1.367-1.418-.236-2.866-1.033-4.079-2.246M10.75 5.971l2.12 2.12c-.41.502-.465 1.17-.128 1.89l.22.465-3.523-3.523a.8.8 0 0 1-.097-.368c0-.22.086-.428.241-.584a.847.847 0 0 1 1.167 0m7.355 1.705c-.31-.461-.746-.758-1.23-.837a1.44 1.44 0 0 0-1.11.275c-.312.24-.505.543-.59.881a1.74 1.74 0 0 0-.906-.465 1.47 1.47 0 0 0-.82.106l-2.182-2.182a1.56 1.56 0 0 0-2.2 0 1.54 1.54 0 0 0-.396.701 1.56 1.56 0 0 0-2.21-.01 1.55 1.55 0 0 0-.416.753c-.624-.624-1.649-.624-2.237-.037a1.557 1.557 0 0 0 0 2.2c-.239.1-.501.238-.715.453a1.56 1.56 0 0 0 0 2.2l.516.515a1.556 1.556 0 0 0-.753 2.615L7.01 19c1.32 1.319 2.909 2.189 4.475 2.449q.482.08.971.08c.85 0 1.653-.198 2.393-.579.231.033.46.054.686.054 1.266 0 2.457-.52 3.505-1.567 2.763-2.763 2.552-5.734 1.439-7.586z" clip-rule="evenodd"></path></svg></div></div></div></a></span></div><div class="pw-multi-vote-count l mo mp mq mr ms mt mu"><p class="bf b dx z dw"><span class="mv">--</span></p></div></div></span><span class="l h g f su sv"><div class="ab q mb mc"><div class="pw-multi-vote-icon fm km md me mf"><span><a class="ag ah ai aj ak al am an ao ap aq ar as at au" data-testid="footerClapButton" rel="noopener follow" href="/m/signin?actionUrl=https%3A%2F%2Fmedium.com%2F_%2Fvote%2Fgoogle-cloud%2Ff7248e077339&operation=register&redirect=https%3A%2F%2Fmedium.com%2Fgoogle-cloud%2Fuse-google-cloud-spanner-with-the-online-boutique-sample-apps-f7248e077339&user=Mathieu+Benoit&userId=1c5a91945323&source=---footer_actions--f7248e077339---------------------clap_footer------------------"><div><div class="bm" aria-hidden="false"><div class="mg ap mh mi mj mk an ml mm mn mf"><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" aria-label="clap"><path fill-rule="evenodd" d="M11.37.828 12 3.282l.63-2.454zM13.916 3.953l1.523-2.112-1.184-.39zM8.589 1.84l1.522 2.112-.337-2.501zM18.523 18.92c-.86.86-1.75 1.246-2.62 1.33a6 6 0 0 0 .407-.372c2.388-2.389 2.86-4.951 1.399-7.623l-.912-1.603-.79-1.672c-.26-.56-.194-.98.203-1.288a.7.7 0 0 1 .546-.132c.283.046.546.231.728.5l2.363 4.157c.976 1.624 1.141 4.237-1.324 6.702m-10.999-.438L3.37 14.328a.828.828 0 0 1 .585-1.408.83.83 0 0 1 .585.242l2.158 2.157a.365.365 0 0 0 .516-.516l-2.157-2.158-1.449-1.449a.826.826 0 0 1 1.167-1.17l3.438 3.44a.363.363 0 0 0 .516 0 .364.364 0 0 0 0-.516L5.293 9.513l-.97-.97a.826.826 0 0 1 0-1.166.84.84 0 0 1 1.167 0l.97.968 3.437 3.436a.36.36 0 0 0 .517 0 .366.366 0 0 0 0-.516L6.977 7.83a.82.82 0 0 1-.241-.584.82.82 0 0 1 .824-.826c.219 0 .43.087.584.242l5.787 5.787a.366.366 0 0 0 .587-.415l-1.117-2.363c-.26-.56-.194-.98.204-1.289a.7.7 0 0 1 .546-.132c.283.046.545.232.727.501l2.193 3.86c1.302 2.38.883 4.59-1.277 6.75-1.156 1.156-2.602 1.627-4.19 1.367-1.418-.236-2.866-1.033-4.079-2.246M10.75 5.971l2.12 2.12c-.41.502-.465 1.17-.128 1.89l.22.465-3.523-3.523a.8.8 0 0 1-.097-.368c0-.22.086-.428.241-.584a.847.847 0 0 1 1.167 0m7.355 1.705c-.31-.461-.746-.758-1.23-.837a1.44 1.44 0 0 0-1.11.275c-.312.24-.505.543-.59.881a1.74 1.74 0 0 0-.906-.465 1.47 1.47 0 0 0-.82.106l-2.182-2.182a1.56 1.56 0 0 0-2.2 0 1.54 1.54 0 0 0-.396.701 1.56 1.56 0 0 0-2.21-.01 1.55 1.55 0 0 0-.416.753c-.624-.624-1.649-.624-2.237-.037a1.557 1.557 0 0 0 0 2.2c-.239.1-.501.238-.715.453a1.56 1.56 0 0 0 0 2.2l.516.515a1.556 1.556 0 0 0-.753 2.615L7.01 19c1.32 1.319 2.909 2.189 4.475 2.449q.482.08.971.08c.85 0 1.653-.198 2.393-.579.231.033.46.054.686.054 1.266 0 2.457-.52 3.505-1.567 2.763-2.763 2.552-5.734 1.439-7.586z" clip-rule="evenodd"></path></svg></div></div></div></a></span></div><div class="pw-multi-vote-count l mo mp mq mr ms mt mu"><p class="bf b dx z dw"><span class="mv">--</span></p></div></div></span></div><div class="bq ab"><div><div class="bm" aria-hidden="false"><button class="ap mg my mz ab q fn na nb" aria-label="responses"><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" class="mx"><path d="M18.006 16.803c1.533-1.456 2.234-3.325 2.234-5.321C20.24 7.357 16.709 4 12.191 4S4 7.357 4 11.482c0 4.126 3.674 7.482 8.191 7.482.817 0 1.622-.111 2.393-.327.231.2.48.391.744.559 1.06.693 2.203 1.044 3.399 1.044.224-.008.4-.112.486-.287a.49.49 0 0 0-.042-.518c-.495-.67-.845-1.364-1.04-2.057a4 4 0 0 1-.125-.598zm-3.122 1.055-.067-.223-.315.096a8 8 0 0 1-2.311.338c-4.023 0-7.292-2.955-7.292-6.587 0-3.633 3.269-6.588 7.292-6.588 4.014 0 7.112 2.958 7.112 6.593 0 1.794-.608 3.469-2.027 4.72l-.195.168v.255c0 .056 0 .151.016.295.025.231.081.478.154.733.154.558.398 1.117.722 1.659a5.3 5.3 0 0 1-2.165-.845c-.276-.176-.714-.383-.941-.59z"></path></svg><p class="bf b bg z dw"><span class="pw-responses-count mw mx">2</span></p></button></div></div></div></div><div class="ab q"><div class="pt l cb"><div><div class="bm" aria-hidden="false"><span><a class="ag ah ai aj ak al am an ao ap aq ar as at au" data-testid="footerBookmarkButton" rel="noopener follow" href="/m/signin?actionUrl=https%3A%2F%2Fmedium.com%2F_%2Fbookmark%2Fp%2Ff7248e077339&operation=register&redirect=https%3A%2F%2Fmedium.com%2Fgoogle-cloud%2Fuse-google-cloud-spanner-with-the-online-boutique-sample-apps-f7248e077339&source=---footer_actions--f7248e077339---------------------bookmark_footer------------------"><svg xmlns="http://www.w3.org/2000/svg" width="25" height="25" fill="none" viewBox="0 0 25 25" class="dw nd" aria-label="Add to list bookmark button"><path fill="currentColor" d="M18 2.5a.5.5 0 0 1 1 0V5h2.5a.5.5 0 0 1 0 1H19v2.5a.5.5 0 1 1-1 0V6h-2.5a.5.5 0 0 1 0-1H18zM7 7a1 1 0 0 1 1-1h3.5a.5.5 0 0 0 0-1H8a2 2 0 0 0-2 2v14a.5.5 0 0 0 .805.396L12.5 17l5.695 4.396A.5.5 0 0 0 19 21v-8.5a.5.5 0 0 0-1 0v7.485l-5.195-4.012a.5.5 0 0 0-.61 0L7 19.985z"></path></svg></a></span></div></div></div><div class="pt l cb"><div class="bm" aria-hidden="false" aria-describedby="postFooterSocialMenu" aria-labelledby="postFooterSocialMenu"><div><div class="bm" aria-hidden="false"><button aria-controls="postFooterSocialMenu" aria-expanded="false" aria-label="Share Post" data-testid="footerSocialShareButton" class="ag fn ai aj ak al am nk ao ap aq ez nl nm nb nn"><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" fill="none" viewBox="0 0 24 24"><path fill="currentColor" fill-rule="evenodd" d="M15.218 4.931a.4.4 0 0 1-.118.132l.012.006a.45.45 0 0 1-.292.074.5.5 0 0 1-.3-.13l-2.02-2.02v7.07c0 .28-.23.5-.5.5s-.5-.22-.5-.5v-7.04l-2 2a.45.45 0 0 1-.57.04h-.02a.4.4 0 0 1-.16-.3.4.4 0 0 1 .1-.32l2.8-2.8a.5.5 0 0 1 .7 0l2.8 2.79a.42.42 0 0 1 .068.498m-.106.138.008.004v-.01zM16 7.063h1.5a2 2 0 0 1 2 2v10a2 2 0 0 1-2 2h-11c-1.1 0-2-.9-2-2v-10a2 2 0 0 1 2-2H8a.5.5 0 0 1 .35.15.5.5 0 0 1 .15.35.5.5 0 0 1-.15.35.5.5 0 0 1-.35.15H6.4c-.5 0-.9.4-.9.9v10.2a.9.9 0 0 0 .9.9h11.2c.5 0 .9-.4.9-.9v-10.2c0-.5-.4-.9-.9-.9H16a.5.5 0 0 1 0-1" clip-rule="evenodd"></path></svg></button></div></div></div></div></div></div></div></div></div></footer><div class="sw l"><div class="ab cd"><div class="ck bh ht hu hv hw"><div class="sx l"><div class="ab sy sz ta kj ki"><div class="tb tc td te tf tg th ti tj tk ab cr"><div class="h k"><a href="https://medium.com/google-cloud?source=post_page---post_publication_info--f7248e077339---------------------------------------" rel="noopener follow"><div class="fm"><img alt="Google Cloud - Community" class="cz hi l jt ju" src="https://miro.medium.com/v2/resize:fill:96:96/1*FUjLiCANvATKeaJEeg20Rw.png" width="48" height="48" loading="lazy"/><div class="hi l ju jt fv n fu hl"></div></div></a></div><div class="j i d"><a href="https://medium.com/google-cloud?source=post_page---post_publication_info--f7248e077339---------------------------------------" rel="noopener follow"><div class="fm"><img alt="Google Cloud - Community" class="cz hi l tm tl" src="https://miro.medium.com/v2/resize:fill:128:128/1*FUjLiCANvATKeaJEeg20Rw.png" width="64" height="64" loading="lazy"/><div class="hi l tl tm fv n fu hl"></div></div></a></div><div class="j i d tn cb"><div class="ab"></div></div></div><div class="ab cq cc"><div class="to tp tq tr ts l"><a class="ag ah ai ak al am an ao ap aq ar as at au ab q" href="https://medium.com/google-cloud?source=post_page---post_publication_info--f7248e077339---------------------------------------" rel="noopener follow"><h2 class="pw-author-name bf gj tu tv tw tx ty tz go gp gq gr gs gt gu gv gw bk"><span class="hn tt">Published in <!-- -->Google Cloud - Community</span></h2></a><div class="sd ab js"><div class="l cb"><span class="pw-follower-count bf b bg z dw"><a class="ag ah ai aj ak al am an ao ap aq ar as kg" rel="noopener follow" href="/google-cloud/followers?source=post_page---post_publication_info--f7248e077339---------------------------------------">62K Followers</a></span></div><div class="bf b bg z dw ab kl"><span class="gx l" aria-hidden="true"><span class="bf b bg z dw">·</span></span><a class="ag ah ai aj ak al am an ao ap aq ar as kg" rel="noopener follow" href="/google-cloud/typed-genai-in-your-warehouse-bigqueryml-generative-ai-functions-6340a05eb932?source=post_page---post_publication_info--f7248e077339---------------------------------------">Last published <!-- -->5 hours ago</a></div></div><div class="hm l"><p class="bf b bg z bk"><span class="hn">A collection of technical articles and blogs published or curated by Google Cloud Developer Advocates. The views expressed are those of the authors and don't necessarily reflect those of Google.</span></p></div></div></div><div class="h k"><div class="ab"></div></div></div></div><div class="ab sy sz ta kj ki"><div class="tb tc td te tf tg th ti tj tk ab cr"><div class="h k"><a tabindex="0" rel="noopener follow" href="/@mabenoit?source=post_page---post_author_info--f7248e077339---------------------------------------"><div class="l fm"><img alt="Mathieu Benoit" class="l ff by ju jt cz" src="https://miro.medium.com/v2/resize:fill:96:96/1*Z8X9oPsrq9JgBRWHTKZNyA.jpeg" width="48" height="48" loading="lazy"/><div class="fu by l ju jt fv n ay hl"></div></div></a></div><div class="j i d"><a tabindex="0" rel="noopener follow" href="/@mabenoit?source=post_page---post_author_info--f7248e077339---------------------------------------"><div class="l fm"><img alt="Mathieu Benoit" class="l ff by tl tm cz" src="https://miro.medium.com/v2/resize:fill:128:128/1*Z8X9oPsrq9JgBRWHTKZNyA.jpeg" width="64" height="64" loading="lazy"/><div class="fu by l tl tm fv n ay hl"></div></div></a></div><div class="j i d tn cb"><div class="ab"><span><button class="bf b bg z ua sf ub uc ud ue uf ex ey ug uh ui fc fd fe ff bm fg fh">Follow</button></span></div></div></div><div class="ab cq cc"><div class="to tp tq tr ts l"><a class="ag ah ai ak al am an ao ap aq ar as at au ab q" rel="noopener follow" href="/@mabenoit?source=post_page---post_author_info--f7248e077339---------------------------------------"><h2 class="pw-author-name bf gj tu tv tw tx ty tz go gp gq gr gs gt gu gv gw bk"><span class="hn tt">Written by <!-- -->Mathieu Benoit</span></h2></a><div class="sd ab js"><div class="l cb"><span class="pw-follower-count bf b bg z dw"><a class="ag ah ai aj ak al am an ao ap aq ar as kg" rel="noopener follow" href="/@mabenoit/followers?source=post_page---post_author_info--f7248e077339---------------------------------------">244 Followers</a></span></div><div class="bf b bg z dw ab kl"><span class="gx l" aria-hidden="true"><span class="bf b bg z dw">·</span></span><a class="ag ah ai aj ak al am an ao ap aq ar as kg" rel="noopener follow" href="/@mabenoit/following?source=post_page---post_author_info--f7248e077339---------------------------------------">0 Following</a></div></div><div class="hm l"><p class="bf b bg z bk"><span class="hn">Customer Success Engineer at Humanitec | CNCF Ambassador | GDE Cloud</span></p></div></div></div><div class="h k"><div class="ab"><span><button class="bf b bg z ua sf ub uc ud ue uf ex ey ug uh ui fc fd fe ff bm fg fh">Follow</button></span></div></div></div></div></div></div><div class="uj uk ul um un l"><div class="uo bh r sw"></div><div class="ab cd"><div class="ck bh ht hu hv hw"><div class="ab q cr"><h2 class="bf gj ql qn gl qo qq gn qr qt qu qv qx qy qz rb rc bk">Responses (<!-- -->2<!-- -->)</h2><div class="ab up"><div><div class="bm" aria-hidden="false"><a class="uq ur" href="https://policy.medium.com/medium-rules-30e5502c4eb4?source=post_page---post_responses--f7248e077339---------------------------------------" rel="noopener follow" target="_blank"><svg xmlns="http://www.w3.org/2000/svg" width="25" height="25" viewBox="0 0 25 25"><path fill-rule="evenodd" d="M11.987 5.036a.754.754 0 0 1 .914-.01c.972.721 1.767 1.218 2.6 1.543.828.322 1.719.485 2.887.505a.755.755 0 0 1 .741.757c-.018 3.623-.43 6.256-1.449 8.21-1.034 1.984-2.662 3.209-4.966 4.083a.75.75 0 0 1-.537-.003c-2.243-.874-3.858-2.095-4.897-4.074-1.024-1.951-1.457-4.583-1.476-8.216a.755.755 0 0 1 .741-.757c1.195-.02 2.1-.182 2.923-.503.827-.322 1.6-.815 2.519-1.535m.468.903c-.897.69-1.717 1.21-2.623 1.564-.898.35-1.856.527-3.026.565.037 3.45.469 5.817 1.36 7.515.884 1.684 2.25 2.762 4.284 3.571 2.092-.81 3.465-1.89 4.344-3.575.886-1.698 1.299-4.065 1.334-7.512-1.149-.039-2.091-.217-2.99-.567-.906-.353-1.745-.873-2.683-1.561m-.009 9.155a2.672 2.672 0 1 0 0-5.344 2.672 2.672 0 0 0 0 5.344m0 1a3.672 3.672 0 1 0 0-7.344 3.672 3.672 0 0 0 0 7.344m-1.813-3.777.525-.526.916.917 1.623-1.625.526.526-2.149 2.152z" clip-rule="evenodd"></path></svg></a></div></div></div></div><div class="us gb ut uu uv uw ux l"></div><div class="pn l"><button class="bf b bg z bk sf uy uz va nd na uf ex ey ez vb vc vd fc ve vf vg vh vi fd fe ff bm fg fh">See all responses</button></div></div></div></div><div class="vj vk vl vm vn l bx"><div class="h k j"><div class="uo bh vo vp"></div><div class="ab cd"><div class="ck bh ht hu hv hw"><div class="vq ab mb kk"><div class="vr vs l"><a class="ag ah ai aj ak al am an ao ap aq ar as at au" href="https://help.medium.com/hc/en-us?source=post_page-----f7248e077339---------------------------------------" rel="noopener follow"><p class="bf b dx z dw">Help</p></a></div><div class="vr vs l"><a class="ag ah ai aj ak al am an ao ap aq ar as at au" href="https://medium.statuspage.io/?source=post_page-----f7248e077339---------------------------------------" rel="noopener follow"><p class="bf b dx z dw">Status</p></a></div><div class="vr vs l"><a class="ag ah ai aj ak al am an ao ap aq ar as at au" rel="noopener follow" href="/about?autoplay=1&source=post_page-----f7248e077339---------------------------------------"><p class="bf b dx z dw">About</p></a></div><div class="vr vs l"><a class="ag ah ai aj ak al am an ao ap aq ar as at au" rel="noopener follow" href="/jobs-at-medium/work-at-medium-959d1a85284e?source=post_page-----f7248e077339---------------------------------------"><p class="bf b dx z dw">Careers</p></a></div><div class="vr vs l"><a class="ag ah ai aj ak al am an ao ap aq ar as at au" href="mailto:pressinquiries@medium.com" rel="noopener follow"><p class="bf b dx z dw">Press</p></a></div><div class="vr vs l"><a class="ag ah ai aj ak al am an ao ap aq ar as at au" href="https://blog.medium.com/?source=post_page-----f7248e077339---------------------------------------" rel="noopener follow"><p class="bf b dx z dw">Blog</p></a></div><div class="vr vs l"><a class="ag ah ai aj ak al am an ao ap aq ar as at au" href="https://policy.medium.com/medium-privacy-policy-f03bf92035c9?source=post_page-----f7248e077339---------------------------------------" rel="noopener follow"><p class="bf b dx z dw">Privacy</p></a></div><div class="vr vs l"><a class="ag ah ai aj ak al am an ao ap aq ar as at au" href="https://policy.medium.com/medium-rules-30e5502c4eb4?source=post_page-----f7248e077339---------------------------------------" rel="noopener follow"><p class="bf b dx z dw">Rules</p></a></div><div class="vr vs l"><a class="ag ah ai aj ak al am an ao ap aq ar as at au" href="https://policy.medium.com/medium-terms-of-service-9db0094a1e0f?source=post_page-----f7248e077339---------------------------------------" rel="noopener follow"><p class="bf b dx z dw">Terms</p></a></div><div class="vr l"><a class="ag ah ai aj ak al am an ao ap aq ar as at au" href="https://speechify.com/medium?source=post_page-----f7248e077339---------------------------------------" rel="noopener follow"><p class="bf b dx z dw">Text to speech</p></a></div></div></div></div></div></div></div></div></div></div></div></div><script>window.__BUILD_ID__="main-20250408-180718-487627e86c"</script><script>window.__GRAPHQL_URI__ = "https://medium.com/_/graphql"</script><script>window.__PRELOADED_STATE__ = {"algolia":{"queries":{}},"cache":{"experimentGroupSet":true,"reason":"","group":"enabled","tags":["group-edgeCachePosts","post-f7248e077339","user-1c5a91945323","collection-e52cf94d98af"],"serverVariantState":"44136fa355b3678a1146ad16f7e8649e94fb4fc21fe77e8310c060f61caaff8a","middlewareEnabled":true,"cacheStatus":"DYNAMIC","shouldUseCache":true,"vary":[],"pubFeaturingPostPageLabelEnabled":false,"storySubscribeCopyEnabled":false},"client":{"hydrated":false,"isUs":false,"isNativeMedium":false,"isSafariMobile":false,"isSafari":false,"isFirefox":false,"routingEntity":{"type":"DEFAULT","explicit":false},"viewerIsBot":false},"debug":{"requestId":"a820b8c0-bd8b-4ad5-8955-dc7c61b2c5a5","requestTag":"","hybridDevServices":[],"originalSpanCarrier":{"traceparent":"00-aba5280cdb3b45c16565a0d23c27ada6-c6c638beb899b017-01"}},"multiVote":{"clapsPerPost":{}},"navigation":{"branch":{"show":null,"hasRendered":null,"blockedByCTA":false},"hideGoogleOneTap":false,"hasRenderedAlternateUserBanner":null,"currentLocation":"https:\u002F\u002Fmedium.com\u002Fgoogle-cloud\u002Fuse-google-cloud-spanner-with-the-online-boutique-sample-apps-f7248e077339","host":"medium.com","hostname":"medium.com","referrer":"","hasSetReferrer":false,"susiModal":{"step":null,"operation":"register"},"postRead":false,"partnerProgram":{"selectedCountryCode":null},"queryString":"","currentHash":""},"config":{"nodeEnv":"production","version":"main-20250408-180718-487627e86c","target":"production","productName":"Medium","publicUrl":"https:\u002F\u002Fcdn-client.medium.com\u002Flite","authDomain":"medium.com","authGoogleClientId":"216296035834-k1k6qe060s2tp2a2jam4ljdcms00sttg.apps.googleusercontent.com","favicon":"production","glyphUrl":"https:\u002F\u002Fglyph.medium.com","branchKey":"key_live_ofxXr2qTrrU9NqURK8ZwEhknBxiI6KBm","algolia":{"appId":"MQ57UUUQZ2","apiKeySearch":"394474ced050e3911ae2249ecc774921","indexPrefix":"medium_","host":"-dsn.algolia.net"},"recaptchaKey":"6Lfc37IUAAAAAKGGtC6rLS13R1Hrw_BqADfS1LRk","recaptcha3Key":"6Lf8R9wUAAAAABMI_85Wb8melS7Zj6ziuf99Yot5","recaptchaEnterpriseKeyId":"6Le-uGgpAAAAAPprRaokM8AKthQ9KNGdoxaGUvVp","datadog":{"applicationId":"6702d87d-a7e0-42fe-bbcb-95b469547ea0","clientToken":"pub853ea8d17ad6821d9f8f11861d23dfed","rumToken":"pubf9cc52896502b9413b68ba36fc0c7162","context":{"deployment":{"target":"production","tag":"main-20250408-180718-487627e86c","commit":"487627e86ce45a047273f1c555a8811288d0d54e"}},"datacenter":"us"},"googleAnalyticsCode":"G-7JY7T788PK","googlePay":{"apiVersion":"2","apiVersionMinor":"0","merchantId":"BCR2DN6TV7EMTGBM","merchantName":"Medium","instanceMerchantId":"13685562959212738550"},"applePay":{"version":3},"signInWallCustomDomainCollectionIds":["3a8144eabfe3","336d898217ee","61061eb0c96b","138adf9c44c","819cc2aaeee0"],"mediumMastodonDomainName":"me.dm","mediumOwnedAndOperatedCollectionIds":["8a9336e5bb4","b7e45b22fec3","193b68bd4fba","8d6b8a439e32","54c98c43354d","3f6ecf56618","d944778ce714","92d2092dc598","ae2a65f35510","1285ba81cada","544c7006046e","fc8964313712","40187e704f1c","88d9857e584e","7b6769f2748b","bcc38c8f6edf","cef6983b292","cb8577c9149e","444d13b52878","713d7dbc99b0","ef8e90590e66","191186aaafa0","55760f21cdc5","9dc80918cc93","bdc4052bbdba","8ccfed20cbb2"],"tierOneDomains":["medium.com","thebolditalic.com","arcdigital.media","towardsdatascience.com","uxdesign.cc","codeburst.io","psiloveyou.xyz","writingcooperative.com","entrepreneurshandbook.co","prototypr.io","betterhumans.coach.me","theascent.pub"],"topicsToFollow":["d61cf867d93f","8a146bc21b28","1eca0103fff3","4d562ee63426","aef1078a3ef5","e15e46793f8d","6158eb913466","55f1c20aba7a","3d18b94f6858","4861fee224fd","63c6f1f93ee","1d98b3a9a871","decb52b64abf","ae5d4995e225","830cded25262"],"topicToTagMappings":{"accessibility":"accessibility","addiction":"addiction","android-development":"android-development","art":"art","artificial-intelligence":"artificial-intelligence","astrology":"astrology","basic-income":"basic-income","beauty":"beauty","biotech":"biotech","blockchain":"blockchain","books":"books","business":"business","cannabis":"cannabis","cities":"cities","climate-change":"climate-change","comics":"comics","coronavirus":"coronavirus","creativity":"creativity","cryptocurrency":"cryptocurrency","culture":"culture","cybersecurity":"cybersecurity","data-science":"data-science","design":"design","digital-life":"digital-life","disability":"disability","economy":"economy","education":"education","equality":"equality","family":"family","feminism":"feminism","fiction":"fiction","film":"film","fitness":"fitness","food":"food","freelancing":"freelancing","future":"future","gadgets":"gadgets","gaming":"gaming","gun-control":"gun-control","health":"health","history":"history","humor":"humor","immigration":"immigration","ios-development":"ios-development","javascript":"javascript","justice":"justice","language":"language","leadership":"leadership","lgbtqia":"lgbtqia","lifestyle":"lifestyle","machine-learning":"machine-learning","makers":"makers","marketing":"marketing","math":"math","media":"media","mental-health":"mental-health","mindfulness":"mindfulness","money":"money","music":"music","neuroscience":"neuroscience","nonfiction":"nonfiction","outdoors":"outdoors","parenting":"parenting","pets":"pets","philosophy":"philosophy","photography":"photography","podcasts":"podcast","poetry":"poetry","politics":"politics","privacy":"privacy","product-management":"product-management","productivity":"productivity","programming":"programming","psychedelics":"psychedelics","psychology":"psychology","race":"race","relationships":"relationships","religion":"religion","remote-work":"remote-work","san-francisco":"san-francisco","science":"science","self":"self","self-driving-cars":"self-driving-cars","sexuality":"sexuality","social-media":"social-media","society":"society","software-engineering":"software-engineering","space":"space","spirituality":"spirituality","sports":"sports","startups":"startup","style":"style","technology":"technology","transportation":"transportation","travel":"travel","true-crime":"true-crime","tv":"tv","ux":"ux","venture-capital":"venture-capital","visual-design":"visual-design","work":"work","world":"world","writing":"writing"},"defaultImages":{"avatar":{"imageId":"1*dmbNkD5D-u45r44go_cf0g.png","height":150,"width":150},"orgLogo":{"imageId":"7*V1_7XP4snlmqrc_0Njontw.png","height":110,"width":500},"postLogo":{"imageId":"bd978bb536350a710e8efb012513429cabdc4c28700604261aeda246d0f980b7","height":810,"width":1440},"postPreviewImage":{"imageId":"1*hn4v1tCaJy7cWMyb0bpNpQ.png","height":386,"width":579}},"collectionStructuredData":{"8d6b8a439e32":{"name":"Elemental","data":{"@type":"NewsMediaOrganization","ethicsPolicy":"https:\u002F\u002Fhelp.medium.com\u002Fhc\u002Fen-us\u002Farticles\u002F360043290473","logo":{"@type":"ImageObject","url":"https:\u002F\u002Fcdn-images-1.medium.com\u002Fmax\u002F980\u002F1*9ygdqoKprhwuTVKUM0DLPA@2x.png","width":980,"height":159}}},"3f6ecf56618":{"name":"Forge","data":{"@type":"NewsMediaOrganization","ethicsPolicy":"https:\u002F\u002Fhelp.medium.com\u002Fhc\u002Fen-us\u002Farticles\u002F360043290473","logo":{"@type":"ImageObject","url":"https:\u002F\u002Fcdn-images-1.medium.com\u002Fmax\u002F596\u002F1*uULpIlImcO5TDuBZ6lm7Lg@2x.png","width":596,"height":183}}},"ae2a65f35510":{"name":"GEN","data":{"@type":"NewsMediaOrganization","ethicsPolicy":"https:\u002F\u002Fhelp.medium.com\u002Fhc\u002Fen-us\u002Farticles\u002F360043290473","logo":{"@type":"ImageObject","url":"https:\u002F\u002Fmiro.medium.com\u002Fmax\u002F264\u002F1*RdVZMdvfV3YiZTw6mX7yWA.png","width":264,"height":140}}},"88d9857e584e":{"name":"LEVEL","data":{"@type":"NewsMediaOrganization","ethicsPolicy":"https:\u002F\u002Fhelp.medium.com\u002Fhc\u002Fen-us\u002Farticles\u002F360043290473","logo":{"@type":"ImageObject","url":"https:\u002F\u002Fmiro.medium.com\u002Fmax\u002F540\u002F1*JqYMhNX6KNNb2UlqGqO2WQ.png","width":540,"height":108}}},"7b6769f2748b":{"name":"Marker","data":{"@type":"NewsMediaOrganization","ethicsPolicy":"https:\u002F\u002Fhelp.medium.com\u002Fhc\u002Fen-us\u002Farticles\u002F360043290473","logo":{"@type":"ImageObject","url":"https:\u002F\u002Fcdn-images-1.medium.com\u002Fmax\u002F383\u002F1*haCUs0wF6TgOOvfoY-jEoQ@2x.png","width":383,"height":92}}},"444d13b52878":{"name":"OneZero","data":{"@type":"NewsMediaOrganization","ethicsPolicy":"https:\u002F\u002Fhelp.medium.com\u002Fhc\u002Fen-us\u002Farticles\u002F360043290473","logo":{"@type":"ImageObject","url":"https:\u002F\u002Fmiro.medium.com\u002Fmax\u002F540\u002F1*cw32fIqCbRWzwJaoQw6BUg.png","width":540,"height":123}}},"8ccfed20cbb2":{"name":"Zora","data":{"@type":"NewsMediaOrganization","ethicsPolicy":"https:\u002F\u002Fhelp.medium.com\u002Fhc\u002Fen-us\u002Farticles\u002F360043290473","logo":{"@type":"ImageObject","url":"https:\u002F\u002Fmiro.medium.com\u002Fmax\u002F540\u002F1*tZUQqRcCCZDXjjiZ4bDvgQ.png","width":540,"height":106}}}},"embeddedPostIds":{"coronavirus":"cd3010f9d81f"},"sharedCdcMessaging":{"COVID_APPLICABLE_TAG_SLUGS":[],"COVID_APPLICABLE_TOPIC_NAMES":[],"COVID_APPLICABLE_TOPIC_NAMES_FOR_TOPIC_PAGE":[],"COVID_MESSAGES":{"tierA":{"text":"For more information on the novel coronavirus and Covid-19, visit cdc.gov.","markups":[{"start":66,"end":73,"href":"https:\u002F\u002Fwww.cdc.gov\u002Fcoronavirus\u002F2019-nCoV"}]},"tierB":{"text":"Anyone can publish on Medium per our Policies, but we don’t fact-check every story. For more info about the coronavirus, see cdc.gov.","markups":[{"start":37,"end":45,"href":"https:\u002F\u002Fhelp.medium.com\u002Fhc\u002Fen-us\u002Fcategories\u002F201931128-Policies-Safety"},{"start":125,"end":132,"href":"https:\u002F\u002Fwww.cdc.gov\u002Fcoronavirus\u002F2019-nCoV"}]},"paywall":{"text":"This article has been made free for everyone, thanks to Medium Members. For more information on the novel coronavirus and Covid-19, visit cdc.gov.","markups":[{"start":56,"end":70,"href":"https:\u002F\u002Fmedium.com\u002Fmembership"},{"start":138,"end":145,"href":"https:\u002F\u002Fwww.cdc.gov\u002Fcoronavirus\u002F2019-nCoV"}]},"unbound":{"text":"This article is free for everyone, thanks to Medium Members. For more information on the novel coronavirus and Covid-19, visit cdc.gov.","markups":[{"start":45,"end":59,"href":"https:\u002F\u002Fmedium.com\u002Fmembership"},{"start":127,"end":134,"href":"https:\u002F\u002Fwww.cdc.gov\u002Fcoronavirus\u002F2019-nCoV"}]}},"COVID_BANNER_POST_ID_OVERRIDE_WHITELIST":["3b31a67bff4a"]},"sharedVoteMessaging":{"TAGS":["politics","election-2020","government","us-politics","election","2020-presidential-race","trump","donald-trump","democrats","republicans","congress","republican-party","democratic-party","biden","joe-biden","maga"],"TOPICS":["politics","election"],"MESSAGE":{"text":"Find out more about the U.S. election results here.","markups":[{"start":46,"end":50,"href":"https:\u002F\u002Fcookpolitical.com\u002F2020-national-popular-vote-tracker"}]},"EXCLUDE_POSTS":["397ef29e3ca5"]},"embedPostRules":[],"recircOptions":{"v1":{"limit":3},"v2":{"limit":8}},"braintreeClientKey":"production_zjkj96jm_m56f8fqpf7ngnrd4","braintree":{"enabled":true,"merchantId":"m56f8fqpf7ngnrd4","merchantAccountId":{"usd":"AMediumCorporation_instant","eur":"amediumcorporation_EUR","cad":"amediumcorporation_CAD"},"publicKey":"ds2nn34bg2z7j5gd","braintreeEnvironment":"production","dashboardUrl":"https:\u002F\u002Fwww.braintreegateway.com\u002Fmerchants","gracePeriodDurationInDays":14,"mediumMembershipPlanId":{"monthly":"ce105f8c57a3","monthlyV2":"e8a5e126-792b-4ee6-8fba-d574c1b02fc5","monthlyWithTrial":"d5ee3dbe3db8","monthlyPremium":"fa741a9b47a2","yearly":"a40ad4a43185","yearlyV2":"3815d7d6-b8ca-4224-9b8c-182f9047866e","yearlyStaff":"d74fb811198a","yearlyWithTrial":"b3bc7350e5c7","yearlyPremium":"e21bd2c12166","monthlyOneYearFree":"e6c0637a-2bad-4171-ab4f-3c268633d83c","monthly25PercentOffFirstYear":"235ecc62-0cdb-49ae-9378-726cd21c504b","monthly20PercentOffFirstYear":"ba518864-9c13-4a99-91ca-411bf0cac756","monthly15PercentOffFirstYear":"594c029b-9f89-43d5-88f8-8173af4e070e","monthly10PercentOffFirstYear":"c6c7bc9a-40f2-4b51-8126-e28511d5bdb0","monthlyForStudents":"629ebe51-da7d-41fd-8293-34cd2f2030a8","yearlyOneYearFree":"78ba7be9-0d9f-4ece-aa3e-b54b826f2bf1","yearly25PercentOffFirstYear":"2dbb010d-bb8f-4eeb-ad5c-a08509f42d34","yearly20PercentOffFirstYear":"47565488-435b-47f8-bf93-40d5fbe0ebc8","yearly15PercentOffFirstYear":"8259809b-0881-47d9-acf7-6c001c7f720f","yearly10PercentOffFirstYear":"9dd694fb-96e1-472c-8d9e-3c868d5c1506","yearlyForStudents":"e29345ef-ab1c-4234-95c5-70e50fe6bc23","monthlyCad":"p52orjkaceei","yearlyCad":"h4q9g2up9ktt"},"braintreeDiscountId":{"oneMonthFree":"MONTHS_FREE_01","threeMonthsFree":"MONTHS_FREE_03","sixMonthsFree":"MONTHS_FREE_06","fiftyPercentOffOneYear":"FIFTY_PERCENT_OFF_ONE_YEAR"},"3DSecureVersion":"2","defaultCurrency":"usd","providerPlanIdCurrency":{"4ycw":"usd","rz3b":"usd","3kqm":"usd","jzw6":"usd","c2q2":"usd","nnsw":"usd","q8qw":"usd","d9y6":"usd","fx7w":"cad","nwf2":"cad"}},"paypalClientId":"AXj1G4fotC2GE8KzWX9mSxCH1wmPE3nJglf4Z2ig_amnhvlMVX87otaq58niAg9iuLktVNF_1WCMnN7v","paypal":{"host":"https:\u002F\u002Fapi.paypal.com:443","clientMode":"production","serverMode":"live","webhookId":"4G466076A0294510S","monthlyPlan":{"planId":"P-9WR0658853113943TMU5FDQA","name":"Medium Membership (Monthly) with setup fee","description":"Unlimited access to the best and brightest stories on Medium. Membership billed monthly."},"yearlyPlan":{"planId":"P-7N8963881P8875835MU5JOPQ","name":"Medium Membership (Annual) with setup fee","description":"Unlimited access to the best and brightest stories on Medium. Membership billed annually."},"oneYearGift":{"name":"Medium Membership (1 Year, Digital Gift Code)","description":"Unlimited access to the best and brightest stories on Medium. Gift codes can be redeemed at medium.com\u002Fredeem.","price":"50.00","currency":"USD","sku":"membership-gift-1-yr"},"oldMonthlyPlan":{"planId":"P-96U02458LM656772MJZUVH2Y","name":"Medium Membership (Monthly)","description":"Unlimited access to the best and brightest stories on Medium. Membership billed monthly."},"oldYearlyPlan":{"planId":"P-59P80963JF186412JJZU3SMI","name":"Medium Membership (Annual)","description":"Unlimited access to the best and brightest stories on Medium. Membership billed annually."},"monthlyPlanWithTrial":{"planId":"P-66C21969LR178604GJPVKUKY","name":"Medium Membership (Monthly) with setup fee","description":"Unlimited access to the best and brightest stories on Medium. Membership billed monthly."},"yearlyPlanWithTrial":{"planId":"P-6XW32684EX226940VKCT2MFA","name":"Medium Membership (Annual) with setup fee","description":"Unlimited access to the best and brightest stories on Medium. Membership billed annually."},"oldMonthlyPlanNoSetupFee":{"planId":"P-4N046520HR188054PCJC7LJI","name":"Medium Membership (Monthly)","description":"Unlimited access to the best and brightest stories on Medium. Membership billed monthly."},"oldYearlyPlanNoSetupFee":{"planId":"P-7A4913502Y5181304CJEJMXQ","name":"Medium Membership (Annual)","description":"Unlimited access to the best and brightest stories on Medium. Membership billed annually."},"sdkUrl":"https:\u002F\u002Fwww.paypal.com\u002Fsdk\u002Fjs"},"stripePublishableKey":"pk_live_7FReX44VnNIInZwrIIx6ghjl","log":{"json":true,"level":"info"},"imageUploadMaxSizeMb":25,"staffPicks":{"title":"Staff Picks","catalogId":"c7bc6e1ee00f"}},"session":{"xsrf":""}}</script><script>window.__APOLLO_STATE__ = {"ROOT_QUERY":{"__typename":"Query","viewer":null,"collectionByDomainOrSlug({\"domainOrSlug\":\"google-cloud\"})":{"__ref":"Collection:e52cf94d98af"},"postResult({\"id\":\"f7248e077339\"})":{"__ref":"Post:f7248e077339"}},"ImageMetadata:":{"__typename":"ImageMetadata","id":""},"Collection:e52cf94d98af":{"__typename":"Collection","id":"e52cf94d98af","favicon":{"__ref":"ImageMetadata:"},"customStyleSheet":null,"colorPalette":{"__typename":"ColorPalette","highlightSpectrum":{"__typename":"ColorSpectrum","backgroundColor":"#FFFFFFFF","colorPoints":[{"__typename":"ColorPoint","color":"#FFFFFFFF","point":0},{"__typename":"ColorPoint","color":"#FFE8F3E8","point":0.1},{"__typename":"ColorPoint","color":"#FFE8F3E8","point":0.2},{"__typename":"ColorPoint","color":"#FFD1E7D1","point":0.6},{"__typename":"ColorPoint","color":"#FFA3D0A2","point":1}]},"defaultBackgroundSpectrum":{"__typename":"ColorSpectrum","backgroundColor":"#FFFFFFFF","colorPoints":[{"__typename":"ColorPoint","color":"#FF1A8917","point":0},{"__typename":"ColorPoint","color":"#FF11800E","point":0.1},{"__typename":"ColorPoint","color":"#FF0F730C","point":0.2},{"__typename":"ColorPoint","color":"#FF095407","point":1}]},"tintBackgroundSpectrum":null},"domain":null,"slug":"google-cloud","googleAnalyticsId":null,"name":"Google Cloud - Community","avatar":{"__ref":"ImageMetadata:1*FUjLiCANvATKeaJEeg20Rw.png"},"description":"A collection of technical articles and blogs published or curated by Google Cloud Developer Advocates. The views expressed are those of the authors and don't necessarily reflect those of Google.","subscriberCount":62745,"latestPostsConnection({\"paging\":{\"limit\":1}})":{"__typename":"PostConnection","posts":[{"__ref":"Post:6340a05eb932"}]},"isAuroraVisible":false,"tintColor":null,"viewerEdge":{"__ref":"CollectionViewerEdge:collectionId:e52cf94d98af-viewerId:lo_92cce514a369"},"twitterUsername":"googlecloudtech","facebookPageId":null,"logo":{"__ref":"ImageMetadata:1*FUjLiCANvATKeaJEeg20Rw.png"}},"ImageMetadata:1*FUjLiCANvATKeaJEeg20Rw.png":{"__typename":"ImageMetadata","id":"1*FUjLiCANvATKeaJEeg20Rw.png","originalWidth":192,"originalHeight":192},"User:539e90d8d864":{"__typename":"User","id":"539e90d8d864","customDomainState":{"__typename":"CustomDomainState","live":{"__typename":"CustomDomain","domain":"garg-ravish.medium.com"}},"hasSubdomain":true,"username":"garg-ravish"},"Post:6340a05eb932":{"__typename":"Post","id":"6340a05eb932","firstPublishedAt":1744130371261,"creator":{"__ref":"User:539e90d8d864"},"collection":{"__ref":"Collection:e52cf94d98af"},"isSeries":false,"mediumUrl":"https:\u002F\u002Fmedium.com\u002Fgoogle-cloud\u002Ftyped-genai-in-your-warehouse-bigqueryml-generative-ai-functions-6340a05eb932","sequence":null,"uniqueSlug":"typed-genai-in-your-warehouse-bigqueryml-generative-ai-functions-6340a05eb932"},"LinkedAccounts:1c5a91945323":{"__typename":"LinkedAccounts","mastodon":null,"id":"1c5a91945323"},"Membership:dcd91934821f":{"__typename":"Membership","tier":"MEMBER","id":"dcd91934821f"},"User:1c5a91945323":{"__typename":"User","id":"1c5a91945323","linkedAccounts":{"__ref":"LinkedAccounts:1c5a91945323"},"isSuspended":false,"name":"Mathieu Benoit","imageId":"1*Z8X9oPsrq9JgBRWHTKZNyA.jpeg","customDomainState":null,"hasSubdomain":false,"username":"mabenoit","verifications":{"__typename":"VerifiedInfo","isBookAuthor":false},"socialStats":{"__typename":"SocialStats","followerCount":244,"followingCount":0,"collectionFollowingCount":0},"bio":"Customer Success Engineer at Humanitec | CNCF Ambassador | GDE Cloud","membership":{"__ref":"Membership:dcd91934821f"},"allowNotes":true,"viewerEdge":{"__ref":"UserViewerEdge:userId:1c5a91945323-viewerId:lo_92cce514a369"},"twitterScreenName":""},"Topic:decb52b64abf":{"__typename":"Topic","slug":"programming","id":"decb52b64abf","name":"Programming"},"Paragraph:8eab67036f59_0":{"__typename":"Paragraph","id":"8eab67036f59_0","name":"77a6","type":"H3","href":null,"layout":null,"metadata":null,"text":"Use Google Cloud Spanner with the Online Boutique sample","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_1":{"__typename":"Paragraph","id":"8eab67036f59_1","name":"3dc8","type":"P","href":null,"layout":null,"metadata":null,"text":"Updated on April 1st, 2024 with the new way to configure Workload Identity with GKE workload.","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"A","start":36,"end":92,"href":"https:\u002F\u002Fwww.linkedin.com\u002Fposts\u002Fcynthia-thomas_k8s-iampolicy-gke-activity-7179636281755258880-m9gy","anchorType":"LINK","userId":null,"linkMetadata":null},{"__typename":"Markup","type":"EM","start":0,"end":93,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_2":{"__typename":"Paragraph","id":"8eab67036f59_2","name":"198a","type":"P","href":null,"layout":null,"metadata":null,"text":"Updated on December 8th, 2022 with the deployment of Online Boutique via its Helm chart.","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"A","start":77,"end":87,"href":"https:\u002F\u002Fmedium.com\u002Fgoogle-cloud\u002F246119e46d53","anchorType":"LINK","userId":null,"linkMetadata":null},{"__typename":"Markup","type":"EM","start":0,"end":88,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_3":{"__typename":"Paragraph","id":"8eab67036f59_3","name":"e988","type":"P","href":null,"layout":null,"metadata":null,"text":"By default the cartservice of the Online Boutique sample stores its data in an in-cluster Redis database. However, using a fully managed database service outside your Google Kubernetes Engine (GKE) cluster such as Memorystore (Redis) could bring more resiliency and more security.","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"CODE","start":15,"end":26,"href":null,"anchorType":null,"userId":null,"linkMetadata":null},{"__typename":"Markup","type":"A","start":34,"end":56,"href":"https:\u002F\u002Fgithub.com\u002FGoogleCloudPlatform\u002Fmicroservices-demo","anchorType":"LINK","userId":null,"linkMetadata":null},{"__typename":"Markup","type":"A","start":214,"end":233,"href":"https:\u002F\u002Fmedium.com\u002Fgoogle-cloud\u002F64b71969318d","anchorType":"LINK","userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_4":{"__typename":"Paragraph","id":"8eab67036f59_4","name":"052e","type":"P","href":null,"layout":null,"metadata":null,"text":"Since the recent v0.4.0 version, the Online Boutique sample can now store its data in Google Cloud Spanner.","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"A","start":17,"end":31,"href":"https:\u002F\u002Fgithub.com\u002FGoogleCloudPlatform\u002Fmicroservices-demo\u002Freleases\u002Ftag\u002Fv0.4.0","anchorType":"LINK","userId":null,"linkMetadata":null},{"__typename":"Markup","type":"A","start":86,"end":106,"href":"https:\u002F\u002Fcloud.google.com\u002Fspanner","anchorType":"LINK","userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_5":{"__typename":"Paragraph","id":"8eab67036f59_5","name":"b71d","type":"PQ","href":null,"layout":null,"metadata":null,"text":"Cloud Spanner is a fully managed relational database with unlimited scale, strong consistency, and up to 99.999% availability.","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"EM","start":0,"end":126,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_6":{"__typename":"Paragraph","id":"8eab67036f59_6","name":"02bb","type":"P","href":null,"layout":null,"metadata":null,"text":"In this tutorial, let’s see how you can connect the Online Boutique sample to Google Cloud Spanner.","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"ImageMetadata:0*A8lG1q1M29P72YWY.png":{"__typename":"ImageMetadata","id":"0*A8lG1q1M29P72YWY.png","originalHeight":1147,"originalWidth":2354,"focusPercentX":null,"focusPercentY":null,"alt":null},"Paragraph:8eab67036f59_7":{"__typename":"Paragraph","id":"8eab67036f59_7","name":"8514","type":"IMG","href":null,"layout":"INSET_CENTER","metadata":{"__ref":"ImageMetadata:0*A8lG1q1M29P72YWY.png"},"text":"","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_8":{"__typename":"Paragraph","id":"8eab67036f59_8","name":"6c3e","type":"H3","href":null,"layout":null,"metadata":null,"text":"Objectives","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_9":{"__typename":"Paragraph","id":"8eab67036f59_9","name":"c096","type":"ULI","href":null,"layout":null,"metadata":null,"text":"Create a Google Kubernetes Engine (GKE) cluster with Workload Identity","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_10":{"__typename":"Paragraph","id":"8eab67036f59_10","name":"50d6","type":"ULI","href":null,"layout":null,"metadata":null,"text":"Provision a Spanner database with a free Spanner instance","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"A","start":36,"end":57,"href":"https:\u002F\u002Fcloud.google.com\u002Fblog\u002Fproducts\u002Fspanner\u002Ftry-cloud-spanner-databases","anchorType":"LINK","userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_11":{"__typename":"Paragraph","id":"8eab67036f59_11","name":"40b0","type":"ULI","href":null,"layout":null,"metadata":null,"text":"Grant the cartservice’s service account access to the Spanner database with a least privilege role assignment via Workload Identity","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"CODE","start":10,"end":21,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_12":{"__typename":"Paragraph","id":"8eab67036f59_12","name":"bb61","type":"ULI","href":null,"layout":null,"metadata":null,"text":"Deploy the Online Boutique sample connected to the Spanner database with its Helm chart","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_13":{"__typename":"Paragraph","id":"8eab67036f59_13","name":"bea8","type":"H3","href":null,"layout":null,"metadata":null,"text":"Costs","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_14":{"__typename":"Paragraph","id":"8eab67036f59_14","name":"e3f1","type":"P","href":null,"layout":null,"metadata":null,"text":"This tutorial uses billable components of Google Cloud, including the following:","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_15":{"__typename":"Paragraph","id":"8eab67036f59_15","name":"4894","type":"ULI","href":null,"layout":null,"metadata":null,"text":"Kubernetes Engine","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"A","start":0,"end":17,"href":"https:\u002F\u002Fcloud.google.com\u002Fkubernetes-engine\u002Fpricing","anchorType":"LINK","userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_16":{"__typename":"Paragraph","id":"8eab67036f59_16","name":"ff0d","type":"ULI","href":null,"layout":null,"metadata":null,"text":"Spanner (in this tutorial we will leverage the free Spanner instance).","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"A","start":0,"end":7,"href":"https:\u002F\u002Fcloud.google.com\u002Fspanner\u002Fpricing","anchorType":"LINK","userId":null,"linkMetadata":null},{"__typename":"Markup","type":"A","start":47,"end":68,"href":"https:\u002F\u002Fcloud.google.com\u002Fblog\u002Fproducts\u002Fspanner\u002Ftry-cloud-spanner-databases","anchorType":"LINK","userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_17":{"__typename":"Paragraph","id":"8eab67036f59_17","name":"3b6d","type":"P","href":null,"layout":null,"metadata":null,"text":"Use the pricing calculator to generate a cost estimate based on your projected usage.","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"A","start":8,"end":26,"href":"https:\u002F\u002Fcloud.google.com\u002Fproducts\u002Fcalculator","anchorType":"LINK","userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_18":{"__typename":"Paragraph","id":"8eab67036f59_18","name":"76d9","type":"H3","href":null,"layout":null,"metadata":null,"text":"Before you begin","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_19":{"__typename":"Paragraph","id":"8eab67036f59_19","name":"9726","type":"P","href":null,"layout":null,"metadata":null,"text":"This guide assumes that you have owner IAM permissions for your Google Cloud project. In production, you do not require owner permission.","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_20":{"__typename":"Paragraph","id":"8eab67036f59_20","name":"01b0","type":"OLI","href":null,"layout":null,"metadata":null,"text":"Select or create a Google Cloud project.","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"A","start":0,"end":39,"href":"https:\u002F\u002Fconsole.cloud.google.com\u002Fprojectselector2","anchorType":"LINK","userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_21":{"__typename":"Paragraph","id":"8eab67036f59_21","name":"074a","type":"OLI","href":null,"layout":null,"metadata":null,"text":"Verify that billing is enabled for your project.","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"A","start":0,"end":30,"href":"https:\u002F\u002Fcloud.google.com\u002Fbilling\u002Fdocs\u002Fhow-to\u002Fmodify-project","anchorType":"LINK","userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_22":{"__typename":"Paragraph","id":"8eab67036f59_22","name":"1aeb","type":"H3","href":null,"layout":null,"metadata":null,"text":"Set up your environment","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_23":{"__typename":"Paragraph","id":"8eab67036f59_23","name":"f6aa","type":"P","href":null,"layout":null,"metadata":null,"text":"Initialize the common variables used throughout this tutorial:","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_24":{"__typename":"Paragraph","id":"8eab67036f59_24","name":"4569","type":"PRE","href":null,"layout":null,"metadata":null,"text":"PROJECT_ID=FIXME-WITH-YOUR-PROJECT-ID\nREGION=us-east5\nZONE=us-east5-a","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"CODE","start":0,"end":69,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_25":{"__typename":"Paragraph","id":"8eab67036f59_25","name":"94cf","type":"P","href":null,"layout":null,"metadata":null,"text":"To avoid repeating the --project in the commands throughout this tutorial, let’s set the current project and get the associated project number:","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"CODE","start":23,"end":32,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_26":{"__typename":"Paragraph","id":"8eab67036f59_26","name":"690d","type":"PRE","href":null,"layout":null,"metadata":null,"text":"gcloud config set project ${PROJECT_ID}","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"CODE","start":0,"end":39,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_27":{"__typename":"Paragraph","id":"8eab67036f59_27","name":"80eb","type":"PRE","href":null,"layout":null,"metadata":null,"text":"PROJECT_NUMBER=$(gcloud projects describe ${PROJECT_ID} \\\n --format='get(projectNumber)')","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_28":{"__typename":"Paragraph","id":"8eab67036f59_28","name":"381a","type":"H3","href":null,"layout":null,"metadata":null,"text":"Enable the required APIs in your project","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_29":{"__typename":"Paragraph","id":"8eab67036f59_29","name":"9606","type":"P","href":null,"layout":null,"metadata":null,"text":"Enable the required APIs in your project:","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_30":{"__typename":"Paragraph","id":"8eab67036f59_30","name":"4527","type":"PRE","href":null,"layout":null,"metadata":null,"text":"gcloud services enable \\\n spanner.googleapis.com \\\n container.googleapis.com","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"CODE","start":0,"end":82,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_31":{"__typename":"Paragraph","id":"8eab67036f59_31","name":"71d4","type":"H3","href":null,"layout":null,"metadata":null,"text":"Create a GKE cluster","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_32":{"__typename":"Paragraph","id":"8eab67036f59_32","name":"29be","type":"P","href":null,"layout":null,"metadata":null,"text":"Create a GKE cluster with Workload Identity enabled:","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_33":{"__typename":"Paragraph","id":"8eab67036f59_33","name":"e4cb","type":"PRE","href":null,"layout":null,"metadata":null,"text":"CLUSTER=spanner-with-onlineboutique\ngcloud container clusters create ${CLUSTER} \\\n --zone ${ZONE} \\\n --machine-type=e2-standard-4 \\\n --num-nodes 4 \\\n --workload-pool ${PROJECT_ID}.svc.id.goog","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"CODE","start":0,"end":203,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_34":{"__typename":"Paragraph","id":"8eab67036f59_34","name":"8bb5","type":"H3","href":null,"layout":null,"metadata":null,"text":"Provision a Spanner database","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_35":{"__typename":"Paragraph","id":"8eab67036f59_35","name":"6b3c","type":"P","href":null,"layout":null,"metadata":null,"text":"Provision the Spanner instance:","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_36":{"__typename":"Paragraph","id":"8eab67036f59_36","name":"f290","type":"PRE","href":null,"layout":null,"metadata":null,"text":"SPANNER_REGION_CONFIG=regional-${REGION}\nSPANNER_INSTANCE_NAME=onlineboutique","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"CODE","start":0,"end":77,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_37":{"__typename":"Paragraph","id":"8eab67036f59_37","name":"999a","type":"PRE","href":null,"layout":null,"metadata":null,"text":"gcloud spanner instances create ${SPANNER_INSTANCE_NAME} \\\n --description=\"online boutique shopping cart\" \\\n --instance-type free-instance \\\n --config ${SPANNER_REGION_CONFIG}","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"CODE","start":0,"end":184,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_38":{"__typename":"Paragraph","id":"8eab67036f59_38","name":"f903","type":"P","href":null,"layout":null,"metadata":null,"text":"Notes: with the latest version of gcloud we are able to provision a free Spanner instance.","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"A","start":68,"end":89,"href":"https:\u002F\u002Fcloud.google.com\u002Fblog\u002Fproducts\u002Fspanner\u002Ftry-cloud-spanner-databases","anchorType":"LINK","userId":null,"linkMetadata":null},{"__typename":"Markup","type":"EM","start":0,"end":90,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_39":{"__typename":"Paragraph","id":"8eab67036f59_39","name":"4f97","type":"P","href":null,"layout":null,"metadata":null,"text":"Provision the Spanner database:","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_40":{"__typename":"Paragraph","id":"8eab67036f59_40","name":"a442","type":"PRE","href":null,"layout":null,"metadata":null,"text":"SPANNER_DATABASE_NAME=carts","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"CODE","start":0,"end":27,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_41":{"__typename":"Paragraph","id":"8eab67036f59_41","name":"d549","type":"PRE","href":null,"layout":null,"metadata":null,"text":"gcloud spanner databases create ${SPANNER_DATABASE_NAME} \\\n --instance ${SPANNER_INSTANCE_NAME} \\\n --database-dialect GOOGLE_STANDARD_SQL \\\n --ddl \"CREATE TABLE CartItems (userId STRING(1024), productId STRING(1024), quantity INT64) PRIMARY KEY (userId, productId); CREATE INDEX CartItemsByUserId ON CartItems(userId);\"","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"CODE","start":0,"end":328,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_42":{"__typename":"Paragraph","id":"8eab67036f59_42","name":"abf8","type":"H3","href":null,"layout":null,"metadata":null,"text":"Grant the cartservice’s service account access to the Spanner database","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"CODE","start":10,"end":21,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_43":{"__typename":"Paragraph","id":"8eab67036f59_43","name":"f36f","type":"P","href":null,"layout":null,"metadata":null,"text":"Grant access to the cartservice’s Kubernetes Service Account to communicate with the Spanner database:","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"CODE","start":20,"end":31,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_44":{"__typename":"Paragraph","id":"8eab67036f59_44","name":"0169","type":"PRE","href":null,"layout":null,"metadata":null,"text":"ONLINEBOUTIQUE_NAMESPACE=onlineboutique\nCARTSERVICE_KSA_NAME=cartservice","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"CODE","start":0,"end":72,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_45":{"__typename":"Paragraph","id":"8eab67036f59_45","name":"fe15","type":"PRE","href":null,"layout":null,"metadata":null,"text":"gcloud spanner databases add-iam-policy-binding ${SPANNER_DATABASE_NAME} \\\n --instance ${SPANNER_INSTANCE_NAME} \\\n --member \"principal:\u002F\u002Fiam.googleapis.com\u002Fprojects\u002F${PROJECT_NUMBER}\u002Flocations\u002Fglobal\u002FworkloadIdentityPools\u002F${PROJECT_ID}.svc.id.goog\u002Fsubject\u002Fns\u002F${ONLINEBOUTIQUE_NAMESPACE}\u002Fsa\u002F${CARTSERVICE_KSA_NAME}\" \\\n --role roles\u002Fspanner.databaseUser","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_46":{"__typename":"Paragraph","id":"8eab67036f59_46","name":"46d9","type":"P","href":null,"layout":null,"metadata":null,"text":"Note: no need anymore to create a dedicated Google Service Account nor annotate the Kubernetes Service Account automatically, this is now simplified.","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"A","start":126,"end":148,"href":"https:\u002F\u002Fwww.linkedin.com\u002Fposts\u002Fcynthia-thomas_k8s-iampolicy-gke-activity-7179636281755258880-m9gy","anchorType":"LINK","userId":null,"linkMetadata":null},{"__typename":"Markup","type":"EM","start":0,"end":149,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_47":{"__typename":"Paragraph","id":"8eab67036f59_47","name":"7893","type":"H3","href":null,"layout":null,"metadata":null,"text":"Deploy Online Boutique connected to the Spanner database","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_48":{"__typename":"Paragraph","id":"8eab67036f59_48","name":"efb9","type":"P","href":null,"layout":null,"metadata":null,"text":"To automate the deployment of Online Boutique integrated with Spanner we will leverage its associated Helm chart:","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_49":{"__typename":"Paragraph","id":"8eab67036f59_49","name":"a35f","type":"PRE","href":null,"layout":null,"metadata":null,"text":"SPANNER_CONNECTION_STRING=projects\u002F${PROJECT_ID}\u002Finstances\u002F${SPANNER_INSTANCE_NAME}\u002Fdatabases\u002F${SPANNER_DATABASE_NAME}","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"CODE","start":35,"end":48,"href":null,"anchorType":null,"userId":null,"linkMetadata":null},{"__typename":"Markup","type":"CODE","start":59,"end":83,"href":null,"anchorType":null,"userId":null,"linkMetadata":null},{"__typename":"Markup","type":"CODE","start":94,"end":118,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_50":{"__typename":"Paragraph","id":"8eab67036f59_50","name":"e045","type":"PRE","href":null,"layout":null,"metadata":null,"text":"helm upgrade onlineboutique oci:\u002F\u002Fus-docker.pkg.dev\u002Fonline-boutique-ci\u002Fcharts\u002Fonlineboutique \\\n --install \\\n --create-namespace \\\n -n onlineboutique \\\n --set cartDatabase.inClusterRedis.create=false \\\n --set cartDatabase.type=spanner \\\n --set cartDatabase.connectionString=${SPANNER_CONNECTION_STRING} \\\n --set serviceAccounts.create=true","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_51":{"__typename":"Paragraph","id":"8eab67036f59_51","name":"ca0c","type":"P","href":null,"layout":null,"metadata":null,"text":"After that all the apps have successfully been deployed, you could navigate to the Online Boutique website by clicking on the link below:","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_52":{"__typename":"Paragraph","id":"8eab67036f59_52","name":"5039","type":"PRE","href":null,"layout":null,"metadata":null,"text":"echo -n \"http:\u002F\u002F\" && kubectl get svc frontend-external -n ${ONLINEBOUTIQUE_NAMESPACE} -o json | jq -r '.status.loadBalancer.ingress[0].ip'","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"CODE","start":0,"end":138,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_53":{"__typename":"Paragraph","id":"8eab67036f59_53","name":"9b17","type":"P","href":null,"layout":null,"metadata":null,"text":"From the Online Boutique website, you can add some products in your shopping cart and then you can click on the link below to see all the data serialized in the Spanner database by you and the loadgenerator app:","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"CODE","start":193,"end":206,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_54":{"__typename":"Paragraph","id":"8eab67036f59_54","name":"57db","type":"PRE","href":null,"layout":null,"metadata":null,"text":"echo -e \"https:\u002F\u002Fconsole.cloud.google.com\u002Fspanner\u002Finstances\u002F${SPANNER_INSTANCE_NAME}\u002Fdatabases\u002F${SPANNER_DATABASE_NAME}\u002Ftables\u002FCartItems\u002Fdetails\u002Fdata?project=${PROJECT_ID}\"","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"CODE","start":0,"end":172,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_55":{"__typename":"Paragraph","id":"8eab67036f59_55","name":"e932","type":"P","href":null,"layout":null,"metadata":null,"text":"And voilà! That’s how easy you can connect your Online Boutique sample to a Spanner database, congrats!","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_56":{"__typename":"Paragraph","id":"8eab67036f59_56","name":"6ffe","type":"H3","href":null,"layout":null,"metadata":null,"text":"Cleaning up","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_57":{"__typename":"Paragraph","id":"8eab67036f59_57","name":"b248","type":"P","href":null,"layout":null,"metadata":null,"text":"To avoid incurring charges to your Google Cloud account, you can delete the resources used in this tutorial.","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_58":{"__typename":"Paragraph","id":"8eab67036f59_58","name":"1a47","type":"P","href":null,"layout":null,"metadata":null,"text":"Delete the GKE cluster:","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_59":{"__typename":"Paragraph","id":"8eab67036f59_59","name":"2518","type":"PRE","href":null,"layout":null,"metadata":null,"text":"gcloud container clusters delete ${CLUSTER} \\\n --zone ${ZONE}","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"CODE","start":0,"end":64,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_60":{"__typename":"Paragraph","id":"8eab67036f59_60","name":"a16a","type":"P","href":null,"layout":null,"metadata":null,"text":"Delete the Spanner database:","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_61":{"__typename":"Paragraph","id":"8eab67036f59_61","name":"98ae","type":"PRE","href":null,"layout":null,"metadata":null,"text":"gcloud spanner instances delete ${SPANNER_INSTANCE_NAME}","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"CODE","start":0,"end":56,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_62":{"__typename":"Paragraph","id":"8eab67036f59_62","name":"cea8","type":"H3","href":null,"layout":null,"metadata":null,"text":"Conclusion","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_63":{"__typename":"Paragraph","id":"8eab67036f59_63","name":"c440","type":"P","href":null,"layout":null,"metadata":null,"text":"Having the database outside of your GKE cluster with a managed service can bring you more resiliency and security, and with this new Cloud Spanner option the Online Boutique will become more highly available. This setup allows complex scenarios like having your apps spread across multiple clusters, etc.","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_64":{"__typename":"Paragraph","id":"8eab67036f59_64","name":"5ffe","type":"P","href":null,"layout":null,"metadata":null,"text":"Thanks to the original implementation of Daniel Quinlan, this new Spanner option is now available to everyone in the Online Boutique GitHub repository, feel free to either give the Helm chart or the Kustomize overlay a try!","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"A","start":41,"end":55,"href":"https:\u002F\u002Fwww.linkedin.com\u002Fin\u002F%F0%9F%8C%8Ddaniel-quinlan-51126016\u002F","anchorType":"LINK","userId":null,"linkMetadata":null},{"__typename":"Markup","type":"A","start":181,"end":191,"href":"https:\u002F\u002Fgithub.com\u002FGoogleCloudPlatform\u002Fmicroservices-demo\u002Fblob\u002Fmain\u002Fhelm-chart\u002Fvalues.yaml#L109","anchorType":"LINK","userId":null,"linkMetadata":null},{"__typename":"Markup","type":"A","start":199,"end":216,"href":"https:\u002F\u002Fgithub.com\u002FGoogleCloudPlatform\u002Fmicroservices-demo\u002Ftree\u002Fmain\u002Fkustomize\u002Fcomponents\u002Fspanner","anchorType":"LINK","userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_65":{"__typename":"Paragraph","id":"8eab67036f59_65","name":"3726","type":"P","href":null,"layout":null,"metadata":null,"text":"Happy sailing, cheers!","hasDropCap":null,"dropCapImage":null,"markups":[],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"Paragraph:8eab67036f59_66":{"__typename":"Paragraph","id":"8eab67036f59_66","name":"1e8b","type":"P","href":null,"layout":null,"metadata":null,"text":"Originally posted at mathieu-benoit.github.io.","hasDropCap":null,"dropCapImage":null,"markups":[{"__typename":"Markup","type":"A","start":21,"end":45,"href":"https:\u002F\u002Fmathieu-benoit.github.io\u002F","anchorType":"LINK","userId":null,"linkMetadata":null},{"__typename":"Markup","type":"EM","start":0,"end":46,"href":null,"anchorType":null,"userId":null,"linkMetadata":null}],"codeBlockMetadata":null,"iframe":null,"mixtapeMetadata":null},"CollectionViewerEdge:collectionId:e52cf94d98af-viewerId:lo_92cce514a369":{"__typename":"CollectionViewerEdge","id":"collectionId:e52cf94d98af-viewerId:lo_92cce514a369","isEditor":false,"isMuting":false},"UserViewerEdge:userId:1c5a91945323-viewerId:lo_92cce514a369":{"__typename":"UserViewerEdge","id":"userId:1c5a91945323-viewerId:lo_92cce514a369","isMuting":false},"PostViewerEdge:postId:f7248e077339-viewerId:lo_92cce514a369":{"__typename":"PostViewerEdge","shouldIndexPostForExternalSearch":true,"id":"postId:f7248e077339-viewerId:lo_92cce514a369"},"Tag:kubernetes":{"__typename":"Tag","id":"kubernetes","displayTitle":"Kubernetes","normalizedTagSlug":"kubernetes"},"Tag:cloud-spanner":{"__typename":"Tag","id":"cloud-spanner","displayTitle":"Cloud Spanner","normalizedTagSlug":"cloud-spanner"},"Tag:dotnet-core":{"__typename":"Tag","id":"dotnet-core","displayTitle":"Dotnet Core","normalizedTagSlug":"dotnet-core"},"Tag:google-cloud-platform":{"__typename":"Tag","id":"google-cloud-platform","displayTitle":"Google Cloud Platform","normalizedTagSlug":"google-cloud-platform"},"Tag:gcp-app-dev":{"__typename":"Tag","id":"gcp-app-dev","displayTitle":"Gcp App Dev","normalizedTagSlug":"gcp-app-dev"},"Post:f7248e077339":{"__typename":"Post","id":"f7248e077339","collection":{"__ref":"Collection:e52cf94d98af"},"content({\"postMeteringOptions\":{\"referrer\":\"\"}})":{"__typename":"PostContent","isLockedPreviewOnly":false,"bodyModel":{"__typename":"RichText","sections":[{"__typename":"Section","name":"9280","startIndex":0,"textLayout":null,"imageLayout":null,"backgroundImage":null,"videoLayout":null,"backgroundVideo":null},{"__typename":"Section","name":"c4f8","startIndex":6,"textLayout":null,"imageLayout":null,"backgroundImage":null,"videoLayout":null,"backgroundVideo":null},{"__typename":"Section","name":"057e","startIndex":8,"textLayout":null,"imageLayout":null,"backgroundImage":null,"videoLayout":null,"backgroundVideo":null},{"__typename":"Section","name":"3398","startIndex":13,"textLayout":null,"imageLayout":null,"backgroundImage":null,"videoLayout":null,"backgroundVideo":null},{"__typename":"Section","name":"1928","startIndex":18,"textLayout":null,"imageLayout":null,"backgroundImage":null,"videoLayout":null,"backgroundVideo":null},{"__typename":"Section","name":"d6c5","startIndex":22,"textLayout":null,"imageLayout":null,"backgroundImage":null,"videoLayout":null,"backgroundVideo":null},{"__typename":"Section","name":"c825","startIndex":28,"textLayout":null,"imageLayout":null,"backgroundImage":null,"videoLayout":null,"backgroundVideo":null},{"__typename":"Section","name":"07e8","startIndex":31,"textLayout":null,"imageLayout":null,"backgroundImage":null,"videoLayout":null,"backgroundVideo":null},{"__typename":"Section","name":"ab18","startIndex":34,"textLayout":null,"imageLayout":null,"backgroundImage":null,"videoLayout":null,"backgroundVideo":null},{"__typename":"Section","name":"192d","startIndex":42,"textLayout":null,"imageLayout":null,"backgroundImage":null,"videoLayout":null,"backgroundVideo":null},{"__typename":"Section","name":"7907","startIndex":47,"textLayout":null,"imageLayout":null,"backgroundImage":null,"videoLayout":null,"backgroundVideo":null},{"__typename":"Section","name":"68a4","startIndex":56,"textLayout":null,"imageLayout":null,"backgroundImage":null,"videoLayout":null,"backgroundVideo":null},{"__typename":"Section","name":"d287","startIndex":62,"textLayout":null,"imageLayout":null,"backgroundImage":null,"videoLayout":null,"backgroundVideo":null},{"__typename":"Section","name":"6a47","startIndex":66,"textLayout":null,"imageLayout":null,"backgroundImage":null,"videoLayout":null,"backgroundVideo":null}],"paragraphs":[{"__ref":"Paragraph:8eab67036f59_0"},{"__ref":"Paragraph:8eab67036f59_1"},{"__ref":"Paragraph:8eab67036f59_2"},{"__ref":"Paragraph:8eab67036f59_3"},{"__ref":"Paragraph:8eab67036f59_4"},{"__ref":"Paragraph:8eab67036f59_5"},{"__ref":"Paragraph:8eab67036f59_6"},{"__ref":"Paragraph:8eab67036f59_7"},{"__ref":"Paragraph:8eab67036f59_8"},{"__ref":"Paragraph:8eab67036f59_9"},{"__ref":"Paragraph:8eab67036f59_10"},{"__ref":"Paragraph:8eab67036f59_11"},{"__ref":"Paragraph:8eab67036f59_12"},{"__ref":"Paragraph:8eab67036f59_13"},{"__ref":"Paragraph:8eab67036f59_14"},{"__ref":"Paragraph:8eab67036f59_15"},{"__ref":"Paragraph:8eab67036f59_16"},{"__ref":"Paragraph:8eab67036f59_17"},{"__ref":"Paragraph:8eab67036f59_18"},{"__ref":"Paragraph:8eab67036f59_19"},{"__ref":"Paragraph:8eab67036f59_20"},{"__ref":"Paragraph:8eab67036f59_21"},{"__ref":"Paragraph:8eab67036f59_22"},{"__ref":"Paragraph:8eab67036f59_23"},{"__ref":"Paragraph:8eab67036f59_24"},{"__ref":"Paragraph:8eab67036f59_25"},{"__ref":"Paragraph:8eab67036f59_26"},{"__ref":"Paragraph:8eab67036f59_27"},{"__ref":"Paragraph:8eab67036f59_28"},{"__ref":"Paragraph:8eab67036f59_29"},{"__ref":"Paragraph:8eab67036f59_30"},{"__ref":"Paragraph:8eab67036f59_31"},{"__ref":"Paragraph:8eab67036f59_32"},{"__ref":"Paragraph:8eab67036f59_33"},{"__ref":"Paragraph:8eab67036f59_34"},{"__ref":"Paragraph:8eab67036f59_35"},{"__ref":"Paragraph:8eab67036f59_36"},{"__ref":"Paragraph:8eab67036f59_37"},{"__ref":"Paragraph:8eab67036f59_38"},{"__ref":"Paragraph:8eab67036f59_39"},{"__ref":"Paragraph:8eab67036f59_40"},{"__ref":"Paragraph:8eab67036f59_41"},{"__ref":"Paragraph:8eab67036f59_42"},{"__ref":"Paragraph:8eab67036f59_43"},{"__ref":"Paragraph:8eab67036f59_44"},{"__ref":"Paragraph:8eab67036f59_45"},{"__ref":"Paragraph:8eab67036f59_46"},{"__ref":"Paragraph:8eab67036f59_47"},{"__ref":"Paragraph:8eab67036f59_48"},{"__ref":"Paragraph:8eab67036f59_49"},{"__ref":"Paragraph:8eab67036f59_50"},{"__ref":"Paragraph:8eab67036f59_51"},{"__ref":"Paragraph:8eab67036f59_52"},{"__ref":"Paragraph:8eab67036f59_53"},{"__ref":"Paragraph:8eab67036f59_54"},{"__ref":"Paragraph:8eab67036f59_55"},{"__ref":"Paragraph:8eab67036f59_56"},{"__ref":"Paragraph:8eab67036f59_57"},{"__ref":"Paragraph:8eab67036f59_58"},{"__ref":"Paragraph:8eab67036f59_59"},{"__ref":"Paragraph:8eab67036f59_60"},{"__ref":"Paragraph:8eab67036f59_61"},{"__ref":"Paragraph:8eab67036f59_62"},{"__ref":"Paragraph:8eab67036f59_63"},{"__ref":"Paragraph:8eab67036f59_64"},{"__ref":"Paragraph:8eab67036f59_65"},{"__ref":"Paragraph:8eab67036f59_66"}]},"validatedShareKey":"","shareKeyCreator":null},"creator":{"__ref":"User:1c5a91945323"},"inResponseToEntityType":null,"isLocked":false,"isMarkedPaywallOnly":false,"lockedSource":"LOCKED_POST_SOURCE_NONE","mediumUrl":"https:\u002F\u002Fmedium.com\u002Fgoogle-cloud\u002Fuse-google-cloud-spanner-with-the-online-boutique-sample-apps-f7248e077339","primaryTopic":{"__ref":"Topic:decb52b64abf"},"topics":[{"__typename":"Topic","slug":"programming"}],"isLimitedState":false,"isPublished":true,"allowResponses":true,"responsesLocked":false,"visibility":"PUBLIC","latestPublishedVersion":"8eab67036f59","postResponses":{"__typename":"PostResponses","count":2},"responseDistribution":"NOT_DISTRIBUTED","clapCount":51,"title":"Use Google Cloud Spanner with the Online Boutique sample","isSeries":false,"sequence":null,"uniqueSlug":"use-google-cloud-spanner-with-the-online-boutique-sample-apps-f7248e077339","socialTitle":"","socialDek":"","canonicalUrl":"","metaDescription":"","latestPublishedAt":1712009614260,"readingTime":3.2716981132075476,"previewContent":{"__typename":"PreviewContent","subtitle":"Updated on April 1st, 2024 with the new way to configure Workload Identity with GKE workload."},"previewImage":{"__ref":"ImageMetadata:0*A8lG1q1M29P72YWY.png"},"isShortform":false,"seoTitle":"","firstPublishedAt":1666097986538,"updatedAt":1712009614260,"shortformType":"SHORTFORM_TYPE_LINK","seoDescription":"","viewerEdge":{"__ref":"PostViewerEdge:postId:f7248e077339-viewerId:lo_92cce514a369"},"isSuspended":false,"license":"ALL_RIGHTS_RESERVED","tags":[{"__ref":"Tag:kubernetes"},{"__ref":"Tag:cloud-spanner"},{"__ref":"Tag:dotnet-core"},{"__ref":"Tag:google-cloud-platform"},{"__ref":"Tag:gcp-app-dev"}],"isFeaturedInPublishedPublication":false,"isNewsletter":false,"statusForCollection":"APPROVED","pendingCollection":null,"detectedLanguage":"en","wordCount":814,"layerCake":3}}</script><script>window.__MIDDLEWARE_STATE__={"session":{"xsrf":""},"cache":{"cacheStatus":"MISS"}}</script><script src="https://cdn-client.medium.com/lite/static/js/manifest.4fdca621.js"></script><script src="https://cdn-client.medium.com/lite/static/js/4783.3b00fa4a.js"></script><script src="https://cdn-client.medium.com/lite/static/js/main.e1b45195.js"></script><script src="https://cdn-client.medium.com/lite/static/js/instrumentation.5bef8967.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/reporting.ff22a7a5.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/8813.659c88d9.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/3171.5b0ceee8.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/628.4b410354.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/6618.db187378.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/3338.0505d492.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/2707.d1d70988.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/9977.b590327e.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/7465.4c2483ec.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/4737.5256e883.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/7381.9944134b.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/6372.7118269b.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/7938.4f8e1aff.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/3862.b8166914.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/3054.3f2efcff.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/4929.37d2472b.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/3623.6012cece.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/7979.15bcd496.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/7975.d44b0cb9.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/6834.aa1899a4.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/8664.b06e2cc0.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/4378.6c27319c.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/144.af31af76.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/3666.cdb15b43.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/8768.516b8cf0.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/1069.499eaa23.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/3523.4da37341.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/PostPage.MainContent.5ba0df03.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/2698.a5c8f865.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/3974.6ff9e2e8.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/2527.19bcbbd2.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/PostResponsesContent.9bd6b113.chunk.js"></script> <script src="https://cdn-client.medium.com/lite/static/js/responses.editor.ec13f6ad.chunk.js"></script><script>window.main();</script><script>(function(){function c(){var b=a.contentDocument||a.contentWindow.document;if(b){var d=b.createElement('script');d.innerHTML="window.__CF$cv$params={r:'92d4fc607ea9fd2c',t:'MTc0NDE0OTA4NS4wMDAwMDA='};var a=document.createElement('script');a.nonce='';a.src='/cdn-cgi/challenge-platform/scripts/jsd/main.js';document.getElementsByTagName('head')[0].appendChild(a);";b.getElementsByTagName('head')[0].appendChild(d)}}if(document.body){var a=document.createElement('iframe');a.height=1;a.width=1;a.style.position='absolute';a.style.top=0;a.style.left=0;a.style.border='none';a.style.visibility='hidden';document.body.appendChild(a);if('loading'!==document.readyState)c();else if(window.addEventListener)document.addEventListener('DOMContentLoaded',c);else{var e=document.onreadystatechange||function(){};document.onreadystatechange=function(b){e(b);'loading'!==document.readyState&&(document.onreadystatechange=e,c())}}}})();</script></body></html>