[Feature] query_comment and labels for saved_query's export on BigQuery #1849
Description
Is this your first time submitting a feature request?
- I have read the expectations for open source contributors
- I have searched the existing issues, and I could not find an existing issue for this feature
- I am requesting a straightforward extension of existing metricflow functionality, rather than a Big Idea better suited to a discussion
Describe the feature
When a saved_query is exported to a table on BigQuery, the query generated the table should have the query-comment defined in the dbt_project.yml at the beginning of the query logged by BigQuery audit log. Current behavior:
Moreover, the exported table should also populate the labels in the same way as models with, for example,
+labels:
managed_by: "dbt-project_name"
Describe alternatives you've considered
No response
Who will this benefit?
- BigQuery Admins who need to maintain which BigQuery tables/views are managed by dbt, which one is manually created.
- BigQuery Users to determine which tables are models, which tables are exported from semantic layers.
Are you interested in contributing this feature?
No response
Anything else?
No response