How do I add Parameters for Custom SQL in the latest QuickSuite UI?

Hi everyone,

I’m using the latest QuickSuite UI , and I’m editing a Dataset that uses Amazon Redshift with Custom SQL.

I already know how to create parameters in an Analysis and add controls there.
However, what I need is Dataset Parameters that can be used directly inside the Custom SQL (e.g., using syntax like <<$parameter_name>> to dynamically change the WHERE clause).

Right now I’m in the Dataset edit screen → Custom SQL query editor (screenshot attached). In this SQL editor modal, but I cannot find where to create/add “Dataset Parameters” in this Dataset editing flow.

Questions:

  1. In the latest QuickSuite UI, where exactly do I create Dataset Parameters for use in Custom SQL?

  2. Is it possible to add Dataset Parameters from this Custom SQL editor screen, or do I need to create them somewhere else first and then reference them in SQL?

Any architectural guidance would be really helpful. Thank you!

Hi @showtree,
In regards to the new data prep experience, there are still a number of limitations in comparison to the legacy experience and unfortunately, dataset parameters are one of those items. You can view the full list at the following:

If you’d like to utilize dataset parameters, you’ll have to switch back to the legacy experience for the time being until this rolls out.
I’ll mark this as a feature request to promote visibility though as well.

Thanks for confirming! Understood that dataset parameters aren’t supported in the new data preparation experience yet.

I will switch back to the legacy experience for now to proceed with dataset parameters. Also, thank you for submitting this as a feature request.

1 Like