bq_table_creation.sh

#!/bin/bash

set -eu

dataset=kamatama_test
table="creation_test"

bq rm -f ${dataset}.${table}
bq mk --schema ts:string,cnt:integer -t ${dataset}.${table}

try_count=0
retry_limit=1200
wait_seconds=1
until [ ${try_count} -eq ${retry_limit} ]; do
  json="{\"ts\": \"$(date +"%h:%M:%S")\", \"cnt\": ${try_count}}"
  echo "${json}"
  echo "${json}" | bq insert ${dataset}.${table}
  sleep ${wait_seconds}
  try_count=$(expr $try_count \+ 1)
done