Open elventear opened 1 month ago
We are seeing a similar issue with our builds on when the role needs quoting - dbt-snowflake produces revoke <PRIVILEGE> on <TABLE> from downcased_role_name
instead of revoke <PRIVILEGE> on <TABLE> from "downcased_role_name"
Is this a new bug in dbt-snowflake?
Current Behavior
DBT is failing to deploy a materialization during the grants revoke phase if the table has database roles applied to it. The failure stems from issuing the wrong syntax for database roles:
where it should be:
Reviewing the code the issue seems to stem from the macro
default__apply_grants
where it is getting bothROLE
andDATABASE_ROLE
entries in the results fromSHOW GRANTS ON
, but it is treating them all as account roles.Expected Behavior
Deployment should not fail.
Steps To Reproduce
Relevant log output
Additional Context
No response