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

Redash 導入・運用を4年ぐらいやって変わったこと・変わらなかったこと / Changed and unchanged things with Redash and me

Redash 導入・運用を4年ぐらいやって変わったこと・変わらなかったこと / Changed and unchanged things with Redash and me

吉祥寺.pm22【オンライン】の飛び込み LT

Takuya Arita

June 02, 2020
Tweet

More Decks by Takuya Arita

Other Decks in Technology

Transcript

  1. Redash ಋೖɾӡ༻Λ4೥͙Β͍΍ͬͯ
    มΘͬͨ͜ͱɾมΘΒͳ͔ͬͨ͜ͱ
    ٢঵ࣉ.pm22ʲΦϯϥΠϯʳ/ʮมΘͬͨ͜ͱɺมΘΒͳ͔ͬͨ͜ͱʯ
    @ariarijp / Takuya Arita

    View Slide

  2. ࣗݾ঺հ
    • @ariarijp / Takuya Arita / ༗ా ୓࠸
    • גࣜձࣾίίϥϒϧॴଐ(Redash ͷͳ͔ͷͻͱͰ͸͋Γ·ͤΜ)
    • ࣗଞͱ΋ʹೝΊΔ Redash ޷͖
    • Redash Meetup ओ࠵
    • getredash/redash ͷ Maintainer

    View Slide

  3. Redash ʹ͍ͭͯ
    • Arik Fraimovich ࢯ͕த৺ͱͳͬͯ։ൃ͍ͯ͠Δ BI πʔϧ
    • ࠷େͷಛ௃͸ʮΦʔϓϯιʔειϑτ΢ΣΞ(OSS)ʯͰ͋Δ͜ͱ
    • αʔόʔͷ؅ཧͳͲ͕ෆཁͳ SaaS ൛΋༗ঈͰఏڙ͞Ε͍ͯΔ
    • σʔλͷૢ࡞͸ɺ΄΅ྫ֎ͳ͘ SQL ͳͲͷΫΤϦʔݴޠΛ࢖༻͢Δ

    View Slide

  4. Redash ಋೖͰΑ͘ޠΒΕΔ͜ͱ
    • σʔλͷՄࢹԽʂຽओԽʂ
    • ΤϯδχΞҎ֎΋ SQL Λॻ͍ͯσʔλநग़ʂ
    • (Self-hosted ͢Ε͹)ແྉͰ੍ݶͳ͘୭Ͱ΋࢖͑Δʂ
    • (؀ڥʹΑͬͯ͸ӡ༻͕େมʂ)

    View Slide

  5. Redash Λ࢖ͬͯมΘͬͨ͜ͱ
    • σʔλͷՄࢹԽʂຽओԽʂ
    • ཉ͍࣌͠ʹཉ͍͠σʔλΛखʹೖΕΔ͜ͱ͕Ͱ͖ΔΑ͏ʹͳͬͨ
    • σʔλͷ૭ޱ͕ Redash ʹ·ͱ·ͬͨ
    • ΤϯδχΞҎ֎΋ SQL Ͱσʔλநग़ʂ
    • ΫΤϦύϥϝʔλػೳΛ࢖ͬͯɺूܭظؒͳͲ৚݅Λม͑ͨσʔλநग़΋ΤϯδχΞΛհͣ͞Ͱ͖Δ
    Α͏ʹͳͬͨ
    • OSS ͳͷͰ(Self-hosted ʹ͢Ε͹)ແྉͰ੍ݶͳ͘୭Ͱ΋࢖͑Δʂ
    • ԸܙΛϑϧʹ׆͔͍ͯ͠Δͭ΋Γ
    • ಋೖલΑΓ΋ OSS /ίϛϡχςΟ׆ಈʹੵۃతʹͳͬͨ

    View Slide

  6. Redash Λ࢖ͬͯมΘΒͳ͔ͬͨ͜ͱ
    • σʔλͷՄࢹԽʂຽओԽʂ
    • Visualization ͸΄΅࢖ͬͯͳ͍
    • ΤϯδχΞҎ֎΋ར༻͢Δ͕ɺΫΤϦʔͷ؅ཧ͸ΤϯδχΞΛத৺ʹूݖతʹ
    • Redash Λϑϧ׆༻͢ΔͨΊͷσʔλϚωδϝϯτ͕՝୊ͱͯ͠දग़
    • ΤϯδχΞҎ֎΋ SQL Λॻ͍ͯσʔλநग़ʂ
    • ಉ্ɻσʔλʹ͍ͭͯͷཧղΛਂΊΔ׆ಈͷҰ؀ͱͯ͠ SQL ษڧձ͸࣮ࢪͨ͜͠ͱ͕͋Δ
    • OSS ͳͷͰ(Self-hosted ʹ͢Ε͹)ແྉͰ੍ݶͳ͘୭Ͱ΋࢖͑Δʂ
    • ݟΔਓ͸ݟΔ͠ɺݟͳ͍ਓ͸ݟͳ͍

    View Slide

  7. ·ͱΊ
    • ಓ۩Λ૿΍ͨ͠Γม͑ͨΓ͢Δ͚ͩͰɺ໰୊͕ղܾ͞ΕΔΘ͚Ͱ΋ͳ
    ͍
    • ͦΕͰ΋ಓ۩Λʮࣗ෼ͷखͰ࣋ͬͯΈΔʯ͜ͱ͸େࣄͩͱࢥ͏
    • ޷͖ݏ͍ ߹͏߹Θͳ͍͸ ͋Δ͚ΕͲ Redashࢼ͠ʹ ৮ΕͯΈͯ
    (57577)

    View Slide