Skip to content

Instantly share code, notes, and snippets.

@n0531m
Created February 18, 2020 12:40
Show Gist options
  • Save n0531m/6c47f6ce17ef95bc2bdd3212007a9647 to your computer and use it in GitHub Desktop.
Save n0531m/6c47f6ce17ef95bc2bdd3212007a9647 to your computer and use it in GitHub Desktop.
function getBqTempTableByJobid {
local JOBID=$1
bq show --format json -j ${JOBID} \
| jq -r '.configuration.query.destinationTable | .projectId +":"+.datasetId+"."+.tableId'
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment