René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"feat: allow QueryJob.result() to be called on a dryRun query","articleBody":"Attempting to call `result()` on a dryRun query results in the following exception.\r\n\r\n```\r\n    def test_dry_run(bigquery_client: bigquery.Client, query_api_method: str, scalars_table_multi_location: Tuple[str, str]):\r\n        location, full_table_id = scalars_table_multi_location\r\n        query_config = bigquery.QueryJobConfig()\r\n        query_config.dry_run = True\r\n    \r\n        query_string = f\"SELECT * FROM {full_table_id}\"\r\n        query_job = bigquery_client.query(query_string, location=location, job_config=query_config, api_method=query_api_method)\r\n\u003e       query_job.result()\r\n\r\ntests/system/test_query.py:430: \r\n_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ \r\ngoogle/cloud/bigquery/job/query.py:1372: in result\r\n    do_get_result()\r\n../python-api-core/google/api_core/retry.py:283: in retry_wrapped_func\r\n    return retry_target(\r\n../python-api-core/google/api_core/retry.py:190: in retry_target\r\n    return target()\r\ngoogle/cloud/bigquery/job/query.py:1362: in do_get_result\r\n    super(QueryJob, self).result(retry=retry, timeout=timeout)\r\ngoogle/cloud/bigquery/job/base.py:713: in result\r\n    return super(_AsyncJob, self).result(timeout=timeout, **kwargs)\r\n../python-api-core/google/api_core/future/polling.py:137: in result\r\n    raise self._exception\r\ngoogle/cloud/bigquery/job/query.py:1233: in _done_or_raise\r\n    self._reload_query_results(retry=retry, timeout=transport_timeout)\r\ngoogle/cloud/bigquery/job/query.py:1214: in _reload_query_results\r\n    self._query_results = self._client._get_query_results(\r\ngoogle/cloud/bigquery/client.py:1835: in _get_query_results\r\n    resource = self._call_api(\r\ngoogle/cloud/bigquery/client.py:732: in _call_api\r\n    return call()\r\n../python-api-core/google/api_core/retry.py:283: in retry_wrapped_func\r\n    return retry_target(\r\n../python-api-core/google/api_core/retry.py:190: in retry_target\r\n    return target()\r\n\r\n...\r\n\r\nE           google.api_core.exceptions.NotFound: 404 GET https://bigquery.googleapis.com/bigquery/v2/projects/swast-scratch/queries/None?maxResults=0\u0026location=asia-northeast1\u0026prettyPrint=false: Not found: Job swast-scratch:asia-northeast1.None\r\nE           \r\nE           (job ID: None)\r\nE           \r\nE                                            -----Query Job SQL Follows-----                                 \r\nE           \r\nE               |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |\r\nE              1:SELECT * FROM swast-scratch.python_bigquery_tests_system_20211008194804_6e302d_tokyo.scalars\r\nE               |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |    .    |\r\n\r\n../python-cloud-core/google/cloud/_http.py:479: NotFound\r\n```\r\n\r\nThis is because the QueryJob tries to fetch query results and/or job state, but there is no job ID in a dry run query response.\r\n\r\nIMO, if we know something is a dryRun response, `resullt()` should do nothing.","author":{"url":"https://github.com/tswast","@type":"Person","name":"tswast"},"datePublished":"2021-10-08T20:33:55.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/1012/python-bigquery/issues/1012"}