I use an Oracle database as my analytics database in Metabase. I typically build my SQL's in SQL Developer and the port them over to Metabase. Today, I built a query in Developer which ran successfully. I copied the SQL into Metabase and received an ORA Error:
ORA-00942: table or view does not exist
I've narrowed the problem down to one table in my query. I looked at the Table Metadata in the Admin panel and it seems to be missing, however I can see it in SQL Developer and a few other applications I use. I had a look at any hidden tables and there are none. All the tables are visible. I've re-scanned the schema and field values in Admin as well, to ensure that's all up-to-date and still, the table isn't viewable. Is there anything else that would cause this issue? I've combed through the Discourse but I don't see anything else I can try.