How to join self created dataset in quicksight with custom query

Question & Answer
,
1

Hi,

I want to use some data in previous created quicksight dataset.
How to join a self created dataset in quicksight with custom query?

Thanks,
Cindy

2

Hi @Cindy,

I hope I undertood your question, if not, let me know.

To do this you just can join them as any other dataset, here is a link to the documention on how to join 2 datasets.

Hope this helps!

3

Thanks for your reply!

here is more details: I am using custom query to join tables together from company’s data base. but now, I need to pull some data from a seperate dataset that is created in quicksight. How can I join with that quicksight created dataset using custom sql.

Please let me know if you have questions.

Thanks,
Cindy

4

Hi @Cindy
You can’t join QS datasets with custom SQL only via dataset editor.
If the separate dataset is also SQL you can create a complete new dataset with the combination of the two.
BR

5

As @ErikG mentioned, you have one dataset which is your custom sql dataset, and one with the quicksight dataset, you join them by editing one of them, adding the second with the “Add data” feature and join them based on a mutual field. This process is explained in the documentation I shared in the first reply.

6

Hi @Cindy. Checking in. We have not heard back from you regarding your question. We’d still like to help. If we do not hear back in the next 3 days, we will archive the question.

7

Thanks Andres for the reply

1 Like
8

I’m unable to add data while writing the custom SQL as the Add Data button remains inactive.

9

Hi @dsalam, can you please open a new topoc with your specific problem? Please add as much information as you can. Thanks!

10

@dsalam, please noted the custom SQL can only apply to the source tables that come from the same data source. Imagine you are running the same SQL in your data warehouse environment, you can only join tables from the same cluster.
If you want to join multiple tables from different sources, you can first ingest them all to SPICE, and then join them in the QS console by configuring the join conditions. You cannot use custom SQL in that case, as the join will be against two SPICE tables, and QS doesn’t expose SQL interface for SPICE.

Does that make sense to you?

11

Hi @dsalam, hope this clarifies — you cannot mix SPICE and Custom SQL — try using tools like Athena to help with complex queries.

I am marking @emilyzhu reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!

Also, I have tagged this as a feature request. More features are being added on a regular basis, so please keep an eye on the What’s New / Blog . You can set up a Watching Alert by clicking on the bell icon.