provider "snowflake" {
  account_name  = "delphi"
}

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

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

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

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