René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[QUESTION][BigQuery] would it be possible to have extract_table_to_storage support with an optional query ","articleBody":"Hi\n\nWould be great to have a query as an optional field to the extract_table_to_storage method in the google.cloud.bigquery.client.py , so that it will be easy with code to extract the data from the desired table with the custom query and write to GS, or is there any other way to directly write the custom query data after creating the job \n\n``` python\nimport uuid \nfrom gcloud import bigquery\nclient = bigquery.Client(project='test-sample')\nquery = \"\"\"\\\nSELECT * FROM test_database.activity \\\nwhere activity_date = DATE_ADD(CURRENT_DATE(), -1, 'DAY') order by activity_date;\"\"\"\ndataset = client.dataset('test_database')\njob_name = 'test_job_name_' +  str(uuid.uuid4())\nquery_job = client.run_async_query('fullname-age-query-job', query)\njob = bigquery_client.extract_table_to_storage(\n    client.run_async_query(job_name, query), destination)\n```\n\n or is there any other way for this work around, i have some tables as partitioned tables and some with out partition tables, and would need to export some times the data from partitioned and the non-partitioned tables for a given date for analysis with other tools. \n\nThanks \n","author":{"url":"https://github.com/vrcs","@type":"Person","name":"vrcs"},"datePublished":"2016-09-20T12:27:53.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":3},"url":"https://github.com/2361/google-cloud-python/issues/2361"}