Union Relations - Make it work with external tables #1031
Description
Describe the feature
Allow the union_relations function to work with external tables.
Describe alternatives you've considered
There aren't any
Additional context
I think depending on the adapter, we need to look for the columns in a different place rather than just information_schema. For Redshift it's svv_external_columns
Who will this benefit?
Everybody using external tables
Are you interested in contributing this feature?
Yes