docs: Add limitation infomation to the document of Snowflak offline st… (feast-dev#4243)

shuchu · web-flow · commit c66c1fefab1b · 2024-06-13T06:26:51.000-05:00
* doc: Add limitation infomation to the document of Snowflak offline storage.

Signed-off-by: Shuchu Han &lt;shuchu.han@gmail.com&gt;

* doc: Add dollar sign information for snowflake.

Signed-off-by: Shuchu Han &lt;shuchu.han@gmail.com&gt;

---------

Signed-off-by: Shuchu Han &lt;shuchu.han@gmail.com&gt;
diff --git a/docs/reference/offline-stores/snowflake.md b/docs/reference/offline-stores/snowflake.md
@@ -34,6 +34,21 @@ offline_store:
 
 The full set of configuration options is available in [SnowflakeOfflineStoreConfig](https://rtd.feast.dev/en/latest/#feast.infra.offline_stores.snowflake.SnowflakeOfflineStoreConfig).
 
+
+## Limitation
+Please be aware that here is a restriction/limitation for using SQL query string in Feast with Snowflake. Try to avoid the usage of single quote in SQL query string. For example, the following query string will fail:
+```
+SELECT
+    some_column
+FROM
+    some_table
+WHERE
+    other_column = 'value'
+```
+That 'value' will fail in Snowflake. Instead, please use pairs of dollar signs like `$$value$$` as [mentioned in Snowflake document](https://docs.snowflake.com/en/sql-reference/data-types-text#label-dollar-quoted-string-constants).  
+
+
+
 ## Functionality Matrix
 
 The set of functionality supported by offline stores is described in detail [here](overview.md#functionality).
