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

mCollins

posted on 22 Sep 21

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds