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

Redash Meetup 3.0.0 の発表資料です

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