Monday, 23 June 2025

bq shell: BigQuery's Interactive Mode for Faster Data Exploration

Want to run multiple BigQuery queries without retyping the bq command or flags each time? 

Just launch the interactive mode with:

bq shell

$bq shell
Welcome to BigQuery! (Type help for more information.)
demo-project>

Execute the command 'ls' to list all the datasets in a project.

demo-project> ls
      datasetId      
 ------------------- 
  my_org  
  test_dataset   

Execute the command ‘ls {dataset}’ to list all the datasets in a project.

demo-project> ls test_dataset
            tableId             Type       Labels       Time Partitioning   Clustered Fields  
 ----------------------------- ------- --------------- ------------------- ------------------ 
  employee_by_department_view   VIEW    department:hr                                         
  employees                     TABLE    

 

 

Previous                                                    Next                                                    Home

No comments:

Post a Comment