Transparent unified views across data sources

Is something like this possible to do?

Kudu is not supported, which is fine. But, is it possible to have a UNION view across two supported data sources?