@kapa.ai what transformations offer the mappings of the enterprise version? does it allow schema change? aggregations?

In the Airbyte Enterprise version (Self-Managed Enterprise and Cloud with Teams add-on), the Mappings feature allows you to perform the following transformations on your data streams: - Hashing fields (using MD5, SHA-256, SHA-512, and some others via API): This is used to irreversibly obscure sensitive data for security and compliance. - Encrypting fields (using RSA encryption): This is a reversible process to protect sensitive data. - Renaming fields: This helps with schema alignment, readability, and avoiding naming conflicts. - Row filtering: You can filter out rows based on your criteria, ensuring only relevant data is synced to the destination. These transformations are set up per stream, allowing you to control how your source data appears in your destination. The mappings feature is designed to help with data security, compliance, and schema alignment, but it does not support aggregations or arbitrary schema changes such as adding/removing columns beyond renaming, hashing, or encrypting existing fields. There is no mention of support for data aggregations (e.g., sum, average) in the mappings feature in the provided documentation. Mappings do allow for some schema changes—specifically, renaming fields and changing the representation of data via hashing or encryption—but not structural changes like adding new computed columns or performing aggregations on the data as it moves through Airbyte. For more complex transformations, you would need to handle them downstream, after the data has landed in your destination system. References: - [Mappings documentation](https://docs.airbyte.com/platform/using-airbyte/mappings) - [Release notes v1.3](https://docs.airbyte.com/release_notes/v-1.3) - [Release notes v1.5](https://docs.airbyte.com/release_notes/v-1.5)