BigQuery metadata viewer
Project description
BigQuery metadata viewer
"Inspect BigQuery metadata faster"
- quick search through available projects, dataset, tables
- view table metadata and schema
- open in browser
Requirements
-
python >= 3.6
-
fzf - https://github.com/junegunn/fzf (required)
brew install fzf
search through list of values (i.e. project, dataset, tables) is done using fzf
Installation
-
Install as python package using pypi, this will create executable in
/usr/local/bin/bq-meta
pip install bq-meta
-
Initialize
bq-meta
bq-meta --init
-
Follow on screen prompts
- create configuration
- login to the google account using browser (Account is separated from
gcloud
cli)
Examples
Usage: bq-meta [OPTIONS] [FULL_TABLE_ID]
BiqQuery table metadata viewer
Options:
-p, --project-id TEXT Project name
-d, --dataset-id TEXT Dataset name
-t, --table-id TEXT Table name
-h, --history Show history of past searched tables
--raw View raw response from the BigQuery in json format
--init Initialize 'bq-meta' configuration
--info Print info of currently used account
--fetch-projects Fetch google projects
--version Show the version and exit.
--help Show this message and exit.
Table metadata
To view table metadata, run bq-meta
and follow through selection of
- project_id
- dataset_id
- table_id
Or directly run bq-meta with full_table_id
bq-meta bigquery-public-data:github_repos.commits
Table metadata can be refreshed, press r
to fetch fresh metadata, bq-meta
will be running until any other key is pressed
Table schema
Once table metadata is opened, press s
key
Open in browser
Same for opening in browser, after viewing table metadata press o
key and table will opened in Google cloud console.
Search history
Every viewed metadata is saved to the history. To search through history, run bq-meta --history
/ bq-meta -h
and view same table again
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.