If CLAIRE recommendations are enabled in your organization, you can select a runtime strategy when you create a

mapping

task based on a mapping in advanced mode. CLAIRE analyzes the mapping and recommends one of the following runtime strategies to optimize cost, performance, or both:

The following image shows a recommendation that you might see:

The default runtime strategy runs the

mapping

task on an

advanced cluster

or using SQL ELT optimization based on whether SQL ELT optimization is configured on the

Runtime Options

page. If SQL ELT optimization is configured, the

mapping

task runs using SQL ELT optimization. Otherwise, the

mapping

task runs on an

advanced cluster

.

The target duration confidence level shows the likelihood that the job will run within the target duration that you specify. The confidence level can change based on the runtime strategy that you select. If you select the runtime strategy that is more performant, it's more likely that the

mapping

task will run within its target duration.

Runtime strategies aren't available for

mapping

tasks that run in a serverless runtime environment.

For more information about SQL ELT optimization, see SQL ELT optimization.