英文:
BigQuery: get table description using INFORMATION_SCHEMA
问题
能否从 INFORMATION_SCHEMA 获取 BigQuery 表的描述？
英文:
Is it possible go get a BigQuery table's description from the INFORMATION_SCHEMA ?
答案1
得分: 1
你可以使用INFORMATION_SCHEMA.TABLE_OPTIONS视图，并使用option_name = 'desciption'条件：
SELECT *
FROM `bigquery-public-data.chicago_crime`.INFORMATION_SCHEMA.TABLE_OPTIONS
WHERE option_name = 'description'
AND table_name = 'crime';
查询结果
-
option_value显示了表的描述信息。 -
链接：https://cloud.google.com/bigquery/docs/information-schema-table-options
英文:
You can use INFORMATION_SCHEMA.TABLE_OPTIONS view with option_name = 'desciption'
SELECT *
FROM `bigquery-public-data.chicago_crime`.INFORMATION_SCHEMA.TABLE_OPTIONS
WHERE option_name = 'description'
AND table_name = 'crime';
Query results
-
option_valueshows a table description. -
https://cloud.google.com/bigquery/docs/information-schema-table-options
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论