Is it possible to pull column descriptions from BigQuery metadata

user_16253327 0
Viewed 161

I'm trying to get the column descriptions from the BigQuery metadata but I can't seem to find it, I've tried using INFORMATION_SCHEMA.COLUMNS but it isn't contained in here, does anyone know where it is please?

Thanks!

google-bigquery sql
1 Answers

You can have access to all the columns metadata by querying the COLUMN_FIELD_PATHS table:

SELECT * FROM `yourdataset.INFORMATION_SCHEMA.COLUMN_FIELD_PATHS`

Doc reference here

You get information about column names and types within all your dataset.

user_150626050
Related