bq-meta 0.3.4

BigQuery metadata viewer

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

1. Install as python package using pypi, this will create executable in /usr/local/bin/bq-meta

   pip install bq-meta
   

2. Initialize bq-meta

   bq-meta --init
   

3. Follow on screen prompts

   • create configuration
   • login to the google account using browser
     • opened automatically if possible
     • otherwise through link and the code

   Account is separated from gcloud cli

Examples

Usage: bq-meta [OPTIONS] [TABLE]

  BiqQuery table metadata viewer

Options:
  -p, --project-id TEXT  Project name
  -d, --dataset-id TEXT  Dataset name
  -t, --table-id TEXT    Table name
  --raw                  View raw response from the BigQuery, in json format
  --init                 Initialize 'bq_meta' (Create config, Authenticate
                         account, Fetch google projects)
  --info                 Print info of currently used account
  --fetch-projects       Fetch google projects
  --version              Show the version and exit.
  --help                 Show this message and exit.