Support dbt transforms in Airbyte

[thomas-gerber]

Is your feature request related to a problem? Please describe.
As a Faros CE user, I want to apply transformations on what Airbyte writes against the Faros Schema to capture my idiosyncrasies.

Describe the solution you'd like
Support for dbt transforms in Airbyte: https://docs.airbyte.com/operator-guides/transformation-and-normalization/transformations-with-airbyte
This would allow the ability to write lightweight transforms in SQL for one's own consumption, but also publish and share those with the community for common use cases. For example, transforming tasks that have a certain label or type into incidents.

Describe alternatives you've considered
It is possible for Analysts in Metabase to transform the data with SQL, but they cannot write it back to the database. dbt transforms during ingestion allows users to leverage canned dashboards better, and provide better separation of concerns between the analyst and data engineer personas.

Additional context

• Currently blocked by Make normalization mapping configurable for custom connectors airbytehq/airbyte#7229 on the Airbyte side.
• If possible, the user should have the option in Airbyte to have the non-transformed data written to Faros (desirable when your dbt transform creates a new metric table like Custom Metric Table dbt transform example #116) or discarded (desirable when your dbt transform swaps entity types, like Task to Incident dbt transform example #114 and Build to Deployment dbt transform example #115 ).

[thomas-gerber]

Airbyte now supports this! Updated the documentation: https://community.faros.ai/docs/data-transforms-with-dbt.