ジモティーでの Redash 利用事例
by
YOSHIDA Katsuhiko
Link
Embed
Share
Beginning
This slide
Copy link URL
Copy link URL
Copy iframe embed code
Copy iframe embed code
Copy javascript embed code
Copy javascript embed code
Share
Tweet
Share
Tweet
Slide 1
Slide 1 text
2018/02/20 #redashmeetup #1 δϞςΟʔͰͷRedashར༻ࣄྫ Katsuhiko YOSHIDA
Slide 2
Slide 2 text
͢͜ͱ ✓ ࣗݾհ ✓ ࣾͰͷར༻౷ܭ ✓ ूܭ·ͰͷྲྀΕ ✓ ར༻ࣄྫ ✓ ·ͱΊ
Slide 3
Slide 3 text
͢͜ͱ ✓ ࣗݾհ ✓ ࣾͰͷར༻౷ܭ ✓ ूܭ·ͰͷྲྀΕ ✓ ར༻ࣄྫ ✓ ·ͱΊ
Slide 4
Slide 4 text
٢ాউ !LZPTIJEBLZPTIJEBKQ झຯɿτϨΠϧϥϯχϯάɾϚϥιϯ ॴଐɿגࣜձࣾδϞςΟʔ αʔόαΠυͱΠϯϑϥͷೋྲྀ Ͱ׆༂ʢ͍ͨ͠ʣ
Slide 5
Slide 5 text
͢͜ͱ ✓ ࣗݾհ ✓ ࣾͰͷར༻౷ܭ ✓ ूܭ·ͰͷྲྀΕ ✓ ར༻ࣄྫ ✓ ·ͱΊ
Slide 6
Slide 6 text
ࣾͰͷར༻౷ܭ Ϣʔβ ΫΤϦ ϝλσʔλ͕؆୯ʹ औಘͰ͖Δ
Slide 7
Slide 7 text
ྫʣ"ENJOΛআ͍ͨΫΤϦ࣮ߦճ͕ଟ͍ϢʔβTOP10
Slide 8
Slide 8 text
ࣄΛͨ͠ؾʹͳΕΔʢ͔ʣ
Slide 9
Slide 9 text
͢͜ͱ ✓ ࣗݾհ ✓ ࣾͰͷར༻౷ܭ ✓ ूܭ·ͰͷྲྀΕ ✓ ར༻ࣄྫ ✓ ·ͱΊ
Slide 10
Slide 10 text
2 1 3 4 5 6 ࣾ Ϣʔβ Amazon Redshift Amazon Aurora
Slide 11
Slide 11 text
͢͜ͱ ✓ ࣗݾհ ✓ ࣾͰͷར༻౷ܭ ✓ ूܭ·ͰͷྲྀΕ ✓ ར༻ࣄྫ ✓ ·ͱΊ
Slide 12
Slide 12 text
ΞΧϯτཧ ✓ ࠷ॳ"ENJOΞΧϯτΛڞ༗ ✓ (PPHMFೝূಋೖ ϢʔβొʴΞΧϯτཧ͘͢͠ͳͬͨ ✓ (PPHMFΞΧϯτͱηΩϡϦςΟʔά ϧʔϓ ʹΑΔΞΫηε੍ݶ ✓ ਃ͕͋Εશһ͕σʔλʹΞΫηεͰ͖Δ
Slide 13
Slide 13 text
ΞΧϯτΛ͚ͨޙͷϢʔβҰཡ ✓ ʢϝʔϧΞυϨεʹඥ͍ͮͨʣ Gravatarͷը૾͕ ϓϩϑΟʔϧը૾ʹͳΔ ✓ ͩΕొ͍ͯ͠ͳ͍ͷͰ ύοͱݟ
Slide 14
Slide 14 text
(PPHMFϓϩϑΟʔϧը૾Λ໊લͷԣʹදࣔ͢Δ13 Show user's profile picture and load it from Google when using Google OAuth https://github.com/getredash/redash/pull/2096 v3.0.0 v4.0.0
Slide 15
Slide 15 text
63-ϩά͔ΒݕࡧΩʔϫʔυநग़ 4MBDLͰ$4ϝϯόʔ͔ΒΤϯδχΞ࣭ʣ ʮ˓˓ͷϖʔδͰೖྗ͞Εͨݕࡧϫʔυ Λநग़͢Δ͜ͱͰ͖ΔͷͰ͠ΐ͏͔ʁʯ ʮRedashΛ͑Ͱ͖·͢ʂʯ
Slide 16
Slide 16 text
ํ๏ͦͷ ΞΫηεϩάͷ63-͔ΒΩʔϫʔυ෦ ΛऔΓग़ͯ͠ू $47&YDFMग़ྗPS"1*ܦ༝Ͱσʔλऔಘ εΫϦϓτͰ63-σίʔυʢඇ3FEBTIʣ ճ͕ଟ͍ͱखಈ࣮ߦ͕໘ɺ"1*Λୟ͍ͨΓ εΫϦϓτΛॻ͘Έͮ͘Γʹ͕͔͔Δ
Slide 17
Slide 17 text
ํ๏ͦͷ ΞΫηεϩάͷ63-͔ΒΩʔϫʔυ෦ ΛऔΓग़ͯ͠ूʢͦͷͱಉ͡ʣ #JH2VFSZϢʔβఆٛؔͰ63-σίʔυ 3FEBTIͰ݁͢Δ͕σʔλιʔεʹ#JH2VFSZ ʢඪ४42-ʣΛ͍ͬͯΔ߹ͷΈՄ
Slide 18
Slide 18 text
ํ๏ͦͷ ΞΫηεϩάͷ63-͔ΒΩʔϫʔυ෦ ΛऔΓग़ͯ͠ूʢͦͷɾͱಉ͡ʣ ผͷΫΤϦͰɺͷ࣮ߦ݁Ռ Λࢀরɾ63-σίʔυͯ͠ग़ྗ͢Δ 1ZUIPOσʔλιʔεʣ ࠷ॳʹूͨ͠ΫΤϦͲͷσʔλιʔεͰ0,☺
Slide 19
Slide 19 text
ࣾRedashษڧձΛ࣮ࢪ ✓ ӡ༻يಓʹ͍ͬͯΔ λΠϛϯάͰ࣮ࢪ ✓ Redashಠࣗػೳͷใڞ༗ ✓ ಛʹύϥϝʔλػೳͷධ ͕ྑ͔ͬͨ
Slide 20
Slide 20 text
ύϥϝʔλػೳͱʁ ✓ ΫΤϦͷதͰڞ௨ͷΛఆٛɾࢀর͢Δࣄ ͕ग़དྷΔมͷΑ͏ͳΈ ✓ ෳճಉ͕͡ࢀর͞ΕΔΫΤϦͰ༻͢Δͱ ϛε͕ݮΔ✌
Slide 21
Slide 21 text
มߋલ มߋޙ
Slide 22
Slide 22 text
'PSLͰύϥϝʔλ͕ফ͑Δ ✓ Πν͔ΒΫΤϦΛॻ͘ ͷ໘ ✓ 'PSLͰطଘΫΤϦ Λγϡͬͱίϐʔ ✓ 'PSL࣌ʹύϥϝʔλ ίϐʔ͞ΕΔΑ͏ʹͨ͠ Copy parameters when forking a query https://github.com/getredash/redash/pull/2068
Slide 23
Slide 23 text
ߘͷʮऔҾ͖ॴʯ • ߘϢʔβऔҾ͖Λߦ͏ॴ Λࢦఆ • ࢢ۠܊͔Ӻ • ଞͷϢʔβ͜ͷใ ΛͱʹݕࡧͰ͖Δ
Slide 24
Slide 24 text
˞αϯϓϧ
Slide 25
Slide 25 text
͢͜ͱ ✓ ࣗݾհ ✓ ࣾͰͷར༻౷ܭ ✓ ूܭ·ͰͷྲྀΕ ✓ ར༻ࣄྫ ✓ ·ͱΊ
Slide 26
Slide 26 text
·ͱΊ ✓ δϞςΟʔͰϩάੳج൫ͷҰͭͱͯ͠ RedashΛͬͯ͞·͟·ͳੳΛ͍ͯ͠Δ ✓ 044ͳͷͰ ʮ͕͜͜ෆຬʯʮ͜͏ͳΕศརͳͷʹʯ ͱײͨ͡Β13Λૹ͍ͬͯΔ