ジモティーでの Redash 利用事例

Redash Meetup #1
https://redash-meetup.connpass.com/event/77681/
での発表スライド

Transcript

1. 2018/02/20 #redashmeetup #1 δϞςΟʔͰͷRedashར༻ࣄྫ Katsuhiko YOSHIDA
2. ࿩͢͜ͱ ✓ ࣗݾ঺հ
   ✓ ࣾ಺Ͱͷར༻౷ܭ
   ✓ ूܭ·ͰͷྲྀΕ
   ✓ ར༻ࣄྫ
   ✓ ·ͱΊ
3. ࿩͢͜ͱ ✓ ࣗݾ঺հ
   ✓ ࣾ಺Ͱͷར༻౷ܭ
   ✓ ूܭ·ͰͷྲྀΕ
   ✓ ར༻ࣄྫ
   ✓ ·ͱΊ
4. ٢ా
   উ඙
   
   
   
   
   
   !LZPTIJEB
   
   
   
   
   
   
   
   
   
   LZPTIJEBKQ
   झຯɿτϨΠϧϥϯχϯάɾϚϥιϯ
   ॴଐɿגࣜձࣾδϞςΟʔ
   αʔόαΠυͱΠϯϑϥͷೋ౛ྲྀ
 Ͱ׆༂
   ʢ͍ͨ͠ʣ
5. ࿩͢͜ͱ ✓ ࣗݾ঺հ
   ✓ ࣾ಺Ͱͷར༻౷ܭ
   ✓ ूܭ·ͰͷྲྀΕ
   ✓ ར༻ࣄྫ
   ✓ ·ͱΊ
6. ࣾ಺Ͱͷར༻౷ܭ Ϣʔβ਺ ໿  ΫΤϦ਺ ໿   ϝλσʔλ͕؆୯ʹ
 औಘͰ͖Δ
7. ྫʣ"ENJOΛআ͍ͨΫΤϦ࣮ߦճ਺͕ଟ͍Ϣʔβ
   TOP10
8. ࢓ࣄΛͨ͠ؾ෼ʹͳΕΔʢ͔΋ʣ
9. ࿩͢͜ͱ ✓ ࣗݾ঺հ
   ✓ ࣾ಺Ͱͷར༻౷ܭ
   ✓ ूܭ·ͰͷྲྀΕ
   ✓ ར༻ࣄྫ
   ✓ ·ͱΊ
10. 2 1 3 4 5 6 ࣾ಺ Ϣʔβ Amazon Redshift Amazon Aurora
11. ࿩͢͜ͱ ✓ ࣗݾ঺հ
    ✓ ࣾ಺Ͱͷར༻౷ܭ
    ✓ ूܭ·ͰͷྲྀΕ
    ✓ ར༻ࣄྫ
    ✓ ·ͱΊ
