Unfortunately this is not possible at the moment. DLTs only target a single schema as destination. 

Companies with such architecture are running several DLTs, one for each schema. 

I believe this is expected for the future, but this is a limitation atm. 

@Hariharan49  'Direct Publishing Mode' Public Preview is now live on all production regions. This feature will allow you to write to multiple schemas & catalogs from the same pipeline.

Thanks for the info! I just tried and it worked! Although I don't know what 'direct publishing mode' is. I don't see that in my environment. But I just specified a different schema in the codes and it worked!

Hello @micmic 

AS DPM is in Public preview so all new DLT pipelines created from the UI will have Direct Publishing Mode (DPM) enabled by default. This will not require any additional configuration.