Use of multiple custom SQL queries in QuickSight dataset

0

Hi, I created a new Dataset in QuickSight and added a custom SQL query. The query adds some fields to my dataset. Now I like to execute a second query which uses those fields. Is it possible to execute multiple queries after each other while creating a Dataset? When I add multiple queries I get an errror. Thanks Cees

  • Where are you writing and executing these SQL queries?

asked 2 years ago1250 views
1 Answer
1

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 !

AWS
answered 2 years ago
AWS
EXPERT
reviewed 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions