22 Sep 21 ·  mCollins in Bigquery ·        Bookmark ·  Report ·  More actions.. Lock comments ·  Pin thread

BigQuery bq show examples

Use the bq show command to display information about a resource

Show dataset

bq show --dataset myDataset

Show table schema

bq show --schema myDataset.myTable

Show view definition

bq show --view myDataset.myView

Show routine definition

bq show --routine myDataset.myRoutine

Show job metadata

bq show -j proj-id:US.bquxjobid_343kadsfkdasjf

Use pretty print for easy readability

bq show --format=prettyjson -j proj-id:US.bquxjobid_343kadsfkdasjf

Show bq ML model

bq show --model myDataset.myModelName