module "lambda_snowflake_query" {
  source = "git@github.com:theorchard/terraform-lambda.git//?ref=5.3.0"

  environment                                    = var.environment
  lambda_name                                    = "lambda-${var.service_name}-sf_query"
  application_family                             = var.application_family
  lambda_description                             = "Lambda function to query Snowflake"
  use_container_image                            = true
  datadog_advanced_enabled                       = true
  vpc_enabled                                    = true
  vpc_id                                         = module.vpc_info.vpc_id
  vpc_subnet_ids                                 = module.vpc_info.default_private_subnet_ids
  lambda_function_timeout                        = 900
  lambda_function_memory_size                    = 4096
  lambda_function_reserved_concurrent_executions = 10
  splitio_enabled                                = false
  zappa_s3_policy_enabled                        = false
  iam_managed_policy_attachments = [
    aws_iam_policy.business_solutions_automations_secrets_manager_read_policy.arn,
    aws_iam_policy.sf_query_results_s3_read_write_policy.arn,
  ]

  lambda_function_environment_variables = {
    ENVIRONMENT  = var.environment
    SERVICE_NAME = "lambda-${var.service_name}-snowflake_query"
  }
}

module "lambda_snowflake_query_secrets_manager" {
  source   = "git@github.com:theorchard/terraform-secrets-manager.git//?ref=1.5.1"
  for_each = toset(var.lambda_snowflake_query_secrets_names)

  environment                    = var.environment
  service_name                   = var.service_name
  secret_name                    = each.value
  application_family             = var.application_family
  secret_recovery_window_in_days = 7
}