Oracle tables with synonyms not viewable through Dremio

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.


Hi @nrchade

This issue is resolved in the next release of Dremio. You can now query synonyms completely or hide them from Dremio.