0

Is there a table similar to v$sql in Oracle where I can retrieve data associated with a particular query that was run in BigQuery using SQL?

0

Is there a table similar to v$sql in oracle where I can retrieve data associated with a particular query that was run in BigQuery using SQL?

Yes, In BigQuery it's called Jobs and you have few ways to retrieve it:

  1. Via the UI from the menu on the left-hand side, Query History

enter image description here

  1. Via API by calling the Jobs API
  2. Via BigQuery bq command-line using the show option as follow

    bq --location=[LOCATION] show -j [JOB_ID]

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.