Based on the information provided in the extracts, it seems that Airbyte currently does not have a built-in mechanism to split the steps in the way you described. When a failure occurs, Airbyte retries the entire connection, including the data sync and normalization steps, which can indeed consume more resources. However, there's a discussion in a [Slack conversation](
https://airbytehq.slack.com/archives/C021JANJ6TY/p1670321195748919) about a similar issue where a user suggested a feature request for a retry mechanism that ensures incomplete writing does not produce partial data. The support team encouraged the user to open a feature request for this. You might want to consider doing the same for your specific case. You can create a feature request by going to the [issues tab in the Airbyte repository](
https://github.com/airbytehq/airbyte/issues). In the meantime, you might want to ensure that your custom DBT transformations and profiles file are correctly set up to avoid failures. The [Airbyte documentation](
https://docs.airbyte.com/operator-guides/transformation-and-normalization/transformations-with-airbyte) provides guidance on how to set up transformations with Airbyte, including how to add custom DBT transformations.