title: How to create Type RECORD of INTEGER in my terraform file for BigQuery
body: <p>I am trying to make the terraform schema for my BigQuery table and I need a column of type RECORD which will be populated by INTEGER.
  The field in question would have the format of brackets with integers inside could be one or mutiple seperated by comma : [1]</p>
  
  <p>I tried writing like this: </p>
  
  <pre><code>resource "google_bigquery_table" "categories" {
    project = "abcd-data-ods-${terraform.workspace}"
    dataset_id = google_bigquery_dataset.bq_dataset_op.dataset_id
    table_id = "categories"
  
  schema = &lt;&lt;EOF
      [
          {"type":"STRING","name":"a","mode":"NULLABLE"},
          {"type":"RECORD[INTEGER]","name":"b","mode":"NULLABLE"}
      ]
  EOF
  
  }
  </code></pre>
  
  <p>and like this:</p>
  
  <pre><code>resource "google_bigquery_table" "categories" {
    project = "abcd-data-ods-${terraform.workspace}"
    dataset_id = google_bigquery_dataset.bq_dataset_op.dataset_id
    table_id = "categories"
  
  schema = &lt;&lt;EOF
      [
          {"type":"STRING","name":"a","mode":"NULLABLE"},
          {"type":"RECORD","name":"b","mode":"NULLABLE"}
      ]
  EOF
  
  }
  </code></pre>
  
  <p>But it didn't work as I keep getting an error in my CI/CD on gitlab
  The error for the first attempt:</p>
  
  <pre><code>Error: googleapi: Error 400: Invalid value for type: RECORD[INTEGER] is not a valid value, invalid
  </code></pre>
  
  <p>The error for the second attempt:</p>
  
  <pre><code>Error: googleapi: Error 400: Field b is type RECORD but has no schema, invalid
  </code></pre>
  
  <p>I presume that the second implementation is the closet to the solution given the error but it is still missing something
  Does anyone has an idea about the right way to declare it</p>