あらためて振り返る Redash の使いどころ / Why I strongly recommend Redash

Redash Meetup 5.0.0 の登壇資料です

Transcript

1. ͋ΒͨΊͯৼΓฦΔ

   ͷ࢖͍Ͳ͜Ζ
   Takuya Arita / @ariarijp
   

   View Slide

2. ࣗݾ঺հ
   • ariarijp / Takuya Arita / ༗ా୓࠸
   • Redash Meetup ओ࠵ / Redash Maintainer
   • גࣜձࣾϢχτʔϯͰ Facebook ΍ Twitter ͷ

   ޿ࠂ API Λ࢖༻ͨ͠ӡ༻πʔϧ։ൃ΍෼ੳج൫

   ߏஙͳͲͷۀ຿ʹऔΓ૊ΉதͰɺRedash Λ

   ੵۃతʹ׆༻͍ͯ͠Δ
   

   View Slide

3. Redash ʹ͍ͭͯ
   ৼΓฦΔ
   

   View Slide

4. Redash ͱ͸
   • Arik Fraimovich ࢯ͕த৺ͱͳͬͯ։ൃ͍ͯ͠Δ

   OSS / SaaS ͷ BI πʔϧ
   • ଟ͘ͷσʔλιʔεʹରԠ͠ɺάϥϑ΍μογϡ
   ϘʔυʹΑΔσʔλՄࢹԽ΍ɺΫΤϦ݁Ռͷμ΢ϯ
   ϩʔυػೳͳͲΛఏڙ͍ͯ͠Δ
   • ೔ຊࠃ಺Ͱ΋ಋೖࣄྫɾ׆༻ࣄྫ͕ϒϩάͳͲͰଟ
   ͘ެ։͞Ε͍ͯΔ
   

   View Slide

5. ϦϦʔεͰৼΓฦΔ

   Redash ͷྺ࢙
   • 2014/10: 0.4.0+b588 ϦϦʔε
   • 2016/5: 0.10.1+b1834 ϦϦʔε
   • 2017/4: 1.0.1 ϦϦʔε
   • 2017/8: 2.0.0 ϦϦʔε
   • 2017/11: 3.0.0 ϦϦʔε
   • 2018/4: 4.0.0 ϦϦʔε
   • 2018/9: 5.0.0 ϦϦʔε
   • 2018/12: 6.0.0 ϦϦʔε
   • 2019/3: 7.0.0 ϦϦʔε
   ͜ͷ͋ͨΓͰࠃ಺ͷར༻ऀ͕૿͑ͨҹ৅
   ࢀߟ: https://github.com/getredash/redash/releases
   

   View Slide

6. ࠃ಺ͷ࿩୊ͰৼΓฦΔ

   Redash ͷྺ࢙
   • 2015/9: re:dashษڧձ at IPROS ։࠵
   • ʮre:dash is awesomeʯεϥΠυެ։
   • 2016/5:ʮσʔλΛҰՕॴʹूΊΔ͜ͱͰσʔλ׆༻ͷຽओԽ͕ਐΜͩ࿩ʯهࣄެ։
   • 2016/8: WEB+DB PRESS Vol.94 Ͱ Redash ʹݴٴ
   • OSS ʹΑΔσʔλ෼ੳج൫ͷߏங(0.10.0+b1836)
   • 2016/12: Rebuild ep145 Ͱ Redash ʹݴٴ
   • 2017/10: Software Design 2017/11߸ Ͱ Redash ʹݴٴ
   • ΤϯδχΞ೚ͤʹ͠ͳ͍σʔλ෼ੳͷج൫࡞Γ(2.0.0+b2990)
   Redash ͷීٴʹେ͖͘ӨڹΛ༩͑ͨ
   

   View Slide

7. Redash ͷʮྑ͞ʯΛ
   ৼΓฦΔ
   

   View Slide

8. Redash ͷྑ͞
   • OSS ͔ͭɺWeb ϕʔε
   • ෳ਺σʔλιʔεͷूܭΫΤϦΛ

   Ұݩతʹ؅ཧɾར༻Ͱ͖Δ
   • Hackable ͳ BI πʔϧ
   

   View Slide

9. OSS ͔ͭɺ

   Web ϕʔεͰ͋Δ͜ͱͷྑ͞
   • Web ϕʔεͰ͋ΔͨΊɺ୭Ͱ΋࢖͑Δ
   • Web ϕʔεͰ͋ΔͨΊɺURL ͰΫΤϦΛڞ༗Ͱ
   ͖Δ
   • Ϣʔβ਺ͷ੍ݶ͕ͳ͍
   • SaaS ൛΋ಉ༷(σʔλιʔε਺ͳͲͷ੍ݶ͋Γ)
   

   View Slide

