Airbyte is an open-source data integration engine that helps you consolidate your data in your data warehouses, lakes and databases.

Airbyte

<@U04S8PLJWMT> I woud like one example of the transformation FlattenFields being used in a manifest file.

The knowledge sources do not explicitly mention `FlattenFields` being used in a manifest file example. However, they do document the closely related `DpathFlattenFields` transformation, and there is a real-world example of it in the Airtable connector's manifest:

```- type: DpathFlattenFields
  field_path:
    - "fields"
  delete_origin_value: true```
This flattens the nested `fields` object to the top level of the record and deletes the original `fields` key. [<https://github.com/airbytehq/airbyte/blob/master/airbyte-integrations/connectors/source-airtable/manifest.yaml#L426-L446|Airtable manifest>]

For reference, `FlattenFields` (without a path) flattens the entire record to a single level, with an optional `flatten_lists` boolean (default `true`). [<https://docs.airbyte.com/platform/connector-development/config-based/understanding-the-yaml-file/reference#/definitions/FlattenFields|FlattenFields docs>] A basic usage in a manifest would look like:

```transformations:
  - type: FlattenFields
    flatten_lists: true```
However, I was unable to find a concrete manifest file in the knowledge sources that uses `FlattenFields` directly — only `DpathFlattenFields` appears in the provided examples. :thumbsup: 0 button :thumbsdown: 0 button :information_source: *Tip:* Mention *@kapa.ai* in the thread for follow-ups or *DM the app* for *1-to-1* help.