Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to add description to an existing bigquery table?

I'm looking for a way to add description to an existing table attributes, is there any simple command line command such as "alter table zzz add description...." to to this?

like image 860
Echo Avatar asked Sep 03 '25 08:09

Echo


1 Answers

You can add descriptions to tables and its fields through the web UI - that would be the simplest way.

Also via the API, using this document endpoint with the PATCH() methos:

https://cloud.google.com/bigquery/docs/reference/v2/tables

description 
schema.fields[].description 

The bq command line tool can be used too:

bq update --description "My table" existing_dataset.existing_table
like image 164
Felipe Hoffa Avatar answered Sep 04 '25 23:09

Felipe Hoffa