I have a question about setting a target schema. How to set different targets for 2 different tables in the same delta live table pipeline. 

We have 2 target schemas in a database Bronze_chema and silver_schema. 

 

The pipeline has a streaming raw table (Bronze table) Table A and a processed table (Silver Table) derived from the bronze table,  Table B. When I set the target schema in the Workflow settings it defaults both the tables to that target schema. 

Table A -> Bronze_schema

TableB -> Bronze_schema

 

But I want  

Table A -> Bronze_schema and 

Table B -> Silver_schema, as part of the same delta live table pipeline.  please suggest how to set the targets as part of pipeline code