The main project here is to use DBT models to drive the correct execution of an Analysis specific SQL LLM to BigQuery

cd dbt_sql_gpt

You need a .env file in that directory with the content:

OPENAI_API_KEY=xxxxx
GCP_PROJECT=xxxx

You also need to be authenticated with gcloud to your project and have the permissions to run the queries in your BigQuery.

gcloud config set project xxxx
gcloud auth application-default login

Then

poetry install
python app.py 

image image