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

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

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

  database_name                                = var.database_name
  grant_roles_to_sysadmin                      = false
  grant_read_role_to_all_db_read_role          = false
  grant_streamlit_usage_to_all_streamlit_usage = false

  schemas = [
    {
      "name" = "PROD",
    },
  ]
}