Is there a way to take a user-provided variable (parameter?) from a QS control and insert it into the SQL that creates the data set? (Dataset query: select * from products where id = [3], where [3] is provided by user via a control.) Could it work with a default parameter to pull initial results a…

Hello Clee1, Yes this is possible. Kindly review the below documentations for implementation steps: Optimize queries using dataset parameters in Amazon QuickSight Insert dataset parameters into custom SQL - Amazon QuickSight Using dataset parameters in Amazon QuickSight - Amazon QuickSight …

How to Insert Parameter into SQL to produce data set

Q&A

Adedolapo July 23, 2024, 7:09pm 2

Hello Clee1,

Yes this is possible. Kindly review the below documentations for implementation steps:

Optimize queries using dataset parameters in Amazon QuickSight
Insert dataset parameters into custom SQL - Amazon QuickSight
Using dataset parameters in Amazon QuickSight - Amazon QuickSight

Regards,

1 Like

Topic		Replies	Views
Create a parameter and use in Custom SQL in where clause Q&A data-source	2	1490	April 21, 2022
Drive dataset results using user parameter values Q&A data-source , parameters , how-to	2	983	September 15, 2022
How to add dynamic parameter in custom sql query dataset? Q&A data-source , analysis , parameters	9	2259	February 10, 2023
Amazon QuickSight launches dataset parameters to optimize slicing and dicing experiences What's New / Blog	5	1027	May 5, 2023
Is there a possibility of SQL Injection when inserting dataset parameters into QuickSight's custom SQL? Q&A parameters , SQL	3	413	May 23, 2023

How to Insert Parameter into SQL to produce data set

Related topics