This is is a simple set of shell commands that transfers an existing GCP Asset Inventory to Bigquery

asset_inventory_to_bq.sh

#!/bin/sh
# more information: https://cloud.google.com/asset-inventory/docs/exporting-to-bigquery

# must have gcloud cli installed
gcloud asset export \      
# must provide a dataset 
 --bigquery-dataset $DATASET   \

# this is for a resource based output
 --content-type resource \
 --project $PROJECT  \
 --bigquery-table $DATASET_TABLE \
     # if the above table does not exist, this command creates it
 --output-bigquery-force