infrastructure/terraform/modules/feature-store/bigquery-tables.tf

# Copyright 2023 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
#
#      http://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 CONDITI} OF ANY KIND, either express or implied.
# See the License for the specific language governing permissi} and
# limitati} under the License.

# This resource creates a BigQuery table named audience_segmentation_inference_preparation 
# in the dataset specified by google_bigquery_dataset.audience_segmentation.dataset_id.
resource "google_bigquery_table" "audience_segmentation_inference_preparation" {
  project     = google_bigquery_dataset.audience_segmentation.project
  dataset_id  = google_bigquery_dataset.audience_segmentation.dataset_id
  table_id    = local.config_bigquery.table.audience_segmentation_inference_preparation.table_name
  description = local.config_bigquery.table.audience_segmentation_inference_preparation.table_description

  # The deletion_protection attribute specifies whether the table should be protected from deletion. In this case, it's set to false, which means that the table can be deleted.
  deletion_protection = false

  labels = {
    version = "prod"
  }

  # The schema attribute specifies the schema of the table. In this case, the schema is defined in the JSON file.
  schema = file("${local.sql_dir}/schema/table/audience_segmentation_inference_preparation.json")
}

# This resource creates a BigQuery table named customer_lifetime_value_inference_preparation 
# in the dataset specified by google_bigquery_dataset.customer_lifetime_value.dataset_id.
resource "google_bigquery_table" "customer_lifetime_value_inference_preparation" {
  project     = google_bigquery_dataset.customer_lifetime_value.project
  dataset_id  = google_bigquery_dataset.customer_lifetime_value.dataset_id
  table_id    = local.config_bigquery.table.customer_lifetime_value_inference_preparation.table_name
  description = local.config_bigquery.table.customer_lifetime_value_inference_preparation.table_description

  # The deletion_protection attribute specifies whether the table should be protected from deletion. In this case, it's set to false, which means that the table can be deleted.
  deletion_protection = false

  labels = {
    version = "prod"
  }

  # The schema attribute specifies the schema of the table. In this case, the schema is defined in the JSON file.
  schema = file("${local.sql_dir}/schema/table/customer_lifetime_value_inference_preparation.json")
}

# This resource creates a BigQuery table named customer_lifetime_value_label 
# in the dataset specified by google_bigquery_dataset.feature_store.dataset_id.
resource "google_bigquery_table" "customer_lifetime_value_label" {
  project     = google_bigquery_dataset.feature_store.project
  dataset_id  = google_bigquery_dataset.feature_store.dataset_id
  table_id    = local.config_bigquery.table.customer_lifetime_value_label.table_name
  description = local.config_bigquery.table.customer_lifetime_value_label.table_description

  # The deletion_protection attribute specifies whether the table should be protected from deletion. In this case, it's set to false, which means that the table can be deleted.
  deletion_protection = false

  labels = {
    version = "prod"
  }

  # The schema attribute specifies the schema of the table. In this case, the schema is defined in the JSON file.
  schema = file("${local.sql_dir}/schema/table/customer_lifetime_value_label.json")

  # The lifecycle block is used to configure the lifecycle of the table. In this case, the ignore_changes attribute is set to all, which means that Terraform will ignore 
  # any changes to the table and will not attempt to update the table. The prevent_destroy attribute is set to true, which means that Terraform will prevent the table from being destroyed.
  lifecycle {
    ignore_changes  = all
    prevent_destroy = true
  }
}

# This resource creates a BigQuery table named purchase_propensity_inference_preparation 
# in the dataset specified by google_bigquery_dataset.purchase_propensity.dataset_id.
resource "google_bigquery_table" "purchase_propensity_inference_preparation" {
  project     = google_bigquery_dataset.purchase_propensity.project
  dataset_id  = google_bigquery_dataset.purchase_propensity.dataset_id
  table_id    = local.config_bigquery.table.purchase_propensity_inference_preparation.table_name
  description = local.config_bigquery.table.purchase_propensity_inference_preparation.table_description

  # The deletion_protection attribute specifies whether the table should be protected from deletion. In this case, it's set to false, which means that the table can be deleted.
  deletion_protection = false
  labels = {
    version = "prod"
  }

  # The schema attribute specifies the schema of the table. In this case, the schema is defined in the JSON file.
  schema = file("${local.sql_dir}/schema/table/purchase_propensity_inference_preparation.json")
}

