# Passing strings containing ' (apostrophe) from Quicksight filter to Snowflake direct query **URL:** \ **Category:** Q&A\ **Tags:** parameters, feature-request, direct-query, Business-Intelligence-Engineer, quick-sight\ **Created:** [August 7, 2024, 5:33pm UTC](https://community.amazonquick.com/t/passing-strings-containing-apostrophe-from-quicksight-filter-to-snowflake-direct-query/33585 "2024-08-07T17:33:24Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![arimando](https://avatars.discourse-cdn.com/v4/letter/a/f0a364/32.png) [@arimando](https://community.amazonquick.com/u/arimando)\ **Post date:** [August 7, 2024, 5:33pm UTC](https://community.amazonquick.com/t/passing-strings-containing-apostrophe-from-quicksight-filter-to-snowflake-direct-query/33585/1 "2024-08-07T17:33:24Z")
I have a multiple value parameter where any number of strings can be selected, for example strings can be like, ‘ABC\_Q1’24’, ‘DEF\_Q1’24’ When I select a string from the filter, it is passed to a direct query in Snowflake which should populate data in a table in Quicksight. The table doesn’t populate any thing and when I go to Snowflake, I see that the JDBC client is passing ‘ABC\_Q1’, ‘DEF\_Q1’. I noticed that the query works if the parameter is single-valued but doesn’t work for multiple valued parameters. Would appreciate any help or ideas to work around this! ---
**Author:** ![WLS-DM](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-dm/32/36109_2.png) [@WLS-DM](https://community.amazonquick.com/u/WLS-DM)\ **Post date:** [August 8, 2024, 8:00pm UTC](https://community.amazonquick.com/t/passing-strings-containing-apostrophe-from-quicksight-filter-to-snowflake-direct-query/33585/2 "2024-08-08T20:00:36Z")
Hello @arimando, welcome to the Quick Sight community! Is your dataset directly linked to a view or table in Snowflake or are you building it with custom SQL in Quick Sight? I think the most likely solution to this issue will be to reformat the field value to exclude the apostrophe. Maybe using something like replace in your SQL statement to remove the apostrophe would help fix this issue. > **[REPLACE | Snowflake Documentation](https://docs.snowflake.com/en/sql-reference/functions/replace)** It seems like it is confusing it for the end of the string value which is causing the query to fail to load any data. Let me know if this helps resolve your issue! ---
**Author:** ![arimando](https://avatars.discourse-cdn.com/v4/letter/a/f0a364/32.png) [@arimando](https://community.amazonquick.com/u/arimando)\ **Post date:** [August 9, 2024, 11:34am UTC](https://community.amazonquick.com/t/passing-strings-containing-apostrophe-from-quicksight-filter-to-snowflake-direct-query/33585/3 "2024-08-09T11:34:53Z")
Hi @WLS-DM thank you for the warm welcome! The dataset is a direct query to a table in Snowflake. As a workaround, I removed the apostrophe, but this isn’t ideal. I have end users that download the tables into a CSV and require the strings to be exactly what they were upstream for further downstream tasks. I am hoping to be able to support the apostrophe in strings. I also tried many escaping methods in Snowflake before it is passed to Quicksight and still doesn’t work. ---
**Author:** ![WLS-DM](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-dm/32/36109_2.png) [@WLS-DM](https://community.amazonquick.com/u/WLS-DM)\ **Post date:** [August 12, 2024, 3:25pm UTC](https://community.amazonquick.com/t/passing-strings-containing-apostrophe-from-quicksight-filter-to-snowflake-direct-query/33585/4 "2024-08-12T15:25:47Z")
Hello @arimando, since the apostrophe is causing an issue and removing it is only a work-around rather than a solution to the issue, I will mark this topic as a feature request. Please let me know if you have any further questions on this topic, otherwise I can archive it for our support team. Thank you! ---
**Author:** ![WLS-DM](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-dm/32/36109_2.png) [@WLS-DM](https://community.amazonquick.com/u/WLS-DM)\ **Post date:** [August 15, 2024, 4:00pm UTC](https://community.amazonquick.com/t/passing-strings-containing-apostrophe-from-quicksight-filter-to-snowflake-direct-query/33585/5 "2024-08-15T16:00:11Z")
Hello @arimando, since we have not heard back from you with any follow-up questions, I will archive this topic for our support team. If you want any further assistance on a work-around solution, please post a new question in the community and link to this topic. That will ensure you are at the top of the priority list for a response from one of our Quick Sight experts. Thank you! ---
**Author:** ![WLS-DM](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-dm/32/36109_2.png) [@WLS-DM](https://community.amazonquick.com/u/WLS-DM)\ **Post date:** [August 15, 2024, 4:00pm UTC](https://community.amazonquick.com/t/passing-strings-containing-apostrophe-from-quicksight-filter-to-snowflake-direct-query/33585/6 "2024-08-15T16:00:19Z")