Incorta joins other than the inner joins (=)

[Ruchita]

Hi everyone !

A quick question, how can two tables be joined as a union using the Joins section in Schemas ? 

If there's another alternative to union two tables, without using Materialized views, i'd be happy to hear about it too.

Thank you !

[Tristan]

Hi Ruchita,

If the tables have the same columns, then you can set up a multi-source table in the physical schema and let Incorta do the union for you.  See the documentation for multi-source tables here.  That is probably the best way to do it because it allows you to join data from disparate data sources but if the tables are from the same source, you can also just write the union SQL yourself when defining the table.

Hope this helps.

Tristan

[amit_kothari]

One more option is our runtime sql view , it is still a lab feature and we can write a Union sql in that , pls check https://docs.incorta.com/5.2/concepts-incorta-sql-view