Upgrade to Pro — share decks privately, control downloads, hide ads and more …

マルチテナントSaaSにおけるAmazon QuickSightの活用例

shogo452
September 26, 2022

マルチテナントSaaSにおけるAmazon QuickSightの活用例

BigData-JAWS 勉強会#21の登壇資料です。
https://jawsug-bigdata.connpass.com/event/257903/

shogo452

September 26, 2022
Tweet

More Decks by shogo452

Other Decks in Programming

Transcript

  1. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE ࣗݾ঺հ 2 Shogo Tanaka GitHub @shogo452 / Twitter

    @shogo__452 2021.2 גࣜձࣾελϝϯʹೖࣾ ॴଐɿνʔϜͶ͗· ؙͷ্ʹࣗ෼ͷࣸਅΛ υϥοάˍυϩοϓ
  2. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE ΞδΣϯμ 3  ձࣾɾࣄۀ঺հ  ΧελϜμογϡϘʔυػೳͷ։ൃ  "NB[PO2VJDL4JHIUͷ֓ཁ

     ΧελϜμογϡϘʔυػೳͷΞʔΩςΫνϟ  "NB[PO2VJDL4JHIUͷΞϓϦέʔγϣϯ΁ͷຒΊࠐΈ  -BNCEBؔ਺ͷ׆༻ྫ  $MPVE8BUDIؔ਺ͷ׆༻ྫ  ӡ༻ͷޮ཰Խ  ·ͱΊ
  3. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE ձࣾ֓ཁ 5 w ໊ࣾɿגࣜձࣾελϝϯ w ઃཱɿ೥݄೔ w ॴࡏ஍

    ຊࣾ ɿ໊ݹ԰ࢢதଜ۠Լ޿Ҫொ w ڌ఺ɿח૔ࢧࣾେࡕࢧࣾ w ୅දऀɿՃ౻ް࢙ w ैۀһ਺ɿ໊ ೥݄຤࣌఺ͷਖ਼ࣾһ਺  w ࢿຊۚɿԯສԁ w ࣄۀ಺༰ɿʮ56/"(ʯ͓Αͼʮ'"/54ʯͷاըɾ։ൃɾӡӦ
  4. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE ΞΧ΢ϯτ 13 ؅ཧऀ "%.*/ ࡞੒ऀ "65)03 Ӿཡऀ 3&"%&3

    ɾμογϡϘʔυͷ࡞੒ ɾυϧ݄˞ ɾμογϡϘʔυͷӾཡ ɾ࠷େυϧ݄˞ ɾ֤छઃఆͷมߋ ɾμογϡϘʔυͷ࡞੒ ɾυϧ݄˞ ˞&OUFSQSJTF൛݄ܖ໿ͷ৔߹
  5. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE άϧʔϓͱ໊લۭؒͷൺֱ 22 w͍ͣΕ΋Ϣʔβʔ΋͘͠͸άϧʔϓผʹ"1*ͳͲΛ༻͍ͯ ֤Ξηοτ΁ͷΞΫηεݖݶΛઃఆՄೳ wϚϧνςφϯτߏ੒ͷ৔߹ɺ໊લۭؒͷར༻͕ਪ঑͞Ε͍ͯΔ quicksight:DescribeDataSet quicksight:DescribeDataSetPermissions quicksight:PassDataSet

    quicksight:DescribeIngestion quicksight:ListIngestions quicksight:UpdateDataSet quicksight:DeleteDataSet quicksight:CreateIngestion quicksight:CancelIngestion quicksight:UpdateDataSetPermissions ฤूݖݶͷΞΫγϣϯ܈ ӾཡݖݶͷΞΫγϣϯ܈ σʔληοτ "65)03 3&"%&3 σʔληοτͷ৔߹ 6QEBUF%BUBTFU1FSNJTTJPOT"1*ͰࢦఆͰ͖Δ"DUJPOT "65)03 "65)03 "65)03 "65)03 σϑΥϧτͷ໊લۭؒ άϧʔϓ" άϧʔϓ# ໊લۭؒ" ໊લۭؒ# ެ։Մೳ 🙆 ެ։ෆՄ 🙅 ✕ άϧʔϓͷ৔߹ ໊લۭؒͷ৔߹
  6. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE શମΞʔΩςΫνϟ 27 ݁߹ͨ͠σʔληοτͷྫ  ϢʔβʔผͷαϯΫεΧʔυૹ෇਺ ᵓαϯΫεૹ෇਺ ᵓϢʔβʔ ૹ෇ऀ

     ᵓ෦ॺº໾৬ ᵓϢʔβʔηάϝϯτ ᵓ੍౓ ᵋϢʔβʔ डྖऀ ᶄᶅΞηοτͷ࡞੒ wϚελʔσʔλͱτϥϯβΫγϣϯσʔλͷ ֤σʔληοτΛ૊Έ߹Θͤͯ݁߹͠ɺࢦඪผͷ σʔληοτΛ࡞੒ w෼ੳΛ࡞੒͠ɺμογϡϘʔυ΁ެ։ ໊લۭؒΛ༻͍ͨ Ϛϧνςφϯτߏ੒Λ࠾༻ 👆 ਖ਼نԽ͞Εͨσʔληοτ
  7. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE  ఆظߋ৽ σʔληοτͷߋ৽ͷ՝୊ͱχʔζ 36 ՝୊ طଘͷεέδϡʔϧߋ৽ػೳ͸ɺ2VJDL4JHIUίϯιʔϧ͔Β ౎౓ઃఆ͕ඞཁɻϢʔβʔ͕σʔληοτΛ࡞੒ͨ͠ࡍͷઃఆ͕ ࿙Ε΍͍͢ɻ

    χʔζ ຖ೔56/"(্ʹར༻σʔλ͕஝ੵ͞ΕΔͨΊɺ ࠷৽ͷར༻σʔλ͕ຖ೔൓ө͞ΕΔΑ͏ʹ͍ͨ͠ɻ 2VJDL4JHIUίϯιʔϧߋ৽εέδϡʔϧ࡞੒ը໘
  8. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE  ଈ࣌ߋ৽ σʔληοτͷߋ৽ͷ՝୊ͱχʔζ 37 ՝୊ 2VJDL4JHIUίϯιʔϧ͔Βʮࠓ͙͢ߋ৽ʯͷԡԼ͕ඞཁɻ શσʔληοτΛߋ৽͠Α͏ͱ͢Δͱ2VJDL4JHIUίϯιʔϧ Ͱͷ࡞ۀͷ޻਺େɻ

    χʔζ ɾϢʔβʔ৘ใɺ෦ॺͷॴଐ৘ใ͕มߋ͞Εͨ৔߹ʹଈ࣌ʹ ෼ੳʹ൓ө͍ͨ͠ɻ ɾଈ࣌ߋ৽Λ56/"(ͷ؅ཧը໘͔ΒϢʔβʔૢ࡞Ͱ͖ΔΑ͏ʹ ͍ͨ͠ɻ 👆 2VJDL4JHIUίϯιʔϧσʔληοτৄࡉը໘ ൈਮ
  9. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE  ਖ਼نԽ͞Εͨσʔληοτ΋͘͠͸݁߹ͯ͠࡞੒͞Εͨ σʔληοτͷߋ৽ʹ͓͍ͯɺਖ਼نԽ͞ΕͨσʔληοτΛ ߋ৽ͨ͠ޙʹ݁߹ࡁΈͷσʔληοτΛߋ৽͢ΔΑ͏ʹ͍ͨ͠ɻ    

       41*$&σʔλߋ৽࣌ʹ"VSPSB΋͘͠͸"UIFOB΁ͷ ଟॏϦΫΤετΛ࠷খݶʹ͍ͨ͠ɻ ࣗಈߋ৽ͷཁ݅ 38 㱺͜ΕΒͷཁ݅Λຬͨࣗ͢ಈߋ৽ͷ࢓૊ΈΛߏங
  10. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE  ໊લۭؒผʹ41*$&ͷ࢖༻ྔΛ೺Ѳ͍ͨ͠      

      ҙਤͤͣେ༰ྔͷσʔληοτ͕࡞੒͞Εɺಛఆͷ໊લۭؒ Ͱ41*$&༰ྔΛେ෯ʹઐ༗͞Εͨ৔߹ʹؾ͖͍ͮͨ 41*$&࢖༻ྔͷ೺Ѳͷχʔζ 44 wͭͷ"84ΞΧ΢ϯτͷ2VJDL4JHIU؀ڥͷ41*$&༰ྔ໊͕લ ۭؒΛԣஅͯ͠࢖༻͞ΕΔɻ w2VJDL4JHIUίϯιʔϧͰ͸໊લۭؒผͷ41*$&࢖༻ྔ͸ ֬ೝͰ͖ͳ͍ɻ 㱺41*$&ͷ࢖༻ྔΛ؂ࢹ͢Δ࢓૊ΈΛߏங
  11. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE ύϑΥʔϚϯεͷ؂ࢹ 48 ɺ$MPVE8BUDIϝτϦΫεͰ2VJDL4JHIUͷύ ϑΥʔϚϯεΛϞχλϦϯάՄೳʹʂ ϝτϦΫε໊ ಺༰ *OHFUJPO&SSPS$PVOU σʔλऔΓࠐΈΤϥʔͷճ਺

    *OHFTUJPO*OWPDBUJPO$PVOU σʔλऔΓࠐΈճ਺ *OHFTUJPO-BUFODZ σʔλऔΓࠐΈ଎౓ *OHFTUJPOSPX$PVOU σʔλऔΓࠐΈߦ਺ %BTICPBSE7JFX$PVOU μογϡϘʔυͷදࣔճ਺ %BTICPBSE7JFX-PBE5JNF μογϡϘʔυͷදࣔ଎౓ 7JTVBM-PBE5JNF ϏδϡΞϧͷදࣔ଎౓ 7JTVBM-PBE&SSPS$PVOU ϏδϡΞϧͷදࣔΤϥʔͷճ਺ 2VJDL4JHIUͷϝτϦΫεҰཡ
  12. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE ৘ใͷऔಘͷޮ཰Խͷχʔζ 58  Ξηοτಉ࢜ͷؔ܎ੑͷ೺Ѳ w֤Ξηοτͷؔ܎ੑΛ໢ཏతʹ֬ೝ͍ͨ͠ɻ ɾͲͷ෼ੳ͕ͲͷμογϡϘʔυʹެ։͞Ε͍ͯΔͷ͔ ɾͲͷσʔληοτ͕Ͳͷ෼ੳʹ࢖༻͞Ε͍ͯΔͷ͔ ɾͲͷσʔληοτ͕݁߹͞Ε͍ͯΔͷ͔

    wΞηοτͷؔ܎ੑΛπϦʔߏ଄Ͱݟ΍͘͢ද͍ࣔͨ͠ σʔληοτͷ෼ྨɾҰཡԽ wͲͷ໊લۭؒʹଐ͍ͯ͠Δ͔ΛҰཡԽ͍ͨ͠ w֤σʔληοτͷ41*$&ͷ࢖༻ྔΛҰཡԽ͍ͨ͠ 㱺ޮ཰Խ༻ͷεΫϦϓτΛ࡞੒
  13. $PQZSJHIU˜TUNO JOD"MMSJHIUTSFTFSWFE ·ͱΊ 63 w ໊લۭؒͷ׆༻ 㱺Ϛϧνςφϯτߏ੒Λ࣮ݱՄೳ w ຒΊࠐΈͷ׆༻ 㱺࠷খ޻਺Ͱ෼ੳ؀ڥΛఏڙՄೳ

    w -BNCEB $MPVE8BUDIͱͷ࿈ܞ 㱺ߋ৽ͷࣗಈԽ΍؂ࢹͷ࢓૊Έ͕ߏஙՄೳ w "844%,ͷ׆༻ 㱺ϢʔβʔɾΞηοτͷॲཧͷػೳԽ͕Մೳ w "84$-*ͷ׆༻ 㱺ΦϖϨʔγϣϯΛޮ཰ԽɺࣗಈԽ͕Մೳ