テーブルスキーマ #

各カラムに格納される情報については Cast で使用可能な変数を参照してください。

field name	type	mode
`test`	BOOLEAN	NULLABLE
`act_id`	INTEGER	NULLABLE
`act_name`	STRING	NULLABLE
`cast_id`	STRING	NULLABLE
`cast_name`	STRING	NULLABLE
`artifact_id`	INTEGER	NULLABLE
`device.id`	STRING	NULLABLE
`device.name`	STRING	NULLABLE
`device.mac_addr`	STRING	NULLABLE
`device.hostname`	STRING	NULLABLE
`device.target_triple`	STRING	NULLABLE
`device.host_version`	STRING	NULLABLE
`device.device_type`	STRING	NULLABLE
`device.tags`	STRING	REPEATED
`device.firmware_version`	STRING	NULLABLE
`sequence_number`	INTEGER	NULLABLE
`act_log_index`	INTEGER	NULLABLE
`detected_at`	INTEGER	NULLABLE
`triggered_at`	INTEGER	NULLABLE
`data`	JSON	NULLABLE

BigQuery にテーブルを作成する場合は以下の JSON をコピーして使用してください。

[
    {
      "name": "test",
      "type": "BOOLEAN"
    },
    {
      "name": "act_id",
      "type": "INTEGER"
    },
    {
      "name": "act_name",
      "type": "STRING"
    },
    {
      "name": "cast_id",
      "type": "STRING"
    },
    {
      "name": "cast_name",
      "type": "STRING"
    },
    {
      "name": "artifact_id",
      "type": "INTEGER"
    },
    {
      "name": "device",
      "type": "RECORD",
      "fields": [
        {
          "name": "id",
          "type": "STRING"
        },
        {
          "name": "name",
          "type": "STRING"
        },
        {
          "name": "mac_addr",
          "type": "STRING"
        },
        {
          "name": "hostname",
          "type": "STRING"
        },
        {
          "name": "target_triple",
          "type": "STRING"
        },
        {
          "name": "host_version",
          "type": "STRING"
        },
        {
          "name": "device_type",
          "type": "STRING"
        },
        {
          "name": "tags",
          "type": "STRING",
          "mode": "REPEATED"
        },
        {
          "name": "firmware_version",
          "type": "STRING"
        }
      ]
    },
    {
      "name": "sequence_number",
      "type": "INTEGER"
    },
    {
      "name": "act_log_index",
      "type": "INTEGER"
    },
    {
      "name": "detected_at",
      "type": "INTEGER"
    },
    {
      "name": "triggered_at",
      "type": "INTEGER"
    },
    {
      "name": "data",
      "type": "JSON"
    }
]