cancel
Showing results for 
Search instead for 
Did you mean: 

Incorta joins other than the inner joins (=)

Ruchita
Cosmonaut

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 !

2 REPLIES 2

Tristan
Employee
Employee

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

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