# This resource creates a BigQuery table named churn_propensity_inference_preparation 
# in the dataset specified by google_bigquery_dataset.churn_propensity.dataset_id.
resource "google_bigquery_table" "churn_propensity_inference_preparation" {
  project     = google_bigquery_dataset.churn_propensity.project
  dataset_id  = google_bigquery_dataset.churn_propensity.dataset_id
  table_id    = local.config_bigquery.table.churn_propensity_inference_preparation.table_name
  description = local.config_bigquery.table.churn_propensity_inference_preparation.table_description

  # The deletion_protection attribute specifies whether the table should be protected from deletion. In this case, it's set to false, which means that the table can be deleted.
  deletion_protection = false
  labels = {
    version = "prod"
  }

  # The schema attribute specifies the schema of the table. In this case, the schema is defined in the JSON file.
  schema = file("${local.sql_dir}/schema/table/churn_propensity_inference_preparation.json")
}

# This resource creates a BigQuery table named lead_score_propensity_inference_preparation 
# in the dataset specified by google_bigquery_dataset.lead_score_propensity.dataset_id.
resource "google_bigquery_table" "lead_score_propensity_inference_preparation" {
  project     = google_bigquery_dataset.lead_score_propensity.project
  dataset_id  = google_bigquery_dataset.lead_score_propensity.dataset_id
  table_id    = local.config_bigquery.table.lead_score_propensity_inference_preparation.table_name
  description = local.config_bigquery.table.lead_score_propensity_inference_preparation.table_description

  # The deletion_protection attribute specifies whether the table should be protected from deletion. In this case, it's set to false, which means that the table can be deleted.
  deletion_protection = false
  labels = {
    version = "prod"
  }

  # The schema attribute specifies the schema of the table. In this case, the schema is defined in the JSON file.
  schema = file("${local.sql_dir}/schema/table/lead_score_propensity_inference_preparation.json")
}

# This resource creates a BigQuery table named purchase_propensity_label 
# in the dataset specified by google_bigquery_dataset.feature_store.dataset_id.
resource "google_bigquery_table" "purchase_propensity_label" {
  project     = google_bigquery_dataset.feature_store.project
  dataset_id  = google_bigquery_dataset.feature_store.dataset_id
  table_id    = local.config_bigquery.table.purchase_propensity_label.table_name
  description = local.config_bigquery.table.purchase_propensity_label.table_description

  # The deletion_protection attribute specifies whether the table should be protected from deletion. In this case, it's set to false, which means that the table can be deleted.
  deletion_protection = false
  labels = {
    version = "prod"
  }

  # The schema attribute specifies the schema of the table. In this case, the schema is defined in the JSON file.
  schema = file("${local.sql_dir}/schema/table/purchase_propensity_label.json")

  # The lifecycle block is used to configure the lifecycle of the table. In this case, the ignore_changes attribute is set to all, which means that Terraform will ignore 
  # any changes to the table and will not attempt to update the table. The prevent_destroy attribute is set to true, which means that Terraform will prevent the table from being destroyed.
  lifecycle {
    ignore_changes  = all
    prevent_destroy = true
  }
}

# This resource creates a BigQuery table named churn_propensity_label 
# in the dataset specified by google_bigquery_dataset.feature_store.dataset_id.
resource "google_bigquery_table" "churn_propensity_label" {
  project     = google_bigquery_dataset.feature_store.project
  dataset_id  = google_bigquery_dataset.feature_store.dataset_id
  table_id    = local.config_bigquery.table.churn_propensity_label.table_name
  description = local.config_bigquery.table.churn_propensity_label.table_description

  # The deletion_protection attribute specifies whether the table should be protected from deletion. In this case, it's set to false, which means that the table can be deleted.
  deletion_protection = false
  labels = {
    version = "prod"
  }

  # The schema attribute specifies the schema of the table. In this case, the schema is defined in the JSON file.
  schema = file("${local.sql_dir}/schema/table/churn_propensity_label.json")

  # The lifecycle block is used to configure the lifecycle of the table. In this case, the ignore_changes attribute is set to all, which means that Terraform will ignore 
  # any changes to the table and will not attempt to update the table. The prevent_destroy attribute is set to true, which means that Terraform will prevent the table from being destroyed.
  lifecycle {
    ignore_changes  = all
    prevent_destroy = true
  }
}

