3

I'm using AWS Quicksight for an Analytics dashboard and I have multiple databases that have the same tables. I then set a Data Source for each database. Now, I've been trying to create a Data Set for a table, let's say "products" table, which should be a UNION of all the "products" tables of all the databases.

So far, I've only been able to combine data from those databases using the UI to do a JOIN. However, for the Analysis I'm trying to create, I'll be needing to do a UNION. How do you do a UNION from multiple different databases in AWS Quicksight? Thanks.

John Rotenstein
  • 241,921
  • 22
  • 380
  • 470
xtan
  • 41
  • 1
  • 3

1 Answers1

0

You can use SQL to connect in whatever way you wish. When you create a dataset, choose use custom sql and you will be presented with the window below, where you can then use SQL to join, union or whatever to your hearts content :)

enter image description here

Rob Davie
  • 53
  • 5
  • 4
    This will only work if both DBs can be accessed from one connection. If they are 2 entirely separate instances, you can't use a single query to union them. – Aurelion Sep 24 '21 at 01:50