Anders

two questions 1. is usage on the schema required for all model-level privileges? or just `SELECT`? 2. does my restatement of desired behavior make sense to you? perhaps there's a...

just came across https://github.com/dbt-labs/dbt-snowflake/issues/527#issuecomment-1476862791 -- @jaysobel any instinct on what should be done in the case of managed schemas?

> @dataders is this something the adapters team is considering working on? Otherwise I may pick it up as it would be useful for us. it's not on the roadmap...

hiya @crystalro0 thanks for writing this up. I have a few follow-up questions ### why does this fail? does the role you prescribe in the pre-hook have access to `MY_DB`?...

my current summary 1. `use secondary role` isn't working as expected when used as a `on-run-start` hook and `dbt docs generate` is called. however, other hooks do work as expected...

hey @joris-swapfiets great suggestion and it is entirely feasible. Query tagging was originally added in https://github.com/dbt-labs/dbt-core/pull/2555/ (back when the snowflake code still lived within dbt-core). afaict, the mechanics for generating...

this error message string handling was introduced in #107 and happens currently in two places ### `get_columns_in_relation` https://github.com/dbt-labs/dbt-snowflake/blob/f67098d585b90303e5a946e363ba860ce9efe78c/dbt/adapters/snowflake/impl.py#L124-L126 ### `list_relations_without_caching` https://github.com/dbt-labs/dbt-snowflake/blob/f67098d585b90303e5a946e363ba860ce9efe78c/dbt/adapters/snowflake/impl.py#L138-L139

@MasterOdin I think you've laid out a compelling use case. One question I have: > Is `authenticator: oauth` the only scenario in which `user` need not be specified and supplied...

linking to a [community Slack thread in #db-snowflake](https://getdbt.slack.com/archives/CJN7XRF1B/p1698261320614359)