I’ve added this {{ config(grants = {‘+select’: [‘reporter_finance’]}) }} to the top of my data model in dbt (according to grants | dbt Developer Hub). The data model was built without error message. The view was populated into my dev environment, but I did not see the role 'reporter_finance’has select privileges to the view.
I’m doing this becasue the views and tables under a schema should have different permission granted to different roles. I’m trying to manage permission from dbt.
I’ve already made sure the role ‘reporter_finance’ was indeed created in Snowflake.
Any idea what else I should do to properly grant read access for this ‘reporter_finance’ role from dbt?