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

by hideki kinjyo

Slide 1

Slide 1 text

ΈΜͳ͕3FEBTIΛ  ؾ࣋ͪΑ͘࢖͏΍ΓํΛ  ߟ͑Δ

Slide 2

Slide 2 text

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

Slide 3

Slide 3 text

ࠓ೔࿩͢͜ͱʙ

Slide 4

Slide 4 text

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

Slide 5

Slide 5 text

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

Slide 6

Slide 6 text

3FEBTIಋೖޙ͋Δ͋Δ w ݁ہ42-͔͚Δਓ͕ݶΒΕͯΔɻΤϯδχΞ͕σʔλग़͢ w ΫΤϦཚཱ໰୊ w ʮΫΤϦʯʮΫΤϦͷίϐʔʯʮ৽͍͠ΫΤϦʯʮ৽͍͠ΫΤϦ ʯɾɾɾ w Ͳ͜ʹͲΜͳσʔλ͕͋ΔΜͰ͔͢ɺ஌Βͳ͍ʂ࢖͑ͳ͍ʂ

Slide 7

Slide 7 text

͓͠ͳ͕͖ w ίωώτʹ͓͚Δʮ3FEBTIಋೖʯ w ಋೖ௚ޙʹߦͬͨ͜ͱ  ʮͻͱ·ͣօ͕σʔλΛ৮ΔʯͨΊͷࢧԉࡦ w ಋೖޙ͠͹Βͯ͘͠ߦͬͨ͜ͱ  ʮ૊৫తʹσʔλ෼ੳΛ׆༻͢ΔʯͨΊͷࢧԉࡦ

Slide 8

Slide 8 text

ίωώτʹ͓͚Δ3FEBTIͷಋೖ

Slide 9

Slide 9 text

3FEBTINFFUVQWPM IUUQTTQFBLFSEFDLDPNTIPJDIJSPOEBUBESJWFO BOESFEBTI

Slide 10

Slide 10 text

3FEBTIͷಋೖظ w ηοτΞοϓ  ʮαʔόʔཱͯ·ͨ͠ʂΞΫηεݖݶઃఆ͠·ͨ͠ʂʯ w ࣾ಺αʔϏεΠϯ  શ෦ॺɾશྖҬΛର৅ʹɺر๬ࢀՃ੍Ͱ  ʮ͸͡Ίͯͷ3FEBTIʯϋϯζΦϯ w ΞϑλʔέΞ  4MBDLʹʮ෼ੳͳΜͰ΋࣭໰ͪΌΜͶΔʯΛ։ઃ

Slide 11

Slide 11 text

σʔλυϦϒϯͳҙࢥܾఆΛࢧ͑ΔSFEBTI׆༻ࣄྫ  !3FEBTINFFUVQWPM IUUQTTQFBLFSEFDLDPNTIPJDIJSPOEBUBESJWFOBOESFEBTI

Slide 12

Slide 12 text

ʮ͸͡Ίͯͷ3FEBTIʯϋϯζΦϯ w ʮ࣮ࡍʹΫΤϦΛॻ͍ͯΈΔʯʮμογϡϘʔυΛ࡞ͬͯΈΔʯͱ͍ ͏ωλͰ w LBLBLBLBLLVSFEBTIIBOETPO͕ΊͬͪΌ࠷ߴͳͷͰίϨΛࢀߟʹ ͭͭ͠ɾɾ w IUUQTHJUIVCDPNLBLBLBLBLLVSFEBTIIBOETPO w ͔ͤͬ͘ͷࣾ಺ษڧձͳͷͰɺ  ࣗࣾαʔϏεΛ୊ࡐͱͯ͠਎ۙɾΠϝʔδ͠΍͍͢΋ͷʹɻ w ඇΤϯδχΞʹରͯ͠ɺ  ʮΈΜͳͰू·ͬͯʯʮ࣮ࡍʹҰॹʹૢ࡞ͯ͠ΈΔʯ  ͱ͍͏ͷ͸ྑ͔ͬͨؾ͕͢Δ

