トレタのGoogle Apps Script / BigQuery活用術

ビデオ: https://www.youtube.com/watch?v=FD4cfwOboeE&feature=youtu.be

gcp ja night #29 http://gcpja.connpass.com/event/9647/ で発表した資料。

Transcript

1. τϨλͷBigQuery

   Google Apps Script׆༻ज़
   Toreta, Inc. Yuichiro MASUI
   

   View Slide

2. View Slide

3. τϨλͷαʔόߏ੒
   • αʔόଆ͸Rails
   • EngineYard + AWS
   • ࣾ಺ͰJenkins
   • ࣾ಺αʔϏε͸heroku
   • ؂ࢹ͸Pingdom+PagerDuty
   http://toreta.blog.jp/archives/18071799.html
   

   View Slide

4. ࢲͷ

   Google Apps ScriptॳΊ
   

   View Slide

5. wri.peͷϢʔβ਺
   

   View Slide

6. Google Apps Script
   • ࠷΋؆୯ʹಈ͔ͤΔServer Side Javascript
   • ແྉ
   • DBͳͲ΋෇͍ͯ͘Δ
   

   View Slide

7. Έ΍΋ͱ͞Μ
   • νϟοτ(Slack)্Ͱಈ͘ۈଵ؅ཧ
   • ʮ͓͸Α͏ʯʮ͓ർΕ͞·ʯͱͭͿ΍͚ͩ͘
   • Google Spreadsheetʹه࿥
   • Google Apps ScriptͰهड़
   

   View Slide

8. ϓϩτλΠϓ
   • 2014/09࡞੒
   • 200ߦ͙Β͍ͷJavascript
   • ScriptEditorͰهड़
   • Ұϲ݄Քಇ
   • ެ։͢ΔͨΊʹશ໘ॻ͖௚͠
   

   View Slide

9. ެ։൛Έ΍΋ͱ͞Μ
   • 2014/10 ׬੒
   • https://github.com/masuidrive/miyamotoɹ
   • 900ߦͷίʔυ
   • 340ߦͷςετ
   

   View Slide

10. Έ΍΋ͱ͞Μͷத਎
    Slack
    Google Spreadsheet
    DB interface
    Timesheets
    Chat interface
    

    View Slide

11. Έ΍΋ͱ͞Μͷ։ൃ
    • ϩʔΧϧͰ։ൃͯ͠ɺgas-managerͰΞοϓϩʔ
    υ
    • QUnitͰϩδοΫ෦෼͚ͩςετΛॻ͘
    

    View Slide

12. طଘΠϯλϑΣʔεͷ
    ׆༻
    • ग़ୀۈ͸Slack → ՄࢹԽ
    • ؅ཧ͸Google Spreadsheet
    • શࣾͰແཧͳ͘࢖͑ΔγεςϜ
    

    View Slide

13. ࠓޙ
    • ࿑ಇ࣌ؒ਺ͷूܭ
    • ஗ࠁɾૣୀ
    

    View Slide

14. BigQuery
    

    View Slide

15. BigQuery
    • ϛΠϧͰॳΊͯ࢖͏
    • MySQLͷ಺༰ΛόονͰ1೔Ұ౓શίϐʔ
    • Ϛʔέͷਓ͕SQLΛॻ͚ͨ
    • ϝʔϧ഑৴ͷσʔλ࡞Γ΋͔͜͜Β
    

    View Slide

16. τϨλͷBigQuery
    • MySQLΛҰ೔Ұ౓ίϐʔ
    • ݸਓ৘ใ͸ίϐʔ͠ͳ͍
    • ඇਖ਼نԽΛߦ͏
    • ϩά΋fluentdܦ༝Ͱ
    • Ϣʔβͷಈ޲ͳͲΛ֬ೝ
    

    View Slide

17. BigQueryΛͲ͏ݟͤΔʁ
    • ΄ͱΜͲͷਓ͸SQLΛୟ͚ͳ͍
    • ܾ·ͬͨ਺஋͕ຖ೔ཉ͍͠ͳΒόονͰ
    • Google Apps Script→ SlackͰ͠ΐ
    

    View Slide

18. BQ͔ΒSpreadsheet
    

    View Slide

19. ࡞Γ͍ͨϞϊϦετ
    • mysql2bq
    • MySQLͷσʔλΛBigQueryʹίϐʔ
    • BigQuery Cheats
    • BigQueryͷ݁Ռ͔Β୯७ͳάϥϑΛੜ੒
    

    View Slide

20. Now hiring!
    • τϨλͰ͸ɺαʔόαΠυ(Rails)ɺiOS(ObjC)ͷ
    ΤϯδχΞΛେืूத
    • ໌Δ͍৬৔Ͱ͢w
    

    View Slide