provider "snowflake" {
  account_name             = "delphi"
  role                     = "PROD_ATLANTIS"
  preview_features_enabled = ["snowflake_table_resource"]
}

module "database" {
  source = "../../../modules/database"

  database_name = "TERRAFORM_SNOWFLAKE_TEST"

  schemas = [
    {
      name    = "SCHEMA_A"
      managed = false
    },
  ]
}

resource "snowflake_table" "test_1" {
  database = module.database.database_name
  schema   = "SCHEMA_A"
  name     = "TEST_TABLE_1"

  column {
    name = "id"
    type = "NUMBER(38,0)"
  }

  depends_on = [module.database]
}

module "role" {
  source                  = "../../../modules/roles/table_access"
  database                = module.database.database_name
  schema                  = "SCHEMA_A"
  table                   = snowflake_table.test_1.name
  enable_write_privileges = true
}