Slide 13

Slide 13 text

࣮ࡍʹϋϯζΦϯͰར༻͞ΕͨࢿྉͷҰ෦  ʮίϐϖϨϕϧͰ0,ʯͳ΋ͷΛͭͬͯ͘ɺҰॹʹಈ͔͠ ͨ

Slide 14

Slide 14 text

4MBDLʹʮ෼ੳͳΜͰ΋࣭໰ͪΌΜͶΔʯΛ։ઃ w 42-తͳҙຯͰͷ࣭໰Ͱ΋ɺαʔϏευϝΠϯͷ஌ࣝతͳҙຯͰͷ࣭ ໰Ͱ΋ɺͻͱ·ͣʮ͜͜ʹ౤͛Ε͹͍͍ʯͱ͢Δ w 42-Λॻ͚ΔΤϯδχΞ΍ɺ  ౰֘υϝΠϯͷ஌ࣝΛ࣋ͭਓ͕ؒࣗओతʹϝϯγϣϯΛर͏ w ෳࡶͳ΋ͷ͸ޱ಄ͰϑΥϩʔͨ͠Γɺ୅ཧͰΫΤϦΛॻ͍ͨΓ΋ w ·ͣ͸ࣾ಺ʹʮ3FEBTIͰग़དྷΔ͜ͱΛ૿΍͢ʯʮ৮ΔػձΛ૿ ΍͢ʯงғؾΛ࡞Δ

Slide 15

Slide 15 text

ʮ࣭໰ऀͱಉ͡νʔϜͷਓ͕౴͑Λग़ͤͦ͏ʯͱࢥͬͨΒɺ  ࣗ෼Ͱ౴͑ͣʹ͋͑ͯৼͬͨΓ΋ ʮ׆༻͢Δଆʯʮ౴͑ΔଆʯΛ͍͔ʹ૿΍ͤΔ͔ɻ

Slide 16

Slide 16 text

ͦͷଞͷऔΓ૊Έ w ,1*ܥͷμογϡϘʔυ࡞੒ͷࢧԉ w ϓϩμΫτνʔϜͷεϓϦϯτʹ૊ΈࠐΜͰɺ  ΤϯδχΞͷλεΫͱͯ͠औΓ૊Ή w ඇΤϯδχΞ σΟϨΫλʔ ޲͚ͷ42-ߨ࠲ w ϦʔυΤϯδχΞ͕ࣗओతʹ։࠵ɺۀ຿࣌ؒ಺ʹ༗ࢤΛର৅ʹ࣮ࢪ w جૅߏจͷϨΫνϟʔͩͬͨΓɺ  ࣋ͪدͬͨϢʔεέʔεʹԊͬͨ಺༰ͩͬͨΓ

Slide 17

Slide 17 text

3FEBTIಋೖͷৼΓฦΓ

Slide 18

Slide 18 text

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

Slide 19

Slide 19 text

͜ΕΒͷ໰୊͸Ͳ͏ʹ͔͍ͨ͠ɻ

Slide 20

Slide 20 text

͚Ͳɺ  ͦͷલʹͪΐͬͱཱͪࢭ·ͬͯߟ͑Δɻ

Slide 21

Slide 21 text

ͦ΋ͦ΋  ʮΈΜͳͰ3FEBTIʯ͸  Կ͕͍ͨ͠Μ͚ͩͬʁ

Slide 22

Slide 22 text

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

Slide 23

Slide 23 text

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

Slide 24

Slide 24 text

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

Slide 25

Slide 25 text

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

Slide 26

Slide 26 text

ඞཁͳσʔλ͸ʮ୭͔͕ॻ͍͍ͯΔʯঢ়ଶ w ,1*΍ͦΕʹ४ͣΔσʔλͳͲɺ  ʮΑ͘࢖͏ʯΑ͏ͳΫΤϦɾμογϡϘʔυ͕੔උ͞Ε͍ͯΔ w ʮطʹଘࡏ͢ΔʯσʔλΛɺ  ࡞੒ͨ͠ຊਓҎ֎΋ൃݟͰ͖Δࣄ͕ॏཁ ೔ৗతͳۀ຿ͷઅʑʹ3FEBTI͕૊Έࠐ·Ε͍ͯΔ

