I'm trying to create a report in Metabase after connecting to an Oracle database, but I'm encountering errors because the DBA has set up synonyms by default. Do you happen to know how to configure synonym settings? I've read online that it can be found in the advanced options in the database, but I'm using the free version and I don't see that menu. I would appreciate any advice from someone who knows.
"When I tried using the Field Filter as a variable type, I encountered an ora-00905 error, and upon examining the executed SQL, it seems that the table owner is omitted during Oracle configuration. However, when I try to include the owner, it still results in an error.