main.tf

resource "google_storage_bucket" "ave-bucket-test1" {
  name     = "ave-bucket-test1"
  location = "EU"
}


resource "google_bigquery_dataset" "terraform-test" {
  dataset_id                  = var.dataset_id
  project                     = var.project_id
  friendly_name               = "terraform-test"
  description                 = "terraformed test dataset"
  location                    = "EU"
  default_table_expiration_ms = 3600000

  labels = {
    env = terraform.workspace
  }
}

resource "google_bigquery_dataset" "view_dataset" {
  dataset_id                  = var.view_dataset_id
  project                     = var.project_id
  friendly_name               = var.view_dataset_id
  description                 = "view dataset"
  location                    = "EU"
  default_table_expiration_ms = 3600000

  labels = {
    env = terraform.workspace
  }
}

resource "google_bigquery_table" "test_table" {
  for_each = fileset("${path.module}/TABLES", "*.json")

  dataset_id = var.dataset_id
  table_id   = trimsuffix(each.value, ".json")
  project    = var.project_id
  schema     = file("${path.module}/TABLES/${each.value}")
  labels = {
    env = terraform.workspace
  }
}

module "bq_view" {
  for_each = fileset("./TABLES/", "*.json")

  source = "git@github.com:averbekedgc/terraform_test.git//modules/bq_view"
  #source = "./modules/bq_view"
  project_id      = var.project_id
  view_dataset_id = var.view_dataset_id
  view_id         = trimsuffix("${each.key}", ".json")
  query           = "SELECT * FROM ${var.dataset_id}.${trimsuffix("${each.key}", ".json")}"

  depends_on = [google_bigquery_dataset.terraform-test, google_bigquery_dataset.view_dataset, google_bigquery_table.test_table]
}