"Union All" of two different database table

Hi Team,

I want to use "union all" function between two different database table(DB-1/T1  & DB-2/ T2) like Oracle(SQL), can you pease let me know how I can achieve this?


Thanks in advance.



1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi  Rudra ,

    There are a couple ways the product will let you achieve this, but the most common way is to define multiple sources for your Incorta table definition.  The approach works best when DB1.T1 and DB2.T2 have the same columns, as this approach requires that the results coming from the different table source defintions agree on column name and type.  Aliases can be used in the defining SQL SELECT statements to subtle adjustments to force agreement.  There are other ways to do this that get slightly more complex (like bringing in DB1.T1 & DB2.T2 as-is as Incorta tables and then defining a Materialize View on top of them to build a unified unioned table).  See screenshot.

    Reply Like
Like Follow
  • 1 mth agoLast active
  • 1Replies
  • 35Views
  • 2 Following


Welcome to Incorta's user community! Whether you are already an Incorta customer, or interested in becoming one, this is your place to come together and discuss the software, register for webinars, learn about events, learn about new product releases and get support from the community. 

Looking for Product Documentation?