Slide 27

Slide 27 text

࡞੒͞Ε͍ͯΔσʔλ͔ΒֶͼΛಘΒΕΔঢ়ଶ w ଞਓͷ࡞੒ͨ͠ΫΤϦɾμογϡϘʔυͷத͔Β  ࣗ਎ʹؔ࿈͢Δ΋ͷΛੵۃతʹݟ͚ͭग़ͤΔঢ়ଶ w طଘͷσʔλ͔ΒࣔࠦΛಘͯɺ  ΑΓ୳ࡧతͳσʔλ෼ੳ΍ϓϩμΫτ΁ͷϑΟʔυόοΫ σʔλ͔Βண૝ΛಘͯΞΠσΟΞ͕ੜ·Ε͍ͯΔ

Slide 28

Slide 28 text

ʮ3FEBTI͋Δ͋Δʯͷ໰୊͸ɺ  ૊৫ͷঢ়ଶʹԠͯ͡  ଊ͑Δඞཁ͕͋Δؾ͕͢Δ

Slide 29

Slide 29 text

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

Slide 30

Slide 30 text

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

Slide 31

Slide 31 text

՝୊ w ͍·ͷͱ͜Ζɺ  ʮ ؆୯ͳΫΤϦͳΒ ࣗ෼Ͱ࣮ߦͰ͖ΔɾσʔλΛҾ͖ग़ͤΔʯ͠ʮ΍ ΍ߴ౓ͳΫΤϦʯ΋νϥϗϥॻ͘ਓ͕૿͍͑ͯΔঢ়ଶ w ࣍ʹ໨ࢦ͍ͨ͠ͷ͸ɺ  ʮޮ཰తʹ3FEBTIΛ࢖͑Δʯʮଞਓͷࢿ࢈Λ΋ͬͱ׆͔ͤΔʯঢ়ଶ

Slide 32

Slide 32 text

ʮಋೖޙ͋Δ͋Δʯͷ  ΫΤϦཚཱ໰୊ΛͲ͏ʹ͔͍ͨ͠ʂ

Slide 33

Slide 33 text

ͱ͍͏͔   ʮ͜ΜͳΫΤϦͳ͍͔ͳʁʯΛ  ͏·͘୳ͤͳ͍໰୊ʂʂ

Slide 34

Slide 34 text

ΞΫγϣϯͷଧͪग़͠

Slide 35

Slide 35 text

Ͳ͏ͨ͠ΒʮΫΤϦ͕ݟ͔ͭΔʯΑ͏ʹͳΔ͔ʁ w ݱঢ়࠶ೝࣝ w ͔ͳΓ޿͍ྖҬͰ3FEBTIʹ৮Ε͍ͯΔঢ়ଶ w ͦΕͧΕ͕খ͍͞νʔϜ w গͣͭ͠ʮߴ౓ͳ෼ੳʯʹ౿Έग़͍ͯ͠Δ ʮଞਓͷΫΤϦʯΛݟ͍ͨͱͨ͠Βɺ  ਂ͘ڱ͘ͳχʔζ͕͋Γͦ͏

Slide 36

Slide 36 text

ʮؔ৺ྖҬʯϕʔεͰɺ  طଘͷΫΤϦΛݟ͚ͭ΍͘͢͠Α͏ ͱ͍͏͜ͱͰɾɾɾ

Slide 37

Slide 37 text

΍ͬͨ͜ͱ w ໋໊نଇͷઃఆ w ΄΅ ૊৫ମʹ߹க͢ΔܗͰɺ  ΫΤϦɾμογϡϘʔυʹQSFpYΛࢦఆ w ʮࣗ෼ͷྖҬʯʹଐ͢ΔΫΤϦΛҾ͖ग़ͤΔΑ͏ʹ

