Table alias in user query is not take as is to source

we have Oracle query with table name alias in join query as below

Source Name : Oracle

Actual Query :
select * from db1.employee as emp join
db2.department as dep on emp.empno = dep.empno.

Dremio translated this query to as below
select * from db1.employee employee join
db2.department department on employee.empno = department.empno.

above query is not taking actual query alias. issue comes when db2 Oracle Schema has table name “employee” then its throw ambiguity error at source.

Does Dremio support Table Alias ? please help on this,

Hi @mahejava

Can you please send me the query profile?

How To Share A Query Profile