Act Management
Cast
Table schema of BigQuery(System Cast)

Table schema of BigQuery(System Cast)

group_id is the group ID, system_cast_id is the System Cast ID, and type is the type of event. For information of the other columns, see Variables Available in Cast.

field name type mode
group_id INTEGER NULLABLE
system_cast_id STRING NULLABLE
type STRING NULLABLE
detected_at INTEGER NULLABLE
sequence_number INTEGER NULLABLE
triggered_at INTEGER NULLABLE
data JSON 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

To create a table in BigQuery, copy and use the following JSON.

[
    {
      "name": "group_id",
      "type": "INTEGER"
    },
    {
      "name": "system_cast_id",
      "type": "STRING"
    },
    {
      "name": "type",
      "type": "STRING"
    },
    {
      "name": "detected_at",
      "type": "INTEGER"
    },
    {
      "name": "sequence_number",
      "type": "INTEGER"
    },
    {
      "name": "triggered_at",
      "type": "INTEGER"
    },
    {
      "name": "data",
      "type": "JSON"
    },
    {
      "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"
        }
      ]
    }
]
Last updated on