Monday, 23 June 2025

How to List All Tables and Views in a BigQuery Dataset using bq ls command

Want to see all the tables and views in a specific BigQuery dataset?

Just run this from your terminal using the bq command-line tool:

 

To list tables and views in a specific project and dataset:

bq ls your_project_id.your_dataset_name

 

 

To list tables and views in a default project:

bq ls your_dataset_name

$bq ls test_dataset
            tableId             Type       Labels       Time Partitioning   Clustered Fields  
 ----------------------------- ------- --------------- ------------------- ------------------ 
  employee_by_department_view   VIEW    department:hr                                         
  employees    

Use --format=prettyjson or --format=csv for programmatic processing!

bq --format=prettyjson ls test_dataset

$bq --format=prettyjson ls test_dataset
[
  {
    "creationTime": "1743953312779",
    "id": "demo-project:test_dataset.employee_by_department_view",
    "kind": "bigquery#table",
    "labels": {
      "department": "hr"
    },
    "tableReference": {
      "datasetId": "test_dataset",
      "projectId": "demo-project",
      "tableId": "employee_by_department_view"
    },
    "type": "VIEW",
    "view": {
      "useLegacySql": false
    }
  },
  {
    "creationTime": "1743946340766",
    "id": "demo-project:test_dataset.employees",
    "kind": "bigquery#table",
    "tableReference": {
      "datasetId": "test_dataset",
      "projectId": "demo-project",
      "tableId": "employees"
    },
    "type": "TABLE"
  }
]



Previous                                                    Next                                                    Home

No comments:

Post a Comment