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

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

あらためて振り返る 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. ࣗݾ঺հ • ariarijp / Takuya Arita / ༗ా୓࠸ • Redash

    Meetup ओ࠵ / Redash Maintainer • גࣜձࣾϢχτʔϯͰ Facebook ΍ Twitter ͷ
 ޿ࠂ API Λ࢖༻ͨ͠ӡ༻πʔϧ։ൃ΍෼ੳج൫
 ߏஙͳͲͷۀ຿ʹऔΓ૊ΉதͰɺRedash Λ
 ੵۃతʹ׆༻͍ͯ͠Δ
  2. Redash ͱ͸ • Arik Fraimovich ࢯ͕த৺ͱͳͬͯ։ൃ͍ͯ͠Δ
 OSS / SaaS ͷ

    BI πʔϧ • ଟ͘ͷσʔλιʔεʹରԠ͠ɺάϥϑ΍μογϡ ϘʔυʹΑΔσʔλՄࢹԽ΍ɺΫΤϦ݁Ռͷμ΢ϯ ϩʔυػೳͳͲΛఏڙ͍ͯ͠Δ • ೔ຊࠃ಺Ͱ΋ಋೖࣄྫɾ׆༻ࣄྫ͕ϒϩάͳͲͰଟ ͘ެ։͞Ε͍ͯΔ
  3. ϦϦʔεͰৼΓฦΔ
 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
  4. ࠃ಺ͷ࿩୊ͰৼΓฦΔ
 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 ͷීٴʹେ͖͘ӨڹΛ༩͑ͨ
  5. OSS ͔ͭɺ
 Web ϕʔεͰ͋Δ͜ͱͷྑ͞ • Web ϕʔεͰ͋ΔͨΊɺ୭Ͱ΋࢖͑Δ • Web ϕʔεͰ͋ΔͨΊɺURL

    ͰΫΤϦΛڞ༗Ͱ ͖Δ • Ϣʔβ਺ͷ੍ݶ͕ͳ͍ • SaaS ൛΋ಉ༷(σʔλιʔε਺ͳͲͷ੍ݶ͋Γ)
  6. ྑ͞Λ׆͔ͨ͠࢖͍Ͳ͜Ζ • ϒϥ΢βͱΞΧ΢ϯτ͕͋Ε͹୭Ͱ΋࢖͑ΔͷͰɺ
 ΤϯδχΞҎ֎͕ SQL Λ৮ΕΒΕΔ৔ͱͯ͠ద͍ͯ͠Δ • ֤ΫΤϦͷ݁ՌͳͲ͕ URL ͰදݱͰ͖ΔͨΊ

    Slack ͳͲ Ͱڞ༗͠΍͍͢ • ༗ঈπʔϧͰ͋Γ͕ͪͳϢʔβʔ୯Ґͷ՝͕ۚൃੜ͠ͳ ͍ͨΊɺϝϯόʔશһʹΞΧ΢ϯτΛ෇༩͢Δ͜ͱ͕Ͱ ͖Δ
  7. Hackable ͳ BI πʔϧ
 Ͱ͋Δ͜ͱͷྑ͞ • Redash ͸ը໘͔Βૢ࡞Ͱ͖Δ
 ΄΅͢΂ͯͷػೳΛ API

    ͔Β΋ૢ࡞Ͱ͖Δ • Python σʔλιʔε΍ΫΤϦϥϯφʔ֦ுΛར༻͠ɺ
 SQL ͚ͩͰ͸࣮ݱͰ͖ͳ͍σʔλॲཧ͕Մೳ • OSS Ͱ͋ΔͨΊɺνʔϜ΍ӡ༻ʹ߹Θͤͯ
 ίʔυʹखΛೖΕΔ͜ͱ΋Ͱ͖Δ