CUR×QuickSightをお客さん環境で実装しようとしたら色々つまづいた話

1. ଜদ঵ 2025/10/30 ଞࣾ؀ڥͰCUR×QuickSightΛ࣮૷ͨ͠Β৭ʑͭ·͍ͮͨ࿩
2. ଞࣾ؀ڥͰCUR×QuickSightΛ࣮૷ͨ͠Β৭ʑͭ·͍ͮͨ࿩ ໨࣍ 1. എܠͱঢ়گ 2. ݱঢ়೺ѲͱݪҼ֬ೝ 3. ղܾํ਑ 4. ऴΘΓʹ
3. ͸͡Ίʹ
4. ଞࣾ؀ڥͰCUR×QuickSightΛ࣮૷ͨ͠Β৭ʑͭ·͍ͮͨ࿩ ࣗݾ঺հ ໊લɿଜদ ঵ (ΉΒ·ͭ ͠ΐ͏) ೥࣍ɿ2021೥ೖࣾ (5೥໨) झຯɿυϥΠϒɺຑ੃ɺF1؍ઓɺ୤ग़ήʔϜ ࢓ࣄɿج൫αʔϏεͷఏڙ(SoEྖҬ)ɺΤϯδχΞҭ੒ͳͲ ͦͷଞɿ 2023 J a p a n AWS Jr.Ch a mpions 2024,25 J a p a n All Cert. Engineers 9ɿ!++N@TIBXO
5. ʮಉ͡AWS؀ڥͳͷʹɺ͏·͍͔͘ͳ͍ʯ
6. ଞࣾ؀ڥͰCUR×QuickSightΛ࣮૷ͨ͠Β৭ʑͭ·͍ͮͨ࿩ ͸͡Ίʹ ࠓճ͸͓٬༷؀ڥͰCUR×QuickSightߏஙΛࢧԉͨ࣌͠ʹɺ ʮٕज़ΑΓ΋ ” ؀ڥͷҧ͍ ” ͕࠷େͷఢͩͬͨʯ࿩Λ͠Α͏ͱࢥ͍·͢ɻ
7. ଞࣾ؀ڥͰCUR×QuickSightΛ࣮૷ͨ͠Β৭ʑͭ·͍ͮͨ࿩ ͸͡Ίʹ CUR is Կʁ CUR(Cost a nd Us a ge Report)ͷུͰɺAWSͷίετ࢖༻ঢ়گʹؔ͢Δ৘ใ͕ग़ྗ͞ΕͨϨϙʔτͰ͢ɻ Athen a ΍QucikSightͱ࿈ܞ͢Δ͜ͱͰɺσʔλ෼ੳ΍ՄࢹԽ͕ՄೳʹͳΔͨΊඇৗʹศརͩͬͨΓ͠·͢ɻ
8. 1.എܠͱঢ়گ
9. ଞࣾ؀ڥͰCUR×QuickSightΛ࣮૷ͨ͠Β৭ʑͭ·͍ͮͨ࿩ 1.1. എܠͱঢ়گ ʮ͓٬༷ͷAWSར༻ྉΛQuickSightͰݟ͑ΔԽ͢Δʯ ͱ͍͏Ҋ݅ʹϔϧϓཁҼͱͯ͠ࢀը͠·ͨ͠ɻ ϔϧϓͷཧ༝͸ʮࣗࣾ؀ڥͰ͸͏·͍͘͘ͷʹɺ͓٬༷؀ڥͩͱ͏·͍͔͘ͳ͍ʯ ͱ͍͏΋ͷͰͨ͠ɻ
10. ଞࣾ؀ڥͰCUR×QuickSightΛ࣮૷ͨ͠Β৭ʑͭ·͍ͮͨ࿩ 1.1. എܠͱঢ়گ https://github.com/ a ws-solutions-libr a ry-s a mples/cloud-intelligence-d a shbo a rds-fr a mework?t a b=re a dme-ov- f ile ΑΓҾ༻
11. ଞࣾ؀ڥͰCUR×QuickSightΛ࣮૷ͨ͠Β৭ʑͭ·͍ͮͨ࿩ 1.1. എܠͱঢ়گ https://github.com/ a ws-solutions-libr a ry-s a mples/cloud-intelligence-d a shbo a rds-fr a mework?t a b=re a dme-ov- f ile ΑΓҾ༻
12. 2.ݱঢ়೺ѲͱݪҼௐࠪ
13. ଞࣾ؀ڥͰCUR×QuickSightΛ࣮૷ͨ͠Β৭ʑͭ·͍ͮͨ࿩ 2.1. ݱঢ়೺ѲͱݪҼௐࠪ ʮ؀ڥࠩʯىҼͰ͋Δ͜ͱ͸΄΅֬ఆͳͷͰɺࠩ෼ΛੜΈग़͍ͯ͠Δ಺༰Λચ͍·͢ ɹɾσʔλܗࣜ͸ਖ਼͍͠΋ͷ͔ ɹɾS3ͷύε͸ਖ਼͍͠΋ͷΛࢦఆ͞Ε͍ͯΔ͔ ɹɾGlueͷCr a wler͸ͦ΋ͦ΋੒ޭ͍ͯ͠Δͷ͔ɹͳͲͳͲ…
14. ଞࣾ؀ڥͰCUR×QuickSightΛ࣮૷ͨ͠Β৭ʑͭ·͍ͮͨ࿩ 2.1. ݱঢ়೺ѲͱݪҼௐࠪ ௐ͍ࠪͯ͘͠ͱݪҼͱࢥΘΕΔՕॴ͕Θ͔͍͖ͬͯ·ͨ͠ɻ ࿈ܞ͞Εͯ͘Δσʔλͷதʹຊདྷଘࡏ͠ͳ͍͸ͣͷΧϥϜ͕਺ຊؚ·Ε͍ͯͨͷͰ͢ɻ
15. Ͳ͔͜Β͜ͷΧϥϜੜ͖͑ͯͨΜͩ…?
16. ଞࣾ؀ڥͰCUR×QuickSightΛ࣮૷ͨ͠Β৭ʑͭ·͍ͮͨ࿩ 2.1. ݱঢ়೺ѲͱݪҼௐࠪ https://github.com/ a ws-solutions-libr a ry-s a mples/cloud-intelligence-d a shbo a rds-fr a mework?t a b=re a dme-ov- f ile ΑΓҾ༻
17. ଞࣾ؀ڥͰCUR×QuickSightΛ࣮૷ͨ͠Β৭ʑͭ·͍ͮͨ࿩ 2.1. ݱঢ়೺ѲͱݪҼௐࠪ ͓٬༷ʹώΞϦϯάͯ͠ΈΔͱʮඞཁ͔ͩͬͨΒ଍ͨ͠ʯͱͷ͜ͱͰͨ͠… ࠓճͷ৔߹͸௥Ճ͞ΕͨΧϥϜ͕Athen a ͷύʔςΟγϣϯΩʔͱҰகͨͨ͠Ίɺ ΧϥϜͷॏෳΤϥʔ͕ൃੜ͍ͯ͠·ͨ͠ɻ
18. ଞࣾ؀ڥͰCUR×QuickSightΛ࣮૷ͨ͠Β৭ʑͭ·͍ͮͨ࿩ 2.1. ݱঢ়೺ѲͱݪҼௐࠪ CURͰ͸ ” source_ a ccount_id ”ͳͲͷ߲໨͕ɺσϑΥϧτͰఆΊΒΕ͍ͯ·͢ɻ ͜ͷ߲໨͕Athen a ͷύʔςΟγϣϯΩʔͱিಥ͠ɺॏෳͱ൑ఆ͞Ε͍ͯ·ͨ͠ɻ
19. 3.ղܾํ਑
20. ଞࣾ؀ڥͰCUR×QuickSightΛ࣮૷ͨ͠Β৭ʑͭ·͍ͮͨ࿩ 3.1. ղܾํ਑ ͻͱ·ͣɺҎԼͷํ਑ͰରԠΛ։࢝͠·ͨ͠ɻ ɹ - ΧϥϜ௥Ճ͕ຊ౰ʹඞཁͳͷ͔ʁ(໊લΛม͑Δ͜ͱ͸Ͱ͖ͳ͍ͷ͔ʁ) ɹ - ॏෳͱͳͬͨύʔςΟγϣϯΩʔͷ໊લΛมߋ͢Δ
21. ଞࣾ؀ڥͰCUR×QuickSightΛ࣮૷ͨ͠Β৭ʑͭ·͍ͮͨ࿩ 3.1. ղܾํ਑ ͓٬༷ଆͰ͸มߋ͕Ͱ͖ͳ͍ͱ͍͏͜ͱͩͬͨͷͰޙऀ͕࠾༻͞ΕͨͷͰ͕͢ɺ GitHubͷCloudForm a tionΛҰ෦վम͍ͯ͠ΔͷͰ೦ͷͨΊAWSαϙʔτʹ֬ೝɻ ɹˠ AWSαϙʔτΑΓʮ໰୊ͳ͍ʯͱͷճ౴Λडྖʂ
22. 4.ऴΘΓʹ
23. ଞࣾ؀ڥͰCUR×QuickSightΛ࣮૷ͨ͠Β৭ʑͭ·͍ͮͨ࿩ 4.1.ऴΘΓʹ ͜ͷखͷ͓࿩͸ ” ͋Δ͋Δ ” ͩͱࢥ͍·͢ɻ ʮ؀ڥࠩʯͷ໰୊͸ݪҼ͕͔ͳΓࠜਂ͍ͱ͜Ζʹ͋Δ࣌΋͋ΔͷͰɺ ʮ͓٬༷؀ڥͰࢼ͢ͱ͖͸ૣΊʹ࣮ݧ͓ͯ͘͠ʯ͜ͱ͕ॏཁͩͳͱࢥΘ͞Ε·ͨ͠ɻ
24. ଞࣾ؀ڥͰCUR×QuickSightΛ࣮૷ͨ͠Β৭ʑͭ·͍ͮͨ࿩ 4.1.ऴΘΓʹ ·ͨɺࠓճΈ͍ͨʹ͓٬༷ଆͰԿΒ͔ͷՃ޻Λ͍ͯ͠Δ৔߹͕͋ΔͷͰɺ ૬खͷ؀ڥͰߦΘΕ͍ͯΔॲཧ΋͋Δఔ౓ཧղ͓͔ͯ͠ͳ͍ͱ͍͚ͳ͔ͬͨΓ͠·͢ɻ