Hi all,
I deploy dbt-docs as a static webpage in S3. We use Snowflake as our datawarehouse that dbt operates in. I have created a dbt_DOCS role in Snowflake but am struggling understanding what permissions are needed to run dbt docs successfully. The role currently has usage and monitor on all databases and schemas that dbt uses as well as select on all tables and views.
Still after providing all of those permissions I am getting errors of Insufficient privileges to operate on database: <MY_DATABASE>
Does anyone have any experience with this or any knowledge of what operations that dbt docs generate is trying to do under the hood so I can grant it the correct privileges? Thank you!