I have dozens of queries that seem to use a synonym name in an Oracle db. Dremio throws error saying that it can’t find the table but querying through any other means outside of dremio is fine. I found the root cause was that these tables have an alias. Is it possible to do this in Dremio without having to modify the original sql to change the table name? There could be hundreds of queries that I would potential need to modify before being able to switch my users over to dremio.
Regards,
Nick