// all variables are required
variable "snowflake_stage_name" {
  type        = string
  description = "The name of the Snowflake stage to create. This stage will be used by the Snowflake storage integration to access the S3 bucket."
  default     = "STARS_MANUAL_PRODUCT_MAPPING_TABLE"
}

variable "snowflake_stage_url" {
  type        = string
  description = "The URL of the Snowflake stage to create. This should be in the format of s3://bucket-name/path/."
  default     = "s3://prod-orcdbucket/feed-drop/SonyInternal/Stars/"
}

variable "snowflake_stage_database" {
  type        = string
  description = "The name of the Snowflake database to create the stage in."
  default     = "SONY_INTERNAL"
}

variable "snowflake_stage_qa_schema" {
  type        = string
  description = "The name of the Snowflake schema to create the stage in."
  default     = "QA"
}

variable "snowflake_stage_prod_schema" {
  type        = string
  description = "The name of the Snowflake schema to create the stage in."
  default     = "PROD"
}

variable "snowflake_storage_integration_name" {
  type        = string
  description = "The name of the Snowflake storage integration to create. This integration will be used by the Snowflake stage to access the S3 bucket."
  default     = "PROD_ORCDBUCKET_FEED_SONY_INTERNAL_STARS_INTEGRATION"
}

variable "snowflake_storage_allowed_locations" {
  type        = list(string)
  description = "The list of allowed locations for the Snowflake storage integration. This should be in the format of s3://bucket-name/path/."
  default = [
    "s3://prod-orcdbucket/feed-drop/SonyInternal/Stars/",
  ]
}

variable "snowflake_storage_aws_role_arn" {
  type        = string
  description = "The ARN of the AWS IAM role that the Snowflake storage integration will assume to access the S3 bucket."
  default     = "arn:aws:iam::437795906767:role/prod-integrations-snowflake-integration-role"
}