terraform/modules/bigquery/bigquery.tf

/**
 * Copyright 2022 Google LLC
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     https://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *
 */

#Creating a bigquery dataset and table schema

resource "google_bigquery_dataset" "data_set" {
  dataset_id    = "validation"
  friendly_name = "Validation Dataset"
  description   = "BQ dataset for validation process"
  location      = "US"
}

resource "google_bigquery_table" "table_id" {
  depends_on = [
    google_bigquery_dataset.data_set
  ]

  deletion_protection = false
  dataset_id          = "validation"
  table_id            = "validation_table"

  schema = <<EOF
[
  {
    "name": "case_id",
    "type": "STRING",
    "mode": "NULLABLE"
  },
  {
    "name": "uid",
    "type": "STRING",
    "mode": "NULLABLE"
  },
  {
    "name": "document_class",
    "type": "STRING",
    "mode": "NULLABLE"
  },
  {
    "name": "document_type",
    "type": "STRING",
    "mode": "NULLABLE"
  },
  {
    "name": "entities",
    "type": "STRING",
    "mode": "NULLABLE"
  }


]
EOF

}