Join tables across two different schemas

We have tables located in different databases, how can we join them?

select xyz from a.table1
join b.table2 on table1.id=table2.id

Hi @narenparimi,

I don’t think is possible to reference a table from one database to another, so as time of writing it’s not possible to join tables belonging to different databases

@candido.dessanti is correct, we do not support joins across databases. We do have the addition of SQL schemas on our roadmap, which would allow you to logically group tables into database-like objects within a single database.