fix: Make snowflake to remote tables temporary (feast-dev#3588)

sfc-gh-madkins · zerafachris · commit 1ba69c240330 · 2024-03-05T20:14:50.000+01:00
Signed-off-by: Miles Adkins &lt;miles.adkins@snowflake.com&gt;
Signed-off-by: zerafachris PERSONAL &lt;zerafachris@gmail.com&gt;
diff --git a/sdk/python/feast/infra/offline_stores/snowflake.py b/sdk/python/feast/infra/offline_stores/snowflake.py
@@ -556,7 +556,7 @@ def to_remote_storage(self) -> List[str]:
             )
 
         table = f"temporary_{uuid.uuid4().hex}"
-        self.to_snowflake(table)
+        self.to_snowflake(table, temporary=True)
 
         query = f"""
             COPY INTO '{self.export_path}/{table}' FROM "{self.config.offline_store.database}"."{self.config.offline_store.schema_}"."{table}"\n

Original file line number	Diff line number	Diff line change
`@@ -556,7 +556,7 @@ def to_remote_storage(self) -> List[str]:`
`556`	`556`	`)`
`557`	`557`
`558`	`558`	`table = f"temporary_{uuid.uuid4().hex}"`
`559`		`- self.to_snowflake(table)`
	`559`	`+ self.to_snowflake(table, temporary=True)`
`560`	`560`
`561`	`561`	`query = f"""`
`562`	`562`	`COPY INTO '{self.export_path}/{table}' FROM "{self.config.offline_store.database}"."{self.config.offline_store.schema_}"."{table}"\n`