provider "snowflake" {
  account_name = "delphi"
  role         = "PROD_ATLANTIS"
}

provider "snowflake" {
  alias        = "useradmin"
  account_name = "delphi"
  role         = "USERADMIN"
}

provider "snowflake" {
  alias        = "securityadmin"
  account_name = "delphi"
  role         = "SECURITYADMIN"
}

terraform {
  backend "s3" {
    bucket  = "orcd-terraform-state"
    key     = "prod/snowflake/delphi/databases/marketing-roi-project/terraform.tfstate"
    region  = "us-east-1"
    encrypt = "true"
  }
}

module "marketing_roi_project_db" {
  source = "git@github.com:theorchard/terraform-snowflake.git//modules/database?ref=7.7.9"

  database_name         = var.database_name
  schemas               = var.schemas
  enable_account_roles  = true
  enable_database_roles = false
}