Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Sign up for free
Menu
Search
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Pricing
Search
Sign in
Sign up for free
一歩踏み込む Redash
Search
Sponsored
·
Your Podcast. Everywhere. Effortlessly.
Share. Educate. Inspire. Entertain. You do you. We'll handle the rest.
→
Takuya Arita
May 23, 2018
Technology
22k
10
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
一歩踏み込む Redash
Redash Meetup #2 の発表資料です #redashmeetup
Takuya Arita
May 23, 2018
Transcript
36 slides
Ұา౿ΈࠐΉ3FEBTI !BSJBSJKQ5BLVZB"SJUB
w ༗ా࠸ !BSJBSJKQ w גࣜձࣾϢχτʔϯॴଐ w ࠂ"1*Λར༻ͨ͠πʔϧ։ൃͱɺ 3FEBTIͳͲΛ༻͍ͨσʔλੳج൫ߏங͕ओͳࣄ w
ݕূظؒΛؚΊΔͱ͔Β3FEBTIΛۀͰ༻ ࣗݾհ
ຊͷൃදʹ͍ͭͯ w 3FEBTIΛӡ༻͍ͯ͠Δɺ·ͨ3FEBTIΛಋೖ͠Α͏ͱ͍ͯ͠Δɺ ΤϯδχΞ͚ͷ༰Ͱ͢ w 3FEBTIͷ͍ํɺ׆༻ࣄྫͳͲʹ͍͓ͭͯ͠·ͤΜ w ͍͔ͭ͘ͷτϐοΫʹ͔ΕͨΛ͢ΔͨΊɺશମͷ·ͱΊ͋Γ·ͤΜ
ΞδΣϯμ w 3FEBTIͷߏ w 3FEBTIͷΫΤϦ࣮ߦͷྲྀΕ w 3FEBTIͷϝλσʔλ w 3FEBTIͷཧը໘ w
3FEBTIͷ"1*
3FEBTIͷߏ
͓࣋ͪؼΓϙΠϯτ w 3FEBTIΛߏ͢ΔϛυϧΣΞΛΔ w 3FEBTIͷಋೖύλʔϯΛΔ
3FEBTIͷߏཁૉ w όοΫΤϯυ1ZUIPO্Ͱಈ࡞͢Δ'MBTL w ϑϩϯτΤϯυ"OHVMBS w ࢄλεΫΩϡʔ$FMFSZΛͬͨϫʔΧʔ w ΞυϗοΫͳΫΤϦΛॲཧ͢ΔΩϡʔ w
εέδϡʔϧ͞ΕͨॲཧΛ࣮ߦ͢ΔΩϡʔ
3FEBTIͷಈ࡞ڥ w 6CVOUV w ηοτΞοϓεΫϦϓτ͕ϦϙδτϦʹ͋Δ w ".*($&ͷΠϝʔδ6CVOUVͰߏங͞Ε͍ͯΔ w %PDLFS %PDLFS$PNQPTF
w SFEBTIͷϕʔεΠϝʔδVCVOUVYFOJBM w ݱߦͷ6CVOUVͷηοτΞοϓεΫϦϓτഇࢭ͞Εɺ6CVOUV্Ͱ %PDLFSΛϗετͱͯ͠ಈ࡞ͤ͞ΔεΫϦϓτʹҠߦ༧ఆ
3FEBTIΛߏ͢ΔϛυϧΣΞ w /HJOY w 8FCΞϓϦͷϦόʔεϓϩΩγ w 1PTUHSF42- w ཧใͷอ࣋ w
3FEJT w $FMFSZͷϝοηʔδϒϩʔΧ
3FEBTIΛߏ͢ΔϛυϧΣΞ w (VOJDPSO w 84(*αʔό w 4VQFSWJTPSE w ϓϩηεཧπʔϧɻ%PDLFSΛ͏߹ෆཁ
ߏΠϝʔδ /HJOY 3FEBTI1ZUIPO 1PTUHSF42- 3FEJT TFSWFS XPSLFS σʔλιʔε 6CVOUV
3FEBTIͷಋೖύλʔϯ w 6CVOUVͷηοτΞοϓεΫϦϓτΛͬͯ3FEBTIΛಋೖ w ʹΞϓϦέʔγϣϯɺϛυϧΣΞશ෦ೖΓͷߏ w 3FEBTIಋೖࡁΈͷ".*($&Πϝʔδ͔ΒΠϯελϯεΛ࡞ w ֤ϓϥοτϑΥʔϜͷ6CVOUVͷΠϝʔδʹηοτΞοϓεΫϦϓτΛద༻ͨ͠ͷ w
%PDLFS$PNQPTFΛͬͯಋೖ w ެࣜυΩϡϝϯτʹ։ൃ͚ͱͯ͠هࡌ͞Ε͍ͯΔ w ͦͷଞ
ΫΤϦ࣮ߦͷྲྀΕ
͓࣋ͪؼΓϙΠϯτ w ΫΤϦ࣮ߦͷྲྀΕΛΔ w ΫΤϦ͕٧·ͬͨ࣌ʹͲ͜Λ֬ೝ͢ΔͱΑ͍͔ɺύλʔϯΛΔ
/HJOY 3FEBTI1ZUIPO 1PTUHSF42- 3FEJT TFSWFS XPSLFS σʔλιʔε 6CVOUV ΫΤϦͲ͏࣮ͬͯߦ͞ΕΔ͔ʁ
/HJOY 3FEBTI1ZUIPO 1PTUHSF42- 3FEJT TFSWFS XPSLFS σʔλιʔε 6CVOUV Α͘٧·Δͱ͜Ζ ݁Ռ͕େ͖͗ͯ͢
ಡΈग़͕͠٧·Δ ݁Ռ͕େ͖͗ͯ͢సૹ࣌ؒ ϝϞϦΛѹഭͯ͠٧·Δ ݁Ռ͕େ͖͗ͯ͢ ॻ͖ࠐΈ͕٧·Δ ݁Ռ͕େ͖͗ͯ͢ ωοτϫʔΫ͕٧·Δ ΫΤϦ͕ॏͯ͘٧·Δ ࣮ߦ͞ΕΔΫΤϦ͕ଟ͘ ͕ͪൃੜͯ͠٧·Δ ݁Ռ͕େ͖͗ͯ͢ ϒϥβ͕མͪΔ
٧·Δͱ͜ΖΛͲ͏͢Δ͔ w ΫΤϦ͕͍ w ΫΤϦΛνϡʔχϯά͢Δ w σʔλιʔεͷεέʔϧΞοϓ#JH2VFSZͳͲͷ%8)ஔ͖͑ w ͍ΫΤϦΛλΠϜΞτͤ͞Δ w
3&%"4)@"%)0$@26&3:@5*.&@-*.*5Ͱը໘͔Βͷ࣮ߦͱϦϑ ϨογϡʹରԠͰ͖Δ w εέδϡʔϧ࣮ߦ্࣌هͷઃఆ͕ద༻͞Εͳ͍͜ͱʹҙ
٧·Δͱ͜ΖΛͲ͏͢Δ͔ w Ωϡʔͷॲཧͪ w ΩϡʔΛௐ͢Δ w ࣮ߦ݁Ռ͕େ͖͍ w ཁ݅ʹ͋Θͤͯ3FEBTIαʔόΛεέʔϧΞοϓ·ͨεέʔϧΞ τ
w খखઌͰͰ͖Δ͜ͱଟ͘ͳ͍
3FEBTIͷϝλσʔλ
͓࣋ͪؼΓϙΠϯτ w 3FEBTIͷϝλσʔλ͚ͬ͜͏ॏཁɻͱ͍͏͜ͱΛΔ w ӡ༻Ͱ͖߹͏͜ͱͷଟ͍ϝλσʔλΛΔ
3FEBTIͷϝλσʔλ w 3FEBTIͰɺϢʔβσʔλιʔεɺΫΤϦͳͲΛσʔλϕʔεʹอ ଘ͍ͯ͠Δ w ΫΤϦ݁Ռσʔλϕʔεʹอ࣋͞Ε͍ͯΔ w ϝλσʔλΛࢀর͢Δ͜ͱͰɺ3FEBTIͷར༻ঢ়گΛ֬ೝ͢Δ͜ͱͰ ͖Δ w
Α͘༻͞Ε͍ͯΔΫΤϦɺ༻͞Ε͍ͯͳ͍͚Ͳఆظ࣮ߦ͞Ε͍ͯΔ ΫΤϦɺ࣮ߦʹ͕͔͔͍࣌ؒͬͯΔΫΤϦͳͲ
3FEBTIͷϝλσʔλҰཡ w BDDFTT@QFSNJTTJPOT w BMFNCJD@WFSTJPO w BMFSU@TVCTDSJQUJPOT w BMFSUT w
BQJ@LFZT w DIBOHFT w EBTICPBSET w EBUB@TPVSDF@HSPVQT w EBUB@TPVSDFT w FWFOUT w HSPVQT w OPUJpDBUJPO@EFTUJOBUJPOT w PSHBOJ[BUJPOT w RVFSJFT w RVFSZ@SFTVMUT w RVFSZ@TOJQQFUT w VTFST w WJTVBMJ[BUJPOT w XJEHFUT
ӡ༻্͖߹͏3FEBTIͷϝλσʔλ w FWFOUT w ΫΤϦͷར༻ঢ়گΛ֬ೝ͢Δͱ͖ʹࢀর͢Δ w RVFSJFT w σʔλιʔε࡞ऀɺΫΤϦʹؚ·ΕΔจࣈྻͰΫΤϦΛ୳͢ͱ͖ʹࢀর ͢Δ
w RVFSZ@SFTVMUT w ͍ΫΤϦɺΑ࣮͘ߦ͞ΕΔΫΤϦΛ୳͢ͱ͖ʹࢀর͢Δ
ӡ༻্·͍͠3FEBTIͷϝλσʔλ w ແअؾʹRVFSZ@SFTVMUTςʔϒϧΛࢀরͯ͠QTRMͳͲͷ࣮ߦ݁Ռ͕େมͳ͜ͱʹͳΔ w 3FEBTI࣮ߦ݁ՌΛRVFSZ@SFTVMUTͷEBUBΧϥϜ 5&95ܕ ʹ+40/จࣈྻͱ͠ ͯอ࣋͢ΔͨΊɺෆ༻ҙʹ݁ՌΛදࣔͯ͠͠·͏ͱλʔϛφϧ͕େมͳ͜ͱʹͳΔ w RVFSZ@SFTVMUTςʔϒϧ͕ංେԽͯ͠3FEBTI͕Քಇ͍ͯ͠ΔαʔόͷσΟεΫΛṧഭ͢Δ
w ࣮ߦ݁ՌΛอ࣋͢ΔͨΊɺσʔλநग़ͷڥͱͯ͠3FEBTIΛ׆༻͢Δ߹ҙ͕ඞཁ w εύΠΫʹରԠͰ͖ͳ͍͕ɺڥมΛௐ͢Δ w 3&%"4)@26&3:@3&46-54@$-&"/61@$06/5 w 3&%"4)@26&3:@3&46-54@$-&"/61@."9@"(&
3FEBTIͷཧը໘
͓࣋ͪؼΓϙΠϯτ w ಛʹͳ͠
3FEBTIͷཧը໘ w BENJOʹજΜͰ͍ͯҙ֎ͱؾ͔ͮͳ͍ w BENJOάϧʔϓʹॴଐ͍ͯ͠ΔϢʔβʔ͚͕ͩར༻Մೳ w #PPUTUSBQͷૉͳσβΠϯͰɺૉͳػೳ͕ఏڙ͞Ε͍ͯΔ w ΠϕϯτΫΤϦ݁ՌͷϝλσʔλΛखؒͳ֬͘ೝ͍ͨ͠ͱ͖ʹศར w
มߋػೳ͋Δ͕ɺϚελσʔλΛฤू͢ΔͨΊɺͲ͏ͯ͠ඞཁͳ ߹Λআ͍ͯ͏ػձͳ͍
3FEBTIͷཧը໘ػೳҰཡ w ΫΤϦҰཡɾมߋɾআɾҰׅআ w ΫΤϦ݁ՌҰཡɾมߋɾআɾҰׅআ w μογϡϘʔυҰཡɾมߋɾআɾҰׅআ w ϏδϡΞϦθʔγϣϯҰཡɾ࡞ɾมߋɾআɾҰׅআ w
ΟδΣοτҰཡɾ࡞ɾมߋɾআɾҰׅআ w ΠϕϯτҰཡɾ࡞ɾมߋɾআɾҰׅআ w ΦʔΨχθʔγϣϯҰཡɾ࡞ɾมߋɾআɾҰׅআ w ར༻ঢ়گͷ֬ೝ
3FEBTIͷ"1*
͓࣋ͪؼΓϙΠϯτ w 3FEBTIͷ"1*Ͱૢ࡞Ͱ͖Δ͜ͱΛΔ w छྨͷΞΫηετʔΫϯͷଘࡏΛΔ w "1*ͷ͍ํΛΔͨΊͷํ๏ΛΔ w "1*ΫϥΠΞϯτͷଘࡏΛΔ
3FEBTIͷ"1* w 3FEBTIͰɺ΄΅ͯ͢ͷૢ࡞Λ"1*ܦ༝Ͱ࣮ߦͰ͖Δ w ΫΤϦ࣮ߦɺ݁Ռͷऔಘ͚ͩͰͳ͘ɺϢʔβใͷऔಘͳͲͰ͖Δ w ೝূΞΫηετʔΫϯΛ༻͢Δ w BQJ@LFZύϥϝʔλΛ͏ w
"VUIPSJ[BUJPOϔομΛ͏
छྨͷΞΫηετʔΫϯ w ΫΤϦΞΫηετʔΫϯ w ΫΤϦ͝ͱʹൃߦ͞ΕɺͦͷΫΤϦͷ݁ՌΛऔಘ͢Δ߹ͳͲʹɺϢʔ βΞΫηετʔΫϯΛඞཁͱͤͣʹ"1*ΛݺͿ͜ͱ͕Ͱ͖Δ w ϢʔβΞΫηετʔΫϯ w Ϣʔβ͝ͱʹൃߦ͞ΕɺϢʔβͷݖݶ࣍ୈͰΫΤϦͷ࣮ߦ͚ͩͰͳ͘ɺ
ΫΤϦͷ࡞ɺϢʔβใͷૢ࡞ͳͲͰ͖Δ
"1*υΩϡϝϯτͲ͜ʹ͋Δʁ w SFEBTIIBOEMFSTBQJQZΑΓॆ࣮ͨ͠ใͳ͍ w "1*ΤϯυϙΠϯτͷҰཡ͜ͷϑΝΠϧͰҰ௨ΓΘ͔Δ w ࣮ͷৄࡉ֤ΤϯυϙΠϯτͷ࣮Λ֬ೝ w ྫΫΤϦͷऔಘ w
ΤϯυϙΠϯτBQJRVFSJFTRVFSZ@JE w SFEBTIIBOEMFSTRVFSZQZͷ2VFSZ3FTPVSDFΛಡΉͱɺ(&5 1045%&-&5&ʹରԠ͢Δ"1*͕͋Δ͜ͱ͕Θ͔Δ
"1*ΫϥΠΞϯτ w ެࣜͷ"1*ΫϥΠΞϯτࠓͷͱ͜Ζͳ͍ w ϑΥʔϥϜͰ3FEBTIͷ։ൃऀ"SJLʹΑΔ·ͱΊ͕ެ։͞Ε͍ͯΔ w IUUQTEJTDVTTSFEBTIJPUTIBSFZPVSSFEBTISFMBUFE PQFOTPVSDFQSPKFDUT w 1ZUIPOɺ1)1ɺ/PEFKTɺ3VCZͳͲɺଟ͘ͷΫϥΠΞϯτ࣮͕͋Δ͕ɺ
ରԠ͍ͯ͠ΔػೳʹϥΠϒϥϦؒͰ͕ࠩ͋Δ w తʹ͋ͬͨϥΠϒϥϦΛݟ͔ͭΒͳ͍߹ɺ'PSL֦ͯ͠ுɺࣗલͰ։ൃ ͢ΔͳͲͷஅ͕ඞཁ
Ҏ্Ͱ͢ʂ
ࢀߟࢿྉ w 6CVOUV্Ͱ%PDLFSΛϗετͱͯ͠3FEBTIͷڥΛߏங͢ΔରԠΛਐΊ͍ͯ Δ1VMM3FRVFTU w IUUQTHJUIVCDPNHFUSFEBTISFEBTIQVMM w ڥมҰཡ w IUUQTSFEBTIJPIFMQPQFOTPVSDFBENJOHVJEFFOWWBST
TFUUJOHT w IUUQTRJJUBDPNLZPTIJEBKQJUFNTFDEFBGFGFEG w LZPTIJEB͞ΜʹΑΔຊޠهࣄ
More Decks by Takuya Arita
See All by Takuya Arita
Hosted Redash の EOL と移行ツール redash-migrate / You should know about Hosted Redash EOL and redash-migrate
ariarijp
0
3.4k
Redash で踏み出す BI 導入はじめの一歩 / DataEngineeringStudy Redash
ariarijp
1
2.8k
Redash のいま / Redash in 2021
ariarijp
2
1.2k
Redash 導入・運用を4年ぐらいやって変わったこと・変わらなかったこと / Changed and unchanged things with Redash and me
ariarijp
0
1.5k
5年前の自分に伝えたい広告 API 周辺の歩き方 / SOT Tech Night vol.1
ariarijp
1
570
使われていない、を知る / How do we know unused things in the real world?
ariarijp
0
490
MULTI_ORG について / What is MULTI_ORG in Redash
ariarijp
1
3.9k
あらためて振り返る Redash の使いどころ / Why I strongly recommend Redash
ariarijp
2
1.3k
PHP Data Structures
ariarijp
1
590
Other Decks in Technology
See All in Technology
BALLAS Technology Deck
ballas_inc
0
770
あの日、見つかっていなかったらどうなっていたか
kazzpapa3
2
230
Go初心者のクラウドエンジニアが、デプロイを通して旨味を知っていく話
ryudai
1
230
81天的 AI Agent 軟體開發團隊治理實務分享
regionbbs
0
180
SSFの現在地 ― CAEP/RISCからAI Identityへ
oidfj
0
460
閉域網でのAPI公開の選択肢全部比較!
takano0131
2
380
Re:ゼロから始めるシェアハウスのペットな鯖
silmin_
0
180
SREのためのFinOps入門
muziyoshiz
3
1.6k
Kiro 入門 (1 つのエージェントを、どの画面からでも) | 目指せ Kiro マスター 01
inariku
PRO
6
1.9k
Frontier Teams — Amazon は AI で「開発のやり方」をどう変えたのか
kmotohas
0
280
Quick Automate | 目指せ Quick マスター 12
inariku
PRO
1
120
Datadog の権限統制 〜Org 統合に向けて調べた注意点 / JDDUG-Meetup_24
visional_engineering_and_design
1
160
Featured
See All Featured
Agile Leadership in an Agile Organization
kimpetersen
PRO
0
310
Visual Storytelling: How to be a Superhuman Communicator
reverentgeek
2
750
A Modern Web Designer's Workflow
chriscoyier
699
190k
Collaborative Software Design: How to facilitate domain modelling decisions
baasie
1
380
Taking LLMs out of the black box: A practical guide to human-in-the-loop distillation
inesmontani
PRO
3
2.5k
Leadership Guide Workshop - DevTernity 2021
reverentgeek
1
430
Measuring & Analyzing Core Web Vitals
bluesmoon
9
1.1k
Automating Front-end Workflow
addyosmani
1370
210k
Beyond borders and beyond the search box: How to win the global "messy middle" with AI-driven SEO
davidcarrasco
3
300
Raft: Consensus for Rubyists
vanstee
143
7.9k
Six Lessons from altMBA
skipperchong
29
4.6k
We Are The Robots
honzajavorek
0
450