[Feature] support `grant_access_to` for materialized views about dbt-bigquery

[mikealfare]

Materialized views don't currently support grant_access_to, though that would definitely be useful. I'm going to update this to a feature request so that it can be prioritized against the feature backlog.

[dataders]

so this chunk of code in dbt-bigquery's view materialization will need to somehow make it into the "materialized_view" materialization.

dbt-bigquery/dbt/include/bigquery/macros/materializations/view.sql

Lines 21 to 25 in 955afbd

	{% if config.get('grant_access_to') %}
	{% for grant_target_dict in config.get('grant_access_to') %}
	{% do adapter.grant_access_to(this, 'view', None, grant_target_dict) %}
	{% endfor %}
	{% endif %}

[mikealfare]

so this chunk of code in dbt-bigquery's view materialization will need to somehow make it into the "materialized_view" materialization.

dbt-bigquery/dbt/include/bigquery/macros/materializations/view.sql

Lines 21 to 25 in 955afbd

	{% if config.get('grant_access_to') %}
	{% for grant_target_dict in config.get('grant_access_to') %}
	{% do adapter.grant_access_to(this, 'view', None, grant_target_dict) %}
	{% endfor %}
	{% endif %}

Presumably? I'd need to look more into it. And then we would want a test or two for it as well, and we'd need to update the docs.