René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"feature request: better api for arbitrary keyword argument pass to query ?","articleBody":"from this example https://googlecloudplatform.github.io/google-cloud-python/stable/bigquery-usage.html#querying-data-asynchronous\r\n\r\n```python\r\n\u003e\u003e\u003e dataset = client.dataset('dataset_name')\r\n\u003e\u003e\u003e table = dataset.table(name='person_ages')\r\n\u003e\u003e\u003e job = client.run_async_query('fullname-age-query-job', query)\r\n\u003e\u003e\u003e job.destination = table\r\n\u003e\u003e\u003e job.write_disposition= 'WRITE_TRUNCATE'\r\n\u003e\u003e\u003e job.name\r\n'fullname-age-query-job'\r\n\u003e\u003e\u003e job.job_type\r\n'query'\r\n\u003e\u003e\u003e job.created\r\nNone\r\n\u003e\u003e\u003e job.state\r\nNone\r\n```\r\n\r\nhow about a better api by allowing arbitrary keyword list to be appended on the insert job POST request\r\nhttps://cloud.google.com/bigquery/docs/reference/rest/v2/jobs the keyword `destinationTable` and `writeDisposition` here are from rest api reference, this way can keep `google-cloud-python` library to be a thinner layer, just gives user the best flexibility\r\n\r\n```python\r\n\u003e\u003e\u003e job = client.run_async_query(query,\r\n          destinationTable={'datasetId': 'dataset_name', 'tableId': 'person_ages'},\r\n          writeDisposition='WRITE_TRUNCATE',\r\n          )\r\n```\r\n\r\nin python it can be implemented as dict as last argument:\r\n\r\n```python\r\ndef run_async_query(query, **kwargs):\r\n    # populate from kwargs to be on the `configuration.query` in the post request body,\r\n    # it could optionally have jobId\r\n```\r\n\r\nBtw, from #3209 I am not puting a `job_name` / `jobid` field because I don't think that's necessary, the `run_async_query` shouldn't require user to provide a `jobid`, in the rest api insert job request, if jobid is absent, server side would generate a unique id","author":{"url":"https://github.com/c0b","@type":"Person","name":"c0b"},"datePublished":"2017-03-27T04:20:05.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":4},"url":"https://github.com/3210/google-cloud-python/issues/3210"}