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

みんなが Redash を 気持ちよく使うやり方を 考える #redashmeetup

みんなが Redash を 気持ちよく使うやり方を 考える #redashmeetup

Redash Meetup 3.0.0 の発表資料です

hideki kinjyo
PRO

July 09, 2018
Tweet

More Decks by hideki kinjyo

Other Decks in Technology

Transcript

  1. ΈΜͳ͕3FEBTIΛ

    ؾ࣋ͪΑ͘࢖͏΍ΓํΛ

    ߟ͑Δ

    View Slide

  2. ࢲ͸ͩΕʁ
    w ͖Μ͡ΐ͏ͻͰ͖
    w αʔόʔαΠυ΍ͬͯ·͢
    w 1)1΍ͬͯ·͢
    w $POOFIJUPJOD
    w ΞΠίϯ͸ʮࡪ਌ࢠကʯͰ͢
    w ʮΊ͠԰ʯ!ࡳຈ

    View Slide

  3. ࠓ೔࿩͢͜ͱʙ

    View Slide

  4. 3FEBTIಋೖɺͷͪΐͬͱઌɻ

    View Slide

  5. 3FEBTIಋೖʂͭͷؾ࣋ͪɻ
    w ,*.0$)*ೖΕ͔ͨΒʹ͸ຊؾͰྲྀߦΒ͍ͤͨʂʂ
    w ,*.0$)*ޮ཰Αͯ͘ੜ࢈తͰ૑଄తͳσʔλ෼ੳ׆ಈͱ͸
    w ,*.0$)*೔ৗۀ຿ʹʮσʔλ෼ੳʯΛεοɾɾͱೖΕࠐΈ͍ͨ

    View Slide

  6. 3FEBTIಋೖޙ͋Δ͋Δ
    w ݁ہ42-͔͚Δਓ͕ݶΒΕͯΔɻΤϯδχΞ͕σʔλग़͢
    w ΫΤϦཚཱ໰୊
    w ʮΫΤϦʯʮΫΤϦͷίϐʔʯʮ৽͍͠ΫΤϦʯʮ৽͍͠ΫΤϦ

    ʯɾɾɾ
    w Ͳ͜ʹͲΜͳσʔλ͕͋ΔΜͰ͔͢ɺ஌Βͳ͍ʂ࢖͑ͳ͍ʂ

    View Slide

  7. ͓͠ͳ͕͖
    w ίωώτʹ͓͚Δʮ3FEBTIಋೖʯ
    w ಋೖ௚ޙʹߦͬͨ͜ͱ

    ʮͻͱ·ͣօ͕σʔλΛ৮ΔʯͨΊͷࢧԉࡦ
    w ಋೖޙ͠͹Βͯ͘͠ߦͬͨ͜ͱ

    ʮ૊৫తʹσʔλ෼ੳΛ׆༻͢ΔʯͨΊͷࢧԉࡦ

    View Slide

  8. ίωώτʹ͓͚Δ3FEBTIͷಋೖ

    View Slide

  9. 3FEBTINFFUVQWPM
    IUUQTTQFBLFSEFDLDPNTIPJDIJSPOEBUBESJWFO
    BOESFEBTI

    View Slide

  10. 3FEBTIͷಋೖظ
    w ηοτΞοϓ

    ʮαʔόʔཱͯ·ͨ͠ʂΞΫηεݖݶઃఆ͠·ͨ͠ʂʯ
    w ࣾ಺αʔϏεΠϯ

    શ෦ॺɾશྖҬΛର৅ʹɺر๬ࢀՃ੍Ͱ

    ʮ͸͡Ίͯͷ3FEBTIʯϋϯζΦϯ
    w ΞϑλʔέΞ

    4MBDLʹʮ෼ੳͳΜͰ΋࣭໰ͪΌΜͶΔʯΛ։ઃ

    View Slide

  11. σʔλυϦϒϯͳҙࢥܾఆΛࢧ͑ΔSFEBTI׆༻ࣄྫ

    !3FEBTINFFUVQWPM
    IUUQTTQFBLFSEFDLDPNTIPJDIJSPOEBUBESJWFOBOESFEBTI

    View Slide

  12. ʮ͸͡Ίͯͷ3FEBTIʯϋϯζΦϯ
    w ʮ࣮ࡍʹΫΤϦΛॻ͍ͯΈΔʯʮμογϡϘʔυΛ࡞ͬͯΈΔʯͱ͍
    ͏ωλͰ
    w LBLBLBLBLLVSFEBTIIBOETPO͕ΊͬͪΌ࠷ߴͳͷͰίϨΛࢀߟʹ
    ͭͭ͠ɾɾ
    w IUUQTHJUIVCDPNLBLBLBLBLLVSFEBTIIBOETPO
    w ͔ͤͬ͘ͷࣾ಺ษڧձͳͷͰɺ

    ࣗࣾαʔϏεΛ୊ࡐͱͯ͠਎ۙɾΠϝʔδ͠΍͍͢΋ͷʹɻ
    w ඇΤϯδχΞʹରͯ͠ɺ

    ʮΈΜͳͰू·ͬͯʯʮ࣮ࡍʹҰॹʹૢ࡞ͯ͠ΈΔʯ

    ͱ͍͏ͷ͸ྑ͔ͬͨؾ͕͢Δ

    View Slide

  13. ࣮ࡍʹϋϯζΦϯͰར༻͞ΕͨࢿྉͷҰ෦

    ʮίϐϖϨϕϧͰ0,ʯͳ΋ͷΛͭͬͯ͘ɺҰॹʹಈ͔͠
    ͨ

    View Slide

  14. 4MBDLʹʮ෼ੳͳΜͰ΋࣭໰ͪΌΜͶΔʯΛ։ઃ
    w 42-తͳҙຯͰͷ࣭໰Ͱ΋ɺαʔϏευϝΠϯͷ஌ࣝతͳҙຯͰͷ࣭
    ໰Ͱ΋ɺͻͱ·ͣʮ͜͜ʹ౤͛Ε͹͍͍ʯͱ͢Δ
    w 42-Λॻ͚ΔΤϯδχΞ΍ɺ

    ౰֘υϝΠϯͷ஌ࣝΛ࣋ͭਓ͕ؒࣗओతʹϝϯγϣϯΛर͏
    w ෳࡶͳ΋ͷ͸ޱ಄ͰϑΥϩʔͨ͠Γɺ୅ཧͰΫΤϦΛॻ͍ͨΓ΋
    w ·ͣ͸ࣾ಺ʹʮ3FEBTIͰग़དྷΔ͜ͱΛ૿΍͢ʯʮ৮ΔػձΛ૿
    ΍͢ʯงғؾΛ࡞Δ

    View Slide

  15. ʮ࣭໰ऀͱಉ͡νʔϜͷਓ͕౴͑Λग़ͤͦ͏ʯͱࢥͬͨΒɺ

    ࣗ෼Ͱ౴͑ͣʹ͋͑ͯৼͬͨΓ΋
    ʮ׆༻͢Δଆʯʮ౴͑ΔଆʯΛ͍͔ʹ૿΍ͤΔ͔ɻ

    View Slide

  16. ͦͷଞͷऔΓ૊Έ
    w ,1*ܥͷμογϡϘʔυ࡞੒ͷࢧԉ
    w ϓϩμΫτνʔϜͷεϓϦϯτʹ૊ΈࠐΜͰɺ

    ΤϯδχΞͷλεΫͱͯ͠औΓ૊Ή
    w ඇΤϯδχΞ σΟϨΫλʔ
    ޲͚ͷ42-ߨ࠲
    w ϦʔυΤϯδχΞ͕ࣗओతʹ։࠵ɺۀ຿࣌ؒ಺ʹ༗ࢤΛର৅ʹ࣮ࢪ
    w جૅߏจͷϨΫνϟʔͩͬͨΓɺ

    ࣋ͪدͬͨϢʔεέʔεʹԊͬͨ಺༰ͩͬͨΓ

    View Slide

  17. 3FEBTIಋೖͷৼΓฦΓ

    View Slide

  18. ʮ3FEBTIಋೖޙ͋Δ͋Δʯͷน
    w ΫΤϦཚཱ໰୊
    w ʮطʹ͋ΔΑ͏ͳΫΤϦʯΛɺࣗ෼Ͱ݁ہॻ͍ͯ͠·͏
    w σʔλιʔε΍εΩʔϚͷ஌ࣝ֨ࠩ
    w Ͳ͜ʹͲΜͳσʔλ͕͋ΔΜͰ͔͢ɺ஌Βͳ͍ʂ࢖͑ͳ͍
    w ฉ͔ͳ͍ͱॻ͚ͳ͍ฉ͘ͷԯ߷ॻ͔ͳ͍

    View Slide

  19. ͜ΕΒͷ໰୊͸Ͳ͏ʹ͔͍ͨ͠ɻ

    View Slide

  20. ͚Ͳɺ

    ͦͷલʹͪΐͬͱཱͪࢭ·ͬͯߟ͑Δɻ

    View Slide

  21. ͦ΋ͦ΋

    ʮΈΜͳͰ3FEBTIʯ͸

    Կ͕͍ͨ͠Μ͚ͩͬʁ

    View Slide

  22. ૊৫ʹ͓͚Δʮσʔλ׆༻ʯͷਐల
    ݸਓతʹߟ͑Δʮσʔλ׆༻ʯͷ౓߹͍͸ҎԼͷΑ͏ͳܗ
    σʔλʹࣗ༝ʹΞΫηεͰ͖Δ
    ؆୯ͳΫΤϦͳΒ
    ࣗ෼Ͱ࣮ߦͰ͖ΔɾσʔλΛҾ͖ग़ͤΔ
    ΍΍ߴ౓ͳΫΤϦ΋ɺॿ͚ΛआΓͳ͕Β࣮ߦͰ͖Δঢ়ଶ
    ඞཁͳσʔλ͸ʮ୭͔͕ॻ͍͍ͯΔʯঢ়ଶ
    ࡞੒͞Ε͍ͯΔσʔλ͔ΒֶͼΛಘΒΕΔঢ়ଶ

    View Slide

  23. σʔλʹࣗ༝ʹΞΫηεͰ͖Δ
    w ΠϯϑϥɺೝূೝՄͷ੔උ
    w ʮσʔλϕʔεʹରͯ͠ʯʮΫΤϦΛ࣮ߦͰ͖Δʯ؀ڥ
    w ίωώτͷ৔߹͸
    શ৬छର৅
    w ˞ΫϦςΟΧϧͳσʔλ΍ݸਓ৘ใ͸আ͘
    3FEBTIͷಋೖɾΞΧ΢ϯτͷൃߦ

    View Slide

  24. ؆୯ͳΫΤϦͳΒ
    ࣗ෼Ͱ࣮ߦͰ͖ΔɾσʔλΛҾ͖ग़ͤΔ
    w 42-ͷجૅจ๏Λཧղ͍ͯ͠Δ
    w ྫ͑͹ʮಛఆظؒͷ౤ߘ਺ $06/5
    ʯʮಛఆϢʔβʔͷ౤ߘҰཡʯ
    ͳͲ
    جૅతͳ਺஋ɾूܭͷͨΊʹ3FEBTIΛར༻͍ͯ͠Δ

    View Slide

  25. ΍΍ߴ౓ͳΫΤϦ΋ɺॿ͚ΛआΓͳ͕Β࣮ߦͰ͖Δঢ়ଶ
    w ʮͲ͜ʹͲΜͳσʔλ͕͋Δ͔ʯʹ͍ͭͯগͣͭ͠ཧղͰ͖͍ͯΔ
    w ʮΫΤϦ͕͋Ε͹Θ͔Γͦ͏ʯͱ͍͏ൃ૝͕਎ʹ͍͍ͭͯΔ
    w σʔλʹओମతͳڵຯΛ࣋ͬͯɺ֤ࣗͷ಺Ͱ՝୊ઃఆ͕Ͱ͖Δ
    ՝୊ղܾͷͨΊʹ3FEBTIΛར༻͍ͯ͠Δ

    View Slide

  26. ඞཁͳσʔλ͸ʮ୭͔͕ॻ͍͍ͯΔʯঢ়ଶ
    w ,1*΍ͦΕʹ४ͣΔσʔλͳͲɺ

    ʮΑ͘࢖͏ʯΑ͏ͳΫΤϦɾμογϡϘʔυ͕੔උ͞Ε͍ͯΔ
    w ʮطʹଘࡏ͢ΔʯσʔλΛɺ

    ࡞੒ͨ͠ຊਓҎ֎΋ൃݟͰ͖Δࣄ͕ॏཁ
    ೔ৗతͳۀ຿ͷઅʑʹ3FEBTI͕૊Έࠐ·Ε͍ͯΔ

    View Slide

  27. ࡞੒͞Ε͍ͯΔσʔλ͔ΒֶͼΛಘΒΕΔঢ়ଶ
    w ଞਓͷ࡞੒ͨ͠ΫΤϦɾμογϡϘʔυͷத͔Β

    ࣗ਎ʹؔ࿈͢Δ΋ͷΛੵۃతʹݟ͚ͭग़ͤΔঢ়ଶ
    w طଘͷσʔλ͔ΒࣔࠦΛಘͯɺ

    ΑΓ୳ࡧతͳσʔλ෼ੳ΍ϓϩμΫτ΁ͷϑΟʔυόοΫ
    σʔλ͔Βண૝ΛಘͯΞΠσΟΞ͕ੜ·Ε͍ͯΔ

    View Slide

  28. ʮ3FEBTI͋Δ͋Δʯͷ໰୊͸ɺ

    ૊৫ͷঢ়ଶʹԠͯ͡

    ଊ͑Δඞཁ͕͋Δؾ͕͢Δ

    View Slide

  29. ίωώτͷ৔߹ɾɾɾ
    w 3FEBTIʹ௚઀৮ΕΔ෦໳͕ɺଟذʹΘͨΔ
    w Ӧۀ ΧελϚʔαϙʔτ ϝσΟΞ ΞϓϦάϩʔε ϚʔέςΟϯά
    ΞϓϦاըFUDʜ
    w ͦΕͰ΋શମͷαΠζ͸͞΄Ͳେ͖͘ͳ͍
    w ࣮ࡍʹʮσʔλग़͠ʯΛͦ͠͏ͳͷ͸໊ఔ౓
    w ֤ྖҬͷαΠζ͕খ͍͞ɻେମʙ໊ఔ౓

    View Slide

  30. ίωώτͷ৔߹ɾɾɾ
    w ޲͖߹͍ͬͯΔ՝୊3FEBTIʹٻΊΔ৘ใ͕༷ʑ
    w ͳΜͱͳ͘શମͷ 42-౳ͷ
    Ϩϕϧײ͸೺ѲͰ͖Δ
    w ୭͔ਓʮ΍Δؾ͕͋Δਓʯ͕͍Ε͹໨͕ಧ͘αΠζ

    View Slide

  31. ՝୊
    w ͍·ͷͱ͜Ζɺ

    ʮ ؆୯ͳΫΤϦͳΒ
    ࣗ෼Ͱ࣮ߦͰ͖ΔɾσʔλΛҾ͖ग़ͤΔʯ͠ʮ΍
    ΍ߴ౓ͳΫΤϦʯ΋νϥϗϥॻ͘ਓ͕૿͍͑ͯΔঢ়ଶ
    w ࣍ʹ໨ࢦ͍ͨ͠ͷ͸ɺ

    ʮޮ཰తʹ3FEBTIΛ࢖͑Δʯʮଞਓͷࢿ࢈Λ΋ͬͱ׆͔ͤΔʯঢ়ଶ

    View Slide

  32. ʮಋೖޙ͋Δ͋Δʯͷ

    ΫΤϦཚཱ໰୊ΛͲ͏ʹ͔͍ͨ͠ʂ

    View Slide

  33. ͱ͍͏͔

    ʮ͜ΜͳΫΤϦͳ͍͔ͳʁʯΛ

    ͏·͘୳ͤͳ͍໰୊ʂʂ

    View Slide

  34. ΞΫγϣϯͷଧͪग़͠

    View Slide

  35. Ͳ͏ͨ͠ΒʮΫΤϦ͕ݟ͔ͭΔʯΑ͏ʹͳΔ͔ʁ
    w ݱঢ়࠶ೝࣝ
    w ͔ͳΓ޿͍ྖҬͰ3FEBTIʹ৮Ε͍ͯΔঢ়ଶ
    w ͦΕͧΕ͕খ͍͞νʔϜ
    w গͣͭ͠ʮߴ౓ͳ෼ੳʯʹ౿Έग़͍ͯ͠Δ
    ʮଞਓͷΫΤϦʯΛݟ͍ͨͱͨ͠Βɺ

    ਂ͘ڱ͘ͳχʔζ͕͋Γͦ͏

    View Slide

  36. ʮؔ৺ྖҬʯϕʔεͰɺ

    طଘͷΫΤϦΛݟ͚ͭ΍͘͢͠Α͏
    ͱ͍͏͜ͱͰɾɾɾ

    View Slide

  37. ΍ͬͨ͜ͱ
    w ໋໊نଇͷઃఆ
    w ΄΅
    ૊৫ମʹ߹க͢ΔܗͰɺ

    ΫΤϦɾμογϡϘʔυʹQSFpYΛࢦఆ
    w ʮࣗ෼ͷྖҬʯʹଐ͢ΔΫΤϦΛҾ͖ग़ͤΔΑ͏ʹ

    View Slide

  38. ΧςΰϦͷઃఆ
    ʮେʯʮதʯͷΧςΰϦΛ૊Έ߹Θͤͯར༻͢ΔΑ͏ʹɻ
    w େΧςΰϦɾɾαʔϏε΍෦ॺ͘Β͍ͷཻ౓
    w தΧςΰϦɾɾ෦ॺҎԼͷྖҬάϧʔϓ͘Β͍ͷཻ౓

    View Slide

  39. ֤ΧςΰϦ͝ͱͷΫΤϦҰཡ
    ໋໊نଇʹै͍ͬͯΔμογϡϘʔυ΍ΫΤϦ͸ɺ

    ʮΧςΰϦผʯʹҰཡԽͰ͖ΔΑ͏ʹ͢Δ

    View Slide

  40. μογϡϘʔυͷάϧʔϐϯά
    A1SFpY999Aͱ͍͏ܗͰɺࣗಈతʹάϧʔϐϯά͞ΕΔͷͰ

    ͦͷػೳΛར༻͢Δ

    View Slide

  41. ΫΤϦͷάϧʔϐϯά
    3FEBTIͷϝλςʔϒϧ RVFSJFT
    ʹରͯ͠ΫΤϦΛ࡞੒͠

    5BCMFͷઃஔ

    View Slide

  42. ؔ৺ྖҬ͝ͱͷάϧʔϐϯά͕࣮ݱʂ
    w ͦΕͧΕͷྖҬ͝ͱͷʮϙʔλϧʯ͕3FEBTI্ʹ࡞੒͞ΕΔ
    w ྫ͑͹ʮϝσΟΞɾฤूνʔϜʯͷ৔߹͸ɺ

    ʮ+1@&EJUPSJBMʯͷΫΤϦ΍ҰཡΛݟΔͱ

    ʮσʔλ͕ू·͍ͬͯΔʯঢ়ଶʹ
    w ·ͣ͸ʮσʔλ͕ἧ͍ͬͯΔʯঢ়ଶʹ͚͍ۙͮͯ͘

    View Slide

  43. ͋ͱ΋͏าʂ
    w ʮ໋໊نଇʯͷਁಁ͸େมͳͷͰ
    w ͻͱ·ͣ͸ɺ

    ਓྗͰʮ໨ʹ͍ͭͨΒ໊લΛ௚͢ʯӡ༻Λ͍ͯ͠·͢

    ʮӡ༻͢Δʯύϫʔ͕ඞཁɻ໘౗ष͕Βͳ͍ɻ
    w ਺͕ू·͖ͬͯͨΒʮάϧʔϐϯά͞Ε͍ͯΔࢫຯʯ͕ग़ͯ͘Δ͸ͣ
    w ࣍ୈʹਁಁ͍ͯ͘͠ͷͰ͸ɾɾɾ

    View Slide

  44. ͜Ε͕ɺ

    ίωώτͰʮ3FEBTIಋೖظʯΛܦͯ

    औΓ૊ΜͰ͍Δ͜ͱɻ

    View Slide

  45. ·ͱΊ
    w ܁Γฦ͠ʹͳΓ·͕͢

    σʔλͷʮ෼ੳʯʮ׆༻ʯʹ͍ͭͯ͸ɺ

    ૊৫΍ϑΣʔζʹԠ๊ͯ͑͡Δ՝୊͕ҟͳΓͦ͏
    w ͱ͸͍͑ɺ

    ʮΫΤϦཚཱʯͷΑ͏ͳ໰୊͸ڞ௨ͷ΋ͷͱͯ͠ଘࡏͦ͠͏
    w ද໘తʹରॲ͢ΔͷͰ͸ͳ͘ɺ

    ʮࣗ෼ͨͪͷ৔߹ɺͲ͏࢖͍͖͍͔ͬͯͨʯ͕େࣄͳͷͰ͸
    w 3FEBTIͷӡ༻ϊ΢ϋ΢͕΋ͬͱੈͷதʹग़ճͬͯ΄͍͠ɾɾʂ

    View Slide

  46. ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ
    ˒ΞΠίϯʹ͍ͭͯ
    ఆ৯Ί͠԰ ۏࣅఆ৯
    3FUUZ

    IUUQTSFUUZNFBSFB13&"3&
    46#

    View Slide

  47. ࢀߟ
    w 1BJSTͰͷ׆༻ྫ͔ΒֶͿSFEBTIಋೖͷ͢ʍΊr&VSFLB&OHJOFFSJOHr.FEJVN

    IUUQTNFEJVNDPNFVSFLBFOHJOFFSJOH⒎EBD
    w 3FEBTIͷ௕ظӡ༻Λݟਾ͑ͯΫΤϦͷ໊લ෇͚ʹ͍ͭͯߟ͑ΔBSJBSJKQ`TCMPH

    IUUQBSJBSJKQIBUFOBCMPHDPNFOUSZSFEBTIBEWFOUDBMFOEBSEBZ
    w 3FEBTIΛৄֶ͘͠΂Δʮ3FEBTIϋϯζΦϯࢿྉʯΛ࡞ͬͨLBLBLBLBLLV
    CMPH

    IUUQTLBLBLBLBLLVIBUFOBCMPHDPNFOUSZ
    w σʔλυϦϒϯͳҙࢥܾఆΛࢧ͑ΔSFEBTI׆༻ࣄྫ%BUBESJWFOBOESFEBTI
    4QFBLFS%FDL

    IUUQTTQFBLFSEFDLDPNTIPJDIJSPOEBUBESJWFOBOESFEBTI
    w 3FσʔλຽओԽͷ࣮ݱͱ3FEBTIʙΑΓσʔλΛ׆༻͢ΔͨΊͷ໋໊نଇΛͲ͏
    ͢Δ͔ʙίωώτ։ൃऀϒϩά

    IUUQUFDIDPOOFIJUPDPNFOUSZ

    View Slide