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.1k
ジモティーでの 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
言語モデルの内部機序:解析と解釈
eumesy
PRO
49
18k
言語モデルによるAI創薬の進展 / Advancements in AI-Driven Drug Discovery Using Language Models
tsurubee
2
380
利用シーンを意識した推薦システム〜SpotifyとAmazonの事例から〜
kuri8ive
1
200
ノンパラメトリック分布表現を用いた位置尤度場周辺化によるRTK-GNSSの整数アンビギュイティ推定
aoki_nosse
0
320
SatCLIP: Global, General-Purpose Location Embeddings with Satellite Imagery
satai
3
220
Computational OT #4 - Gradient flow and diffusion models
gpeyre
0
300
[輪講] SigLIP 2: Multilingual Vision-Language Encoders with Improved Semantic Understanding, Localization, and Dense Features
nk35jk
2
530
(NULLCON Goa 2025)Windows Keylogger Detection: Targeting Past and Present Keylogging Techniques
asuna_jp
1
530
Type Theory as a Formal Basis of Natural Language Semantics
daikimatsuoka
1
220
EOGS: Gaussian Splatting for Efficient Satellite Image Photogrammetry
satai
4
270
SkySense : A Multi-Modal Remote Sensing Foundation Model Towards Universal Interpretation for Earth Observation Imagery
satai
3
250
実行環境に中立なWebAssemblyライブマイグレーション機構/techtalk-2025spring
chikuwait
0
230
Featured
See All Featured
Art, The Web, and Tiny UX
lynnandtonic
299
21k
Visualization
eitanlees
146
16k
KATA
mclloyd
30
14k
Typedesign – Prime Four
hannesfritz
42
2.7k
4 Signs Your Business is Dying
shpigford
184
22k
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
marktimemedia
31
2.4k
How STYLIGHT went responsive
nonsquared
100
5.6k
Faster Mobile Websites
deanohume
307
31k
Fight the Zombie Pattern Library - RWD Summit 2016
marcelosomers
233
17k
A Modern Web Designer's Workflow
chriscoyier
694
190k
Done Done
chrislema
184
16k
Embracing the Ebb and Flow
colly
86
4.7k
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Λૹ͍ͬͯΔ