BigQuery - JSON schema to basic Python Schema

main.py

#!/usr/bin/env python3
import sys
import json

# used as
#  bq show --schema --format=prettyjson PROJECT:DATASET.TABLE | ./main.py

data = ""
for x in sys.stdin:
  data = data + x

loaded_data = json.loads(data)

for item in loaded_data:
   print(f'bigquery.SchemaField("{item["name"]}", "{item["type"]}"),')