René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Provide support for synchronous queries through the v2/projects/{projectId}/queries endpoint","articleBody":" **Is your feature request related to a problem? Please describe.**\r\nWe are part of the BI Engine preview so we're trying to minimize the latency between our python application and BigQuery. The current approach of creating an asynchronous job and then waiting for it to complete adds significant latency and hurts the value proposition of BI Engine.\r\n **Describe the solution you'd like**\r\nWe'd like a way to utilize the `v2/projects/{projectId}/queries` endpoint to execute a query and wait for the response.\r\n **Describe alternatives you've considered**\r\nWe could call the REST API directly. The main drawbacks are 1) authentication with a service account 2) the existing python client does a nice job of creating `Row` objects with the results.\r\nI've also used the following snippet:\r\n```python\r\nbq_client = bigquery.Client(project=project_id)\r\nsynchronous_api_response = bq_client._connection.api_request(\r\n    \"POST\", \r\n    f\"/projects/{project_id}/queries\",\r\n    data={\"query\": query, \"useLegacySql\": False},\r\n)\r\n```\r\n","author":{"url":"https://github.com/kdeggelman","@type":"Person","name":"kdeggelman"},"datePublished":"2021-04-06T16:13:39.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":16},"url":"https://github.com/589/python-bigquery/issues/589"}