Can I do Union / Union ALL in Custom SQL Redshift?

Hi @Yuxiu_Gan

A union all requires the same columns to be in the same positions for both queries.

For example you might look to do

select customer_id,date from table1 
select customer_id,date from table2

If the names are different you would need to rename them to a similar name.

I’m assuming that’s the issue.