Union specific columns from one data table to another

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.

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.