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

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

0ec58a040e1e4e959c8566484b4bba19?s=128

Yuichiro MASUI

December 12, 2014
Tweet

Transcript

  1. τϨλͷBigQuery
 Google Apps Script׆༻ज़ Toreta, Inc. Yuichiro MASUI <masui@toreta.in>

  2. None
  3. τϨλͷαʔόߏ੒ • αʔόଆ͸Rails • EngineYard + AWS • ࣾ಺ͰJenkins •

    ࣾ಺αʔϏε͸heroku • ؂ࢹ͸Pingdom+PagerDuty http://toreta.blog.jp/archives/18071799.html
  4. ࢲͷ
 Google Apps ScriptॳΊ

  5. wri.peͷϢʔβ਺

  6. Google Apps Script • ࠷΋؆୯ʹಈ͔ͤΔServer Side Javascript • ແྉ •

    DBͳͲ΋෇͍ͯ͘Δ
  7. Έ΍΋ͱ͞Μ • νϟοτ(Slack)্Ͱಈ͘ۈଵ؅ཧ • ʮ͓͸Α͏ʯʮ͓ർΕ͞·ʯͱͭͿ΍͚ͩ͘ • Google Spreadsheetʹه࿥ • Google

    Apps ScriptͰهड़
  8. ϓϩτλΠϓ • 2014/09࡞੒ • 200ߦ͙Β͍ͷJavascript • ScriptEditorͰهड़ • Ұϲ݄Քಇ •

    ެ։͢ΔͨΊʹશ໘ॻ͖௚͠
  9. ެ։൛Έ΍΋ͱ͞Μ • 2014/10 ׬੒ • https://github.com/masuidrive/miyamotoɹ • 900ߦͷίʔυ • 340ߦͷςετ

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

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

  12. طଘΠϯλϑΣʔεͷ ׆༻ • ग़ୀۈ͸Slack → ՄࢹԽ • ؅ཧ͸Google Spreadsheet •

    શࣾͰແཧͳ͘࢖͑ΔγεςϜ
  13. ࠓޙ • ࿑ಇ࣌ؒ਺ͷूܭ • ஗ࠁɾૣୀ

  14. BigQuery

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

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

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

  18. BQ͔ΒSpreadsheet

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

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