if airbyte is syncing a table from s3 (json) to postgres how many job containers will be launched at the same time source destination and normalization container or normalization happens in last?

Airbyte's data synchronization process involves extracting data from the source (in this case, S3), loading it into the destination (Postgres), and then optionally performing a normalization step. The normalization process structures the data from the source into a format appropriate for consumption in the destination. For example, it can un-nest JSON from the source into a relational table format in the destination like Postgres. This step is optional and can be enabled or disabled when setting up a connection. If enabled, it happens after the data has been loaded into the destination. However, the extracts do not provide specific information on how many job containers are launched simultaneously during this process. The extracts mention running source and destination Postgres containers, but it's not clear if these are run concurrently or sequentially. For more detailed information on how Airbyte manages its jobs and tasks, you may want to refer to the [Airbyte Documentation](https://docs.airbyte.com/). Sources: - [Airbyte Documentation - Core Concepts](https://docs.airbyte.com/cloud/core-concepts) - [Airbyte Documentation - Connections and Sync Modes](https://docs.airbyte.com/understanding-airbyte/connections)