Kar's questions

需求：需要给var中的值赋值。选择数据库名称、架构名称和表名称

我想将每个 table_name 授予 share_name

问题 ：

│   19:   dynamic "schema_name" {
│
│ Blocks of type "schema_name" are not expected here.

代码：下面是我写的但无法解决问题

resource "snowflake_table_grant" "grant" {
  for_each = var.select

  database_name = each.key

  dynamic "schema_name" {
    for_each = each.value
    content {
      schema_name = schema_name.key

      dynamic "table_name" {
        for_each = schema_name.value
        content {
          table_name = table_name.value

          privilege         = "SELECT"
          roles             = ["role1"]
          shares            = ["share1"]
          on_future         = false
          with_grant_option = false
        }
      }
    }
  }
}

变量.tf

variable "select" {
  type    = map(map(list(string)))
  default = {
    database1 = {
      schema1 = ["table1", "table2"],
      schema2 = ["table3", "table4"],
    },
  }
}

要求：要获取在所有行中具有唯一值的 single_address_object 示例如下数据，国家和地区在所有行中都是通用的

     id , address
     ----------------
    111 , {   "City": "Garner",   "Country": "US",   "County": "Hancock",   "Line1": "490 W 8th St",   "PostalCode": "50438",   "Region": "TX" }
    111 , {   "City": "Colleyville",   "Country": "US",   "County": "Tarrant",   "Line1": "1002 Saddlebrook Dr",   "PostalCode": "76034",   "Region": "TX" }
    111 , {   "City": "Dublin",   "Country": "US",   "County": "Franklin",   "Line1": "545 Metro Pl S Ste 100",   "PostalCode": "43017",   "Region": "TX" }

输出

需要如下新列

    single_address_object
    ----------------------
    {"Country:"US", "Region":"TX"}