Retrieving executed query list in BigQuery via SQL
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:


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





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

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