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

BigQuery bq ls examples

Use the bq ls command to get the list of objects

List projects

bq ls --projects

List datasets

bq ls --datasets

List tables in a dataset

bq ls myDataset

List routines & procedures

bq ls --routines myDataset

List bq ML models

bq ls --models myDataset

List my Jobs

bq ls -jobs

List all jobs in a project

bq ls --jobs --all -n 10 myProject

List capacity commitments

bq ls --capacity_commitment

List reservations

bq ls --reservation --project_id=myProject


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