Upgrade to Pro — share decks privately, control downloads, hide ads and more …

ジモティーでの Redash 利用事例

Ca32aad7fe21e4091b93d59c6cf71350?s=47 YOSHIDA Katsuhiko
February 20, 2018
Research
4
5k

ジモティーでの Redash 利用事例

Redash Meetup #1
https://redash-meetup.connpass.com/event/77681/
での発表スライド

Ca32aad7fe21e4091b93d59c6cf71350?s=128

YOSHIDA Katsuhiko

February 20, 2018
Tweet

More Decks by YOSHIDA Katsuhiko

See All by YOSHIDA Katsuhiko
Redash v5 アップデートピックアップ / Redash v5 Update Pick Up
Ca32aad7fe21e4091b93d59c6cf71350?s=48 kyoshidajp
0
2.6k
ec2spec の紹介 / Introduction of ec2spec
Ca32aad7fe21e4091b93d59c6cf71350?s=48 kyoshidajp
0
910
Visual Studio Code 機能拡張「VS Code TOSA」の紹介 / Introduction of Visual Studio Code extension "VS Code TOSA"
Ca32aad7fe21e4091b93d59c6cf71350?s=48 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)
6d667e747a4a1cda7d201c3358424257?s=48 digitalnaturegroup
0
810
アノテーションのバイアス排除に関する2020年代の研究動向
Cb3c74960f845f8309702eb95f7e2f2a?s=48 kuri8ive
1
470
組込み向けROS 2ノード実行環境の定量的評価 [ROBOMECH2022再演＋α]
91b03a57e0ef56fee59fbddc66a7f6fd?s=48 takasehideki
0
320
PLDI '21論文読み会: DNNFusion: Accelerating Deep Neural Networks Execution with Advanced Operator Fusion
5148cbb852e980b3b3d0e71d579ddbf8?s=48 ideininc
0
860
BigQueryとPythonではじめるプロ野球選手の成績予測（もしくは成績占い） / Baseball Player Performance Prediction using BigQuery and Python
2c0947c6a28e7f771ebd9859ecf54e5c?s=48 shinyorke
0
660
JGS594 Lecture 18
B546a9b97d993392e4b22b74b99b91fe?s=48 javiergs
PRO
0
360
第13回チャンピオンズミーティング・タウラス杯ラウンド2集計 / Umamusume Taurus 2022 Round2
9782dd351a8f1737d4ef02d839e821f9?s=48 kitachan_black
0
790
熊本都市交通リノベーション / 日本の公共交通 が ICT を真に活かすには 【 前編 】JCoMaaS 2022年3月研究会 ゲスト講演
E8f618bf29b36a046d01e235071b2ac3?s=48 trafficbrain
0
230
Generating a Pairwise Dataset for Click-through Rate Prediction of News Articles Considering Positions and Contents
B1cc148711c6a37a5c922b6e72a4ad52?s=48 upura
0
130
Structure of NLP Papers
1ce0216a2274827385dab9a066077d98?s=48 ukyh
2
130
ACTBE Inc. Company Deck FY2022
9bfa8572afa09a6feca3e6937fd16f81?s=48 actbeinc
0
300
再帰化への認知的転回/the-turn-to-recursive-system
Cd3d2cb2dadf5488935fe0ddaea7938a?s=48 monochromegane
0
190

Featured

See All Featured
Designing for Performance
245cee81a9c424266e5e401d844ea881?s=48 lara
597
63k
4 Signs Your Business is Dying
E4f5d494ebdc9e7cce1aecf3ce3e8bc1?s=48 shpigford
169
20k
JavaScript: Past, Present, and Future - NDC Porto 2020
3ab1249be442027903e1180025340b3f?s=48 reverentgeek
37
3.3k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
D8fc2580cfaca035f666d9e4ee79a7f7?s=48 mongodb
29
4.4k
What's new in Ruby 2.0
7edec06b5435e0dac07a353b2cc26253?s=48 geeforr
336
30k
It's Worth the Effort
Ba530e786553390f3fb271848485681c?s=48 3n
172
26k
Rebuilding a faster, lazier Slack
C0b42577cfc2b321be3474618107e933?s=48 samanthasiow
62
7.3k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
B3d6434763caa0ef5dc4b792662c49f7?s=48 smashingmag
237
19k
GraphQLの誤解/rethinking-graphql
3cb4e761dbdb7aebd1ffd85f752e1e3e?s=48 sonatard
31
6.8k
Facilitating Awesome Meetings
245cee81a9c424266e5e401d844ea881?s=48 lara
29
4.1k
Side Projects
027d1ebf66cc039a0bd3b55eeadbe75d?s=48 sachag
450
37k
JazzCon 2018 Closing Keynote - Leadership for the Reluctant Leader
3ab1249be442027903e1180025340b3f?s=48 reverentgeek
173
8.6k

