Skip to content

Instantly share code, notes, and snippets.

@Arqentum

Arqentum/bigquery_table_ddl_as_json.sh

Created November 9, 2023 00:24
Show Gist options
  • Save Arqentum/01f6542c546db881b765e34778f42909 to your computer and use it in GitHub Desktop.
Save Arqentum/01f6542c546db881b765e34778f42909 to your computer and use it in GitHub Desktop.
Download ZIP
#BigQuery get table DDL as json schema
Raw
bigquery_table_ddl_as_json.sh
# Activate console to run "bq" commands:
# https://console.cloud.google.com/bigquery?cloudshell=true
# bq show --format=prettyjson bigquery-public-data:samples.wikipedia | jq '.schema.fields'
bq show --format=prettyjson <project>:<bucket>.<table> | jq '.schema.fields'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment