variable "aws_region" {
  default     = "us-east-1"
  description = "Fargate AWS region"
}

variable "environment" {
  description = "Available values:  dev, qa, prod"
  default     = "prod"
}

variable "service_name" {
  default = "snowflake-etl"
}

variable "application_family" {
  default = "accounting"
}

variable "team_name" {
  default = "data-platform"
}

variable "feed_ingestion_table" {
  default = "prod_feed_ingestion_status"
}

variable "feed_sender_table" {
  default = "prod_feed_sender_status"
}

variable "loggly_uri" {
  default = "https://logs-01.loggly.com/bulk/6d6d489b-56a2-46f2-8038-414c5561d2f6/tag/ows1,snowflake-etl/"
}

variable "logger_dsn" {
  default = "https://prod-fluentd-applications.theorchard.io:8888/application"
}

variable "mysql_art_relations_host" {
  default = "reportsar.theorchard.com"
}

variable "mysql_art_relations_port" {
  default = "3306"
}

variable "mysql_art_relations_user" {
  default = "ar-etl"
}

variable "mysql_content_review_host" {
  default = "prod-ows-content-review.cb22xqmk0y0q.us-east-1.rds.amazonaws.com"
}

variable "mysql_content_review_port" {
  default = "3306"
}

variable "mysql_content_review_user" {
  default = "snowflake-etl"
}

variable "mysql_ft_host" {
  default = "ows-film-transparency.cb22xqmk0y0q.us-east-1.rds.amazonaws.com"
}

variable "mysql_ft_port" {
  default = "3306"
}

variable "mysql_ft_user" {
  default = "ows-ft-etl"
}

variable "mysql_ows_host" {
  default = "prod-daemon-youtube-ownership.cluster-cb22xqmk0y0q.us-east-1.rds.amazonaws.com"
}

variable "mysql_ows_port" {
  default = "3306"
}

variable "mysql_ows_user" {
  default = "ows-ytoship-etl"
}

variable "mysql_pricing_host" {
  default = "ows-film-transparency-replica-1.cb22xqmk0y0q.us-east-1.rds.amazonaws.com"
}

variable "mysql_pricing_port" {
  default = "3306"
}

variable "mysql_pricing_user" {
  default = "ows-pricing-etl"
}

variable "mysql_promo_player_host" {
  default = "prod-promo-player.cb22xqmk0y0q.us-east-1.rds.amazonaws.com"
}

variable "mysql_promo_player_port" {
  default = "3306"
}

variable "mysql_promo_player_user" {
  default = "ows_promo_player"
}

variable "mysql_research_collections_host" {
  default = "research-collections.cb22xqmk0y0q.us-east-1.rds.amazonaws.com"
}

variable "mysql_research_collections_port" {
  default = "3306"
}

variable "mysql_research_collections_user" {
  default = "ppb-etl"
}

variable "mysql_sg_host" {
  default = "prod-ows-sales-goals.cluster-cb22xqmk0y0q.us-east-1.rds.amazonaws.com"
}

variable "mysql_sg_port" {
  default = "3306"
}

variable "mysql_sg_user" {
  default = "ows-sg-etl"
}

variable "mysql_sony_metadata_host" {
  default = "prod-ows-sony-metadata.cluster-cb22xqmk0y0q.us-east-1.rds.amazonaws.com"
}

variable "mysql_sony_metadata_port" {
  default = "3306"
}

variable "mysql_sony_metadata_user" {
  default = "ows-sm-etl"
}

variable "mysql_ss_host" {
  default = "prod-ows-salessheets.cluster-cb22xqmk0y0q.us-east-1.rds.amazonaws.com"
}

variable "mysql_ss_port" {
  default = "3306"
}

variable "mysql_ss_user" {
  default = "ows-ss-etl"
}

variable "mysql_statements_host" {
  default = "statementdb.theorchard.io"
}

variable "mysql_statements_port" {
  default = "3306"
}

variable "mysql_statements_user" {
  default = "ows-st-etl"
}

variable "mysql_ytoship_host" {
  default = "prod-daemon-youtube-ownership.cluster-cb22xqmk0y0q.us-east-1.rds.amazonaws.com"
}

variable "mysql_ytoship_port" {
  default = "3306"
}

variable "mysql_ytoship_user" {
  default = "ows-ytoship-etl"
}

variable "pgoptions" {
  default = "-c statement_timeout=0"
}

variable "red_spotify_samis_sns_topic" {
  default = "arn:aws:sns:us-east-1:437795906767:prod_red_samis_smart"
}

variable "reportsar02_art_relations_host" {
  default = "reportsar02.theorchard.com"
}

variable "reportsar02_art_relations_port" {
  default = "3306"
}

variable "reportsar02_art_relations_user" {
  default = "snowflake-etl"
}

variable "sf_db" {
  default = "PROD"
}

variable "sf_jdbc_jar" {
  default = "/var/app/snowflake_jdbc.jar"
}

variable "sf_schema" {
  default = "production"
}

variable "sf_user" {
  default = "SWF_ETL_LOADER"
}

variable "sf_whse" {
  default = "PROD_ETL_WAREHOUSE"
}

variable "snowflake_account" {
  default = "delphi.us-east-1"
}

variable "snowflake_database" {
  default = "PROD"
}

variable "snowflake_role" {
  default = "SYSADMIN"
}

variable "snowflake_schema" {
  default = "production"
}

variable "snowflake_user" {
  default = "SNOWFLAKE_ETL"
}

variable "snowflake_warehouse" {
  default = "PROD_ETL_WAREHOUSE"
}

variable "sns_topic_auto_cleanup" {
  default = "arn:aws:sns:us-east-1:437795906767:prod-rs2sf-auto-cleanup"
}

variable "spotify_snowflake_account" {
  default = "delphi.us-east-1"
}

variable "spotify_snowflake_role" {
  default = "SWF_SPOTIFY_OUTGOING"
}

variable "spotify_snowflake_user" {
  default = "SWF_ETL_LOADER"
}

variable "spotify_snowflake_warehouse" {
  default = "PROD_ETL_WAREHOUSE"
}

variable "sql2sf_status_table" {
  default = "prod_sql2sf_table_sync_status"
}

variable "monitor_notification_endpoint" {
  default = "@slack-abacus-monitoring"
}

variable "additional_tags" {
  default = {
    "map-migrated" = "d-server-02m51bf1hoyfhr"
  }
}

variable "secrets_manager_secret_names" {
  description = "List of secrets manager secrets to create"
  type        = list(string)
  default = [
    "AWS_ACCESS_KEY_ID",
    "AWS_SECRET_ACCESS_KEY",
    "MYSQL_ART_RELATIONS_PASSWORD",
    "MYSQL_CONTENT_REVIEW_PASSWORD",
    "MYSQL_FT_PASSWORD",
    "MYSQL_OWS_PASSWORD",
    "MYSQL_PRICING_PASSWORD",
    "MYSQL_PROMO_PLAYER_PASSWORD",
    "MYSQL_RESEARCH_COLLECTIONS_PASSWORD",
    "MYSQL_SG_PASSWORD",
    "MYSQL_SONY_METADATA_PASSWORD",
    "MYSQL_SS_PASSWORD",
    "MYSQL_STATEMENTS_PASSWORD",
    "MYSQL_YTOSHIP_PASSWORD",
    "REPORTSAR02_ART_RELATIONS_PASSWORD",
    "SF_PASS",
    "SNOWFLAKE_PASSWORD",
    "SPOTIFY_SNOWFLAKE_PASSWORD",
    "SNOWFLAKE_KEY"
  ]
}