The relevant information about running a BQ script manually can be found here - BigQuery Intro

Cheatsheet:

1. Check OpsTracker to make sure that the view you want to update is not disabled.
2. ssh root@app1.logimeter.com
3. source /opt/logimeter/env/live/bin/activate
4. cd /usr/local/src/lm/live/web
5. python manage.py dbshell
6. DROP VIEW IF EXISTS <bigquery_materialized_view>;
7. Then you add the SQL to create the view for the dash
8. cd /usr/local/src/lm/live/script/bigquery/
9. To FORCE the BQ to run, we can do it in a few ways:
10. python bigquery_upload.py -dr "<bigquery_dataset_record_name>"
eg. active_tns, connect_v2
11. python bigquery_upload.py -d "<bigquery_query_name>"
eg. "[MOTUS] BQ Data - Unique Connects - Master V2"
12. Make sure to check the logs for any errors.

‍