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

AWS分析系&IaCサービス入門

 AWS分析系&IaCサービス入門

BigData-JAWS 勉強会 #24 QuickSight分科会
https://jawsug-bigdata.connpass.com/event/284869/

みのるん

July 13, 2023
Tweet

More Decks by みのるん

Other Decks in Technology

Transcript

  1. "84෼ੳܥʴ*B$αʔϏεೖ໳
    (MVF "UIFOB 2VJDL4JHIU $%,
    ΈͷΔΜ !NJOPSVO

    View Slide

  2. XIPBNJ
    御⽥ 稔 !NJOPSVO
    ,%%*גࣜձࣾ ˍ ,%%*ΞδϟΠϧ։ൃηϯλʔגࣜձࣾʢ,"(ʣ
    ࠷ۙɺຖ೔2JJUBॻ͍ͯͨΒʮޚా͸࣮͸ਓ͍Δʯͱ
    ࣾ಺Ͱ·͜ͱ͠΍͔ʹݴΘΕΔΑ͏ʹͳΓ·ͨ͠
    +"846(43&ࢧ෦ӡӦ +"84%":4࣮ߦҕһ
    • "84$PNNVOJUZ#VJMEFS
    • ,%%*$MPVE4".63"*
    • ,%%*$MPVE"NCBTTBEPST

    View Slide

  3. ,%%*Ͱ͸$$P&νʔϜͷऔΓ૊Έͱͯ͠
    ࣾ಺ͷ"84ར༻ঢ়گՄࢹԽπʔϧΛ։ൃ͍ͯ͠·͢💪
    ˞$$P&ʹ $MPVE$FOUFSPG&YFMMFODF
    ࣲాʢ10ʣ ޚాʢΤϯδχΞʣ
    ຤ޫʢ4.ʣ

    View Slide

  4. ௨শ,$-67*5ʢΫϧʔϏοτʣ
    ,%%*$MPVE6UJMJ[BUJPO
    7JTVBMJ[BUJPO*OTJHIU5PPM

    View Slide

  5. ྫ͑͹ɺࣾ಺ͷ"84Ϣʔβʔ͔Β
    Α͘ฉ͘ͷ͕ʜ

    View Slide

  6. ͪΐͬͱલʹ("͞ΕͨYYYͱ͍͏
    "84ͷ৽αʔϏε͕ؾʹͳΔΜ͚ͩͲɺ
    ࣾ಺Ͱ࢖ͬͯΔਓ͍ͳ͍͔ͳ͊ʁ
    ίϯγϡʔϚʔ޲͚γεςϜͷ
    Πϯϑϥӡ༻୲౰

    View Slide

  7. ΫϧʔϏοτͳΒ"84αʔϏε໊Λબ୒͢Δ͚ͩͰ
    ར༻ΞΧ΢ϯτɾҊ໊݅ɾ෦ॺؙ໊͕Θ͔Γʂ
    ౷ׅ
    ຊ෦
    ຊ෦ ෦ ΞΧ΢
    ϯτ*%
    ༻్
    ʢҊ໊݅ͳͲʣ
    ίετ

    View Slide

  8. ͦͷத͔Β"84ΞΧ΢ϯτΛҰͭબ୒͢Δͱ
    ར༻தαʔϏεͷߏ੒ൺ͕ݟΒΕ·͢

    View Slide

  9. ࣾ಺ʹ"84ΞΧ΢ϯτ͕ Ҏ্͋ΔͷͰ
    ͜ͷπʔϧ͸͔ͳΓॏๅ͠·͢ɻ

    View Slide

  10. ࣮͸͜ͷπʔϧɺ"84ͷ1SP4FSWF͞Μʹ
    ϓϩτΛ࡞ͬͯ΋Β͍·ͨ͠
    ͦͷޙɺࣗ෼ͨͪͰ಺੡Τϯϋϯε͍ͯ͠·͢

    View Slide

  11. ͕͢͞"84͞Μ͕
    ॳظઃܭ͚ͨͩ͋ͬͯ͠ɺ
    ෼ੳܥϚωʔδυαʔϏεͷ
    ͓खຊߏ੒ʹͳ͍ͬͯ·͢ɻ
    ͦͯ͠$%,Ͱ͹ͬͪΓ*B$ԽࡁΈʂ

    View Slide

  12. ࠓ೔͸͜ͷΫϧʔϏοτͷ
    ߏ੒Λ΋ͱʹɺ
    "84ͷ෼ੳܥˍ*B$αʔϏε
    ͷجຊΛΈͳ͞Μʹ঺հ͠·͢ɻ

    View Slide

  13. ΫϧʔϏοτͷΞʔΩςΫνϟ঺հ

    View Slide

  14. ,$-67*5ʹαʔόʔϨε෼ੳͷ͓खຊߏ੒ʂ
    $%,
    "84ΞΧ΢ϯτʢ,$-67*5ʣ
    ར༻ऀ

    View Slide

  15. ,$-67*5ʹαʔόʔϨε෼ੳͷ͓खຊߏ੒ʂ
    (MVF "UIFOB 2VJDL4JHIU
    $%,
    "84ΞΧ΢ϯτʢ,$-67*5ʣ
    4
    ֤"84ϦιʔεΛσϓϩΠ
    ར༻ऀ

    View Slide

  16. ,$-67*5ʹαʔόʔϨε෼ੳͷ͓खຊߏ੒ʂ
    (MVF "UIFOB 2VJDL4JHIU
    $%,
    "84ΞΧ΢ϯτʢ,$-67*5ʣ
    4
    ֤"84ϦιʔεΛσϓϩΠ
    ར༻ऀ
    μογϡϘʔυ

    View Slide

  17. ,$-67*5ʹαʔόʔϨε෼ੳͷ͓खຊߏ੒ʂ
    (MVF "UIFOB 2VJDL4JHIU
    $%,
    "84ΞΧ΢ϯτʢ,$-67*5ʣ
    4
    ֤"84ϦιʔεΛσϓϩΠ
    ར༻ऀ
    ݕࡧΫΤϦʔ μογϡϘʔυ

    View Slide

  18. ,$-67*5ʹαʔόʔϨε෼ੳͷ͓खຊߏ੒ʂ
    (MVF "UIFOB 2VJDL4JHIU
    $%,
    "84ΞΧ΢ϯτʢ,$-67*5ʣ
    4
    σʔλΧλϩά
    ֤"84ϦιʔεΛσϓϩΠ
    ར༻ऀ
    ݕࡧΫΤϦʔ μογϡϘʔυ

    View Slide

  19. ,$-67*5ʹαʔόʔϨε෼ੳͷ͓खຊߏ੒ʂ
    (MVF "UIFOB 2VJDL4JHIU
    $%,
    "84ΞΧ΢ϯτʢ,$-67*5ʣ
    4
    σʔλιʔε σʔλΧλϩά
    ֤"84ϦιʔεΛσϓϩΠ
    ར༻ऀ
    ݕࡧΫΤϦʔ μογϡϘʔυ

    View Slide

  20. "UIFOB͔Βඥղ͘ͱ෼͔Γ΍͍͢
    (MVF 2VJDL4JHIU
    $%,
    "84ΞΧ΢ϯτʢ,$-67*5ʣ
    4
    σʔλιʔε σʔλΧλϩά
    ֤"84ϦιʔεΛσϓϩΠ
    ར༻ऀ
    μογϡϘʔυ
    "UIFOB
    ݕࡧΫΤϦʔ

    View Slide

  21. "NB[PO"UIFOBͱ͸ʁ

    View Slide

  22. "NB[PO"UIFOBͱ͸ʁ
    ҰݴͰ͍͏ͱ4ͷσʔλΛ42-Ͱ෼ੳͰ͖ΔαʔϏεɻ
    "UIFOB
    4

    View Slide

  23. "NB[PO"UIFOBͱ͸ʁ
    ͜Ε·Ͱɺܗ͕ࣜἧ͍ͬͯͳ͍༷ʑͳσʔλΛ
    ·ͱΊͯ෼ੳ͢Δͷ͸೉͔ͬͨ͠ɻ
    4όέοτ
    $47 +40/ 1BSRVFU

    View Slide

  24. "NB[PO"UIFOBͱ͸ʁ
    "UIFOB͸ςʔϒϧఆٛΛߦ͏͜ͱͰ
    ৭ΜͳσʔλΛ%#Խͯ͠42-Ͱ෼ੳՄೳʹͨ͠ʂ
    4όέοτ
    $47 +40/
    "UIFOB
    ςʔϒϧఆٛ
    ͜ͷ$47ͷྻ໨͸
    ʮ6TFS/BNFʯͱ͍͏จࣈྻσʔλͰ͐͢ʂ

    View Slide

  25. "NB[PO"UIFOBͱ͸ʁ
    Ͱ΋͜ͷςʔϒϧఆٛɺखಈͰϙνϙνઃఆ͢ΔͷͰ
    ݩσʔλ͕ଟ͍ͱΊͪΌେมͳΜͰ͢💦

    View Slide

  26. ͦ͜Ͱొ৔ͨ͠ͷ͕ʂ

    View Slide

  27. υυυυʜ

    View Slide

  28. υυυυʜ

    View Slide

  29. υυυυʜ

    View Slide

  30. "84(MVF

    View Slide

  31. "84(MVFͱ͸ʁ
    खಈͰ"UIFOBͷςʔϒϧఆٛΛઃఆ͠ͳͯ͘΋
    4ΛࣗಈͰΫϩʔϧͯ͠%#Խͯ͘͠ΕΔʂ
    4όέοτ "UIFOB
    σʔλΧλϩά
    Ϋϩʔϥʔ
    (MVF

    View Slide

  32. ͦͷͨΊ"UIFOBར༻࣌͸
    4(MVF"UIFOBͷ૊Έ߹Θ͕ͤԦಓɻ
    4όέοτ "UIFOB
    σʔλΧλϩά
    Ϋϩʔϥʔ
    (MVF
    "84(MVFͱ͸ʁ

    View Slide

  33. (MVFͷ΋͏Ұͭͷػೳͱͯ͠&5-δϣϒ͕ར༻Մೳɻ
    σʔλม׵ͳͲΛαʔόʔϨεͰ࣮ߦͰ͖Δɻ
    "UIFOB
    σʔλΧλϩά
    Ϋϩʔϥʔ
    (MVF
    4όέοτ
    (MVF
    &5-δϣϒ
    $47
    • σʔλܗࣜΛม׵
    • ෆཁͳྻΛ࡟আ
    "84(MVFͱ͸ʁ
    4όέοτ
    1BSRVFU

    View Slide

  34. &5-δϣϒ͸؆қͳ΋ͷͳΒ1ZUIPOγΣϧɺ
    େن໛ͳॲཧ͸4QBSLʢ1ZUIPOPS4DBMBʣͰهड़Մೳɻ
    "UIFOB
    σʔλΧλϩά
    Ϋϩʔϥʔ
    (MVF
    4όέοτ
    (MVF
    &5-δϣϒ
    $47
    • σʔλܗࣜΛม׵
    • ෆཁͳྻΛ࡟আ
    "84(MVFͱ͸ʁ
    4όέοτ
    1BSRVFU

    View Slide

  35. ,$-67*5Ͱ͸$PTU&YQMPSFSͷݩσʔλʢ$63ˍ%#3ʣΛ
    &5-δϣϒͰ1BSRVFUܗࣜʹม׵ͯ͠·ͱΊͯ·͢ɻ
    "UIFOB
    σʔλΧλϩά
    Ϋϩʔϥʔ
    (MVF
    4όέοτ
    (MVF
    &5-δϣϒ
    $47
    1BSRVFU
    "84(MVFͱ͸ʁ
    4όέοτ
    1BSRVFU
    • ίετͱ࢖༻ঢ়گ
    Ϩϙʔτʢ$63ʣ
    • چɿ੥ٻ໌ࡉ
    Ϩϙʔτʢ%#3ʣ ෼ੳઐ༻ͷܗࣜʹͯ͠
    εϦϜԽˍίετ࡟ݮ

    View Slide

  36. ͜Μͳײ͡Ͱ༷ʑͳσʔλΛ
    ކʢHMVFʣͷΑ͏ʹܨ͗߹Θͤͯ͘ΕΔΜͰ͢ʂ
    "UIFOB
    σʔλΧλϩά
    Ϋϩʔϥʔ
    4όέοτ &5-δϣϒ
    $47
    1BSRVFU
    "84(MVFͱ͸ʁ
    (MVF
    (MVF
    4όέοτ
    1BSRVFU

    View Slide

  37. ϫʔΫϑϩʔػೳΛ࢖͑͹
    &5-δϣϒ΍ΫϩʔϥʔΛ
    4UFQ'VODUJPOTͷΑ͏ʹ
    (6*Ͱ૊Έ߹ΘͤΒΕΔ
    "84(MVFͱ͸ʁ

    View Slide

  38. "NB[PO2VJDL4JHIUͱ͸ʁ

    View Slide

  39. "NB[PO2VJDL4JHIUͱ͸ʁ
    ࠓݟ͖ͯͨ఺ηοτͰͷσʔλ෼ੳ͸
    ࣗ෼Ͱ42-Λॻ͖ɺ݁Ռ͸ςΩετͰग़ྗ͞ΕΔελΠϧɻ
    (MVF "UIFOB
    4
    • ച্ཤྺͷ$47
    • ঎඼Ϛελͷ&YDFM
    ઌ݄ͷച্૯ֹτοϓ
    ͷ঎඼໊Λग़ྗʂ

    View Slide

  40. "NB[PO2VJDL4JHIUͱ͸ʁ
    ϢʔεέʔεʹΑͬͯ͸ʮ42-Λॻ͘ͷ͕ϋʔυϧʯ΍
    ʮ݁ՌΛάϥϑͰද͍ࣔͨ͠ʯ͜ͱ΋͋Γɻ

    View Slide

  41. "NB[PO2VJDL4JHIUͱ͸ʁ
    ͦ͜Ͱศརͳͷ͕2VJDL4JHIUʂ
    (MVF "UIFOB
    4 2VJDL4JHIU

    View Slide

  42. "NB[PO2VJDL4JHIUͱ͸ʁ
    (6*Ͱ৚݅Λઃఆ͢Δ͚ͩͰάϥϑΛग़ྗͯ͘͠ΕΔɻ

    View Slide

  43. "NB[PO2VJDL4JHIUͱ͸ʁ
    ଞͷσʔλιʔεΛݩʹʮσʔληοτʯΛ࡞੒ɻ
    ͜ΕΛʮ෼ੳʯͰՄࢹԽ͠ɺμογϡϘʔυͱͯ͠ެ։Ͱ͖Δ
    (MVF "UIFOB
    4
    2VJDL4JHIU
    σʔλ
    ηοτ
    ෼ੳ μογϡ
    Ϙʔυ
    σʔλιʔε

    View Slide

  44. "NB[PO2VJDL4JHIUͱ͸ʁ
    σʔλιʔεʹ͸"UIFOB΍3%4ͳͲͷ"84Ϧιʔεͷଞɺ
    5XJUUFS΍4OPXGMBLFͳͲͷ֎෦4BB4ʹ΋ରԠɻ
    "UIFOB
    2VJDL4JHIU
    σʔλ
    ηοτ
    ෼ੳ μογϡ
    Ϙʔυ
    σʔλιʔεʢ෼ੳର৅ʣ
    3%4
    5XJUUFS
    4OPXGMBLF
    ˞΄͔ଟ਺ରԠ

    View Slide

  45. "84$%,ͱ͸ʁ

    View Slide

  46. $%,ͬͯͲΕ͚ͩͬͨͬʁ
    (MVF "UIFOB 2VJDL4JHIU
    $%,
    "84ΞΧ΢ϯτʢ,$-67*5ʣ
    4
    ֤"84ϦιʔεΛσϓϩΠ
    👉

    View Slide

  47. "84$%,ͱ͸ʁ
    ͍ΘΏΔ*B$ʢ*OGSBTUSVDUVSFBT$PEFʣπʔϧͷҰͭɻ

    View Slide

  48. "84$%,ͱ͸ʁ
    Ϋϥ΢υͷૢ࡞͸"1*ͰߦΘΕ͍ͯΔͨΊɺࣗಈԽ͕Մೳɻ
    Թ΋Γͷ͋ΔϚωίϯख࡞ۀΛଔۀͰ͖Δʂ

    View Slide

  49. "84$%,ͱ͸ʁ
    *B$πʔϧ͸SEύʔςΟ΋ؚΊ͍͔ͯͭ͋͘Γ·͢ɻ
    5FSSBGPSN $MPVE'PSNBUJPO $%,

    View Slide

  50. "84$%,ͱ͸ʁ
    5FSSBGPSN $MPVE'PSNBUJPO $%,
    SEπʔϧɻ
    "84Ҏ֎ʹ΋ରԠ
    "84ͷݩ૆*B$αʔϏεɻ
    ఆٛϑΝΠϧ෩ʹهड़͢Δ
    5ZQF4DSJQUͳͲͷݴޠͰ
    $'OςϯϓϨʔτΛੜ੒͢Δ
    ϥοϐϯά

    View Slide

  51. $'Oͱ$%,ͷߏ੒ཁૉ
    $MPVE'PSNBUJPO $%,
    ςϯϓϨʔτ
    ʢ+40/:".-ఆٛϑΝΠϧʣ
    ελοΫ
    ʢੜ੒͞ΕΔ"84Ϧιʔε܈ʣ
    • ྫɿ424ʴ-BNCEBʴ4
    ΞϓϦέʔγϣϯ
    ελοΫ
    ίϯετϥΫτʢྫɿ424ʴ-BNCEBʣ
    ίϯετϥΫτʢྫɿ4ʣ

    View Slide

  52. $'O WT$%,
    $MPVE'PSNBUJPO $%,
    ελοΫ
    ʢ௕ׂ͗ͯ͢Ѫʣ
    ΞϓϦέʔγϣϯ
    ελοΫ
    ʢίϯετϥΫτར༻ʣ
    ʴ

    View Slide

  53. ,$-67*5ͷίʔυྫ
    CJO
    MJC
    SFTPVSDFT
    HMVF
    MBNCEB
    ΞϓϦέʔγϣϯUT
    ελοΫUT
    ίϯετϥΫτUT
    ίϯετϥΫτUT
    &5-δϣϒQZ
    ϑΝϯΫγϣϯQZ
    ΠϯελϯεԽ
    ελοΫੜ੒
    Πϯϑϥ
    ʢ$%,ʣ
    ΞϓϦ
    $PEF$PNNJU
    ҰॹʹσϓϩΠ

    View Slide

  54. ࠷ॳ͔Β$%,ͰίʔυԽ͞Ε͍͓͔ͯͨ͛Ͱɺ
    ։ൃ؀ڥͷ૿ங͕͔ͳΓ؆ུԽͰ͖·ͨ͠ʂ

    View Slide

  55. ࠷ޙʹએ఻

    View Slide

  56. ,%%*ΞδϟΠϧ։ൃηϯλʔʢ,"(ʣઈࢍ࠾༻தʂ
    ϑϧϦϞʔτͳιϑτ΢ΣΞΤϯδχΞઈࢍืूͯ͠·͢👍

    View Slide

  57. དྷिܾணʂ2JJUBͰձࣾର߅͍͍ͶҐΛૂͬͯ·͢🔥
    RJJUBDPNPSHBOJ[BUJPOTLEEJBHJMF

    View Slide

  58. +"846(౦ژϦϒʔτ͠·͢💪
    ৽ελΠϧ͸ΦϯϥΠϯಛԽʂϑϦʔςʔϚͷϥϯνλΠϜ-5ձ

    View Slide