stackoverflow gcp pubsub bigquery

bq-schema.json

[
  {
    "name": "subscription_name",
    "type": "STRING"
  },
  {
    "name": "messageid",
    "type": "STRING"
  },
  {
    "name": "publish_time",
    "type": "TIMESTAMP"
  },
  {
    "name": "attributes",
    "type": "STRING"
  },
  {
    "name": "data",
    "type": "record",
    "fields": [
      {
        "name": "domain",
        "type": "STRING"
      },
      {
        "name": "grade",
        "type": "STRING"
      },
      {
        "name": "host",
        "type": "STRING"
      },
      {
        "name": "likelihood_indicator",
        "type": "STRING"
      },
      {
        "name": "response_headers",
        "type": "record",
        "mode": "repeated",
        "fields": [
          {
            "name": "header",
            "type": "STRING"
          },
          {
            "name": "value",
            "type": "STRING"
          }
        ]
      }
    ]
  }
]

httpobs-schema.avsc

{
  "name": "data",
  "type": "record",
  "fields": [
    {
      "name": "domain",
      "type": "string"
    },
    {
      "name": "grade",
      "type": "string"
    },
    {
      "name": "host",
      "type": "string"
    },
    {
      "name": "likelihood_indicator",
      "type": "string"
    },
    {
      "name": "response_headers",
      "type": {
        "type": "array",
        "items": [
          {
            "name": "header_value",
            "type": "record",
            "fields": [
              { "name": "header", "type": "string" },
              { "name": "value", "type": "string" }
            ]
          }
        ]
      }
    }
  ]
}

topic info

$ gcloud pubsub topics describe projects/agilicus/topics/check-me.httpobs
name: projects/agilicus/topics/check-me.httpobs
schemaSettings:
  encoding: JSON
  schema: projects/agilicus/schemas/check-me.httpobs
  
$ gcloud pubsub subscriptions list
Listed 0 items.