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

provider "snowflake" {
  account_name = var.account
  role         = "PROD_ATLANTIS"
}

provider "snowflake" {
  alias        = "useradmin"
  account_name = var.account
  role         = "USERADMIN"
}

provider "snowflake" {
  alias        = "securityadmin"
  account_name = var.account
  role         = "SECURITYADMIN"
}

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

  database_name = var.database_name
  schemas       = var.schemas
}