10. ྑ͞Λ׆͔ͨ͠࢖͍Ͳ͜Ζ
    • ϒϥ΢βͱΞΧ΢ϯτ͕͋Ε͹୭Ͱ΋࢖͑ΔͷͰɺ

    ΤϯδχΞҎ֎͕ SQL Λ৮ΕΒΕΔ৔ͱͯ͠ద͍ͯ͠Δ
    • ֤ΫΤϦͷ݁ՌͳͲ͕ URL ͰදݱͰ͖ΔͨΊ Slack ͳͲ
    Ͱڞ༗͠΍͍͢
    • ༗ঈπʔϧͰ͋Γ͕ͪͳϢʔβʔ୯Ґͷ՝͕ۚൃੜ͠ͳ
    ͍ͨΊɺϝϯόʔશһʹΞΧ΢ϯτΛ෇༩͢Δ͜ͱ͕Ͱ
    ͖Δ
    

    View Slide

11. ෳ਺σʔλιʔεͷूܭΫΤϦΛ
    Ұݩతʹ؅ཧɾར༻Ͱ͖Δ͜ͱͷྑ͞
    • ଟ͘ͷσʔλιʔεʹରԠ͍ͯ͠ΔͨΊɺ઀
    ଓͰ͖Ε͹ɺ͋ΒΏΔΫΤϦΛ Redash ͔Β
    ࣮ߦͰ͖Δ
    • ෼ࢄ͕ͪ͠ͳूܭΫΤϦΛ Redash ͰҰݩత
    ʹอଘɾڞ༗Ͱ͖Δ
    

    View Slide

12. ྑ͞Λ׆͔ͨ͠࢖͍Ͳ͜Ζ
    • σʔλιʔε͝ͱʹπʔϧΛ੾Γସ͑Δඞཁ͕ͳ͍ͨΊɺ

    Redash Ͱ౷ҰతʹσʔλΛૢ࡞Ͱ͖Δ
    • Redash ʹΫΤϦΛอଘ͢Δ͜ͱͰɺΤϯδχΞ΍

    ΞφϦετ͕ॻ͍ͨ SQL Λ୭Ͱ΋࠶ར༻Ͱ͖Δ
    • ෳࡶͳूܭΫΤϦΛ Redash ্Ͱอଘ͢Δ͜ͱͰɺ

    ݸਓͷϊ΢ϋ΢΋ڞ༗Ͱ͖Δ
    

    View Slide

13. Hackable ͳ BI πʔϧ

    Ͱ͋Δ͜ͱͷྑ͞
    • Redash ͸ը໘͔Βૢ࡞Ͱ͖Δ

    ΄΅͢΂ͯͷػೳΛ API ͔Β΋ૢ࡞Ͱ͖Δ
    • Python σʔλιʔε΍ΫΤϦϥϯφʔ֦ுΛར༻͠ɺ

    SQL ͚ͩͰ͸࣮ݱͰ͖ͳ͍σʔλॲཧ͕Մೳ
    • OSS Ͱ͋ΔͨΊɺνʔϜ΍ӡ༻ʹ߹Θͤͯ

    ίʔυʹखΛೖΕΔ͜ͱ΋Ͱ͖Δ
    

    View Slide

14. ྑ͞Λ׆͔ͨ͠࢖͍ॴ
    • API Λར༻ͯ͠ɺSQL ͚ͩͰ͸࣮ݱ͠ʹ͍͘Α͏
    ͳσʔλूܭɺՃ޻͸ϓϩάϥϜʹ೚ͤΔ͜ͱ
    ͰɺෳࡶʹͳΓ͕ͪͳΫΤϦΛ͋Δఔ౓୯७ԽͰ
    ͖Δ
    • API ͔ΒΫΤϦ݁ՌΛऔಘ͢Δ͜ͱͰɺ

    ॻ͖ग़͠ઌΛεϓϨουγʔτͳͲʹॻ͖ग़͢ͳ
    Ͳɺ࢖͍উखΛ Hack ͢Δ
    

    View Slide

15. ࠶ܝ: Redash ͷྑ͞
    • OSS ͔ͭɺWeb ϕʔε
    • ෳ਺σʔλιʔεͷूܭΫΤϦΛ

    Ұݩతʹ؅ཧɾར༻Ͱ͖Δ
    • Hackable ͳ BI πʔϧ
    

    View Slide

16. ·ͱΊ
    • Web ϕʔεΏ͑ʹɺ୭Ͱ΋࢖͑Δ
    • Redash ʹΫΤϦΛू໿͢Δ͜ͱͰɺ

    ୭Ͱ΋࢖͑ΔϝϦοτΛ࠷େԽ͢Δ
    • API ͳͲΛ׆༻ͯ͠ɺָ͘͠ɺศརʹ

    σʔλ෼ੳΛ Redash Ͱ Hack ͢Δ
    

    View Slide

17. Happy Redash-ing !
    

    View Slide