Application Ingestion and Replication > Application Ingestion and Replication > Overriding schema drift options when resuming an application ingestion and replication job
  

Overriding schema drift options when resuming an application ingestion and replication job

You can override the schema drift options when you resume an application ingestion and replication job that is in the Stopped, Aborted, or Failed state. The overrides affect only those objects that are currently in the Error state because of the Stop Object, Stop Table, Stop Report, or Stop Job schema drift option. Use the overrides to correct or resolve these errors.
You can override schema drift options and resume an incremental load job or a combined initial and incremental load job either from the My Jobs page in the Data Ingestion and Replication service or from the All Jobs tab on the Data Ingestion and Replication page in Operational Insights.
    1Navigate to the row for the job that you want to resume with an override.
    2In the Actions menu for the row, click Resume With Options.
    Note: The Resume With Options command is not available if the job is in the Failed state because the task deployment failed.
    The Resume Options dialog box appears.
    3In the Schema Drift Options list, select the schema drift option that will be used to process the DDL operation on the source that caused the application ingestion and replication job to stop.
    The following table describes the schema drift options:
    Option
    Description
    Ignore
    Do not replicate DDL changes that occur on the source to the target.
    Stop Table
    Stop processing the source object on which the DDL change occurred.
    Important: The application ingestion and replication job cannot retrieve the data changes that occurred on the source object after the job stopped processing it. Consequently, data loss might occur on the target. To avoid data loss, you will need to resynchronize the source and target objects that the job stopped processing. Use the Resume With Options > Resync option.
    Resync
    Resynchronize the target table with the source object. Use this option for objects that the job stopped processing because of the Stop Object, Stop Table, or Stop Report setting for a Schema Drift option.
    Important: This option is available only for combined initial and incremental load jobs.
    Replicate
    Allow the application ingestion and replication job to replicate the DDL change to the target.
    Important: If you specify the Replicate option for Rename Column operations on Microsoft Azure Synapse Analytics targets, the job will end with an error.
    4Click Resume With Options.
    The resumed job will use the schema drift option that you specified in step 3 to process the schema change that caused the job to stop. Thereafter, the schema drift options that you specified when creating the task take effect again.
    Important: Application Ingestion and Replication processes a schema change to a source object only after a DML operation occurs on the object. Therefore, after you resume a job, the object subtask state remains unchanged until the first DML operation occurs on the object.