[Feature]: STREAMLITS - Enable ALL and FUTURE grants in snowflake_grant_privileges_to_database_role

[jarach]

Company Name

No response

Use Cases or Problem Statement

Since 2024_08 bundle it is possible to GRANT USAGE FUTURE STREAMLITS IN SCHEMA ... TO DATABASE ROLE ...

Unfortunately it is missing in Snowflake provider:
Error: expected [{{} on_schema_object} {{} {{{{} 78}} 0xc001058750}} {{} future} {{} {{{{} 78}} 0xc0010592c0}} {{} object_type_plural}] to be one of ["ALERTS" "AUTHENTICATION POLICIES" "DATA METRIC FUNCTIONS" "DYNAMIC TABLES" "EVENT TABLES" "EXTERNAL TABLES" "FILE FORMATS" "FUNCTIONS" "GIT REPOSITORIES" "HYBRID TABLES" "ICEBERG TABLES" "MATERIALIZED VIEWS" "MODELS" "NETWORK RULES" "NOTEBOOKS" "PASSWORD POLICIES" "PIPES" "PROCEDURES" "SECRETS" "SERVICES" "SEQUENCES" "SNAPSHOTS" "STAGES" "STREAMS" "TABLES" "TASKS" "VIEWS" "DATASETS"], got STREAMLITS

Category

category:grants

Object type(s)

resource:grant_privileges_to_database_role

Proposal

Enable STREAMLIT for ALL and FUTURE grants in snowflake_grant_privileges_to_database_role

How much impact is this issue causing?

Medium

Additional Information

No response

Would you like to implement a fix?

• Yeah, I'll take it 😎

[sfc-gh-jcieslak]

Hey @jarach 👋
I'll try to squeeze it into the next provider version. As you can see in the documentation STREAMLITS are allowed for on_all, but were disabled for on_future, because of the Snowflake error. Currently, it seems to work, so I'll update the validation rules.