Hi @Vander
I don’t know Oracle or “dblink”, but currently Metabase does not allow filter substitution of schema/table/column/function names. This is because of security. Though, there’s a PR, which tries to add some of the functionality.
You would have to create a function/stored procedure, that takes a value and creates your query.
You might find better help in a more Oracle specific forum or stackoverflow.com