module "dev_ows_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "DEV_OWS_WH" statement_timeout_in_seconds = 172800 auto_suspend = 30 # TODO: enable monitor once atlantis permissions have been fixed resource_monitor_enabled = false team = "fansifter" generation = "1" } module "qa_ows_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_OWS_WH" size = "MEDIUM" max_cluster_count = 2 auto_suspend = 30 statement_timeout_in_seconds = 172800 # TODO: enable monitor once atlantis permissions have been fixed resource_monitor_enabled = false team = "fansifter" generation = "1" } module "prod_ows_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_OWS_WH" size = "MEDIUM" max_cluster_count = 2 auto_suspend = 60 statement_timeout_in_seconds = 172800 # TODO: enable monitor once atlantis permissions have been fixed resource_monitor_enabled = false team = "fansifter" generation = "1" } module "qa_etl_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_ETL_WH" size = "XSMALL" max_cluster_count = 2 auto_suspend = 60 statement_timeout_in_seconds = 21600 # TODO: enable monitor once atlantis permissions have been fixed resource_monitor_enabled = false # shared with Data Platform, KDH, fansifter team = "shared" generation = "1" } module "prod_etl_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_ETL_WH" size = "XSMALL" max_cluster_count = 2 auto_suspend = 60 statement_timeout_in_seconds = 21600 # TODO: enable monitor once atlantis permissions have been fixed resource_monitor_enabled = false # shared with Data Platform, KDH, fansifter team = "shared" generation = "1" } module "dev_dbt_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "DEV_DBT_WH" size = "LARGE" auto_suspend = 30 statement_timeout_in_seconds = 21600 team = "fansifter" generation = "1" } module "qa_dbt_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_DBT_WH" size = "X-LARGE" max_cluster_count = 3 auto_suspend = 30 statement_timeout_in_seconds = 21600 team = "fansifter" generation = "1" } module "prod_dbt_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_DBT_WH" size = "X-LARGE" max_cluster_count = 3 auto_suspend = 30 statement_timeout_in_seconds = 21600 team = "fansifter" generation = "1" } module "prod_amplitude_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_AMPLITUDE_WH" size = "SMALL" auto_suspend = 60 # TODO: enable monitor once atlantis permissions have been fixed resource_monitor_enabled = false generation = "1" } module "exploration_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "EXPLORATION_WH" size = "MEDIUM" auto_suspend = 60 max_cluster_count = 2 scaling_policy = "ECONOMY" # comment = "Exploration users DWH" # TODO: enable monitor once atlantis permissions have been fixed resource_monitor_enabled = false team = "shared" generation = "1" } module "qa_shopify_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_SHOPIFY_INTEGRATIONS_WH" auto_suspend = 30 statement_timeout_in_seconds = 172800 team = "fansifter" generation = "1" } module "prod_shopify_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_SHOPIFY_INTEGRATIONS_WH" auto_suspend = 30 statement_timeout_in_seconds = 172800 team = "fansifter" generation = "1" } module "qa_marketing_integrations_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_MARKETING_INTEGRATIONS_WH" auto_suspend = 30 statement_timeout_in_seconds = 172800 team = "fansifter" generation = "1" } module "prod_marketing_integrations_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_MARKETING_INTEGRATIONS_WH" auto_suspend = 30 statement_timeout_in_seconds = 172800 team = "fansifter" generation = 2 } module "cicd_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "CICD_WH" size = "XSMALL" auto_suspend = 60 statement_timeout_in_seconds = 172800 team = "data-platform" generation = "1" } module "team_dev_ba_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "TEAM_DEV_BA_WH" size = "MEDIUM" statement_timeout_in_seconds = 21600 auto_suspend = 60 comment = "DWH for development and BA Teams purposes" team = "data-platform" generation = "1" } module "team_qa_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "TEAM_QA_WH" size = "XSMALL" statement_timeout_in_seconds = 21600 auto_suspend = 60 comment = "DWH for QA team purposes" team = "data-platform" generation = "1" } module "fivetran_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "FIVETRAN_WAREHOUSE" size = "XSMALL" auto_suspend = 60 statement_timeout_in_seconds = 604800 generation = "1" } module "qa_preference_center_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_PREFERENCE_CENTER_WH" size = "SMALL" auto_suspend = 60 max_cluster_count = 2 statement_timeout_in_seconds = 3600 resource_monitor_enabled = false team = "fansifter" generation = "1" } module "prod_preference_center_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_PREFERENCE_CENTER_WH" size = "SMALL" auto_suspend = 60 max_cluster_count = 2 statement_timeout_in_seconds = 3600 resource_monitor_enabled = false team = "fansifter" generation = "1" } module "team_l2_support_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "TEAM_L2_SUPPORT_WH" size = "XSMALL" statement_timeout_in_seconds = 604800 auto_suspend = 60 team = "data-platform" generation = "1" } module "kafka_data_highgway_team_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "KAFKA_DATA_HIGHWAY_WH" auto_suspend = 60 size = "XSMALL" team = "kafka-data-highway" generation = "1" } module "prod_martech_snowflake_salesforce_node_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_MARTECH_SNOWFLAKE_SALESFORCE_NODE_WH" auto_suspend = 60 size = "XSMALL" generation = "1" } module "chartmetric_analytics_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "CHARTMETRIC_ANALYTICS_WH" size = "SMALL" comment = "DWH for Chartmetric analytics users" auto_suspend = 60 max_cluster_count = 1 generation = "1" } module "sfmc_alerts_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SFMC_ALERTS_WH" size = "XSMALL" comment = "Snowflake SQL REST API for SFMC alerts" auto_suspend = 60 max_cluster_count = 1 generation = "1" } module "songwhip_segment_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SONGWHIP_SEGMENT_WH" size = "XSMALL" comment = "SYS-22959 snowflake-songwhip segment new destination." auto_suspend = 60 statement_timeout_in_seconds = 172800 team = "songwhip" generation = "1" } module "crm_fanresponse_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "CRM_FANRESPONSE_WH" comment = "DS-7346 Salesforce Transformation" size = "XSMALL" auto_suspend = 60 generation = "1" } module "qa_fansifter_fan_deletion_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_FANSIFTER_FAN_DELETION_WH" comment = "DS-9668 Fan deletion process" size = "XSMALL" auto_suspend = 60 team = "fansifter" } module "prod_fansifter_fan_deletion_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_FANSIFTER_FAN_DELETION_WH" comment = "DS-9668 Fan deletion process" size = "XSMALL" auto_suspend = 60 team = "fansifter" } module "segment_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SEGMENT_WH" comment = "SYS-22959 Segment integration warehouse" size = "XSMALL" max_cluster_count = 2 auto_suspend = 60 generation = "1" } module "sony_music_publishing_analyst_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SONY_MUSIC_PUBLISHING_ANALYST_WH" comment = "DS-7815 Sony music publishing analyst warehouse" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 generation = "1" } module "sony_orchrd_listing_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SONY_ORCHRD_LISTING" comment = "DS-7989 warehouse for delphi to orchrd listings" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 generation = "1" } module "sigma_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_SIGMA_WAREHOUSE" comment = "Warehouse for Sigma related workloads" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 statement_timeout_in_seconds = 7200 generation = 2 } # SME France module "sme_analytics_fr_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_FR_SMALL_WAREHOUSE" comment = "SME France (FR) Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-france" statement_timeout_in_seconds = 3600 } module "sme_analytics_fr_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_FR_MEDIUM_WAREHOUSE" comment = "SME France (FR) Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-france" statement_timeout_in_seconds = 3600 } module "sme_analytics_fr_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_FR_LARGE_WAREHOUSE" comment = "SME France (FR) Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-france" statement_timeout_in_seconds = 3600 } # SME Finland module "sme_analytics_fi_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_FI_SMALL_WAREHOUSE" comment = "SME Finland (FI) Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-finland" statement_timeout_in_seconds = 3600 } module "sme_analytics_fi_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_FI_MEDIUM_WAREHOUSE" comment = "SME Finland (FI) Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-finland" statement_timeout_in_seconds = 3600 } module "sme_analytics_fi_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_FI_LARGE_WAREHOUSE" comment = "SME Finland (FI) Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-finland" statement_timeout_in_seconds = 3600 } # SME Benelux module "sme_analytics_bx_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_BX_SMALL_WAREHOUSE" comment = "SME Benelux (BX) Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-benelux" statement_timeout_in_seconds = 3600 } module "sme_analytics_bx_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_BX_MEDIUM_WAREHOUSE" comment = "SME Benelux (BX) Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-benelux" statement_timeout_in_seconds = 3600 } module "sme_analytics_bx_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_BX_LARGE_WAREHOUSE" comment = "SME Benelux (BX) Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-benelux" statement_timeout_in_seconds = 3600 } # SME GSA module "sme_analytics_gsa_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_GSA_SMALL_WAREHOUSE" comment = "SME GSA Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-gsa" statement_timeout_in_seconds = 3600 } module "sme_analytics_gsa_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_GSA_MEDIUM_WAREHOUSE" comment = "SME GSA Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-gsa" statement_timeout_in_seconds = 3600 } module "sme_analytics_gsa_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_GSA_LARGE_WAREHOUSE" comment = "SME GSA Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-gsa" statement_timeout_in_seconds = 3600 } # SME UK module "sme_analytics_uk_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_UK_SMALL_WAREHOUSE" comment = "SME UK Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-uk" statement_timeout_in_seconds = 3600 } module "sme_analytics_uk_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_UK_MEDIUM_WAREHOUSE" comment = "SME UK Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-uk" statement_timeout_in_seconds = 3600 } module "sme_analytics_uk_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_UK_LARGE_WAREHOUSE" comment = "SME UK Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-uk" statement_timeout_in_seconds = 3600 } # SME Brazil module "sme_analytics_br_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_BR_SMALL_WAREHOUSE" comment = "SME Brazil (BR) Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-brazil" statement_timeout_in_seconds = 3600 } module "sme_analytics_br_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_BR_MEDIUM_WAREHOUSE" comment = "SME Brazil (BR) Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-brazil" statement_timeout_in_seconds = 3600 } module "sme_analytics_br_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_BR_LARGE_WAREHOUSE" comment = "SME Brazil (BR) Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-brazil" statement_timeout_in_seconds = 3600 } # SME Philippines module "sme_analytics_ph_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_PH_SMALL_WAREHOUSE" comment = "SME Philippines (PH) Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-philippines" statement_timeout_in_seconds = 3600 } module "sme_analytics_ph_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_PH_MEDIUM_WAREHOUSE" comment = "SME Philippines (PH) Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-philippines" statement_timeout_in_seconds = 3600 } module "sme_analytics_ph_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_PH_LARGE_WAREHOUSE" comment = "SME Philippines (PH) Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-philippines" statement_timeout_in_seconds = 3600 } # SME Insights & Reporting module "sme_analytics_insights_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_INSIGHTS_SMALL_WAREHOUSE" comment = "SME Insights & Reporting Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-insights-reporting" statement_timeout_in_seconds = 3600 } module "sme_analytics_insights_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_INSIGHTS_MEDIUM_WAREHOUSE" comment = "SME Insights & Reporting Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-insights-reporting" statement_timeout_in_seconds = 3600 } module "sme_analytics_insights_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_INSIGHTS_LARGE_WAREHOUSE" comment = "SME Insights & Reporting Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-insights-reporting" statement_timeout_in_seconds = 3600 } # SME Data Science & Analytics module "sme_analytics_data_science_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_DATA_SCIENCE_SMALL_WAREHOUSE" comment = "SME Data Science Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-data-science-and-analytics" statement_timeout_in_seconds = 3600 } module "sme_analytics_data_science_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_DATA_SCIENCE_MEDIUM_WAREHOUSE" comment = "SME Data Science Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-data-science-and-analytics" statement_timeout_in_seconds = 3600 } module "sme_analytics_data_science_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_DATA_SCIENCE_LARGE_WAREHOUSE" comment = "SME Data Science Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-data-science-and-analytics" statement_timeout_in_seconds = 3600 } # SME International Marketing module "sme_analytics_int_mktg_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_INT_MKTG_SMALL_WAREHOUSE" comment = "SME International Marketing Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-int-mktg" statement_timeout_in_seconds = 3600 } module "sme_analytics_int_mktg_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_INT_MKTG_MEDIUM_WAREHOUSE" comment = "SME International Marketing Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-int-mktg" statement_timeout_in_seconds = 3600 } module "sme_analytics_int_mktg_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_INT_MKTG_LARGE_WAREHOUSE" comment = "SME International Marketing Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-int-mktg" statement_timeout_in_seconds = 3600 } module "pde_sigma_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PDE_SIGMA_WAREHOUSE" comment = "Sigma Warehouse for PDE" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 auto_resume = true generation = 2 } module "quicksight_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QUICKSIGHT_WH" comment = "Quicksight Warehouse" size = "XLARGE" max_cluster_count = 2 scaling_policy = "ECONOMY" auto_suspend = 300 statement_timeout_in_seconds = 600 generation = "2" # TODO: enable monitor once atlantis permissions have been fixed resource_monitor_enabled = false } # SME Latin-Iberia module "sme_analytics_latiniberia_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_LATINIBERIA_SMALL_WAREHOUSE" comment = "SME Latin-Iberia Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-latiniberia" statement_timeout_in_seconds = 3600 } module "sme_analytics_latiniberia_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_LATINIBERIA_MEDIUM_WAREHOUSE" comment = "SME Latin-Iberia Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-latiniberia" statement_timeout_in_seconds = 3600 } module "sme_analytics_latiniberia_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_LATINIBERIA_LARGE_WAREHOUSE" comment = "SME Latin-Iberia Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-latiniberia" statement_timeout_in_seconds = 3600 } # SME Analytics Alamo module "sme_analytics_alamo_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_ALAMO_SMALL_WAREHOUSE" comment = "SME Analytics Alamo Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-alamo" statement_timeout_in_seconds = 3600 } module "sme_analytics_alamo_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_ALAMO_MEDIUM_WAREHOUSE" comment = "SME Analytics Alamo Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-alamo" statement_timeout_in_seconds = 3600 } module "sme_analytics_alamo_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_ALAMO_LARGE_WAREHOUSE" comment = "SME Analytics Alamo Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-alamo" statement_timeout_in_seconds = 3600 } # SME Analytics US RCA module "sme_analytics_us_rca_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_US_RCA_SMALL_WAREHOUSE" comment = "SME Analytics US RCA Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-us-rca" statement_timeout_in_seconds = 3600 } module "sme_analytics_us_rca_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_US_RCA_MEDIUM_WAREHOUSE" comment = "SME Analytics US RCA Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-us-rca" statement_timeout_in_seconds = 3600 } module "sme_analytics_us_rca_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_US_RCA_LARGE_WAREHOUSE" comment = "SME Analytics US RCA Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-us-rca" statement_timeout_in_seconds = 3600 } # SME Analytics US Columbia module "sme_analytics_us_columbia_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_US_COLUMBIA_SMALL_WAREHOUSE" comment = "SME Analytics US COLUMBIA Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-us-columbia" statement_timeout_in_seconds = 3600 } module "sme_analytics_us_columbia_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_US_COLUMBIA_MEDIUM_WAREHOUSE" comment = "SME Analytics US COLUMBIA Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-us-columbia" statement_timeout_in_seconds = 3600 } module "sme_analytics_us_columbia_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_US_COLUMBIA_LARGE_WAREHOUSE" comment = "SME Analytics US COLUMBIA Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-us-columbia" statement_timeout_in_seconds = 3600 } # Reporting DB module "sme_analytics_reporting_db_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_REPORTING_DB_SMALL_WAREHOUSE" comment = "SME Analytics Reporting DB Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "reporting-db" } module "sme_analytics_reporting_db_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_REPORTING_DB_MEDIUM_WAREHOUSE" comment = "SME Analytics Reporting DB Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "reporting-db" } module "sme_analytics_reporting_db_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_REPORTING_DB_LARGE_WAREHOUSE" comment = "SME Analytics Reporting DB Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "reporting-db" } module "exploration_sys_prod_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "EXPLORATION_SYS_PROD_WH" comment = "System warehouse for Exploration regular load. Not for ad-hoc queries" size = "XSMALL" max_cluster_count = 2 scaling_policy = "STANDARD" auto_suspend = 60 statement_timeout_in_seconds = 86400 team = "data-platform" generation = "1" } module "exploration_sys_prod_hl_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "EXPLORATION_SYS_PROD_HL_WH" comment = "System warehouse for Exploration heavy load. Not for ad-hoc queries" size = "MEDIUM" max_cluster_count = 2 scaling_policy = "STANDARD" auto_suspend = 60 statement_timeout_in_seconds = 86400 generation = "2" team = "data-platform" } module "ae_reporting_prod_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "AE_REPORTING_PROD_WH" comment = "Loading data to DELPHI_AE_REPORTING" size = "MEDIUM" auto_suspend = 60 statement_timeout_in_seconds = 86400 team = "data-platform" generation = "1" } # Orchard Analytics module "orchard_analytics_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "ORCHARD_ANALYTICS_SMALL_WAREHOUSE" comment = "Orchard Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 statement_timeout_in_seconds = 3600 team = "orchard-analytics" } module "orchard_analytics_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "ORCHARD_ANALYTICS_MEDIUM_WAREHOUSE" comment = "Orchard Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 statement_timeout_in_seconds = 3600 team = "orchard-analytics" } module "orchard_analytics_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "ORCHARD_ANALYTICS_LARGE_WAREHOUSE" comment = "Orchard Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 statement_timeout_in_seconds = 3600 team = "orchard-analytics" } module "prod_luminate_dbt_scheduler_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_LUMINATE_DBT_SCHEDULER_WH" comment = "dbt-luminate warehouse" size = "3X-LARGE" max_cluster_count = 1 auto_suspend = 60 generation = "2" statement_timeout_in_seconds = 1800 # 30 minutes } module "prod_luminate_dbt_scheduler_heavy_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_LUMINATE_DBT_SCHEDULER_HEAVY_WH" comment = "dbt-luminate warehouse for heavy workloads" size = "3X-LARGE" max_cluster_count = 1 auto_suspend = 60 statement_timeout_in_seconds = 10800 # 3 hours } module "prod_luminate_dbt_scheduler_light_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_LUMINATE_DBT_SCHEDULER_LIGHT_WH" comment = "dbt-luminate warehouse for light workloads" size = "XSMALL" max_cluster_count = 1 auto_suspend = 30 generation = "1" } # SME Poland module "sme_analytics_pl_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_PL_SMALL_WAREHOUSE" comment = "SME Poland (PL) Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-poland" statement_timeout_in_seconds = 3600 } module "sme_analytics_pl_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_PL_MEDIUM_WAREHOUSE" comment = "SME Poland (PL) Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-poland" statement_timeout_in_seconds = 3600 } module "sme_analytics_pl_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_PL_LARGE_WAREHOUSE" comment = "SME Poland (PL) Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-poland" statement_timeout_in_seconds = 3600 } # SME South Africa module "sme_analytics_south_africa_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_SOUTH_AFRICA_SMALL_WAREHOUSE" comment = "SME South Africa Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-south-africa" statement_timeout_in_seconds = 3600 } module "sme_analytics_south_africa_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_SOUTH_AFRICA_MEDIUM_WAREHOUSE" comment = "SME South Africa Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-south-africa" statement_timeout_in_seconds = 3600 } module "sme_analytics_south_africa_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_SOUTH_AFRICA_LARGE_WAREHOUSE" comment = "SME South Africa Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-south-africa" statement_timeout_in_seconds = 3600 } # SME Italy module "sme_analytics_it_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_IT_SMALL_WAREHOUSE" comment = "SME Italy (IT) Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-italy" statement_timeout_in_seconds = 3600 } module "sme_analytics_it_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_IT_MEDIUM_WAREHOUSE" comment = "SME Italy (IT) Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-italy" statement_timeout_in_seconds = 3600 } module "sme_analytics_it_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_IT_LARGE_WAREHOUSE" comment = "SME Italy (IT) Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-italy" statement_timeout_in_seconds = 3600 } # SME Norway module "sme_analytics_no_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_NO_SMALL_WAREHOUSE" comment = "SME Norway (NO) Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-norway" statement_timeout_in_seconds = 3600 } module "sme_analytics_no_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_NO_MEDIUM_WAREHOUSE" comment = "SME Norway (NO) Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-norway" statement_timeout_in_seconds = 3600 } module "sme_analytics_no_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_NO_LARGE_WAREHOUSE" comment = "SME Norway (NO) Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-norway" statement_timeout_in_seconds = 3600 } # SME Denmark module "sme_analytics_dk_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_DK_SMALL_WAREHOUSE" comment = "SME Denmark (DK) Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-denmark" statement_timeout_in_seconds = 3600 } module "sme_analytics_dk_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_DK_MEDIUM_WAREHOUSE" comment = "SME Denmark (DK) Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-denmark" statement_timeout_in_seconds = 3600 } module "sme_analytics_dk_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_DK_LARGE_WAREHOUSE" comment = "SME Denmark (DK) Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-denmark" statement_timeout_in_seconds = 3600 } # SME Sweden module "sme_analytics_se_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_SE_SMALL_WAREHOUSE" comment = "SME Sweden (SE) Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-sweden" statement_timeout_in_seconds = 3600 } module "sme_analytics_se_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_SE_MEDIUM_WAREHOUSE" comment = "SME Sweden (SE) Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-sweden" statement_timeout_in_seconds = 3600 } module "sme_analytics_se_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_SE_LARGE_WAREHOUSE" comment = "SME Sweden (SE) Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-sweden" statement_timeout_in_seconds = 3600 } # SME Turkey module "sme_analytics_tr_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_TR_SMALL_WAREHOUSE" comment = "SME Turkey (TR) Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-turkey" statement_timeout_in_seconds = 3600 } module "sme_analytics_tr_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_TR_MEDIUM_WAREHOUSE" comment = "SME Turkey (TR) Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-turkey" statement_timeout_in_seconds = 3600 } module "sme_analytics_tr_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_TR_LARGE_WAREHOUSE" comment = "SME Turkey (TR) Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-turkey" statement_timeout_in_seconds = 3600 } # SME Australia module "sme_analytics_au_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_AU_SMALL_WAREHOUSE" comment = "SME Australia (AU) Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-australia" statement_timeout_in_seconds = 3600 } module "sme_analytics_au_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_AU_MEDIUM_WAREHOUSE" comment = "SME Australia (AU) Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-australia" statement_timeout_in_seconds = 3600 } module "sme_analytics_au_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_AU_LARGE_WAREHOUSE" comment = "SME Australia (AU) Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-australia" statement_timeout_in_seconds = 3600 } # SME Strategy & Investments module "sme_analytics_strategy_investments_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_STRATEGY_INVESTMENTS_SMALL_WAREHOUSE" comment = "SME Analytics Strategy & Investments Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-strategy-investments" statement_timeout_in_seconds = 3600 } module "sme_analytics_strategy_investments_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_STRATEGY_INVESTMENTS_MEDIUM_WAREHOUSE" comment = "SME Analytics Strategy & Investments Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-strategy-investments" statement_timeout_in_seconds = 3600 } module "sme_analytics_strategy_investments_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_STRATEGY_INVESTMENTS_LARGE_WAREHOUSE" comment = "SME Analytics Strategy & Investments Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-strategy-investments" statement_timeout_in_seconds = 3600 } # AWAL Analytics module "awal_analytics_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "AWAL_ANALYTICS_SMALL_WAREHOUSE" comment = "AWAL Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "awal-analytics" statement_timeout_in_seconds = 3600 } module "awal_analytics_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "AWAL_ANALYTICS_MEDIUM_WAREHOUSE" comment = "AWAL Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "awal-analytics" statement_timeout_in_seconds = 3600 } module "awal_analytics_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "AWAL_ANALYTICS_LARGE_WAREHOUSE" comment = "AWAL Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "awal-analytics" statement_timeout_in_seconds = 3600 } # SME Robots & Humans module "sme_analytics_robots_humans_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_ROBOTS_HUMANS_SMALL_WAREHOUSE" comment = "SME Robots & Humans Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-robots-humans" statement_timeout_in_seconds = 3600 } module "sme_analytics_robots_humans_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_ROBOTS_HUMANS_MEDIUM_WAREHOUSE" comment = "SME Robots & Humans Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-robots-humans" statement_timeout_in_seconds = 3600 } module "sme_analytics_robots_humans_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_ROBOTS_HUMANS_LARGE_WAREHOUSE" comment = "SME Robots & Humans Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-robots-humans" statement_timeout_in_seconds = 3600 } # SME Canada module "sme_analytics_ca_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_CA_SMALL_WAREHOUSE" comment = "SME Canada (CA) Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-canada" statement_timeout_in_seconds = 3600 } module "sme_analytics_ca_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_CA_MEDIUM_WAREHOUSE" comment = "SME Canada (CA) Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-canada" statement_timeout_in_seconds = 3600 } module "sme_analytics_ca_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_CA_LARGE_WAREHOUSE" comment = "SME Canada (CA) Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-canada" statement_timeout_in_seconds = 3600 } # SME Partner Dev module "sme_asia_partner_dev_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ASIA_PARTNER_DEV_SMALL_WAREHOUSE" comment = "SME Asia Partner Dev Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-asia-partner-dev" statement_timeout_in_seconds = 3600 } module "sme_asia_partner_dev_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ASIA_PARTNER_DEV_MEDIUM_WAREHOUSE" comment = "SME Asia Partner Dev Analytics Warehouse - Medium " size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-asia-partner-dev" statement_timeout_in_seconds = 3600 } module "sme_asia_partner_dev_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ASIA_PARTNER_DEV_LARGE_WAREHOUSE" comment = "SME Asia Partner Dev Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-asia-partner-dev" statement_timeout_in_seconds = 3600 } # SME Spain module "sme_analytics_es_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_ES_SMALL_WAREHOUSE" comment = "SME Spain (ES) Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-spain" statement_timeout_in_seconds = 3600 } module "sme_analytics_es_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_ES_MEDIUM_WAREHOUSE" comment = "SME Spain (ES) Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-spain" statement_timeout_in_seconds = 3600 } module "sme_analytics_es_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_ES_LARGE_WAREHOUSE" comment = "SME Spain (ES) Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-spain" statement_timeout_in_seconds = 3600 } # SME China module "sme_analytics_cn_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_CN_SMALL_WAREHOUSE" comment = "SME China (CN) Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-china" statement_timeout_in_seconds = 3600 } module "sme_analytics_cn_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_CN_MEDIUM_WAREHOUSE" comment = "SME China (CN) Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-china" statement_timeout_in_seconds = 3600 } module "sme_analytics_cn_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_CN_LARGE_WAREHOUSE" comment = "SME China (CN) Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-china" statement_timeout_in_seconds = 3600 } # SME United Arab Emirates module "sme_analytics_ae_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_AE_SMALL_WAREHOUSE" comment = "SME United Arab Emirates (AE) Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-uae" statement_timeout_in_seconds = 3600 } module "sme_analytics_ae_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_AE_MEDIUM_WAREHOUSE" comment = "SME United Arab Emirates (AE) Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-uae" statement_timeout_in_seconds = 3600 } module "sme_analytics_ae_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_AE_LARGE_WAREHOUSE" comment = "SME United Arab Emirates (AE) Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-uae" statement_timeout_in_seconds = 3600 } # SME Mexico module "sme_analytics_mx_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_MX_SMALL_WAREHOUSE" comment = "SME Mexico (MX) Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-mexico" statement_timeout_in_seconds = 3600 } module "sme_analytics_mx_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_MX_MEDIUM_WAREHOUSE" comment = "SME Mexico (MX) Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-mexico" statement_timeout_in_seconds = 3600 } module "sme_analytics_mx_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_MX_LARGE_WAREHOUSE" comment = "SME Mexico (MX) Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-mexico" statement_timeout_in_seconds = 3600 } # SME 5020Records module "sme_analytics_5020records_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_5020RECORDS_SMALL_WAREHOUSE" comment = "SME 5020Records Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-5020records" statement_timeout_in_seconds = 3600 } module "sme_analytics_5020records_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_5020RECORDS_MEDIUM_WAREHOUSE" comment = "SME 5020Records Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-5020records" statement_timeout_in_seconds = 3600 } module "sme_analytics_5020records_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_5020RECORDS_LARGE_WAREHOUSE" comment = "SME 5020Records Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-5020records" statement_timeout_in_seconds = 3600 } # SME RecordsCo module "sme_analytics_recordsco_small" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_RECORDSCO_SMALL_WAREHOUSE" comment = "SME RecordsCo Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-recordsco" statement_timeout_in_seconds = 3600 } module "sme_analytics_recordsco_medium" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_RECORDSCO_MEDIUM_WAREHOUSE" comment = "SME RecordsCo Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-recordsco" statement_timeout_in_seconds = 3600 } module "sme_analytics_recordsco_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_RECORDSCO_LARGE_WAREHOUSE" comment = "SME RecordsCo Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-recordsco" statement_timeout_in_seconds = 3600 } # SME Arista module "sme_analytics_arista_small" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_ARISTA_SMALL_WAREHOUSE" comment = "SME Analytics Arista Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-arista" statement_timeout_in_seconds = 3600 } module "sme_analytics_arista_medium" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_ARISTA_MEDIUM_WAREHOUSE" comment = "SME Analytics Arista Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-arista" statement_timeout_in_seconds = 3600 } module "sme_analytics_arista_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_ARISTA_LARGE_WAREHOUSE" comment = "SME Analytics Arista Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-arista" statement_timeout_in_seconds = 3600 } # SME Epic module "sme_analytics_epic_small" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_EPIC_SMALL_WAREHOUSE" comment = "SME Epic Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-epic" statement_timeout_in_seconds = 3600 } module "sme_analytics_epic_medium" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_EPIC_MEDIUM_WAREHOUSE" comment = "SME Epic Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-epic" statement_timeout_in_seconds = 3600 } module "sme_analytics_epic_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_EPIC_LARGE_WAREHOUSE" comment = "SME Epic Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-epic" statement_timeout_in_seconds = 3600 } # SME Masterworks module "sme_analytics_masterworks_small" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_MASTERWORKS_SMALL_WAREHOUSE" comment = "SME Masterworks Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-masterworks" statement_timeout_in_seconds = 3600 } module "sme_analytics_masterworks_medium" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_MASTERWORKS_MEDIUM_WAREHOUSE" comment = "SME Masterworks Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-masterworks" statement_timeout_in_seconds = 3600 } module "sme_analytics_masterworks_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_MASTERWORKS_LARGE_WAREHOUSE" comment = "SME Masterworks Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-masterworks" statement_timeout_in_seconds = 3600 } # SME USRevenueAnalytics module "sme_analytics_us_revenue_small" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_US_REVENUE_SMALL_WAREHOUSE" comment = "SME US Revenue Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-us-revenue" statement_timeout_in_seconds = 3600 } module "sme_analytics_us_revenue_medium" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_US_REVENUE_MEDIUM_WAREHOUSE" comment = "SME US Revenue Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-us-revenue" statement_timeout_in_seconds = 3600 } module "sme_analytics_us_revenue_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_US_REVENUE_LARGE_WAREHOUSE" comment = "SME US Revenue Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-us-revenue" statement_timeout_in_seconds = 3600 } # SME SomLivre module "sme_analytics_somlivre_small" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_SOMLIVRE_SMALL_WAREHOUSE" comment = "SME SomLivre Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-somlivre" statement_timeout_in_seconds = 3600 } module "sme_analytics_somlivre_medium" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_SOMLIVRE_MEDIUM_WAREHOUSE" comment = "SME SomLivre Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-somlivre" statement_timeout_in_seconds = 3600 } module "sme_analytics_somlivre_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_SOMLIVRE_LARGE_WAREHOUSE" comment = "SME SomLivre Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-somlivre" statement_timeout_in_seconds = 3600 } # SME Indonesia module "sme_analytics_id_small" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_ID_SMALL_WAREHOUSE" comment = "SME Indonesia (ID) Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-indonesia" statement_timeout_in_seconds = 3600 } module "sme_analytics_id_medium" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_ID_MEDIUM_WAREHOUSE" comment = "SME Indonesia (ID) Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-indonesia" statement_timeout_in_seconds = 3600 } module "sme_analytics_id_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_ID_LARGE_WAREHOUSE" comment = "SME Indonesia (ID) Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-indonesia" statement_timeout_in_seconds = 3600 } # SME South Korea module "sme_analytics_kr_small" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_KR_SMALL_WAREHOUSE" comment = "SME South Korea Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-south-korea" statement_timeout_in_seconds = 3600 } module "sme_analytics_kr_medium" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_KR_MEDIUM_WAREHOUSE" comment = "SME South Korea Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-south-korea" statement_timeout_in_seconds = 3600 } module "sme_analytics_kr_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_KR_LARGE_WAREHOUSE" comment = "SME South Korea Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-south-korea" statement_timeout_in_seconds = 3600 } # D2C module "d2c_small" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "D2C_SMALL_WAREHOUSE" comment = "D2C Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "d2c" statement_timeout_in_seconds = 3600 } module "d2c_medium" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "D2C_MEDIUM_WAREHOUSE" comment = "D2C Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "d2c" statement_timeout_in_seconds = 3600 } module "d2c_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "D2C_LARGE_WAREHOUSE" comment = "D2C Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "d2c" statement_timeout_in_seconds = 3600 } # SME Taiwan module "sme_analytics_tw_small" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_TW_SMALL_WAREHOUSE" comment = "SME Taiwan (TW) Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-taiwan" statement_timeout_in_seconds = 3600 } module "sme_analytics_tw_medium" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_TW_MEDIUM_WAREHOUSE" comment = "SME Taiwan (TW) Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-taiwan" statement_timeout_in_seconds = 3600 } module "sme_analytics_tw_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_TW_LARGE_WAREHOUSE" comment = "SME Taiwan (TW) Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-taiwan" statement_timeout_in_seconds = 3600 } # SME Core Sales & Mktg Systems module "sme_analytics_core_sales_marketing_systems_small" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_CORE_SALES_MARKETING_SYSTEMS_SMALL_WAREHOUSE" comment = "SME Core Sales & Mktg Systems Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-core-sales-marketing-systems" statement_timeout_in_seconds = 3600 } module "sme_analytics_core_sales_marketing_systems_medium" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_CORE_SALES_MARKETING_SYSTEMS_MEDIUM_WAREHOUSE" comment = "SME Core Sales & Mktg Systems Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-core-sales-marketing-systems" statement_timeout_in_seconds = 3600 } module "sme_analytics_core_sales_marketing_systems_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_CORE_SALES_MARKETING_SYSTEMS_LARGE_WAREHOUSE" comment = "SME Core Sales & Mktg Systems Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-core-sales-marketing-systems" statement_timeout_in_seconds = 3600 } module "qa_luminate_dbt_scheduler_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_LUMINATE_DBT_SCHEDULER_WH" comment = "QA-dbt-luminate warehouse" size = "3X-LARGE" max_cluster_count = 1 auto_suspend = 60 generation = "2" statement_timeout_in_seconds = 10800 # 3 hours } module "qa_luminate_dbt_scheduler_heavy_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_LUMINATE_DBT_SCHEDULER_HEAVY_WH" comment = "dbt-luminate warehouse for heavy workloads" size = "3X-LARGE" max_cluster_count = 1 auto_suspend = 60 statement_timeout_in_seconds = 10800 # 3 hours } module "qa_luminate_dbt_scheduler_light_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_LUMINATE_DBT_SCHEDULER_LIGHT_WH" comment = "QA-dbt-luminate warehouse for light workloads" size = "XSMALL" max_cluster_count = 1 auto_suspend = 30 generation = "1" } module "prod_shopify_global_dbt_scheduler_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_SHOPIFY_GLOBAL_DBT_SCHEDULER_WH" comment = "dbt shopify-global-schema prod warehouse" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 statement_timeout_in_seconds = 3600 # 1 hour } module "qa_shopify_global_dbt_scheduler_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_SHOPIFY_GLOBAL_DBT_SCHEDULER_WH" comment = "dbt shopify-global-schema QA warehouse" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 statement_timeout_in_seconds = 3600 # 1 hour } # SME India module "sme_analytics_in_small" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_IN_SMALL_WAREHOUSE" comment = "SME India Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-india" statement_timeout_in_seconds = 3600 } module "sme_analytics_in_medium" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_IN_MEDIUM_WAREHOUSE" comment = "SME India Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-india" statement_timeout_in_seconds = 3600 } module "sme_analytics_in_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_IN_LARGE_WAREHOUSE" comment = "SME India Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-india" statement_timeout_in_seconds = 3600 } # SME Colombia module "sme_analytics_co_small" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_CO_SMALL_WAREHOUSE" comment = "SME Colombia Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-colombia" statement_timeout_in_seconds = 3600 } module "sme_analytics_co_medium" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_CO_MEDIUM_WAREHOUSE" comment = "SME Colombia Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-colombia" statement_timeout_in_seconds = 3600 } module "sme_analytics_co_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_CO_LARGE_WAREHOUSE" comment = "SME Colombia Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-colombia" statement_timeout_in_seconds = 3600 } module "global_finance_small" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "GLOBAL_FINANCE_SMALL_WAREHOUSE" comment = "Global Finance Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "global-finance" statement_timeout_in_seconds = 3600 } module "global_finance_medium" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "GLOBAL_FINANCE_MEDIUM_WAREHOUSE" comment = "Global Finance Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "global-finance" statement_timeout_in_seconds = 3600 } module "global_finance_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "GLOBAL_FINANCE_LARGE_WAREHOUSE" comment = "Global Finance Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "global-finance" statement_timeout_in_seconds = 3600 } # SME US Nashville module "sme_analytics_us_nashville_small" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_US_NASHVILLE_SMALL_WAREHOUSE" comment = "SME US Nashville Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-us-nashville" statement_timeout_in_seconds = 3600 } module "sme_analytics_us_nashville_medium" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_US_NASHVILLE_MEDIUM_WAREHOUSE" comment = "SME US Nashville Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-us-nashville" statement_timeout_in_seconds = 3600 } module "sme_analytics_us_nashville_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_US_NASHVILLE_LARGE_WAREHOUSE" comment = "SME US Nashville Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-us-nashville" statement_timeout_in_seconds = 3600 } # SME Digital Ops module "sme_analytics_digital_ops_small" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_DIGITAL_OPS_SMALL_WAREHOUSE" comment = "SME Digital Ops Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-digital-ops" statement_timeout_in_seconds = 3600 } module "sme_analytics_digital_ops_medium" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_DIGITAL_OPS_MEDIUM_WAREHOUSE" comment = "SME Digital Ops Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-digital-ops" statement_timeout_in_seconds = 3600 } module "sme_analytics_digital_ops_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_DIGITAL_OPS_LARGE_WAREHOUSE" comment = "SME Digital Ops Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-digital-ops" statement_timeout_in_seconds = 3600 } # SME Repertoire Management module "SME_REPERTOIRE_MANAGEMENT_small" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_REPERTOIRE_MANAGEMENT_SMALL_WAREHOUSE" comment = "SME Repertoire Management Analytics Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-repertoire-management" statement_timeout_in_seconds = 3600 } module "SME_REPERTOIRE_MANAGEMENT_medium" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_REPERTOIRE_MANAGEMENT_MEDIUM_WAREHOUSE" comment = "SME Repertoire Management Analytics Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-repertoire-management" statement_timeout_in_seconds = 3600 } module "SME_REPERTOIRE_MANAGEMENT_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_REPERTOIRE_MANAGEMENT_LARGE_WAREHOUSE" comment = "SME Repertoire Management Analytics Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-repertoire-management" statement_timeout_in_seconds = 3600 } module "qa_fansifter_streamlit_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_FANSIFTER_STREAMLIT_WH" comment = "For running dev/qa Streamlit apps managed by Fansifter team" size = "XSMALL" auto_suspend = 60 team = "fansifter" } module "prod_fansifter_streamlit_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_FANSIFTER_STREAMLIT_WH" comment = "For running prod Streamlit apps managed by Fansifter team" size = "XSMALL" auto_suspend = 60 team = "fansifter" } # SME Global Tech module "sme_global_tech_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_GLOBAL_TECH_SMALL_WAREHOUSE" comment = "SME Global Tech Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-global-tech" statement_timeout_in_seconds = 3600 } module "sme_global_tech_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_GLOBAL_TECH_MEDIUM_WAREHOUSE" comment = "SME Global Tech Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-global-tech" statement_timeout_in_seconds = 3600 } module "sme_global_tech_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_GLOBAL_TECH_LARGE_WAREHOUSE" comment = "SME Global Tech Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-global-tech" statement_timeout_in_seconds = 3600 } module "apollo_dev_jobs_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "APOLLO_DEV_JOBS_WH" comment = "APM-416" size = "SMALL" max_cluster_count = 2 auto_suspend = 60 max_concurrency_level = 3 statement_queued_timeout_in_seconds = 600 statement_timeout_in_seconds = 3600 generation = "1" } module "apollo_prod_jobs_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "APOLLO_PROD_JOBS_WH" comment = "APM-416" size = "SMALL" max_cluster_count = 2 auto_suspend = 60 max_concurrency_level = 3 statement_queued_timeout_in_seconds = 600 statement_timeout_in_seconds = 3600 generation = "1" } module "apollo_team_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "APOLLO_TEAM_WH" comment = "Warehouse for Apollo team usage (DAE-10449)" size = "SMALL" auto_suspend = 60 statement_timeout_in_seconds = 86400 auto_resume = false generation = "1" } module "ads_data_prod_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "ADS_DATA_PROD_WH" auto_suspend = 60 statement_timeout_in_seconds = 86400 generation = "1" } module "app_enablement_prod_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "APP_ENABLEMENT_PROD_WAREHOUSE" size = "SMALL" auto_suspend = 60 statement_timeout_in_seconds = 86400 generation = "1" } module "app_enablement_reader" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "APP_ENABLEMENT_READER" auto_suspend = 60 statement_timeout_in_seconds = 86400 generation = "1" } module "chartmetric_prod_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "CHARTMETRIC_PROD_WH" size = "MEDIUM" auto_suspend = 60 statement_timeout_in_seconds = 86400 generation = "1" } module "charts_sys_prod_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "CHARTS_SYS_PROD_WH" auto_suspend = 60 statement_timeout_in_seconds = 86400 generation = "1" } module "charts_sys_prod_wh_xs" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "CHARTS_SYS_PROD_WH_XS" size = "MEDIUM" auto_suspend = 60 statement_timeout_in_seconds = 86400 generation = "1" } module "crm_ae_powerbi_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "CRM_AE_POWERBI_WH" comment = "Warehouse created to power the PowerBI dashboards using AE data for the CRM team" size = "LARGE" auto_suspend = 300 statement_timeout_in_seconds = 3600 generation = "1" } module "crm_data_prod_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "CRM_DATA_PROD_WH" comment = "Warehouse used for CRM ETL and admin tasks" auto_suspend = 120 statement_timeout_in_seconds = 86400 generation = "1" } module "crm_ecommerce_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "CRM_ECOMMERCE_WH" size = "MEDIUM" auto_suspend = 60 statement_timeout_in_seconds = 86400 generation = "1" } module "crm_wave_dashboard" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "CRM_WAVE_DASHBOARD" comment = "Wave Dashboard on Power BI" size = "MEDIUM" max_cluster_count = 2 scaling_policy = "ECONOMY" auto_suspend = 180 statement_timeout_in_seconds = 86400 generation = "1" } module "dae11890_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "DAE11890_WH" comment = "Performance and cost testing for marketing initiative." auto_suspend = 300 statement_timeout_in_seconds = 86400 generation = "1" } module "dae12436_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "DAE12436_WH" comment = "Temporary warehouse to verify on DAE12436" size = "3X-LARGE" auto_suspend = 6 statement_timeout_in_seconds = 86400 generation = 2 } module "decibel_pbi_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "DECIBEL_PBI_WH" comment = "DEXP-3417" size = "MEDIUM" auto_suspend = 60 statement_timeout_in_seconds = 86400 generation = "1" } module "deploy_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "DEPLOY_WAREHOUSE" comment = "Deploy warehouse" size = "2X-LARGE" auto_suspend = 60 statement_timeout_in_seconds = 172800 } module "dexp3127_dna_m_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "DEXP3127_DNA_M_WH" comment = "Temporary warehouse to work on DEXP-3127: DNA app (used to be named Whitelist)" size = "MEDIUM" max_cluster_count = 3 auto_suspend = 60 statement_timeout_in_seconds = 86400 generation = "1" } module "dexp3127_dna_s_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "DEXP3127_DNA_S_WH" comment = "Temporary warehouse to work on DEXP-3127: DNA app (used to be named Whitelist)" size = "SMALL" max_cluster_count = 2 scaling_policy = "ECONOMY" auto_suspend = 60 statement_timeout_in_seconds = 86400 generation = "1" } module "dna_dev_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "DNA_DEV_WH" comment = "Warehouse to work with DNA_DEV/DNA_STAKEHOLDER roles - manual interaction with DB (human)" size = "SMALL" auto_suspend = 60 statement_timeout_in_seconds = 86400 auto_resume = false generation = "1" } module "dna_non_prod_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "DNA_NON_PROD_WH" comment = "Warehouse to work with DNA_NON_PROD role - automation purposes (computer)" size = "SMALL" auto_suspend = 60 statement_timeout_in_seconds = 86400 auto_resume = false generation = "1" } module "dna_prod_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "DNA_PROD_WH" comment = "Warehouse to work with DNA_PROD role - automation purposes (computer)" size = "SMALL" auto_suspend = 60 statement_timeout_in_seconds = 86400 auto_resume = false generation = "1" } module "exploration_apps_etl_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "EXPLORATION_APPS_ETL_WH" size = "MEDIUM" min_cluster_count = 2 max_cluster_count = 8 auto_suspend = 60 statement_timeout_in_seconds = 86400 generation = "1" } module "exploration_decibel_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "EXPLORATION_DECIBEL_WH" size = "SMALL" auto_suspend = 60 statement_timeout_in_seconds = 86400 generation = "1" } module "exploration_retrieval_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "EXPLORATION_RETRIEVAL_WH" size = "MEDIUM" max_cluster_count = 4 scaling_policy = "ECONOMY" auto_suspend = 60 statement_timeout_in_seconds = 86400 generation = "1" } module "exploration_sys_orch_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "EXPLORATION_SYS_ORCH_WH" auto_suspend = 60 statement_timeout_in_seconds = 86400 generation = "1" } module "fivetran_dbt_models" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "FIVETRAN_DBT_MODELS" comment = "Warehouse used to run DBT models" size = "SMALL" max_cluster_count = 2 auto_suspend = 60 statement_timeout_in_seconds = 86400 generation = "1" } module "legacy_yt_poc_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "LEGACY_YT_POC_WH" comment = "DEXP-3206 Warehouse for Legacy Dashboard POC" auto_suspend = 600 statement_timeout_in_seconds = 86400 generation = "1" } module "linkfire_prod_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "LINKFIRE_PROD_WH" auto_suspend = 60 statement_timeout_in_seconds = 86400 generation = "1" } module "pc_hightouch_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PC_HIGHTOUCH_WH" comment = "System created warehouse for partner etl integration." size = "MEDIUM" auto_suspend = 60 statement_timeout_in_seconds = 86400 generation = "1" } module "poc_dynamic_table_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "POC_DYNAMIC_TABLE_WH" comment = "DEXP-3420" size = "LARGE" auto_suspend = 60 statement_timeout_in_seconds = 604800 generation = "1" } module "prod_fivetran" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_FIVETRAN" comment = "Warehouse for Fivetran Orchard POC (DAE-10372)" auto_suspend = 60 statement_timeout_in_seconds = 86400 generation = "1" } module "sfsupport_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SFSUPPORT_WH" size = "LARGE" auto_suspend = 3600 statement_timeout_in_seconds = 86400 } module "sme_germany_ft_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_GERMANY_FT_WH" comment = "Warehouse to track fivetran compute (Sony Germany Team)" auto_suspend = 60 statement_timeout_in_seconds = 86400 generation = "1" } module "sme_germany_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_GERMANY_WH" comment = "Warehouse to track compute for Sony Germany ads team" auto_suspend = 600 statement_timeout_in_seconds = 86400 generation = "1" } module "snowflake_learning_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SNOWFLAKE_LEARNING_WH" comment = "Created by Snowflake during account provisioning" auto_suspend = 300 statement_timeout_in_seconds = 86400 generation = 1 } module "sony_publishing_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SONY_PUBLISHING_WH" comment = "The warehouse for Sony Publishing Team computing" auto_suspend = 60 statement_timeout_in_seconds = 86400 generation = "1" } module "team_apollo_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "TEAM_APOLLO_WH" comment = "The separate WH for Apollo/ReportingDB purposes" auto_suspend = 60 statement_timeout_in_seconds = 86400 generation = "1" } module "tmp_sigma" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "TMP_SIGMA" size = "MEDIUM" scaling_policy = "ECONOMY" auto_suspend = 300 statement_timeout_in_seconds = 86400 generation = "1" } module "whitelist_prod_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "WHITELIST_PROD_WH" comment = "Loading data to WHITELIST_REPLICA" size = "SMALL" auto_suspend = 60 statement_timeout_in_seconds = 86400 generation = "1" } # SWF ETL Warehouses: module "prod_swf_etl_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_SWF_ETL_WAREHOUSE" comment = "Prod SWF ETL warehouse" max_cluster_count = 1 size = "MEDIUM" auto_suspend = 300 statement_timeout_in_seconds = 18000 team = "data-platform" } module "qa_swf_etl_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_SWF_ETL_WAREHOUSE" comment = "QA SWF ETL warehouse" max_cluster_count = 1 size = "MEDIUM" auto_suspend = 300 statement_timeout_in_seconds = 18000 team = "data-platform" } module "shopify_global_stores_medium_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SHOPIFY_GLOBAL_STORES_MEDIUM_WAREHOUSE" comment = "Fivetran shopify global stores warehouse" size = "MEDIUM" team = "data-platform" max_cluster_count = 1 auto_suspend = 60 statement_timeout_in_seconds = 3600 } module "acct_reporting_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "ACCT_REPORTING_WAREHOUSE" size = "SMALL" auto_resume = false auto_suspend = 900 statement_timeout_in_seconds = 172800 } module "ad_hoc_mgmt_reports" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "AD_HOC_MGMT_REPORTS" size = "2X-LARGE" auto_suspend = 120 max_cluster_count = 2 } module "analytics_ad_hoc" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "ANALYTICS_AD_HOC" size = "MEDIUM" auto_suspend = 60 comment = "Deprecated Orchard BI Team Medium Warehouse" max_cluster_count = 3 } module "analytics_dbt_forecasting" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "ANALYTICS_DBT_FORECASTING" size = "MEDIUM" auto_suspend = 300 } module "awal_ar_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "AWAL_AR_WH" size = "SMALL" auto_resume = true auto_suspend = 60 comment = "SYS-24202" } module "awal_dev_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "AWAL_DEV_WAREHOUSE" size = "X-LARGE" auto_suspend = 60 comment = "SYS-20160 AWAL Parity with Orchard BI - Snowflake database space" max_cluster_count = 2 } module "awal_looker_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "AWAL_LOOKER_WH" size = "SMALL" auto_suspend = 120 comment = "Jira Ticket: SYS-20105" max_cluster_count = 7 } module "bi_etl_jobs_standard" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "BI_ETL_JOBS_STANDARD" size = "X-SMALL" auto_suspend = 3600 comment = "For BI ETL Jobs" } module "cron_jobs_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "CRON_JOBS_LARGE" size = "X-LARGE" auto_suspend = 900 comment = "For Automated & Scheduled Jobs that need a larger cluster" } module "cron_jobs_small" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "CRON_JOBS_SMALL" size = "X-SMALL" auto_suspend = 1800 comment = "For use in nightly-scheduled Cron jobs, when the job does not require speed" max_cluster_count = 5 } module "datalytics_etl_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "DATALYTICS_ETL_WAREHOUSE" size = "X-LARGE" auto_suspend = 300 } module "data_beta_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "DATA_BETA_WAREHOUSE" size = "SMALL" auto_suspend = 300 comment = "Test warehouse used for analytics dashboard in workstation." } module "dense_rank_test" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "DENSE_RANK_TEST" size = "X-SMALL" auto_resume = false auto_suspend = 3600 } module "dev_analytics_orchard" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "DEV_ANALYTICS_ORCHARD" size = "MEDIUM" max_cluster_count = 3 } module "dev_analytics_orchard_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "DEV_ANALYTICS_ORCHARD_LARGE" size = "LARGE" auto_suspend = 60 comment = "Orchard Analytics Team dev warehouse for ad-hoc work that require a larger cluster" max_cluster_count = 3 } module "dev_datadog_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "DEV_DATADOG_WAREHOUSE" size = "X-SMALL" comment = "DataDog metric collector warehouse" } module "dev_datalytics_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "DEV_DATALYTICS_WAREHOUSE" size = "2X-LARGE" auto_resume = false auto_suspend = 900 } module "dev_ows_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "DEV_OWS_WAREHOUSE" size = "X-SMALL" auto_suspend = 60 } module "dev_performance_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "DEV_PERFORMANCE_WAREHOUSE" size = "LARGE" auto_suspend = 60 max_cluster_count = 2 } module "fa2_backfill" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "FA2_BACKFILL" size = "MEDIUM" auto_resume = false auto_suspend = 300 comment = "Warehouse for FA 2.0 backfill. (Destroy at end of project)" } module "gdoc_sync" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "GDOC_SYNC" size = "X-SMALL" auto_suspend = 3600 comment = "This is the warehouse that is run whenever there is a delta in a google doc vs s3" } module "knr_looker_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "KNR_LOOKER_WH" size = "SMALL" auto_suspend = 120 comment = "Orchard BI Team Warehouse for KNR Looker Users" max_cluster_count = 7 statement_timeout_in_seconds = 14400 } module "load_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "LOAD_WH" size = "MEDIUM" auto_suspend = 900 comment = "standard-server warehouse for loading data" team = "data-platform" } module "looker_dynamic_table_refresh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "LOOKER_DYNAMIC_TABLE_REFRESH" size = "X-SMALL" } module "looker_high_performance" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "LOOKER_HIGH_PERFORMANCE" size = "LARGE" auto_suspend = 120 max_cluster_count = 2 } module "looker_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "LOOKER_WH" size = "MEDIUM" auto_suspend = 600 comment = "LOOKER_WH" max_cluster_count = 7 statement_timeout_in_seconds = 14400 } module "looker_wh_2" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "LOOKER_WH_2" size = "MEDIUM" auto_suspend = 120 comment = "Jira ticket: SYS-20108" max_cluster_count = 7 } module "looker_wh_abacus" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "LOOKER_WH_ABACUS" size = "2X-LARGE" auto_suspend = 60 comment = "Jira Ticket: ACC-10709" max_cluster_count = 7 } module "looker_wh_accounting_aggregates" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "LOOKER_WH_ACCOUNTING_AGGREGATES" size = "MEDIUM" auto_suspend = 120 max_cluster_count = 7 } module "looker_wh_explore" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "LOOKER_WH_EXPLORE" size = "MEDIUM" auto_suspend = 600 comment = "LOOKER_WH_EXPLORE" max_cluster_count = 7 statement_timeout_in_seconds = 14400 } module "looker_wh_integration" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "LOOKER_WH_INTEGRATION" size = "MEDIUM" auto_suspend = 600 max_cluster_count = 7 } module "looker_wh_orchard_biz_rev" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "LOOKER_WH_ORCHARD_BIZ_REV" size = "MEDIUM" auto_suspend = 300 max_cluster_count = 7 } module "looker_wh_pde" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "LOOKER_WH_PDE" size = "MEDIUM" auto_suspend = 120 max_cluster_count = 7 } module "looker_wh_publishing" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "LOOKER_WH_PUBLISHING" size = "MEDIUM" auto_suspend = 120 max_cluster_count = 7 } module "looker_wh_sony" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "LOOKER_WH_SONY" size = "SMALL" auto_suspend = 120 comment = "Orchard BI Team Warehouse for Sony Music Users" max_cluster_count = 7 statement_timeout_in_seconds = 14400 } module "looker_wh_sony_podcasting" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "LOOKER_WH_SONY_PODCASTING" size = "MEDIUM" auto_suspend = 300 max_cluster_count = 7 } module "looker_wh_strategy" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "LOOKER_WH_STRATEGY" size = "MEDIUM" auto_suspend = 120 max_cluster_count = 7 } module "looker_wh_x_small" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "LOOKER_WH_X_SMALL" size = "MEDIUM" auto_suspend = 300 max_cluster_count = 7 } module "looker_wh_youtube" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "LOOKER_WH_YOUTUBE" size = "MEDIUM" auto_suspend = 120 max_cluster_count = 7 } module "marketing_integrations" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "MARKETING_INTEGRATIONS" size = "X-SMALL" } module "mysql_connector_compute_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "MYSQL_CONNECTOR_COMPUTE_WH" size = "X-SMALL" auto_suspend = 600 } module "operations_reporting_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "OPERATIONS_REPORTING_WAREHOUSE" size = "SMALL" auto_suspend = 300 comment = "Ops reporting warehouse" scaling_policy = "ECONOMY" } module "ops_looker_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "OPS_LOOKER_WH" size = "MEDIUM" auto_suspend = 300 comment = "Ops Looker Warehouse" max_cluster_count = 7 generation = "1" } module "orchard_biz_browse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "ORCHARD_BIZ_BROWSE" size = "SMALL" auto_suspend = 600 max_cluster_count = 7 statement_timeout_in_seconds = 3600 } module "orchard_youtube_browse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "ORCHARD_YOUTUBE_BROWSE" size = "SMALL" statement_timeout_in_seconds = 3600 } module "physical_reporting_large_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PHYSICAL_REPORTING_LARGE_WAREHOUSE" size = "LARGE" auto_resume = true auto_suspend = 60 comment = "Physical Reporting Warehouse - Large" max_cluster_count = 1 statement_timeout_in_seconds = 3600 team = "physical-reporting" generation = "1" } module "physical_reporting_medium_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PHYSICAL_REPORTING_MEDIUM_WAREHOUSE" size = "MEDIUM" auto_resume = true auto_suspend = 60 comment = "Physical Reporting Warehouse - Medium" max_cluster_count = 1 statement_timeout_in_seconds = 3600 team = "physical-reporting" generation = "1" } module "physical_reporting_small_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PHYSICAL_REPORTING_SMALL_WAREHOUSE" size = "SMALL" auto_resume = true auto_suspend = 60 comment = "Physical Reporting Warehouse - Small" max_cluster_count = 1 statement_timeout_in_seconds = 3600 team = "physical-reporting" generation = "1" } module "pipedream_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PIPEDREAM_WAREHOUSE" size = "MEDIUM" auto_resume = true auto_suspend = 600 comment = "SYS-22956" } module "prod_abacus_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_ABACUS_WH" size = "2X-LARGE" auto_suspend = 300 comment = "Jira Ticket: SYS-20521" max_cluster_count = 4 statement_timeout_in_seconds = 172800 team = "abacus" } module "prod_accounting_dbt_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_ACCOUNTING_DBT_WAREHOUSE" size = "3X-LARGE" auto_resume = true auto_suspend = 60 comment = "Prod accounting dbt warehouse" max_cluster_count = 3 statement_timeout_in_seconds = 18000 generation = "1" } module "prod_analytics_dbt_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_ANALYTICS_DBT_WAREHOUSE" size = "LARGE" auto_suspend = 300 max_cluster_count = 2 } module "prod_analytics_orchard_backfill" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_ANALYTICS_ORCHARD_BACKFILL" size = "LARGE" auto_suspend = 300 comment = "Orchard Analytics Team prod warehouse for backfill jobs." max_cluster_count = 3 } module "prod_analytics_orchard_external" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_ANALYTICS_ORCHARD_EXTERNAL" size = "MEDIUM" auto_suspend = 60 comment = "Orchard Analytics Team prod warehouse for moving data to external teams." max_cluster_count = 3 } module "prod_analytics_orchard_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_ANALYTICS_ORCHARD_LARGE" size = "LARGE" auto_suspend = 300 comment = "Orchard Analytics Team prod warehouse for jobs that require a larger cluster" max_cluster_count = 3 } module "prod_analytics_orchard_medium" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_ANALYTICS_ORCHARD_MEDIUM" size = "MEDIUM" auto_suspend = 300 comment = "Prod Orchard BI Team Medium Warehouse" max_cluster_count = 3 } module "prod_analytics_orchard_small" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_ANALYTICS_ORCHARD_SMALL" size = "SMALL" auto_suspend = 300 comment = "Prod Orchard BI Team Small Warehouse" max_cluster_count = 3 } module "prod_analytics_orchard_tableau" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_ANALYTICS_ORCHARD_TABLEAU" size = "MEDIUM" max_cluster_count = 3 generation = "1" } module "prod_analytics_orchard_xl" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_ANALYTICS_ORCHARD_XL" size = "X-LARGE" auto_suspend = 300 comment = "XL Orchard Analytics Team warehouse for ETL jobs." max_cluster_count = 3 statement_timeout_in_seconds = 14400 } module "prod_async_reporting_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_ASYNC_REPORTING_WAREHOUSE" size = "MEDIUM" auto_suspend = 300 statement_timeout_in_seconds = 172800 } module "prod_cortex_search_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_CORTEX_SEARCH_WAREHOUSE" size = "X-SMALL" auto_suspend = 60 statement_timeout_in_seconds = 300 generation = "1" } module "prod_datadog_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_DATADOG_WAREHOUSE" size = "X-SMALL" comment = "DataDog metric collector warehouse" statement_timeout_in_seconds = 172800 } module "prod_dbt_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_DBT_WAREHOUSE" size = "3X-LARGE" auto_resume = true auto_suspend = 60 comment = "Prod dbt warehouse" max_cluster_count = 4 statement_timeout_in_seconds = 18000 generation = "1" } module "prod_etl_accounting_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_ETL_ACCOUNTING_WAREHOUSE" size = "MEDIUM" auto_suspend = 60 statement_timeout_in_seconds = 172800 } module "prod_etl_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_ETL_WAREHOUSE" size = "LARGE" auto_suspend = 300 comment = "Prod ETL warehouse" generation = 2 max_cluster_count = 2 statement_timeout_in_seconds = 18000 team = "data-platform" } module "prod_fansifter_fan_engagement_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_FANSIFTER_FAN_ENGAGEMENT_WAREHOUSE" size = "X-LARGE" auto_resume = true auto_suspend = 60 comment = "Used for calculating Fansifter fan engagement metrics" statement_timeout_in_seconds = 14400 } module "prod_fivetran_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_FIVETRAN_WAREHOUSE" size = "X-SMALL" auto_suspend = 600 generation = 2 max_cluster_count = 2 statement_timeout_in_seconds = 172800 } module "prod_insights_playlists_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_INSIGHTS_PLAYLISTS_WAREHOUSE" size = "SMALL" auto_resume = true auto_suspend = 60 enable_query_acceleration = false max_cluster_count = 1 min_cluster_count = 1 query_acceleration_max_scale_factor = 2 scaling_policy = "STANDARD" statement_timeout_in_seconds = 60 team = "insights" } module "prod_insights_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_INSIGHTS_WAREHOUSE" size = "MEDIUM" auto_suspend = 0 generation = 2 max_cluster_count = 3 max_concurrency_level = 10 min_cluster_count = 3 scaling_policy = "STANDARD" statement_timeout_in_seconds = 60 team = "insights" } module "prod_iq_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_IQ_WAREHOUSE" size = "SMALL" auto_suspend = 300 statement_timeout_in_seconds = 172800 } module "prod_kafka_connect_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_KAFKA_CONNECT_WH" size = "X-SMALL" auto_suspend = 300 statement_timeout_in_seconds = 18000 team = "kafka-data-highway" } module "prod_knr_orchard_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_KNR_ORCHARD_LARGE" size = "LARGE" auto_suspend = 300 comment = "Prod KNR Team Large Warehouse" max_cluster_count = 3 } module "prod_knr_orchard_medium" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_KNR_ORCHARD_MEDIUM" size = "MEDIUM" auto_suspend = 300 comment = "Prod KNR Team Medium Warehouse" max_cluster_count = 3 } module "prod_mode_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_MODE_WAREHOUSE" size = "MEDIUM" auto_suspend = 300 max_cluster_count = 2 } module "prod_moments" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_MOMENTS" size = "LARGE" } module "prod_ows_conflict_manager_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_OWS_CONFLICT_MANAGER_WAREHOUSE" size = "MEDIUM" auto_suspend = 300 max_cluster_count = 2 statement_timeout_in_seconds = 7200 } module "prod_ows_reporting_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_OWS_REPORTING_WAREHOUSE" size = "MEDIUM" auto_suspend = 900 comment = "PROD_OWS_REPORTING_WAREHOUSE" statement_timeout_in_seconds = 172800 } module "prod_ows_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_OWS_WAREHOUSE" size = "MEDIUM" auto_suspend = 0 max_cluster_count = 2 max_concurrency_level = 10 min_cluster_count = 1 scaling_policy = "STANDARD" } module "prod_playlist_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_PLAYLIST_WAREHOUSE" size = "LARGE" max_cluster_count = 2 statement_timeout_in_seconds = 172800 team = "insights" } module "prod_qa_automation_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_QA_AUTOMATION_WAREHOUSE" size = "XSMALL" auto_resume = true auto_suspend = 60 comment = "DS-7906" } module "prod_revenue_file_ingestion_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_REVENUE_FILE_INGESTION_WH" comment = "For running REVENUE_FILE_INGESTION (formerly SlaughterHouse) PROD workloads" size = "XSMALL" auto_suspend = 60 team = "abacus" } module "prod_sales_processing_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_SALES_PROCESSING_WH" comment = "For running SALES_PROCESSING PROD workloads to share PDE data with STARS for single supply chain sales processing" size = "SMALL" auto_suspend = 60 team = "abacus" } module "prod_rights_mgmt_orchard_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_RIGHTS_MGMT_ORCHARD_LARGE" size = "LARGE" auto_suspend = 300 comment = "Prod Orchard Rights Management Team Large Warehouse" max_cluster_count = 3 } module "prod_rights_mgmt_orchard_medium" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_RIGHTS_MGMT_ORCHARD_MEDIUM" size = "MEDIUM" auto_suspend = 300 comment = "Prod Orchard Rights Management Team Medium Warehouse" max_cluster_count = 3 } module "prod_royaltyshare_fivetran_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_ROYALTYSHARE_FIVETRAN_WAREHOUSE" size = "X-SMALL" auto_suspend = 15 statement_timeout_in_seconds = 172800 } module "prod_shopify_integrations_fivetran" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_SHOPIFY_INTEGRATIONS_FIVETRAN" size = "X-SMALL" } module "prod_strategy_orchard_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_STRATEGY_ORCHARD_LARGE" size = "LARGE" auto_suspend = 300 comment = "Prod Orchard Strategy Team Large Warehouse" max_cluster_count = 3 } module "prod_strategy_orchard_medium" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_STRATEGY_ORCHARD_MEDIUM" size = "MEDIUM" auto_suspend = 300 comment = "Prod Orchard Strategy Team Medium Warehouse" max_cluster_count = 3 } module "prod_swf_collaborator_report" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_SWF_COLLABORATOR_REPORT" size = "LARGE" auto_suspend = 60 comment = "PROD_SWF_COLLABORATOR_REPORT" max_cluster_count = 3 } module "prod_task_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "PROD_TASK_WAREHOUSE" size = "X-SMALL" auto_resume = true auto_suspend = 300 comment = "Prod Snowflake task warehouse" max_cluster_count = 2 statement_timeout_in_seconds = 18000 generation = "1" } module "qa_abacus_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_ABACUS_WH" size = "2X-LARGE" auto_suspend = 60 comment = "Jira Ticket: SYS-20521" max_cluster_count = 4 team = "abacus" } module "qa_accounting_dbt_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_ACCOUNTING_DBT_WAREHOUSE" size = "3X-LARGE" auto_resume = true auto_suspend = 60 enable_query_acceleration = true max_cluster_count = 3 query_acceleration_max_scale_factor = 2 statement_timeout_in_seconds = 18000 generation = "1" } module "qa_cortex_search_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_CORTEX_SEARCH_WAREHOUSE" size = "X-SMALL" auto_suspend = 60 statement_timeout_in_seconds = 300 generation = "1" } module "qa_dbt_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_DBT_WAREHOUSE" size = "LARGE" auto_suspend = 60 enable_query_acceleration = false max_cluster_count = 1 statement_timeout_in_seconds = 3600 } module "qa_etl_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_ETL_WAREHOUSE" size = "MEDIUM" auto_suspend = 300 statement_timeout_in_seconds = 18000 team = "data-platform" } module "qa_insights_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_INSIGHTS_WAREHOUSE" size = "MEDIUM" max_cluster_count = 1 scaling_policy = "STANDARD" statement_timeout_in_seconds = 60 team = "insights" } module "qa_kafka_connect_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_KAFKA_CONNECT_WH" size = "X-SMALL" auto_suspend = 300 statement_timeout_in_seconds = 18000 team = "kafka-data-highway" } module "qa_mode_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_MODE_WAREHOUSE" size = "MEDIUM" auto_suspend = 300 max_cluster_count = 2 } module "qa_ows_conflict_manager_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_OWS_CONFLICT_MANAGER_WAREHOUSE" size = "MEDIUM" auto_suspend = 300 max_cluster_count = 1 statement_timeout_in_seconds = 7200 } module "qa_ows_reporting_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_OWS_REPORTING_WAREHOUSE" size = "MEDIUM" auto_suspend = 60 comment = "QA_OWS_REPORTING_WAREHOUSE" } module "qa_ows_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_OWS_WAREHOUSE" size = "MEDIUM" auto_suspend = 60 } module "qa_playlist_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_PLAYLIST_WAREHOUSE" size = "LARGE" team = "insights" } module "qa_revenue_file_ingestion_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_REVENUE_FILE_INGESTION_WH" comment = "For running REVENUE_FILE_INGESTION (formerly SlaughterHouse) QA workloads" size = "XSMALL" auto_suspend = 60 team = "abacus" } module "qa_sales_processing_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_SALES_PROCESSING_WH" comment = "For running SALES_PROCESSING QA workloads to share PDE data with STARS for single supply chain sales processing" size = "XSMALL" auto_suspend = 60 team = "abacus" } module "qa_royaltyshare_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_ROYALTYSHARE_WAREHOUSE" size = "MEDIUM" auto_suspend = 60 generation = "1" } module "qa_shopify_integrations_fivetran" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_SHOPIFY_INTEGRATIONS_FIVETRAN" size = "X-SMALL" comment = "QA_SHOPIFY_INTEGRATIONS_FIVETRAN" } module "qa_swf_collaborator_report" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_SWF_COLLABORATOR_REPORT" size = "LARGE" } module "qa_task_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "QA_TASK_WAREHOUSE" size = "X-SMALL" auto_resume = true auto_suspend = 300 comment = "QA Snowflake task warehouse" max_cluster_count = 1 statement_timeout_in_seconds = 18000 generation = "1" } module "sagemaker" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SAGEMAKER" size = "MEDIUM" } module "scheduler_jenkins_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SCHEDULER_JENKINS_WH" size = "MEDIUM" auto_suspend = 300 max_cluster_count = 7 } module "science" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SCIENCE" size = "X-SMALL" auto_suspend = 300 } module "segment_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SEGMENT_WAREHOUSE" size = "X-SMALL" auto_suspend = 60 comment = "SEGMENT_WAREHOUSE" statement_timeout_in_seconds = 172800 } module "sf_test_high_memory_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SF_TEST_HIGH_MEMORY_WAREHOUSE" size = "3X-LARGE" auto_resume = false auto_suspend = 900 } module "smej_warehouse_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SMEJ_WAREHOUSE_LARGE" size = "LARGE" auto_suspend = 300 max_cluster_count = 2 } module "smej_warehouse_small" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SMEJ_WAREHOUSE_SMALL" size = "SMALL" auto_suspend = 300 max_cluster_count = 2 } module "sme_dev_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_DEV_WAREHOUSE" size = "MEDIUM" auto_suspend = 300 comment = "Created for ticket SYS-22238" max_cluster_count = 2 } module "sme_jv_spotify_sales_etl" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_JV_SPOTIFY_SALES_ETL" size = "SMALL" auto_suspend = 600 max_cluster_count = 2 } module "sme_poc" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_POC" size = "X-LARGE" auto_suspend = 300 } module "snowflake_intelligence_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SNOWFLAKE_INTELLIGENCE_WH" size = "X-SMALL" auto_resume = true auto_suspend = 300 comment = "Snowflake Intelligence POC SYS-25910" generation = "1" } module "snowflake_notebooks_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SNOWFLAKE_NOTEBOOKS_WAREHOUSE" size = "X-SMALL" auto_resume = true auto_suspend = 60 comment = "Used by data science team to run Snowflake notebooks" statement_timeout_in_seconds = 1800 } module "sony_internal_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SONY_INTERNAL_WH" size = "X-SMALL" auto_suspend = 300 } module "sony_internal_wh_large" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SONY_INTERNAL_WH_LARGE" size = "LARGE" auto_suspend = 300 max_cluster_count = 2 statement_timeout_in_seconds = 86400 } module "spotify_backfill_etl_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SPOTIFY_BACKFILL_ETL_WAREHOUSE" size = "X-LARGE" auto_suspend = 600 } module "streamlit_data_apps_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "STREAMLIT_DATA_APPS_WH" size = "X-SMALL" auto_resume = true auto_suspend = 300 generation = "1" } module "swf_activity_detector" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SWF_ACTIVITY_DETECTOR" size = "MEDIUM" auto_suspend = 60 comment = "Prod & QA swf-acitivity-detector warehouse" max_cluster_count = 2 scaling_policy = "ECONOMY" statement_timeout_in_seconds = 172800 team = "data-platform" } module "swf_sme_analytics_ingest_data_backload" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SWF_SME_ANALYTICS_INGEST_DATA_BACKLOAD" size = "X-LARGE" auto_suspend = 600 max_cluster_count = 2 statement_timeout_in_seconds = 172800 team = "data-platform" } module "temp_statementdb_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "TEMP_STATEMENTDB_WAREHOUSE" size = "SMALL" auto_resume = true auto_suspend = 1800 comment = "Used for statementdb to snowflake POC" statement_timeout_in_seconds = 1800 } module "uat_abacus_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "UAT_ABACUS_WH" size = "2X-LARGE" auto_suspend = 300 max_cluster_count = 4 team = "abacus" } module "uat_cortex_search_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "UAT_CORTEX_SEARCH_WAREHOUSE" size = "X-SMALL" auto_suspend = 60 statement_timeout_in_seconds = 300 } module "uat_etl_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "UAT_ETL_WAREHOUSE" size = "MEDIUM" auto_suspend = 300 statement_timeout_in_seconds = 18000 team = "data-platform" } module "uat_ows_warehouse" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "UAT_OWS_WAREHOUSE" size = "SMALL" auto_suspend = 300 comment = "UAT version of QA_OWS_WAREHOUSE used by lambda-documents-close-balance" } module "youtube_etl" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "YOUTUBE_ETL" size = "X-SMALL" auto_resume = false auto_suspend = 2700 comment = "ETLs from the YT API (mostly used by Leon's py scripts)" } # SME Analytics US provident label group module "sme_analytics_us_provident_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_US_PROVIDENT_SMALL_WAREHOUSE" comment = "SME Analytics US PROVIDENT Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-us-provident" statement_timeout_in_seconds = 3600 } module "sme_analytics_us_provident_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_US_PROVIDENT_MEDIUM_WAREHOUSE" comment = "SME Analytics US PROVIDENT Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-us-provident" statement_timeout_in_seconds = 3600 } module "sme_analytics_us_provident_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_ANALYTICS_US_PROVIDENT_LARGE_WAREHOUSE" comment = "SME Analytics US PROVIDENT Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_suspend = 60 team = "sme-analytics-us-provident" statement_timeout_in_seconds = 3600 } # SME GDB Business Development module "sme_gdb_business_development_small_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_GDB_BUSINESS_DEVELOPMENT_SMALL_WAREHOUSE" comment = "SME GDB Business Development Warehouse - Small" size = "SMALL" max_cluster_count = 1 auto_resume = true auto_suspend = 60 team = "sme-gdb-business-development" statement_timeout_in_seconds = 3600 } module "sme_gdb_business_development_medium_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_GDB_BUSINESS_DEVELOPMENT_MEDIUM_WAREHOUSE" comment = "SME GDB Business Development Warehouse - Medium" size = "MEDIUM" max_cluster_count = 1 auto_resume = true auto_suspend = 60 team = "sme-gdb-business-development" statement_timeout_in_seconds = 3600 } module "sme_gdb_business_development_large_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "SME_GDB_BUSINESS_DEVELOPMENT_LARGE_WAREHOUSE" comment = "SME GDB Business Development Warehouse - Large" size = "LARGE" max_cluster_count = 1 auto_resume = true auto_suspend = 60 team = "sme-gdb-business-development" statement_timeout_in_seconds = 3600 } module "business_solutions_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "BUSINESS_SOLUTIONS_WH" comment = "Warehouse for Business Solutions team to run ad-hoc queries and data exploration from AirTable requests" size = "SMALL" max_cluster_count = 1 auto_resume = true auto_suspend = 60 statement_timeout_in_seconds = 3600 } module "fact_analytics_backfill_DS_10291_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "fact_analytics_backfill_ds_10291_wh" comment = "Warehouse for backfilling fact_analytics for DS-10291" size = "XLARGE" max_cluster_count = 1 auto_resume = true auto_suspend = 60 statement_timeout_in_seconds = 3600 generation = "2" } module "revenue_file_ingestion_fivetran_wh" { source = "git@github.com:theorchard/terraform-snowflake.git//modules/warehouse?ref=7.7.9" name = "REVENUE_FILE_INGESTION_FIVETRAN_WH" size = "X-SMALL" comment = "Warehouse for Fivetran ingestion of the stmt-db tables" }