Union specific columns from one data table to another

Question & Answer
1

I am trying to combine specific columns of data from two different datasets (not all columns of data are needed).

In my example, I’ve created a dashboard pulled from one data table. However, this data table only has data from Feb 2021 and onwards. Jan 2021 and prior data lives in a separate data table and I want to combine the data (only specific columns; some column names differ as well) from the table with Jan 2021 and prior data to the Feb 2021 and onwards table.

2

You’ll have to do this at the dataset level using SQL. The visual editor doesn’t support union yet.

I was told by AWS support that it is on the roadmap.

2 Likes