Improve custom dbt transformation handling profiles.yml

[ChristopheDuong]

Tell us about the problem you're trying to solve

As follow up to #4721, do proper yaml parsing/extract to be used in

airbyte/airbyte-workers/src/main/resources/dbt_transformation_entrypoint.sh

Line 7 in 7decb12

PROFILE_NAME=$(grep -e "profile:" < "${CWD}/git_repo/dbt_project.yml" | sed -E "s/profile: *['\"]?([^'\"]*)['\"]?/\1/")

Describe the solution you’d like

we should write (a python?) script that uses a yaml parser to load the dbt_project.yml file and output the name of the profile being used, something like: load yaml file; print(config.get("profile")) it would be more robust

[marcosmarxm]

Python yaml is native so probably should be easy to do this! :D