Mass Ingestion

Back Next

Microsoft Azure Synapse Analytics target properties

When you define a

database ingestion

task, you must enter some properties for your Microsoft Azure Synapse Analytics target on the

Target

page of the task wizard.

These properties apply to initial load, incremental load, and combined initial and incremental load operations.

The following table describes the target properties that appear under

Target

Property	Description
Target Creation	The only available option is Create Target Tables , which generates the target tables based on the source tables. After the target table is created, Mass Ingestion Databases intelligently handles the target tables on subsequent job runs. Mass Ingestion Databases might truncate or re-create the target tables depending on the specific circumstances.
Schema	Select the target schema in which Mass Ingestion Databases creates the target tables. The schema name that is specified in the connection properties is displayed by default. Because this field is case sensitive, ensure that you entered the schema name in the connection properties in the correct case.