René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"schema built when creating a view in bigquery","articleBody":"Calling create on a table with view_query set fails, as _build_resource sets the schema. Running\n\n``` python\nnew_table = dataset.table('test_view')\ntable.view_query = query_string\nnew_table.create()\n```\n\ngives the following error:\n\n```\nBadRequest: 400 {\n \"error\": {\n  \"errors\": [\n   {\n    \"domain\": \"global\",\n    \"reason\": \"invalid\",\n    \"message\": \"Schema field shouldn't be used as input with a view\"\n   }\n  ],\n  \"code\": 400,\n  \"message\": \"Schema field shouldn't be used as input with a view\"\n }\n}\n```\n\nOne fix that works is only setting `schema` if `view_query` is `None` in `_build_resource` in [`gcloud/bigquery/table.py`](https://github.com/GoogleCloudPlatform/gcloud-python/blob/188515f192e3823ce21a47df2d4742995d08f109/gcloud/bigquery/table.py#L397), e.g.:\n\n``` python\n    def _build_resource(self):\n        \"\"\"Generate a resource for ``create`` or ``update``.\"\"\"\n        resource = {\n            'tableReference': {\n                'projectId': self._dataset.project,\n                'datasetId': self._dataset.name,\n                'tableId': self.name},\n        }\n        if self.description is not None:\n            resource['description'] = self.description\n\n        if self.expires is not None:\n            value = _millis_from_datetime(self.expires)\n            resource['expirationTime'] = value\n\n        if self.friendly_name is not None:\n            resource['friendlyName'] = self.friendly_name\n\n        if self.location is not None:\n            resource['location'] = self.location\n\n        if self.view_query is not None:\n            view = resource['view'] = {}\n            view['query'] = self.view_query\n        else:\n            resource['schema'] = {'fields': _build_schema_resource(self._schema)}\n\n        return resource\n```\n","author":{"url":"https://github.com/jeremyjamesmitchell","@type":"Person","name":"jeremyjamesmitchell"},"datePublished":"2016-04-07T15:13:55.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/1701/google-cloud-python/issues/1701"}