Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Speaker Deck
PRO
Sign in
Sign up for free
ジモティーでの Redash 利用事例
YOSHIDA Katsuhiko
February 20, 2018
Research
4
5k
ジモティーでの Redash 利用事例
Redash Meetup #1
https://redash-meetup.connpass.com/event/77681/
での発表スライド
YOSHIDA Katsuhiko
February 20, 2018
Tweet
Share
More Decks by YOSHIDA Katsuhiko
See All by YOSHIDA Katsuhiko
Redash v5 アップデートピックアップ / Redash v5 Update Pick Up
kyoshidajp
0
2.6k
ec2spec の紹介 / Introduction of ec2spec
kyoshidajp
0
910
Visual Studio Code 機能拡張「VS Code TOSA」の紹介 / Introduction of Visual Studio Code extension "VS Code TOSA"
kyoshidajp
0
120
Other Decks in Research
See All in Research
See-Through Captions in a Museum Guided Tour: Exploring Museum Guided Tour for Deaf and Hard-of-Hearing People with Real-Time Captioning on Transparent Display ICCHP-AAATE 2022 #ICCHP_AAATE_22 (Oral presentation by Ippei Suzuki)
digitalnaturegroup
0
810
アノテーションのバイアス排除に関する2020年代の研究動向
kuri8ive
1
470
組込み向けROS 2ノード実行環境の定量的評価 [ROBOMECH2022再演+α]
takasehideki
0
320
PLDI '21論文読み会: DNNFusion: Accelerating Deep Neural Networks Execution with Advanced Operator Fusion
ideininc
0
860
BigQueryとPythonではじめるプロ野球選手の成績予測(もしくは成績占い) / Baseball Player Performance Prediction using BigQuery and Python
shinyorke
0
660
JGS594 Lecture 18
javiergs
PRO
0
360
第13回チャンピオンズミーティング・タウラス杯ラウンド2集計 / Umamusume Taurus 2022 Round2
kitachan_black
0
790
熊本都市交通リノベーション / 日本の公共交通 が ICT を真に活かすには 【 前編 】JCoMaaS 2022年3月研究会 ゲスト講演
trafficbrain
0
230
Generating a Pairwise Dataset for Click-through Rate Prediction of News Articles Considering Positions and Contents
upura
0
130
Structure of NLP Papers
ukyh
2
130
ACTBE Inc. Company Deck FY2022
actbeinc
0
300
再帰化への認知的転回/the-turn-to-recursive-system
monochromegane
0
190
Featured
See All Featured
Designing for Performance
lara
597
63k
4 Signs Your Business is Dying
shpigford
169
20k
JavaScript: Past, Present, and Future - NDC Porto 2020
reverentgeek
37
3.3k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
mongodb
29
4.4k
What's new in Ruby 2.0
geeforr
336
30k
It's Worth the Effort
3n
172
26k
Rebuilding a faster, lazier Slack
samanthasiow
62
7.3k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
237
19k
GraphQLの誤解/rethinking-graphql
sonatard
31
6.8k
Facilitating Awesome Meetings
lara
29
4.1k
Side Projects
sachag
450
37k
JazzCon 2018 Closing Keynote - Leadership for the Reluctant Leader
reverentgeek
173
8.6k
Transcript
2018/02/20 #redashmeetup #1 δϞςΟʔͰͷRedashར༻ࣄྫ Katsuhiko YOSHIDA
͢͜ͱ ✓ ࣗݾհ ✓ ࣾͰͷར༻౷ܭ ✓ ूܭ·ͰͷྲྀΕ ✓ ར༻ࣄྫ ✓
·ͱΊ
͢͜ͱ ✓ ࣗݾհ ✓ ࣾͰͷར༻౷ܭ ✓ ूܭ·ͰͷྲྀΕ ✓ ར༻ࣄྫ ✓
·ͱΊ
٢ాউ !LZPTIJEBLZPTIJEBKQ झຯɿτϨΠϧϥϯχϯάɾϚϥιϯ ॴଐɿגࣜձࣾδϞςΟʔ αʔόαΠυͱΠϯϑϥͷೋྲྀ Ͱ׆༂ʢ͍ͨ͠ʣ
͢͜ͱ ✓ ࣗݾհ ✓ ࣾͰͷར༻౷ܭ ✓ ूܭ·ͰͷྲྀΕ ✓ ར༻ࣄྫ ✓
·ͱΊ
ࣾͰͷར༻౷ܭ Ϣʔβ ΫΤϦ ϝλσʔλ͕؆୯ʹ औಘͰ͖Δ
ྫʣ"ENJOΛআ͍ͨΫΤϦ࣮ߦճ͕ଟ͍ϢʔβTOP10
ࣄΛͨ͠ؾʹͳΕΔʢ͔ʣ
͢͜ͱ ✓ ࣗݾհ ✓ ࣾͰͷར༻౷ܭ ✓ ूܭ·ͰͷྲྀΕ ✓ ར༻ࣄྫ ✓
·ͱΊ
2 1 3 4 5 6 ࣾ Ϣʔβ Amazon Redshift
Amazon Aurora
͢͜ͱ ✓ ࣗݾհ ✓ ࣾͰͷར༻౷ܭ ✓ ूܭ·ͰͷྲྀΕ ✓ ར༻ࣄྫ ✓
·ͱΊ
ΞΧϯτཧ ✓ ࠷ॳ"ENJOΞΧϯτΛڞ༗ ✓ (PPHMFೝূಋೖ ϢʔβొʴΞΧϯτཧ͘͢͠ͳͬͨ ✓ (PPHMFΞΧϯτͱηΩϡϦςΟʔά ϧʔϓ ʹΑΔΞΫηε੍ݶ
✓ ਃ͕͋Εશһ͕σʔλʹΞΫηεͰ͖Δ
ΞΧϯτΛ͚ͨޙͷϢʔβҰཡ ✓ ʢϝʔϧΞυϨεʹඥ͍ͮͨʣ Gravatarͷը૾͕ ϓϩϑΟʔϧը૾ʹͳΔ ✓ ͩΕొ͍ͯ͠ͳ͍ͷͰ ύοͱݟ
(PPHMFϓϩϑΟʔϧը૾Λ໊લͷԣʹදࣔ͢Δ13 Show user's profile picture and load it from Google
when using Google OAuth https://github.com/getredash/redash/pull/2096 v3.0.0 v4.0.0
63-ϩά͔ΒݕࡧΩʔϫʔυநग़ 4MBDLͰ$4ϝϯόʔ͔ΒΤϯδχΞ࣭ʣ ʮ˓˓ͷϖʔδͰೖྗ͞Εͨݕࡧϫʔυ Λநग़͢Δ͜ͱͰ͖ΔͷͰ͠ΐ͏͔ʁʯ ʮRedashΛ͑Ͱ͖·͢ʂʯ
ํ๏ͦͷ ΞΫηεϩάͷ63-͔ΒΩʔϫʔυ෦ ΛऔΓग़ͯ͠ू $47&YDFMग़ྗPS"1*ܦ༝Ͱσʔλऔಘ εΫϦϓτͰ63-σίʔυʢඇ3FEBTIʣ ճ͕ଟ͍ͱखಈ࣮ߦ͕໘ɺ"1*Λୟ͍ͨΓ εΫϦϓτΛॻ͘Έͮ͘Γʹ͕͔͔Δ
ํ๏ͦͷ ΞΫηεϩάͷ63-͔ΒΩʔϫʔυ෦ ΛऔΓग़ͯ͠ूʢͦͷͱಉ͡ʣ #JH2VFSZϢʔβఆٛؔͰ63-σίʔυ 3FEBTIͰ݁͢Δ͕σʔλιʔεʹ#JH2VFSZ ʢඪ४42-ʣΛ͍ͬͯΔ߹ͷΈՄ
ํ๏ͦͷ ΞΫηεϩάͷ63-͔ΒΩʔϫʔυ෦ ΛऔΓग़ͯ͠ूʢͦͷɾͱಉ͡ʣ ผͷΫΤϦͰɺͷ࣮ߦ݁Ռ Λࢀরɾ63-σίʔυͯ͠ग़ྗ͢Δ 1ZUIPOσʔλιʔεʣ ࠷ॳʹूͨ͠ΫΤϦͲͷσʔλιʔεͰ0,☺
ࣾRedashษڧձΛ࣮ࢪ ✓ ӡ༻يಓʹ͍ͬͯΔ λΠϛϯάͰ࣮ࢪ ✓ Redashಠࣗػೳͷใڞ༗ ✓ ಛʹύϥϝʔλػೳͷධ ͕ྑ͔ͬͨ
ύϥϝʔλػೳͱʁ ✓ ΫΤϦͷதͰڞ௨ͷΛఆٛɾࢀর͢Δࣄ ͕ग़དྷΔมͷΑ͏ͳΈ ✓ ෳճಉ͕͡ࢀর͞ΕΔΫΤϦͰ༻͢Δͱ ϛε͕ݮΔ✌
มߋલ มߋޙ
'PSLͰύϥϝʔλ͕ফ͑Δ ✓ Πν͔ΒΫΤϦΛॻ͘ ͷ໘ ✓ 'PSLͰطଘΫΤϦ Λγϡͬͱίϐʔ ✓ 'PSL࣌ʹύϥϝʔλ ίϐʔ͞ΕΔΑ͏ʹͨ͠
Copy parameters when forking a query https://github.com/getredash/redash/pull/2068
ߘͷʮऔҾ͖ॴʯ • ߘϢʔβऔҾ͖Λߦ͏ॴ Λࢦఆ • ࢢ۠܊͔Ӻ • ଞͷϢʔβ͜ͷใ ΛͱʹݕࡧͰ͖Δ
˞αϯϓϧ
͢͜ͱ ✓ ࣗݾհ ✓ ࣾͰͷར༻౷ܭ ✓ ूܭ·ͰͷྲྀΕ ✓ ར༻ࣄྫ ✓
·ͱΊ
·ͱΊ ✓ δϞςΟʔͰϩάੳج൫ͷҰͭͱͯ͠ RedashΛͬͯ͞·͟·ͳੳΛ͍ͯ͠Δ ✓ 044ͳͷͰ ʮ͕͜͜ෆຬʯʮ͜͏ͳΕศརͳͷʹʯ ͱײͨ͡Β13Λૹ͍ͬͯΔ