Slide 38

Slide 38 text

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

Slide 39

Slide 39 text

֤ΧςΰϦ͝ͱͷΫΤϦҰཡ ໋໊نଇʹै͍ͬͯΔμογϡϘʔυ΍ΫΤϦ͸ɺ  ʮΧςΰϦผʯʹҰཡԽͰ͖ΔΑ͏ʹ͢Δ

Slide 40

Slide 40 text

μογϡϘʔυͷάϧʔϐϯά A1SFpY999Aͱ͍͏ܗͰɺࣗಈతʹάϧʔϐϯά͞ΕΔͷͰ  ͦͷػೳΛར༻͢Δ

Slide 41

Slide 41 text

ΫΤϦͷάϧʔϐϯά 3FEBTIͷϝλςʔϒϧ RVFSJFT ʹରͯ͠ΫΤϦΛ࡞੒͠  5BCMFͷઃஔ

Slide 42

Slide 42 text

ؔ৺ྖҬ͝ͱͷάϧʔϐϯά͕࣮ݱʂ w ͦΕͧΕͷྖҬ͝ͱͷʮϙʔλϧʯ͕3FEBTI্ʹ࡞੒͞ΕΔ w ྫ͑͹ʮϝσΟΞɾฤूνʔϜʯͷ৔߹͸ɺ  ʮ+1@&EJUPSJBMʯͷΫΤϦ΍ҰཡΛݟΔͱ  ʮσʔλ͕ू·͍ͬͯΔʯঢ়ଶʹ w ·ͣ͸ʮσʔλ͕ἧ͍ͬͯΔʯঢ়ଶʹ͚͍ۙͮͯ͘

Slide 43

Slide 43 text

͋ͱ΋͏าʂ w ʮ໋໊نଇʯͷਁಁ͸େมͳͷͰ w ͻͱ·ͣ͸ɺ  ਓྗͰʮ໨ʹ͍ͭͨΒ໊લΛ௚͢ʯӡ༻Λ͍ͯ͠·͢  ʮӡ༻͢Δʯύϫʔ͕ඞཁɻ໘౗ष͕Βͳ͍ɻ w ਺͕ू·͖ͬͯͨΒʮάϧʔϐϯά͞Ε͍ͯΔࢫຯʯ͕ग़ͯ͘Δ͸ͣ w ࣍ୈʹਁಁ͍ͯ͘͠ͷͰ͸ɾɾɾ

Slide 44

Slide 44 text

͜Ε͕ɺ  ίωώτͰʮ3FEBTIಋೖظʯΛܦͯ  औΓ૊ΜͰ͍Δ͜ͱɻ

Slide 45

Slide 45 text

·ͱΊ w ܁Γฦ͠ʹͳΓ·͕͢   σʔλͷʮ෼ੳʯʮ׆༻ʯʹ͍ͭͯ͸ɺ  ૊৫΍ϑΣʔζʹԠ๊ͯ͑͡Δ՝୊͕ҟͳΓͦ͏ w ͱ͸͍͑ɺ  ʮΫΤϦཚཱʯͷΑ͏ͳ໰୊͸ڞ௨ͷ΋ͷͱͯ͠ଘࡏͦ͠͏ w ද໘తʹରॲ͢ΔͷͰ͸ͳ͘ɺ  ʮࣗ෼ͨͪͷ৔߹ɺͲ͏࢖͍͖͍͔ͬͯͨʯ͕େࣄͳͷͰ͸ w 3FEBTIͷӡ༻ϊ΢ϋ΢͕΋ͬͱੈͷதʹग़ճͬͯ΄͍͠ɾɾʂ

Slide 46

Slide 46 text

͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ ˒ΞΠίϯʹ͍ͭͯ ఆ৯Ί͠԰ ۏࣅఆ৯ 3FUUZ  IUUQTSFUUZNFBSFB13&"3& 46#

Slide 47

Slide 47 text

ࢀߟ 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