fix: Make generated temp table name escaped (#3797)

BearDimonR · james-crabtree-sp · commit 27a0b701601f · 2023-10-23T11:37:26.000-05:00
* Fix critical issue with saving results in BigQuery

Need to encapsulate table path as tmp table path can contain symbols that can't be process by BigQuery without encapsulation

Signed-off-by: Dmytro Miedviediev &lt;beardimon2001@gmail.com&gt;

* update numpy

Signed-off-by: Dmytro Miedviediev &lt;beardimon2001@gmail.com&gt;

* revert numpy version

Signed-off-by: Dmytro Miedviediev &lt;beardimon2001@gmail.com&gt;

---------

Signed-off-by: Dmytro Miedviediev &lt;beardimon2001@gmail.com&gt;
Signed-off-by: James Crabtree &lt;james.crabtree@sailpoint.com&gt;
diff --git a/sdk/python/feast/infra/offline_stores/bigquery.py b/sdk/python/feast/infra/offline_stores/bigquery.py
@@ -515,7 +515,7 @@ def to_bigquery(
                 temp_dest_table = f"{tmp_dest['projectId']}.{tmp_dest['datasetId']}.{tmp_dest['tableId']}"
 
                 # persist temp table
-                sql = f"CREATE TABLE `{dest}` AS SELECT * FROM {temp_dest_table}"
+                sql = f"CREATE TABLE `{dest}` AS SELECT * FROM `{temp_dest_table}`"
                 self._execute_query(sql, timeout=timeout)
 
             print(f"Done writing to '{dest}'.")