# This resource creates a BigQuery table named lead_score_propensity_label 
# in the dataset specified by google_bigquery_dataset.feature_store.dataset_id.
resource "google_bigquery_table" "lead_score_propensity_label" {
  project     = google_bigquery_dataset.feature_store.project
  dataset_id  = google_bigquery_dataset.feature_store.dataset_id
  table_id    = local.config_bigquery.table.lead_score_propensity_label.table_name
  description = local.config_bigquery.table.lead_score_propensity_label.table_description

  # The deletion_protection attribute specifies whether the table should be protected from deletion. In this case, it's set to false, which means that the table can be deleted.
  deletion_protection = false
  labels = {
    version = "prod"
  }

  # The schema attribute specifies the schema of the table. In this case, the schema is defined in the JSON file.
  schema = file("${local.sql_dir}/schema/table/lead_score_propensity_label.json")

  # The lifecycle block is used to configure the lifecycle of the table. In this case, the ignore_changes attribute is set to all, which means that Terraform will ignore 
  # any changes to the table and will not attempt to update the table. The prevent_destroy attribute is set to true, which means that Terraform will prevent the table from being destroyed.
  lifecycle {
    ignore_changes  = all
    prevent_destroy = true
  }
}

# This resource creates a BigQuery table named user_dimensions 
# in the dataset specified by google_bigquery_dataset.feature_store.dataset_id.
resource "google_bigquery_table" "user_dimensions" {
  project     = google_bigquery_dataset.feature_store.project
  dataset_id  = google_bigquery_dataset.feature_store.dataset_id
  table_id    = local.config_bigquery.table.user_dimensions.table_name
  description = local.config_bigquery.table.user_dimensions.table_description

  # The deletion_protection attribute specifies whether the table should be protected from deletion. In this case, it's set to false, which means that the table can be deleted.
  deletion_protection = false
  labels = {
    version = "prod"
  }

  # The schema attribute specifies the schema of the table. In this case, the schema is defined in the JSON file.
  schema = file("${local.sql_dir}/schema/table/user_dimensions.json")

  # The lifecycle block is used to configure the lifecycle of the table. In this case, the ignore_changes attribute is set to all, which means that Terraform will ignore 
  # any changes to the table and will not attempt to update the table. The prevent_destroy attribute is set to true, which means that Terraform will prevent the table from being destroyed.
  lifecycle {
    ignore_changes  = all
    prevent_destroy = true
  }
}

# This resource creates a BigQuery table named user_lifetime_dimensions 
# in the dataset specified by google_bigquery_dataset.feature_store.dataset_id.
resource "google_bigquery_table" "user_lifetime_dimensions" {
  project     = google_bigquery_dataset.feature_store.project
  dataset_id  = google_bigquery_dataset.feature_store.dataset_id
  table_id    = local.config_bigquery.table.user_lifetime_dimensions.table_name
  description = local.config_bigquery.table.user_lifetime_dimensions.table_description

  # The deletion_protection attribute specifies whether the table should be protected from deletion. In this case, it's set to false, which means that the table can be deleted.
  deletion_protection = false
  labels = {
    version = "prod"
  }

  # The schema attribute specifies the schema of the table. In this case, the schema is defined in the JSON file.
  schema = file("${local.sql_dir}/schema/table/user_lifetime_dimensions.json")

  # The lifecycle block is used to configure the lifecycle of the table. In this case, the ignore_changes attribute is set to all, which means that Terraform will ignore 
  # any changes to the table and will not attempt to update the table. The prevent_destroy attribute is set to true, which means that Terraform will prevent the table from being destroyed.
  lifecycle {
    ignore_changes  = all
    prevent_destroy = true
  }
}

