Share
Embed
マルチテナントSaaSにおけるAmazon QuickSightの活用例
BigData-JAWS 勉強会#21の登壇資料です。
https://jawsug-bigdata.connpass.com/event/257903/
shogo452
September 26, 2022
Transcript
66 slides
-
$PQZSJHIUTUNO JOD"MMSJHIUTSFTFSWFE ࣗݾհ 2 Shogo Tanaka GitHub @shogo452 / Twitter
@shogo__452 2021.2 גࣜձࣾελϝϯʹೖࣾ ॴଐɿνʔϜͶ͗· ؙͷ্ʹࣗͷࣸਅΛ υϥοάˍυϩοϓ -
$PQZSJHIUTUNO JOD"MMSJHIUTSFTFSWFE ΞδΣϯμ 3 ձࣾɾࣄۀհ ΧελϜμογϡϘʔυػೳͷ։ൃ "NB[PO2VJDL4JHIUͷ֓ཁ
ΧελϜμογϡϘʔυػೳͷΞʔΩςΫνϟ "NB[PO2VJDL4JHIUͷΞϓϦέʔγϣϯͷຒΊࠐΈ -BNCEBؔͷ׆༻ྫ $MPVE8BUDIؔͷ׆༻ྫ ӡ༻ͷޮԽ ·ͱΊ -
$PQZSJHIUTUNO JOD"MMSJHIUTSFTFSWFE ձࣾ֓ཁ 5 w ໊ࣾɿגࣜձࣾελϝϯ w ઃཱɿ݄ w ॴࡏ
ຊࣾ ɿ໊ݹࢢதଜ۠ԼҪொ w ڌɿחࢧࣾେࡕࢧࣾ w දऀɿՃ౻ް࢙ w ैۀһɿ໊ ݄࣌ͷਖ਼ࣾһ w ࢿຊۚɿԯສԁ w ࣄۀ༰ɿʮ56/"(ʯ͓Αͼʮ'"/54ʯͷاըɾ։ൃɾӡӦ -
$PQZSJHIUTUNO JOD"MMSJHIUTSFTFSWFE ओཁը໘ 7 ʲ੍Ұཡʳ ॏཁͳऔΓΈࣾͷจԽΛ ՄࢹԽ ʲλΠϜϥΠϯʳ ձࣾਓͷಈ͖Λ ϦΞϧλΠϜʹڞ༗
ʲ৫Ұཡʳ ͲͷΑ͏ͳ৫ɾਓ͕͍Δͷ͔Λ ՄࢹԽ ৫ਓͷใΛΔ͖͔͚ͬΛͭ͘Δͭͷը໘ -
$PQZSJHIUTUNO JOD"MMSJHIUTSFTFSWFE ΞΧϯτ 13 ཧऀ "%.*/ ࡞ऀ "65)03 Ӿཡऀ 3&"%&3
ɾμογϡϘʔυͷ࡞ ɾυϧ݄˞ ɾμογϡϘʔυͷӾཡ ɾ࠷େυϧ݄˞ ɾ֤छઃఆͷมߋ ɾμογϡϘʔυͷ࡞ ɾυϧ݄˞ ˞&OUFSQSJTF൛݄ܖͷ߹ -
$PQZSJHIUTUNO JOD"MMSJHIUTSFTFSWFE Ξηοτ 14 σʔλιʔε σʔληοτ ੳ μογϡϘʔυ ެ։ ࢹ֮Խ
ɾμΠϨΫτΫΤϦ ɾ41*$&Πϯϙʔτ -
$PQZSJHIUTUNO 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 σϑΥϧτͷ໊લۭؒ άϧʔϓ" άϧʔϓ# ໊લۭؒ" ໊લۭؒ# ެ։Մೳ 🙆 ެ։ෆՄ 🙅 ✕ άϧʔϓͷ߹ ໊લۭؒͷ߹ -
$PQZSJHIUTUNO JOD"MMSJHIUTSFTFSWFE શମΞʔΩςΫνϟ 27 ݁߹ͨ͠σʔληοτͷྫ ϢʔβʔผͷαϯΫεΧʔυૹ ᵓαϯΫεૹ ᵓϢʔβʔ ૹऀ
ᵓ෦ॺº৬ ᵓϢʔβʔηάϝϯτ ᵓ੍ ᵋϢʔβʔ डྖऀ ᶄᶅΞηοτͷ࡞ wϚελʔσʔλͱτϥϯβΫγϣϯσʔλͷ ֤σʔληοτΛΈ߹Θͤͯ݁߹͠ɺࢦඪผͷ σʔληοτΛ࡞ wੳΛ࡞͠ɺμογϡϘʔυެ։ ໊લۭؒΛ༻͍ͨ ϚϧνςφϯτߏΛ࠾༻ 👆 ਖ਼نԽ͞Εͨσʔληοτ -
$PQZSJHIUTUNO JOD"MMSJHIUTSFTFSWFE ఆظߋ৽ σʔληοτͷߋ৽ͷ՝ͱχʔζ 36 ՝ طଘͷεέδϡʔϧߋ৽ػೳɺ2VJDL4JHIUίϯιʔϧ͔Β ઃఆ͕ඞཁɻϢʔβʔ͕σʔληοτΛ࡞ͨ͠ࡍͷઃఆ͕ ࿙Ε͍͢ɻ
χʔζ ຖ56/"(্ʹར༻σʔλ͕ੵ͞ΕΔͨΊɺ ࠷৽ͷར༻σʔλ͕ຖө͞ΕΔΑ͏ʹ͍ͨ͠ɻ 2VJDL4JHIUίϯιʔϧߋ৽εέδϡʔϧ࡞ը໘ -
$PQZSJHIUTUNO JOD"MMSJHIUTSFTFSWFE ଈ࣌ߋ৽ σʔληοτͷߋ৽ͷ՝ͱχʔζ 37 ՝ 2VJDL4JHIUίϯιʔϧ͔Βʮࠓ͙͢ߋ৽ʯͷԡԼ͕ඞཁɻ શσʔληοτΛߋ৽͠Α͏ͱ͢Δͱ2VJDL4JHIUίϯιʔϧ Ͱͷ࡞ۀͷେɻ
χʔζ ɾϢʔβʔใɺ෦ॺͷॴଐใ͕มߋ͞Εͨ߹ʹଈ࣌ʹ ੳʹө͍ͨ͠ɻ ɾଈ࣌ߋ৽Λ56/"(ͷཧը໘͔ΒϢʔβʔૢ࡞Ͱ͖ΔΑ͏ʹ ͍ͨ͠ɻ 👆 2VJDL4JHIUίϯιʔϧσʔληοτৄࡉը໘ ൈਮ -
$PQZSJHIUTUNO JOD"MMSJHIUTSFTFSWFE ਖ਼نԽ͞Εͨσʔληοτ݁͘͠߹ͯ͠࡞͞Εͨ σʔληοτͷߋ৽ʹ͓͍ͯɺਖ਼نԽ͞ΕͨσʔληοτΛ ߋ৽ͨ͠ޙʹ݁߹ࡁΈͷσʔληοτΛߋ৽͢ΔΑ͏ʹ͍ͨ͠ɻ
41*$&σʔλߋ৽࣌ʹ"VSPSB͘͠"UIFOBͷ ଟॏϦΫΤετΛ࠷খݶʹ͍ͨ͠ɻ ࣗಈߋ৽ͷཁ݅ 38 㱺͜ΕΒͷཁ݅Λຬͨࣗ͢ಈߋ৽ͷΈΛߏங -
$PQZSJHIUTUNO JOD"MMSJHIUTSFTFSWFE ໊લۭؒผʹ41*$&ͷ༻ྔΛѲ͍ͨ͠
ҙਤͤͣେ༰ྔͷσʔληοτ͕࡞͞Εɺಛఆͷ໊લۭؒ Ͱ41*$&༰ྔΛେ෯ʹઐ༗͞Εͨ߹ʹؾ͖͍ͮͨ 41*$&༻ྔͷѲͷχʔζ 44 wͭͷ"84ΞΧϯτͷ2VJDL4JHIUڥͷ41*$&༰ྔ໊͕લ ۭؒΛԣஅͯ͠༻͞ΕΔɻ w2VJDL4JHIUίϯιʔϧͰ໊લۭؒผͷ41*$&༻ྔ ֬ೝͰ͖ͳ͍ɻ 㱺41*$&ͷ༻ྔΛࢹ͢ΔΈΛߏங -
$PQZSJHIUTUNO 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ͷϝτϦΫεҰཡ -
$PQZSJHIUTUNO JOD"MMSJHIUTSFTFSWFE ใͷऔಘͷޮԽͷχʔζ 58 Ξηοτಉ࢜ͷؔੑͷѲ w֤ΞηοτͷؔੑΛཏతʹ֬ೝ͍ͨ͠ɻ ɾͲͷੳ͕ͲͷμογϡϘʔυʹެ։͞Ε͍ͯΔͷ͔ ɾͲͷσʔληοτ͕Ͳͷੳʹ༻͞Ε͍ͯΔͷ͔ ɾͲͷσʔληοτ͕݁߹͞Ε͍ͯΔͷ͔
wΞηοτͷؔੑΛπϦʔߏͰݟ͘͢ද͍ࣔͨ͠ σʔληοτͷྨɾҰཡԽ wͲͷ໊લۭؒʹଐ͍ͯ͠Δ͔ΛҰཡԽ͍ͨ͠ w֤σʔληοτͷ41*$&ͷ༻ྔΛҰཡԽ͍ͨ͠ 㱺ޮԽ༻ͷεΫϦϓτΛ࡞ -
$PQZSJHIUTUNO JOD"MMSJHIUTSFTFSWFE ·ͱΊ 63 w ໊લۭؒͷ׆༻ 㱺ϚϧνςφϯτߏΛ࣮ݱՄೳ w ຒΊࠐΈͷ׆༻ 㱺࠷খͰੳڥΛఏڙՄೳ
w -BNCEB $MPVE8BUDIͱͷ࿈ܞ 㱺ߋ৽ͷࣗಈԽࢹͷΈ͕ߏஙՄೳ w "844%,ͷ׆༻ 㱺ϢʔβʔɾΞηοτͷॲཧͷػೳԽ͕Մೳ w "84$-*ͷ׆༻ 㱺ΦϖϨʔγϣϯΛޮԽɺࣗಈԽ͕Մೳ -
$PQZSJHIUTUNO JOD"MMSJHIUTSFTFSWFE ·ͱΊ 64 ϚϧνςφϯτߏɺຒΊࠐΈɺ-BNCEBؔͷৄࡉ ςοΫϒϩάͰ·ͱΊ͍ͯ·͢ɻ w ໊લۭؒΛ༻͍ͨ2VJDL4JHIU্ͰͷϚϧνςφϯτͷ࣮ݱ w 2VJDL4JHIUΛར༻ͯ͠ΧελϚΠζͨ͠μογϡϘʔυΛຒΊࠐΉ
w 2VJDL4JHIU41*$&σʔλͷ-BNCEBؔΛ༻͍ͨࣗಈߋ৽ॲཧ w 2VJDL4JHIUͷ41*$&σʔλ༻ྔΛ-BNCEBͰࢹ͍ͯ͠Δ 👇 ςοΫϒϩά -
$PQZSJHIUTUNO JOD"MMSJHIUTSFTFSWFE ΤϯδχΞઈࢍ࠾༻தͰ͢ʂ 65 ΤϯδχΞ σβΠφʔ 1E.Λ࠾༻தɻ ݄ΑΓ౦ژڌΛ։ઃ͠·͢ʂ 8BOUFEMZ ΤϯδχΞϦϯά
ϋϯυϒοΫ 👇 ։ൃମ੍։ൃͷྲྀΕʹ͍ͭͯ 👇 ౦ژڌͷ࠾༻ใ