Bigquery Data View is a nice Visual Studio Code extension that lets you view BigQuery table schemas, contents and run queries directly in VScode, viewing the results in the same app. Unlike some of the alternatives you don’t need to set up a special BQ service account.