Azure data factory copy activity custom schema name for auto created tables

You can do this by parameterizing the Schema and Table name in the Sink (SQL) dataset.

Data set parameters tab:

Data set connection tab:

Copy activity sink tab:

NOTE: these would typically be variables or parameters.