google-bigqueryinformation-schema

BigQuery: get table description using INFORMATION_SCHEMA


Is it possible go get a BigQuery table's description from the INFORMATION_SCHEMA ?

enter image description here


Solution

  • 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

    enter image description here