# This resource creates a BigQuery table named user_lookback_metrics 
# in the dataset specified by google_bigquery_dataset.feature_store.dataset_id.
resource "google_bigquery_table" "user_lookback_metrics" {
  project     = google_bigquery_dataset.feature_store.project
  dataset_id  = google_bigquery_dataset.feature_store.dataset_id
  table_id    = local.config_bigquery.table.user_lookback_metrics.table_name
  description = local.config_bigquery.table.user_lookback_metrics.table_description

  # The deletion_protection attribute specifies whether the table should be protected from deletion. In this case, it's set to false, which means that the table can be deleted.
  deletion_protection = false
  labels = {
    version = "prod"
  }

  # The schema attribute specifies the schema of the table. In this case, the schema is defined in the JSON file.
  schema = file("${local.sql_dir}/schema/table/user_lookback_metrics.json")

  # The lifecycle block is used to configure the lifecycle of the table. In this case, the ignore_changes attribute is set to all, which means that Terraform will ignore 
  # any changes to the table and will not attempt to update the table. The prevent_destroy attribute is set to true, which means that Terraform will prevent the table from being destroyed.
  lifecycle {
    ignore_changes  = all
    prevent_destroy = true
  }
}

# This resource creates a BigQuery table named user_rolling_window_lifetime_metrics 
# in the dataset specified by google_bigquery_dataset.feature_store.dataset_id.
resource "google_bigquery_table" "user_rolling_window_lifetime_metrics" {
  project     = google_bigquery_dataset.feature_store.project
  dataset_id  = google_bigquery_dataset.feature_store.dataset_id
  table_id    = local.config_bigquery.table.user_rolling_window_lifetime_metrics.table_name
  description = local.config_bigquery.table.user_rolling_window_lifetime_metrics.table_description

  # The deletion_protection attribute specifies whether the table should be protected from deletion. In this case, it's set to false, which means that the table can be deleted.
  deletion_protection = false
  labels = {
    version = "prod"
  }

  # The schema attribute specifies the schema of the table. In this case, the schema is defined in the JSON file.
  schema = file("${local.sql_dir}/schema/table/user_rolling_window_lifetime_metrics.json")

  # The lifecycle block is used to configure the lifecycle of the table. In this case, the ignore_changes attribute is set to all, which means that Terraform will ignore 
  # any changes to the table and will not attempt to update the table. The prevent_destroy attribute is set to true, which means that Terraform will prevent the table from being destroyed.
  lifecycle {
    ignore_changes  = all
    prevent_destroy = true
  }
}

# This resource creates a BigQuery table named user_rolling_window_metrics 
# in the dataset specified by google_bigquery_dataset.feature_store.dataset_id.
resource "google_bigquery_table" "user_rolling_window_metrics" {
  project     = google_bigquery_dataset.feature_store.project
  dataset_id  = google_bigquery_dataset.feature_store.dataset_id
  table_id    = local.config_bigquery.table.user_rolling_window_metrics.table_name
  description = local.config_bigquery.table.user_rolling_window_metrics.table_description

  # The deletion_protection attribute specifies whether the table should be protected from deletion. In this case, it's set to false, which means that the table can be deleted.
  deletion_protection = false
  labels = {
    version = "prod"
  }

  # The schema attribute specifies the schema of the table. In this case, the schema is defined in the JSON file.
  schema = file("${local.sql_dir}/schema/table/user_rolling_window_metrics.json")

  # The lifecycle block is used to configure the lifecycle of the table. In this case, the ignore_changes attribute is set to all, which means that Terraform will ignore 
  # any changes to the table and will not attempt to update the table. The prevent_destroy attribute is set to true, which means that Terraform will prevent the table from being destroyed.
  lifecycle {
    ignore_changes  = all
    prevent_destroy = true
  }
}

# This resource creates a BigQuery table named user_rolling_window_lead_metrics 
# in the dataset specified by google_bigquery_dataset.feature_store.dataset_id.
resource "google_bigquery_table" "user_rolling_window_lead_metrics" {
  project     = google_bigquery_dataset.feature_store.project
  dataset_id  = google_bigquery_dataset.feature_store.dataset_id
  table_id    = local.config_bigquery.table.user_rolling_window_lead_metrics.table_name
  description = local.config_bigquery.table.user_rolling_window_lead_metrics.table_description

  # The deletion_protection attribute specifies whether the table should be protected from deletion. In this case, it's set to false, which means that the table can be deleted.
  deletion_protection = false
  labels = {
    version = "prod"
  }

  # The schema attribute specifies the schema of the table. In this case, the schema is defined in the JSON file.
  schema = file("${local.sql_dir}/schema/table/user_rolling_window_lead_metrics.json")

  # The lifecycle block is used to configure the lifecycle of the table. In this case, the ignore_changes attribute is set to all, which means that Terraform will ignore 
  # any changes to the table and will not attempt to update the table. The prevent_destroy attribute is set to true, which means that Terraform will prevent the table from being destroyed.
  lifecycle {
    ignore_changes  = all
    prevent_destroy = true
  }
}

# This resource creates a BigQuery table named user_scoped_lifetime_metrics 
# in the dataset specified by google_bigquery_dataset.feature_store.dataset_id.
resource "google_bigquery_table" "user_scoped_lifetime_metrics" {
  project     = google_bigquery_dataset.feature_store.project
  dataset_id  = google_bigquery_dataset.feature_store.dataset_id
  table_id    = local.config_bigquery.table.user_scoped_lifetime_metrics.table_name
  description = local.config_bigquery.table.user_scoped_lifetime_metrics.table_description

  # The deletion_protection attribute specifies whether the table should be protected from deletion. In this case, it's set to false, which means that the table can be deleted.
  deletion_protection = false
  labels = {
    version = "prod"
  }

  # The schema attribute specifies the schema of the table. In this case, the schema is defined in the JSON file.
  schema = file("${local.sql_dir}/schema/table/user_scoped_lifetime_metrics.json")

  # The lifecycle block is used to configure the lifecycle of the table. In this case, the ignore_changes attribute is set to all, which means that Terraform will ignore 
  # any changes to the table and will not attempt to update the table. The prevent_destroy attribute is set to true, which means that Terraform will prevent the table from being destroyed.
  lifecycle {
    ignore_changes  = all
    prevent_destroy = true
  }
}

# This resource creates a BigQuery table named user_scoped_metrics 
# in the dataset specified by google_bigquery_dataset.feature_store.dataset_id.
resource "google_bigquery_table" "user_scoped_metrics" {
  project     = google_bigquery_dataset.feature_store.project
  dataset_id  = google_bigquery_dataset.feature_store.dataset_id
  table_id    = local.config_bigquery.table.user_scoped_metrics.table_name
  description = local.config_bigquery.table.user_scoped_metrics.table_description

  # The deletion_protection attribute specifies whether the table should be protected from deletion. In this case, it's set to false, which means that the table can be deleted.
  deletion_protection = false
  labels = {
    version = "prod"
  }

  # The schema attribute specifies the schema of the table. In this case, the schema is defined in the JSON file.
  schema = file("${local.sql_dir}/schema/table/user_scoped_metrics.json")

  # The lifecycle block is used to configure the lifecycle of the table. In this case, the ignore_changes attribute is set to all, which means that Terraform will ignore 
  # any changes to the table and will not attempt to update the table. The prevent_destroy attribute is set to true, which means that Terraform will prevent the table from being destroyed.
  lifecycle {
    ignore_changes  = all
    prevent_destroy = true
  }
}

# This resource creates a BigQuery table named user_scoped_segmentation_metrics 
# in the dataset specified by google_bigquery_dataset.feature_store.dataset_id.
resource "google_bigquery_table" "user_scoped_segmentation_metrics" {
  project     = google_bigquery_dataset.feature_store.project
  dataset_id  = google_bigquery_dataset.feature_store.dataset_id
  table_id    = local.config_bigquery.table.user_scoped_segmentation_metrics.table_name
  description = local.config_bigquery.table.user_scoped_segmentation_metrics.table_description

  # The deletion_protection attribute specifies whether the table should be protected from deletion. In this case, it's set to false, which means that the table can be deleted.
  deletion_protection = false
  labels = {
    version = "prod"
  }

  # The schema attribute specifies the schema of the table. In this case, the schema is defined in the JSON file.
  schema = file("${local.sql_dir}/schema/table/user_scoped_segmentation_metrics.json")

  # The lifecycle block is used to configure the lifecycle of the table. In this case, the ignore_changes attribute is set to all, which means that Terraform will ignore 
  # any changes to the table and will not attempt to update the table. The prevent_destroy attribute is set to true, which means that Terraform will prevent the table from being destroyed.
  lifecycle {
    ignore_changes  = all
    prevent_destroy = true
  }
}

