run_audit.sh

#!/bin/bash

# get the current directory
DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" >/dev/null 2>&1 && pwd )"

cd $DIR

# table URI in project:dataset.table format
TABLE="<project>:<dataset>.<table>"

# remove previous run data files
rm folders.json projects.json owners_nldj.json

# run the audit files
python3 get_folders.py
python3 get_projects.py
python3 owner_report.py

# load into BQ table
bq load --source_format=NEWLINE_DELIMITED_JSON "$TABLE" owners_nldj.json schema.json