"Show with OnAllSchemasInDatabase option is skipped" warning? 🤔

[chrisweis]

Does anyone know what this means, and what I should do about it?

│ Warning: Show with OnAllSchemasInDatabase option is skipped.
│ 
│   with snowflake_grant_privileges_to_account_role.RESOURCENAME,
│   on grant_privileges_to_account_role.tf line 32, in resource "snowflake_grant_privileges_to_account_role" "RESOURCENAME":
│   32: resource "snowflake_grant_privileges_to_account_role" "RESOURCENAME" {
│ 
│ See our document on design decisions for grants: <LINK (coming soon)>
╵

Looks like it's coming from here in the code.

My TF code:

resource "snowflake_grant_privileges_to_account_role" "ENV_DW_DB__ALL_SCHEMAS__DBT_ENV_ROLE" {
  account_role_name  = "DBT_${var.ENV}_ROLE"
  privileges = ["USAGE","CREATE TABLE","CREATE VIEW","MODIFY"]
  on_schema {
    all_schemas_in_database = snowflake_database.ENV_DW_DB.name
  }
  depends_on = [snowflake_database.ENV_DW_DB, snowflake_schema.ENV_DW_DB__DW_STAGING]
  with_grant_option = true
}

Thanks,
Chris

[sfc-gh-asawicki]

Hey @chrisweis. Thanks for reaching out to us.

There's nothing to worry about. We used the warning message here but we already got some complaints about it. We will decrease its level to INFO message. It should land in the 0.87.0 release.