Carlos Eduardo Abrantes
Reputation: 53
How to query column metadata in BigQuery
Within a BigQuery table, I need to return from a query each column size and data type of this table. Is this possible ?
Upvotes: 0
Views: 2841
Answers (1)
Alfons Muñoz
Reputation: 519
You can view column data type with:
SELECT column_name,data_type FROM <MY_DATA_SET>.<MY_TABLE>.INFORMATION_SCHEMA.COLUMNS;
https://cloud.google.com/bigquery/docs/information-schema-tables
Upvotes: 1
Related Questions
- How to get column name from BigQuery API?
- BigQuery SQL to add metadata to a column
- Is it possible to pull column descriptions from BigQuery metadata
- How can I read google-cloud-storage file's metadata from BigQuery
- Querying Bigtable by column values
- Extract metadata_fields from table as well as data columns from bigquery table
- Google BigQuery Metadata
- How can I query a Bigtable column value in BigQuery standard SQL?
- Querying BigQuery tables from Cloud SQL
- Bigquery Dataset/Table's metadata