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:
-
In the latest QuickSuite UI, where exactly do I create Dataset Parameters for use in Custom SQL?
-
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!
