I want to create a view in BigQuery that also shows comments such as the author, date created etc.
But if I try this in the UI the comments are left out.
Is there a way to do this in the BigQuery UI?
Or are there other ways using bq client or python, or ...?
So for example if I run this:
CREATE OR REPLACE VIEW `my_project_id.my_dataset.my_view_name`
AS
-- this is my important comment. This will be a long and extensive comment.
SELECT 1 as column_a
;
BigQuery will not show the comments in the view when the UI is used to create that view:
First create the view without the comment.
Then edit the sql of that view you just created and add the comments then.
See screenshots below.
Choose Edit Query: