需求:需要给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"],
},
}
}