[X] I have searched the existing issues, and I could not find an existing issue for this bug
Current Behavior
Currently we are adding microbatch to the list of builtin_incremental_strategies only when the behavior flag require_batched_execution_for_custom_microbatch_strategy is set to True. However, we only want to set it True when that flag evaluates to False. This is because having the flag set to True implies by the transitive property that the project has a custom microbatch macro defined. In this situation, we don't want microbatch to be in the list of builtins because if the adapter doesn't have a builtin microbatch macro, things will break. Said another way, the only time that having microbatch in the list of builtin incremental strategies is relevant is when the flag is False.
Expected Behavior
microbatch should only be added to the list of builtin_incremental_strategies when the behavior flag require_batched_execution_for_custom_microbatch_strategy is False
Steps To Reproduce
Grab an adapter that doesn't support microbatch yet, like dbt-athena
Create a project with a custom microbatch macro
Create a microbatch incremental model
Set require_batched_execution_for_custom_microbatch_strategy to true in your project.yaml
Is this a new bug?
Current Behavior
Currently we are adding
microbatchto the list ofbuiltin_incremental_strategiesonly when the behavior flagrequire_batched_execution_for_custom_microbatch_strategyis set to True. However, we only want to set it True when that flag evaluates to False. This is because having the flag set to True implies by the transitive property that the project has a custom microbatch macro defined. In this situation, we don't wantmicrobatchto be in the list ofbuiltinsbecause if the adapter doesn't have a builtinmicrobatchmacro, things will break. Said another way, the only time that havingmicrobatchin the list of builtin incremental strategies is relevant is when the flag is False.Expected Behavior
microbatchshould only be added to the list ofbuiltin_incremental_strategieswhen the behavior flagrequire_batched_execution_for_custom_microbatch_strategyisFalseSteps To Reproduce
require_batched_execution_for_custom_microbatch_strategyto true in your project.yamldbt-runRelevant log output
No response
Environment
Additional Context
No response