Hello,

Thank you for reaching out to us.

If I understand it correctly, you would like to add multiple sqls to Quicksight SPICE dataset so that you can use the columns available in one sql into another sql.

I would like to confirm that, as of now we dont have this feature available in Quicksight. If we try to add multiple sqls to SPICE dataset ,then it will throw an error saying "One query is expected".

However, as a wrok-around you can consider using CTE ->

Original SQLs :-

select tran_id as id,store_id as store, store_city as city, store_city as new_city from retail_transactions; select store_city as new_city from retail_transactions;

CTE :-

with test_cte as (select tran_id as id,store_id as store, store_city as city, store_city as new_city from retail_transactions) select new_city from test_cte;

Thank you and have a great day !