If you only need the list of fields (the array), you can pipe this to jq : bq show --schema --format=prettyjson my_table | jq '.fields' > fields.json . 3. Automate with Python (Client Libraries)
A JSON array representing your schema will appear. You can copy this and save it to a .json file locally. download bigquery schema
If you are building a tool to manage many tables, use the google-cloud-bigquery Python library. If you only need the list of fields
Scroll down to the field list and click the toggle (usually located near the top right of the schema list). you can query the INFORMATION_SCHEMA:
If you want a CSV of the column names and types, you can query the INFORMATION_SCHEMA: