ikuwow
1/22/2017 - 2:57 PM

CloudLoggingからBigQueryに流したログ（tsv in json）をみる ref: http://qiita.com/ikuwow/items/28369c4dc31a832a6ca1

CloudLoggingからBigQueryに流したログ（tsv in json）をみる ref: http://qiita.com/ikuwow/items/28369c4dc31a832a6ca1

viewのクエリ
content_copyfile_download
-- use regacy sqlはoff
SELECT
  REGEXP_EXTRACT(textPayload,r'^(?:[^\t]*\t){0}([^\t]*).*') AS field1,
  REGEXP_EXTRACT(textPayload,r'^(?:[^\t]*\t){1}([^\t]*).*') AS field2,
  REGEXP_EXTRACT(textPayload,r'^(?:[^\t]*\t){2}([^\t]*).*') AS field3,
  ...
FROM
  `projectname.datasetname.somelogs_*`
;