Using the Snowflake provider for Terraform I am able to grant “all” privileges to all tables in a schema as follows:
resource “snowflake_grant_privileges_to_role” “grant_all_tables” {
provider = snowflake.nadr-securityadmin
privileges = [“SELECT”]
role_name = snowflake_role.pt_ppw_dev_stg_all_reader_role.name
on_schema_object {
all {
object_type_plural = “TABLES”
in_schema = “"{snowflake_database.src_ppw_dev.name}\".\"{snowflake_schema.stg.name}"”
}
}
}
How would I grant to “all” tables using Snowflake CDKTF (Typescript) for Terraform (cdktf-provider-snowflake)?