Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
ジモティーでの Redash 利用事例
Search
YOSHIDA Katsuhiko
February 20, 2018
Research
4
6.2k
ジモティーでの 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
3.1k
ec2spec の紹介 / Introduction of ec2spec
kyoshidajp
0
1.1k
Visual Studio Code 機能拡張「VS Code TOSA」の紹介 / Introduction of Visual Studio Code extension "VS Code TOSA"
kyoshidajp
0
200
Other Decks in Research
See All in Research
引力・斥力を制御可能なランダム部分集合の確率分布
wasyro
0
270
[RSJ25] Enhancing VLA Performance in Understanding and Executing Free-form Instructions via Visual Prompt-based Paraphrasing
keio_smilab
PRO
0
150
PhD Defense 2025: Visual Understanding of Human Hands in Interactions
tkhkaeio
1
270
ウェブ・ソーシャルメディア論文読み会 第31回: The rising entropy of English in the attention economy. (Commun Psychology, 2024)
hkefka385
1
110
能動適応的実験計画
masakat0
2
880
A scalable, annual aboveground biomass product for monitoring carbon impacts of ecosystem restoration projects
satai
4
380
Remote sensing × Multi-modal meta survey
satai
4
520
Hiding What from Whom? A Critical Review of the History of Programming languages for Music
tomoyanonymous
0
210
Adaptive Experimental Design for Efficient Average Treatment Effect Estimation and Treatment Choice
masakat0
0
130
Stealing LUKS Keys via TPM and UUID Spoofing in 10 Minutes - BSides 2025
anykeyshik
0
150
日本語新聞記事を用いた大規模言語モデルの暗記定量化 / LLMC2025
upura
0
270
[CV勉強会@関東 CVPR2025] VLM自動運転model S4-Driver
shinkyoto
2
550
Featured
See All Featured
VelocityConf: Rendering Performance Case Studies
addyosmani
333
24k
GraphQLとの向き合い方2022年版
quramy
49
14k
The Invisible Side of Design
smashingmag
302
51k
Building Adaptive Systems
keathley
44
2.8k
ReactJS: Keep Simple. Everything can be a component!
pedronauck
667
130k
How GitHub (no longer) Works
holman
315
140k
Chrome DevTools: State of the Union 2024 - Debugging React & Beyond
addyosmani
9
930
Balancing Empowerment & Direction
lara
5
700
Speed Design
sergeychernyshev
32
1.2k
Into the Great Unknown - MozCon
thekraken
40
2.1k
Optimising Largest Contentful Paint
csswizardry
37
3.5k
Side Projects
sachag
455
43k
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Λૹ͍ͬͯΔ