René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Query error when trying to insert in partitioned table","articleBody":"Using following code to write in an existing daily partitioned table:\r\n```\r\nbigquery_client = bigquery.Client(project=self.project_id)\r\ndataset = bigquery_client.dataset(self.destination_dataset)\r\ndestination_table_with_day = \"table$20170927\"\r\nsql = \"\"\"\r\n        #standardSQL\r\n        ...\r\n       \"\"\"\r\n\r\ntable = dataset.table(destination_table_with_day)\r\ntable.partitioning_type = \"DAY\"\r\nquery = client.run_async_query(str(uuid.uuid4()), sql)\r\nquery.destination = table\r\nquery.write_disposition = 'WRITE_TRUNCATE'\r\nquery.begin()\r\nquery.result()\r\n```\r\n\r\nI expected similar result as the CLI with\r\n`bq query --use_legacy_sql=false --replace --destination_table 'dataset.table$20170927' \"...\"` which works flawlessly\r\n\r\nBut it returned `ERROR - 400 Partitioning specification must be provided in order to create partitioned table`\r\n\r\nI suspect that some parameters are missing that would result in this error such as https://cloud.google.com/bigquery/docs/reference/rest/v2/jobs#configuration.query.timePartitioning.type\r\n\r\nI'm not really that fluent in Python so I couldn't find out that it's the problem is the way I use the SDK or in the SDK. \r\n\r\nI didn't find any sample related on that case inside https://github.com/GoogleCloudPlatform/python-docs-samples but I saw https://github.com/GoogleCloudPlatform/google-cloud-python/issues/2729 that could be related somehow.\r\n","author":{"url":"https://github.com/Kayrnt","@type":"Person","name":"Kayrnt"},"datePublished":"2017-09-27T15:50:08.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/4073/google-cloud-python/issues/4073"}