polleyg · March 20, 2019 05:39
diff --git a/copy_bq_dataset.sh b/copy_bq_dataset.sh
 export SOURCE_DATASET=$1  # project1:dataset
 export DEST_PREFIX=$2  # project2:dataset2.any_prefix_
 for f in `bq ls $SOURCE_DATASET |grep TABLE | awk '{print $1}'`
 do
  export CP_COMMAND="bq cp $SOURCE_DATASET.$f $DEST_PREFIX$f"
  echo $CP_COMMAND
  echo `$CP_COMMAND`
 done
	export SOURCE_DATASET=$1 # project1:dataset
	export DEST_PREFIX=$2 # project2:dataset2.any_prefix_
	for f in `bq ls $SOURCE_DATASET \|grep TABLE \| awk '{print $1}'`
	do
	export CP_COMMAND="bq cp $SOURCE_DATASET.$f $DEST_PREFIX$f"
	echo $CP_COMMAND
	echo `$CP_COMMAND`
	done