CLI to retrieve SQL schema information about the Dimensions on Google BigQuery dataset.
NOTE This is the same documentation available from https://docs.dimensions.ai/bigquery/data-sources.html - only it's retrieving from the BigQuery database itself.
pip install dimschema
- Python 3+
- Personal Google account credentials set up in your local machine. The BigQueryLAB has a tutorial showing how to do that.
-
dimschema publications .: show all fields from the Publications table -
dimschema ids: show fields containing the string 'ids' -
dimschema datasets ids: show fields containing the string 'ids', only in the Datasets table
$ mkvirtualenv dimschema
$ pip install --editable .
See https://stackoverflow.com/questions/30306099/pip-install-editable-vs-python-setup-py-develop
Working prototype / unsupported