12. ΞΧ΢ϯτ؅ཧ ✓ ࠷ॳ͸
    "ENJO
    ΞΧ΢ϯτΛڞ༗
    ✓ (PPHMF
    ೝূಋೖ
    Ϣʔβొ࿥ʴΞΧ΢ϯτ؅ཧ͠΍͘͢ͳͬͨ
    ✓ (PPHMF
    ΞΧ΢ϯτͱηΩϡϦςΟʔά ϧʔϓ
 ʹΑΔΞΫηε੍ݶ
    ✓ ਃ੥͕͋Ε͹શһ͕σʔλʹΞΫηεͰ͖Δ
13. ΞΧ΢ϯτΛ෼͚ͨޙͷϢʔβҰཡ ✓ ʢϝʔϧΞυϨεʹඥ͍ͮͨʣ
 Gravatarͷը૾͕
 ϓϩϑΟʔϧը૾ʹͳΔ
    ✓ ͩΕ΋ొ࿥͍ͯ͠ͳ͍ͷͰ
 ύοͱݟ
    
14. (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
15. 63-
    ϩά͔ΒݕࡧΩʔϫʔυநग़ 4MBDLͰ$4ϝϯόʔ͔ΒΤϯδχΞ΁࣭໰ʣ
    ʮ˓˓ͷϖʔδͰೖྗ͞Εͨݕࡧϫʔυ
 Λநग़͢Δ͜ͱ͸Ͱ͖ΔͷͰ͠ΐ͏͔ʁʯ
    ʮRedash
    Λ࢖͑͹Ͱ͖·͢ʂʯ
16. ํ๏ͦͷ  ΞΫηεϩάͷ63-͔ΒΩʔϫʔυ෦෼
 ΛऔΓग़ͯ͠ू໿
     $47&YDFMग़ྗ
    PS
    "1*
    ܦ༝Ͱσʔλऔಘ
     εΫϦϓτ౳Ͱ63-σίʔυʢඇ3FEBTIʣ ճ਺͕ଟ͍ͱखಈ࣮ߦ͕໘౗ɺ"1*
    Λୟ͍ͨΓ
 εΫϦϓτΛॻ͘࢓૊Έͮ͘Γʹ޻਺͕͔͔Δ
17. ํ๏ͦͷ  ΞΫηεϩάͷ63-͔ΒΩʔϫʔυ෦෼
 ΛऔΓग़ͯ͠ू໿ʢͦͷͱಉ͡ʣ
     #JH2VFSZϢʔβఆٛؔ਺Ͱ63-σίʔυ 3FEBTIͰ׬݁͢Δ͕σʔλιʔεʹ#JH2VFSZ
 ʢඪ४42-ʣΛ࢖͍ͬͯΔ৔߹ͷΈՄ
    
18. ํ๏ͦͷ  ΞΫηεϩάͷ63-͔ΒΩʔϫʔυ෦෼
 ΛऔΓग़ͯ͠ू໿ʢͦͷɾͱಉ͡ʣ
     ผͷΫΤϦͰɺͷ࣮ߦ݁Ռ
 Λࢀরɾ63-σίʔυͯ͠ग़ྗ͢Δ
 1ZUIPOσʔλιʔεʣ ࠷ॳʹू໿ͨ͠ΫΤϦ͸ͲͷσʔλιʔεͰ΋0,
    ☺
    
19. ࣾ಺RedashษڧձΛ࣮ࢪ ✓ ӡ༻΋يಓʹ৐͍ͬͯΔ
 λΠϛϯάͰ࣮ࢪ
    ✓ Redashಠࣗػೳͷ৘ใڞ༗
    ✓ ಛʹύϥϝʔλػೳͷධ൑
 ͕ྑ͔ͬͨ
20. ύϥϝʔλػೳͱ͸ʁ ✓ ΫΤϦͷதͰڞ௨ͷ஋Λఆٛɾࢀর͢Δࣄ
 ͕ग़དྷΔม਺ͷΑ͏ͳ࢓૊Έ
    ✓ ෳ਺ճಉ͡஋͕ࢀর͞ΕΔΫΤϦͰ࢖༻͢Δͱ
 ϛε͕ݮΔ✌
21. มߋલ มߋޙ
22. 'PSLͰύϥϝʔλ஋͕ফ͑Δ໰୊ ✓ Πν͔ΒΫΤϦΛॻ͘
 ͷ͸໘౗
    ✓ 'PSLͰطଘΫΤϦ
 Λγϡͬͱίϐʔ
    ✓ 'PSL࣌ʹύϥϝʔλ஋
 ΋ίϐʔ͞ΕΔΑ͏ʹͨ͠ Copy parameters when forking a query https://github.com/getredash/redash/pull/2068
23. ౤ߘͷʮऔҾ͖৔ॴʯ • ౤ߘϢʔβ͸औҾ͖Λߦ͏৔ॴ
 Λࢦఆ
    • ࢢ۠܊͔Ӻ
    • ଞͷϢʔβ͸͜ͷ৘ใ
 Λ΋ͱʹݕࡧͰ͖Δ
24. ˞਺஋͸αϯϓϧ
25. ࿩͢͜ͱ ✓ ࣗݾ঺հ
    ✓ ࣾ಺Ͱͷར༻౷ܭ
    ✓ ूܭ·ͰͷྲྀΕ
    ✓ ར༻ࣄྫ
    ✓ ·ͱΊ
26. ·ͱΊ ✓ δϞςΟʔͰ͸ϩά෼ੳج൫ͷҰͭͱͯ͠
 RedashΛ࢖ͬͯ͞·͟·ͳ෼ੳΛ͍ͯ͠Δ
    ✓ 044ͳͷͰ
 ʮ͕͜͜ෆຬʯʮ͜͏ͳΕ͹ศརͳͷʹ
    ʯ
 ͱײͨ͡Β13Λૹ͍ͬͯΔ