Can I comment on items in Google BigQuery?
Can I comment on tables, columns, etc. in Google BigQuery? For example PostgreSQL has a command comment
: http://www.postgresql.org/docs/9.4/static/sql-comment.html .
If so, are there system tables from which these comments can be retrieved through the SQL interface?
+3
source to share
1 answer
Question 1: Yes
Question 2: No
Through the API, you can add comments to datasets, tables, and fields. You can also receive comments via the API, but not via the SQL interface.
You can also view and edit annotations through the web interface (which uses the API to do this).
See API docs:
https://cloud.google.com/bigquery/docs/reference/v2/tables#resource
(pay attention to the "description" field for the table and its fields)
+2
source to share