Shell script to extract the schema from an existing BigQuery table and output the schema in a format suitable for use with `bq mk`.

getBigQuerySchema.sh

#!/bin/bash

if [ -z $1 ]; then
	echo "Provide a BQ table spec, ideally fully qualified."
	exit 1
fi


if $(echo "" | jq .); then
	bq --format json show $1 | jq -j '[.schema.fields[] | .name + ":" + .type] | join(",")'
else
  echo "Please install jq."
  exit 1
fi