module "cicd_wh" {
  source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.2.0"
  name   = "CICD_WH"

  size                         = "XSMALL"
  statement_timeout_in_seconds = 172800
}

module "team_l2_support_wh" {
  source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.2.0"
  name   = "TEAM_L2_SUPPORT_WH"

  size                         = "XSMALL"
  statement_timeout_in_seconds = 604800
}

module "kafka_data_highgway_team_wh" {
  source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.2.0"
  name   = "KAFKA_DATA_HIGHWAY_WH"
  size   = "XSMALL"
}

module "qa_martech_snowflake_salesforce_node_wh" {
  source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.2.0"
  name   = "QA_MARTECH_SNOWFLAKE_SALESFORCE_NODE_WH"
  size   = "XSMALL"
}

module "qa_etl_wh" {
  source  = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.2.0"
  name    = "QA_ETL_WH"
  size    = "XSMALL"
  comment = "Warehouse for QA ETL"
}
module "exploration_sys_stage_wh" {
  source            = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.2.0"
  name              = "EXPLORATION_SYS_STAGE_WH"
  comment           = "System warehouse for Exploration STAGE regular load. Not for ad-hoc queries"
  size              = "XSMALL"
  max_cluster_count = 2
  scaling_policy    = "ECONOMY"
  auto_suspend      = 60
  statement_timeout_in_seconds = 86400
}
module "exploration_sys_stage_hl_wh" {
  source            = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.2.0"
  name              = "EXPLORATION_SYS_STAGE_HL_WH"
  comment           = "System warehouse for Exploration STAGE heavy load. Not for ad-hoc queries"
  size              = "MEDIUM"
  max_cluster_count = 2
  scaling_policy    = "ECONOMY"
  auto_suspend      = 60
  statement_timeout_in_seconds = 86400
  generation        = "1"
}
module "ae_reporting_stage_wh" {
  source            = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.2.0"
  name              = "AE_REPORTING_STAGE_WH"
  comment           = "Loading data to STAGE_DELPHI_AE_REPORTING"
  size              = "SMALL"
  auto_suspend      = 60
  statement_timeout_in_seconds = 86400
}
module "exploration_sys_qa_wh" {
  source            = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.2.0"
  name              = "EXPLORATION_SYS_QA_WH"
  comment           = "System warehouse for Exploration QA regular load. Not for ad-hoc queries"
  size              = "XSMALL"
  max_cluster_count = 1
  scaling_policy    = "ECONOMY"
  auto_suspend      = 60
  statement_timeout_in_seconds = 86400
}
module "exploration_sys_qa_hl_wh" {
  source            = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.2.0"
  name              = "EXPLORATION_SYS_QA_HL_WH"
  comment           = "System warehouse for Exploration STAGE heavy load. Not for ad-hoc queries"
  size              = "XSMALL"
  max_cluster_count = 1
  scaling_policy    = "ECONOMY"
  auto_suspend      = 60
  statement_timeout_in_seconds = 86400
  generation        = "1"
}
module "ae_reporting_qa_wh" {
  source            = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.2.0"
  name              = "AE_REPORTING_QA_WH"
  comment           = "Loading data to QA_DELPHI_AE_REPORTING"
  size              = "XSMALL"
  auto_suspend      = 60
  statement_timeout_in_seconds = 86400
}