Create a parameter and use in Custom SQL in where clause

[cgreenacre]

a very popular question, here’s the answer provided for someone else’s question.

Drive dataset results using user parameter values

I have a need to search for a small slice of data from a very large database after which the comparison between the slices can be computed in the analysis layer. I am wanting to avoid ingesting the large database table into spice dataset but drive the results based on the input chosen by the user. Is this doable in QuickSight? Parameters as far as I know only goes to the dataset but does not get passed to the data source for querying. The dashboard gets rendered only after the data is refresh…

in essence, it’s coming