Grant access to all tables in share

[natashamathur]

I've created a share to share out data from our main Snowflake database. We gave the share permission using:

resource "snowflake_grant_privileges_to_share" "xyz_share_grant" {

xyz_share now has access to the database and schema, but not all the tables within it. How do you do the equivalent of:

grant all on all tables in schema xyz_schema to share xyz_share

with the new granting patterns?

[sfc-gh-jcieslak]

you cannot grant "all" privileges to share, it's not available (see here). But with specified privileges I guess it would look something like:

resource "snowflake_grant_privileges_to_share" "xyz_share_grant" {
  to_share = "todo"
  privileges = ["todo"]
  on_all_tables_in_schema = "todo"
}