Transcript

  1. 2018/02/20 #redashmeetup #1 δϞςΟʔͰͷRedashར༻ࣄྫ Katsuhiko YOSHIDA

  2. ࿩͢͜ͱ ✓ ࣗݾ঺հ ✓ ࣾ಺Ͱͷར༻౷ܭ ✓ ूܭ·ͰͷྲྀΕ ✓ ར༻ࣄྫ ✓

    ·ͱΊ

  3. ࿩͢͜ͱ ✓ ࣗݾ঺հ ✓ ࣾ಺Ͱͷར༻౷ܭ ✓ ूܭ·ͰͷྲྀΕ ✓ ར༻ࣄྫ ✓

    ·ͱΊ

  4. ٢ాউ඙ !LZPTIJEBLZPTIJEBKQ झຯɿτϨΠϧϥϯχϯάɾϚϥιϯ ॴଐɿגࣜձࣾδϞςΟʔ αʔόαΠυͱΠϯϑϥͷೋ౛ྲྀ
 Ͱ׆༂ʢ͍ͨ͠ʣ

  5. ࿩͢͜ͱ ✓ ࣗݾ঺հ ✓ ࣾ಺Ͱͷར༻౷ܭ ✓ ूܭ·ͰͷྲྀΕ ✓ ར༻ࣄྫ ✓

    ·ͱΊ

  6. ࣾ಺Ͱͷར༻౷ܭ Ϣʔβ਺ ໿  ΫΤϦ਺ ໿   ϝλσʔλ͕؆୯ʹ
 औಘͰ͖Δ

  7. ྫʣ"ENJOΛআ͍ͨΫΤϦ࣮ߦճ਺͕ଟ͍ϢʔβTOP10

  8. ࢓ࣄΛͨ͠ؾ෼ʹͳΕΔʢ͔΋ʣ

  9. ࿩͢͜ͱ ✓ ࣗݾ঺հ ✓ ࣾ಺Ͱͷར༻౷ܭ ✓ ूܭ·ͰͷྲྀΕ ✓ ར༻ࣄྫ ✓

    ·ͱΊ

  10. 2 1 3 4 5 6 ࣾ಺ Ϣʔβ Amazon Redshift

    Amazon Aurora

  11. ࿩͢͜ͱ ✓ ࣗݾ঺հ ✓ ࣾ಺Ͱͷར༻౷ܭ ✓ ूܭ·ͰͷྲྀΕ ✓ ར༻ࣄྫ ✓

    ·ͱΊ

  12. ΞΧ΢ϯτ؅ཧ ✓ ࠷ॳ͸"ENJOΞΧ΢ϯτΛڞ༗ ✓ (PPHMFೝূಋೖ Ϣʔβొ࿥ʴΞΧ΢ϯτ؅ཧ͠΍͘͢ͳͬͨ ✓ (PPHMFΞΧ΢ϯτͱηΩϡϦςΟʔά ϧʔϓ
 ʹΑΔΞΫηε੍ݶ

    ✓ ਃ੥͕͋Ε͹શһ͕σʔλʹΞΫηεͰ͖Δ

  13. ΞΧ΢ϯτΛ෼͚ͨޙͷϢʔβҰཡ ✓ ʢϝʔϧΞυϨεʹඥ͍ͮͨʣ
 Gravatarͷը૾͕
 ϓϩϑΟʔϧը૾ʹͳΔ ✓ ͩΕ΋ొ࿥͍ͯ͠ͳ͍ͷͰ
 ύοͱݟ

  14. (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

  15. 63-ϩά͔ΒݕࡧΩʔϫʔυநग़ 4MBDLͰ$4ϝϯόʔ͔ΒΤϯδχΞ΁࣭໰ʣ ʮ˓˓ͷϖʔδͰೖྗ͞Εͨݕࡧϫʔυ
 Λநग़͢Δ͜ͱ͸Ͱ͖ΔͷͰ͠ΐ͏͔ʁʯ ʮRedashΛ࢖͑͹Ͱ͖·͢ʂʯ

  16. ํ๏ͦͷ  ΞΫηεϩάͷ63-͔ΒΩʔϫʔυ෦෼
 ΛऔΓग़ͯ͠ू໿  $47&YDFMग़ྗPS"1*ܦ༝Ͱσʔλऔಘ  εΫϦϓτ౳Ͱ63-σίʔυʢඇ3FEBTIʣ ճ਺͕ଟ͍ͱखಈ࣮ߦ͕໘౗ɺ"1*Λୟ͍ͨΓ
 εΫϦϓτΛॻ͘࢓૊Έͮ͘Γʹ޻਺͕͔͔Δ

  17. ํ๏ͦͷ  ΞΫηεϩάͷ63-͔ΒΩʔϫʔυ෦෼
 ΛऔΓग़ͯ͠ू໿ʢͦͷͱಉ͡ʣ  #JH2VFSZϢʔβఆٛؔ਺Ͱ63-σίʔυ 3FEBTIͰ׬݁͢Δ͕σʔλιʔεʹ#JH2VFSZ
 ʢඪ४42-ʣΛ࢖͍ͬͯΔ৔߹ͷΈՄ

  18. ํ๏ͦͷ  ΞΫηεϩάͷ63-͔ΒΩʔϫʔυ෦෼
 ΛऔΓग़ͯ͠ू໿ʢͦͷɾͱಉ͡ʣ  ผͷΫΤϦͰɺͷ࣮ߦ݁Ռ
 Λࢀরɾ63-σίʔυͯ͠ग़ྗ͢Δ
 1ZUIPOσʔλιʔεʣ ࠷ॳʹू໿ͨ͠ΫΤϦ͸ͲͷσʔλιʔεͰ΋0,☺

  19. ࣾ಺RedashษڧձΛ࣮ࢪ ✓ ӡ༻΋يಓʹ৐͍ͬͯΔ
 λΠϛϯάͰ࣮ࢪ ✓ Redashಠࣗػೳͷ৘ใڞ༗ ✓ ಛʹύϥϝʔλػೳͷධ൑
 ͕ྑ͔ͬͨ

  20. ύϥϝʔλػೳͱ͸ʁ ✓ ΫΤϦͷதͰڞ௨ͷ஋Λఆٛɾࢀর͢Δࣄ
 ͕ग़དྷΔม਺ͷΑ͏ͳ࢓૊Έ ✓ ෳ਺ճಉ͡஋͕ࢀর͞ΕΔΫΤϦͰ࢖༻͢Δͱ
 ϛε͕ݮΔ✌

  21. มߋલ มߋޙ

  22. 'PSLͰύϥϝʔλ஋͕ফ͑Δ໰୊ ✓ Πν͔ΒΫΤϦΛॻ͘
 ͷ͸໘౗ ✓ 'PSLͰطଘΫΤϦ
 Λγϡͬͱίϐʔ ✓ 'PSL࣌ʹύϥϝʔλ஋
 ΋ίϐʔ͞ΕΔΑ͏ʹͨ͠

    Copy parameters when forking a query https://github.com/getredash/redash/pull/2068

  23. ౤ߘͷʮऔҾ͖৔ॴʯ • ౤ߘϢʔβ͸औҾ͖Λߦ͏৔ॴ
 Λࢦఆ • ࢢ۠܊͔Ӻ • ଞͷϢʔβ͸͜ͷ৘ใ
 Λ΋ͱʹݕࡧͰ͖Δ

  24. ˞਺஋͸αϯϓϧ

  25. ࿩͢͜ͱ ✓ ࣗݾ঺հ ✓ ࣾ಺Ͱͷར༻౷ܭ ✓ ूܭ·ͰͷྲྀΕ ✓ ར༻ࣄྫ ✓

    ·ͱΊ

  26. ·ͱΊ ✓ δϞςΟʔͰ͸ϩά෼ੳج൫ͷҰͭͱͯ͠
 RedashΛ࢖ͬͯ͞·͟·ͳ෼ੳΛ͍ͯ͠Δ ✓ 044ͳͷͰ
 ʮ͕͜͜ෆຬʯʮ͜͏ͳΕ͹ศརͳͷʹʯ
 ͱײͨ͡Β13Λૹ͍ͬͯΔ