Skip to content

torchbox/nlbq

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

30 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

nlbq

Natural language interface to BigQuery

Google credentials

The Python BigQuery library expects the environment variable GOOGLE_APPLICATION_CREDENTIALS, which should point to a JSON file containing the credentials of a Google service account. You can create a service account and download its credentials from the Google Cloud Console. Then set the environment variable:

export GOOGLE_APPLICATION_CREDENTIALS=/path/to/your/google-service-account.json

Creating a demo environment

mkdir demo # Git will ignore this directory
cd demo
python3 -m venv venv
source venv/bin/activate
pip install -e ../ # Install the local package in editable mode
nlbq init  # generates prompt.txt, Dockerfile and index.html
# make changes then
pip uninstall nlbq --yes; pip install -e ../

You can initialise with prepopulated BigQuery dataset table schema information with

nlbq init --table dataset.table_id

Usage

nlbq --help