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

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

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

Redash Meetup 5.0.0 の登壇資料です

Takuya Arita

April 23, 2019
Tweet

More Decks by Takuya Arita

Other Decks in Programming

Transcript

  1. ͋ΒͨΊͯৼΓฦΔ

    ͷ࢖͍Ͳ͜Ζ
    Takuya Arita / @ariarijp

    View full-size slide

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

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

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

    ੵۃతʹ׆༻͍ͯ͠Δ

    View full-size slide

  3. Redash ʹ͍ͭͯ
    ৼΓฦΔ

    View full-size slide

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

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

    View full-size 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 full-size 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 full-size slide

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

    View full-size slide

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

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

    View full-size slide

  9. OSS ͔ͭɺ

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

    View full-size slide

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

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

    View full-size slide

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

    View full-size slide

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

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

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

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

    View full-size slide

  13. Hackable ͳ BI πʔϧ

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

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

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

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

    View full-size slide

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

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

    View full-size slide

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

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

    View full-size slide

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

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

    σʔλ෼ੳΛ Redash Ͱ Hack ͢Δ

    View full-size slide

  17. Happy Redash-ing !

    View full-size slide