Add ability to choose to use legacy SQL or standard SQL when creating a view.

davidquintana · davidquintana · commit d09ef1aab7ff · 2016-12-21T18:18:22.000-06:00
diff --git a/bigquery/client.py b/bigquery/client.py
@@ -680,7 +680,7 @@ def patch_table(self, dataset, table, schema):
             else:
                 return {}
 
-    def create_view(self, dataset, view, query):
+    def create_view(self, dataset, view, query, use_legacy_sql=None):
         """Create a new view in the dataset.
 
         Parameters
@@ -710,6 +710,9 @@ def create_view(self, dataset, view, query):
             }
         }
 
+        if use_legacy_sql is not None:
+            body['view']['useLegacySql'] = use_legacy_sql
+
         try:
             view = self.bigquery.tables().insert(
                 projectId=self.project_id,
