In one of my projects I need to access some test-data on an Oracle Database, which exists in a schema called "test". The source-table is then called test.customer.
When transferring the project to Production, I need to get my data from another schema called "crm". My source is then called "crm.customer".
So far, I have not been able to find any great solution.
Are there any easy way to get around this issue?