Parameters in Custom SQL

Hello Team,

When using parameters in Quicksight’s Custom SQL, the platform automatically wraps parameter values in single quotes. This becomes problematic when the parameter is intended to represent a table name, as quotation marks invalidate the SQL syntax for table references. Are there any workaround solution to escape the single quotation on parameter values.

Any inputs would be appreciated! Thanks!

Hello @Vaishnavi_Ganesan , welcome to the QuickSight community!

Can you share an anonymized view of your SQL statement that is causing problems?

You should be able to define your parameters with this syntax <<$param_name>>: