bigqueryの実行履歴クエリをまとめて取ってくる
$ bq ls -j -n 1000 | sed -e '1d' | sed -e '1d' | awk '{print $1}' | xargs -n 1 bq show --format=prettyjson -j | jq -c '[.statistics.startTime, .configuration.query.query, .configuration.query.destinationTable.tableId]'
More than 3 years have passed since last update.
bigqueryの実行履歴クエリをまとめて取ってくる
$ bq ls -j -n 1000 | sed -e '1d' | sed -e '1d' | awk '{print $1}' | xargs -n 1 bq show --format=prettyjson -j | jq -c '[.statistics.startTime, .configuration.query.query, .configuration.query.destinationTable.tableId]'
Register as a new user and use Qiita more conveniently