# This resource creates a BigQuery table named user_segmentation_dimensions 
# in the dataset specified by google_bigquery_dataset.feature_store.dataset_id.
resource "google_bigquery_table" "user_segmentation_dimensions" {
  project     = google_bigquery_dataset.feature_store.project
  dataset_id  = google_bigquery_dataset.feature_store.dataset_id
  table_id    = local.config_bigquery.table.user_segmentation_dimensions.table_name
  description = local.config_bigquery.table.user_segmentation_dimensions.table_description

  # The deletion_protection attribute specifies whether the table should be protected from deletion. In this case, it's set to false, which means that the table can be deleted.
  deletion_protection = false
  labels = {
    version = "prod"
  }

  # The schema attribute specifies the schema of the table. In this case, the schema is defined in the JSON file.
  schema = file("${local.sql_dir}/schema/table/user_segmentation_dimensions.json")

  # The lifecycle block is used to configure the lifecycle of the table. In this case, the ignore_changes attribute is set to all, which means that Terraform will ignore 
  # any changes to the table and will not attempt to update the table. The prevent_destroy attribute is set to true, which means that Terraform will prevent the table from being destroyed.
  lifecycle {
    ignore_changes  = all
    prevent_destroy = true
  }
}

# This resource creates a BigQuery table named user_session_event_aggregated_metrics 
# in the dataset specified by google_bigquery_dataset.feature_store.dataset_id.
resource "google_bigquery_table" "user_session_event_aggregated_metrics" {
  project     = google_bigquery_dataset.feature_store.project
  dataset_id  = google_bigquery_dataset.feature_store.dataset_id
  table_id    = local.config_bigquery.table.user_session_event_aggregated_metrics.table_name
  description = local.config_bigquery.table.user_session_event_aggregated_metrics.table_description

  # The deletion_protection attribute specifies whether the table should be protected from deletion. In this case, it's set to false, which means that the table can be deleted.
  deletion_protection = false
  labels = {
    version = "prod"
  }

  # The schema attribute specifies the schema of the table. In this case, the schema is defined in the JSON file.
  schema = file("${local.sql_dir}/schema/table/user_session_event_aggregated_metrics.json")

  # The lifecycle block is used to configure the lifecycle of the table. In this case, the ignore_changes attribute is set to all, which means that Terraform will ignore 
  # any changes to the table and will not attempt to update the table. The prevent_destroy attribute is set to true, which means that Terraform will prevent the table from being destroyed.
  lifecycle {
    ignore_changes  = all
    prevent_destroy = true
  }
}

# This resource creates a BigQuery table named predictions_placeholder
# in the dataset specified by google_bigquery_dataset.purchase_propensity
resource "google_bigquery_table" "purchase_propurchase_propensity_predictions_placeholder" {
  project     = google_bigquery_dataset.purchase_propensity.project
  dataset_id  = google_bigquery_dataset.purchase_propensity.dataset_id
  table_id    = "predictions_placeholder"
  description = "Dummy table to facilitate the creation of down stream dependent views"

  # The deletion_protection attribute specifies whether the table should be protected from deletion. In this case, it's set to false, which means that the table can be deleted.
  deletion_protection = false
  labels = {
    version = "prod"
  }

  # The schema attribute specifies the schema of the table. In this case, the schema is defined in the JSON file.
  schema = file("${local.sql_dir}/schema/table/purchase_propensity_predictions_placeholder.json")

  # The lifecycle block is used to configure the lifecycle of the table. In this case, the ignore_changes attribute is set to all, which means that Terraform will ignore
  # any changes to the table and will not attempt to update the table.
  lifecycle {
    ignore_changes  = all
  }
}