Table schema of BigQuery

Table schema #

See Variables available in Cast for the information of each field.

field nametypemode
testBOOLEANNULLABLE
act_idINTEGERNULLABLE
act_nameSTRINGNULLABLE
cast_idSTRINGNULLABLE
cast_nameSTRINGNULLABLE
artifact_idINTEGERNULLABLE
device.idSTRINGNULLABLE
device.nameSTRINGNULLABLE
device.mac_addrSTRINGNULLABLE
device.hostnameSTRINGNULLABLE
device.target_tripleSTRINGNULLABLE
device.host_versionSTRINGNULLABLE
device.device_typeSTRINGNULLABLE
device.tagsSTRINGREPEATED
device.firmware_versionSTRINGNULLABLE
sequence_numberINTEGERNULLABLE
act_log_indexINTEGERNULLABLE
detected_atINTEGERNULLABLE
triggered_atINTEGERNULLABLE
dataJSONNULLABLE

To create a table in BigQuery, copy and use the following 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"
    }
]

Back to Cast