
Amazon QuickSight dataset parameters enable optimized SQL queries for direct query datasets by allowing parameter values to be passed to the WHERE clause, improving dashboard performance and enabling dataset reusability across analyses.


<div><p>This article explains how to use dataset parameters in Amazon QuickSight to optimize dashboard queries and performance.</p><ul><li>Dataset parameters enable optimized SQL queries by filtering data at the source level</li><li>Differ from analysis parameters; operate at dataset level for direct query custom SQL</li><li>Support multi-value parameters using IN clauses for flexible filtering</li><li>Enable reusable datasets across multiple analyses, reducing maintenance effort</li><li>Support complex SQL scenarios: range predicates, calculated fields, UDFs, case statements</li><li>Improve performance by reducing backend database load and dashboard load times</li><li>Allow centralized governance of parameter-dependent calculated fields at dataset level</li><li>Limitations: not supported in SPICE datasets, no cascading controls, no "select all" option</li></ul><p>Dataset parameters help QuickSight users optimize direct query performance while enabling dataset reusability and better governance of business logic.</p></div>


Related articles