[Feature] Add union schema capability

[fivetran-catfritz]

Is there an existing feature request for this?

• [X] I have searched the existing issues

Describe the Feature

Issue for adding the union schema capability.

Describe alternatives you've considered

No response

Are you interested in contributing this feature?

• [ ] Yes.
• [ ] Yes, but I will need assistance and will schedule time during your office hours for guidance.
• [ ] No.

Anything else?

No response