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 の使いどころ / Why I strongly recom...
Search
Takuya Arita
April 23, 2019
Programming
1.3k
2
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
あらためて振り返る Redash の使いどころ / Why I strongly recommend Redash
Redash Meetup 5.0.0 の登壇資料です
Takuya Arita
April 23, 2019
Transcript
17 slides
͋ΒͨΊͯৼΓฦΔ ͷ͍Ͳ͜Ζ Takuya Arita / @ariarijp
ࣗݾհ • ariarijp / Takuya Arita / ༗ా࠸ • Redash
Meetup ओ࠵ / Redash Maintainer • גࣜձࣾϢχτʔϯͰ Facebook Twitter ͷ ࠂ API Λ༻ͨ͠ӡ༻πʔϧ։ൃੳج൫ ߏஙͳͲͷۀʹऔΓΉதͰɺRedash Λ ੵۃతʹ׆༻͍ͯ͠Δ
Redash ʹ͍ͭͯ ৼΓฦΔ
Redash ͱ • Arik Fraimovich ࢯ͕த৺ͱͳͬͯ։ൃ͍ͯ͠Δ OSS / SaaS ͷ
BI πʔϧ • ଟ͘ͷσʔλιʔεʹରԠ͠ɺάϥϑμογϡ ϘʔυʹΑΔσʔλՄࢹԽɺΫΤϦ݁Ռͷμϯ ϩʔυػೳͳͲΛఏڙ͍ͯ͠Δ • ຊࠃͰಋೖࣄྫɾ׆༻ࣄྫ͕ϒϩάͳͲͰଟ ͘ެ։͞Ε͍ͯΔ
ϦϦʔεͰৼΓฦΔ Redash ͷྺ࢙ • 2014/10: 0.4.0+b588 ϦϦʔε • 2016/5: 0.10.1+b1834
ϦϦʔε • 2017/4: 1.0.1 ϦϦʔε • 2017/8: 2.0.0 ϦϦʔε • 2017/11: 3.0.0 ϦϦʔε • 2018/4: 4.0.0 ϦϦʔε • 2018/9: 5.0.0 ϦϦʔε • 2018/12: 6.0.0 ϦϦʔε • 2019/3: 7.0.0 ϦϦʔε ͜ͷ͋ͨΓͰࠃͷར༻ऀ͕૿͑ͨҹ ࢀߟ: https://github.com/getredash/redash/releases
ࠃͷͰৼΓฦΔ Redash ͷྺ࢙ • 2015/9: re:dashษڧձ at IPROS ։࠵ •
ʮre:dash is awesomeʯεϥΠυެ։ • 2016/5:ʮσʔλΛҰՕॴʹूΊΔ͜ͱͰσʔλ׆༻ͷຽओԽ͕ਐΜͩʯهࣄެ։ • 2016/8: WEB+DB PRESS Vol.94 Ͱ Redash ʹݴٴ • OSS ʹΑΔσʔλੳج൫ͷߏங(0.10.0+b1836) • 2016/12: Rebuild ep145 Ͱ Redash ʹݴٴ • 2017/10: Software Design 2017/11߸ Ͱ Redash ʹݴٴ • ΤϯδχΞͤʹ͠ͳ͍σʔλੳͷج൫࡞Γ(2.0.0+b2990) Redash ͷීٴʹେ͖͘ӨڹΛ༩͑ͨ
Redash ͷʮྑ͞ʯΛ ৼΓฦΔ
Redash ͷྑ͞ • OSS ͔ͭɺWeb ϕʔε • ෳσʔλιʔεͷूܭΫΤϦΛ Ұݩతʹཧɾར༻Ͱ͖Δ •
Hackable ͳ BI πʔϧ
OSS ͔ͭɺ Web ϕʔεͰ͋Δ͜ͱͷྑ͞ • Web ϕʔεͰ͋ΔͨΊɺ୭Ͱ͑Δ • Web ϕʔεͰ͋ΔͨΊɺURL
ͰΫΤϦΛڞ༗Ͱ ͖Δ • Ϣʔβͷ੍ݶ͕ͳ͍ • SaaS ൛ಉ༷(σʔλιʔεͳͲͷ੍ݶ͋Γ)
ྑ͞Λ׆͔͍ͨ͠Ͳ͜Ζ • ϒϥβͱΞΧϯτ͕͋Ε୭Ͱ͑ΔͷͰɺ ΤϯδχΞҎ֎͕ SQL Λ৮ΕΒΕΔͱͯ͠ద͍ͯ͠Δ • ֤ΫΤϦͷ݁ՌͳͲ͕ URL ͰදݱͰ͖ΔͨΊ
Slack ͳͲ Ͱڞ༗͍͢͠ • ༗ঈπʔϧͰ͋Γ͕ͪͳϢʔβʔ୯Ґͷ՝͕ۚൃੜ͠ͳ ͍ͨΊɺϝϯόʔશһʹΞΧϯτΛ༩͢Δ͜ͱ͕Ͱ ͖Δ
ෳσʔλιʔεͷूܭΫΤϦΛ Ұݩతʹཧɾར༻Ͱ͖Δ͜ͱͷྑ͞ • ଟ͘ͷσʔλιʔεʹରԠ͍ͯ͠ΔͨΊɺ ଓͰ͖Εɺ͋ΒΏΔΫΤϦΛ Redash ͔Β ࣮ߦͰ͖Δ • ࢄ͕ͪ͠ͳूܭΫΤϦΛ
Redash ͰҰݩత ʹอଘɾڞ༗Ͱ͖Δ
ྑ͞Λ׆͔͍ͨ͠Ͳ͜Ζ • σʔλιʔε͝ͱʹπʔϧΛΓସ͑Δඞཁ͕ͳ͍ͨΊɺ Redash Ͱ౷ҰతʹσʔλΛૢ࡞Ͱ͖Δ • Redash ʹΫΤϦΛอଘ͢Δ͜ͱͰɺΤϯδχΞ ΞφϦετ͕ॻ͍ͨ SQL
Λ୭Ͱ࠶ར༻Ͱ͖Δ • ෳࡶͳूܭΫΤϦΛ Redash ্Ͱอଘ͢Δ͜ͱͰɺ ݸਓͷϊϋڞ༗Ͱ͖Δ
Hackable ͳ BI πʔϧ Ͱ͋Δ͜ͱͷྑ͞ • Redash ը໘͔Βૢ࡞Ͱ͖Δ ΄΅ͯ͢ͷػೳΛ API
͔Βૢ࡞Ͱ͖Δ • Python σʔλιʔεΫΤϦϥϯφʔ֦ுΛར༻͠ɺ SQL ͚ͩͰ࣮ݱͰ͖ͳ͍σʔλॲཧ͕Մೳ • OSS Ͱ͋ΔͨΊɺνʔϜӡ༻ʹ߹Θͤͯ ίʔυʹखΛೖΕΔ͜ͱͰ͖Δ
ྑ͞Λ׆͔͍ͨ͠ॴ • API Λར༻ͯ͠ɺSQL ͚ͩͰ࣮ݱ͠ʹ͍͘Α͏ ͳσʔλूܭɺՃϓϩάϥϜʹͤΔ͜ͱ ͰɺෳࡶʹͳΓ͕ͪͳΫΤϦΛ͋Δఔ୯७ԽͰ ͖Δ • API
͔ΒΫΤϦ݁ՌΛऔಘ͢Δ͜ͱͰɺ ॻ͖ग़͠ઌΛεϓϨουγʔτͳͲʹॻ͖ग़͢ͳ Ͳɺ͍উखΛ Hack ͢Δ
࠶ܝ: Redash ͷྑ͞ • OSS ͔ͭɺWeb ϕʔε • ෳσʔλιʔεͷूܭΫΤϦΛ Ұݩతʹཧɾར༻Ͱ͖Δ
• Hackable ͳ BI πʔϧ
·ͱΊ • Web ϕʔεΏ͑ʹɺ୭Ͱ͑Δ • Redash ʹΫΤϦΛू͢Δ͜ͱͰɺ ୭Ͱ͑ΔϝϦοτΛ࠷େԽ͢Δ • API
ͳͲΛ׆༻ͯ͠ɺָ͘͠ɺศརʹ σʔλੳΛ Redash Ͱ Hack ͢Δ
Happy Redash-ing !
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
PHP Data Structures
ariarijp
1
590
サーバー監視[自作]入門 / How to build monitoring system with Redash
ariarijp
0
780
Other Decks in Programming
See All in Programming
Ruby から Emacs を操作したい
phigasui
0
120
手の動かし方がわからなかった私が個人開発者になるまで
usagi0920_pochi
0
110
느린 네트워크와 저사양 디바이스 사용자를 위한 웹뷰 로딩 시간 개선기
kmkim
1
240
エージェントを使い続けるためのメタワーク / Meta-work for keeping using the agent
rkaga
6
2.3k
[DroidKnights 2026] Workflow AX: From Auto-Documented Policies to E2E Testing
raeminkang
0
580
クラウドゲーミングのパフォーマンス最適化に挑む / Cloud Gaming Performance Tuning
vivion
0
350
Engineering Biometric UX Across Android Versions | DroidKnights 2026
ryunen344
1
210
Vue.jsで作る空間解析アプリとCapacitorプラグインのData Bridge
hal_spidernight
1
170
Spec-Driven Development - Why Vaadin Is the Perfect Fit
simas
PRO
0
250
ビジネスロジックを堅牢に~Scala 3のドメインプリミティブ~
j5ik2o
0
190
baseline으로 마이그레이션, 리팩토링 안전하게 맡기기
fornewid
1
990
protojson における文字化けの扱い
kazuki1023
0
430
Featured
See All Featured
We Are The Robots
honzajavorek
0
450
Typedesign – Prime Four
hannesfritz
42
3.2k
XXLCSS - How to scale CSS and keep your sanity
sugarenia
250
1.3M
Easily Structure & Communicate Ideas using Wireframe
afnizarnur
194
17k
How GitHub (no longer) Works
holman
316
150k
Optimising Largest Contentful Paint
csswizardry
37
4k
So, you think you're a good person
axbom
PRO
2
2.3k
Imperfection Machines: The Place of Print at Facebook
scottboms
270
14k
HU Berlin: Industrial-Strength Natural Language Processing with spaCy and Prodigy
inesmontani
PRO
0
810
Discover your Explorer Soul
emna__ayadi
2
1.3k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
35
3.9k
A Modern Web Designer's Workflow
chriscoyier
699
190k