Skip to content

Instantly share code, notes, and snippets.

@MatthewDaniels

MatthewDaniels/dl-bq-schema.sh

Created October 16, 2019 10:09
Show Gist options
  • Save MatthewDaniels/e582158ff85599d0945819f9204312dd to your computer and use it in GitHub Desktop.
Save MatthewDaniels/e582158ff85599d0945819f9204312dd to your computer and use it in GitHub Desktop.
Download ZIP
Downloads a BQ Table's defined schema and places it into a JSON file. Note: Remove the "> github-commits-schema.json" to show it on screen.
Raw
dl-bq-schema.sh
#!/bin/bash
bq show --format=prettyjson bigquery-public-data:github_repos.commits | jq '.schema.fields' > github-commits-schema.json
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment