(partially) AI generated sources.yml and models.yml

[maikelkorff]

Describe the feature

Within the tabs of power user in vscode, you should have the ability to create (partially) a source.yml or model.yml generated by ChatGTP4. When you have like one hundered dbt .yml files as a template as input, ChatGTP4 can be used to automatically generate a .yml based on the query including automatic generated descriptions for example.

This is a step no analyst or developer likes to do manually and leads to bad documented work and poorly structured models. When you are able to run a query in dbt Power User you can generate a model for it.

Describe alternatives you've considered

This is an alternative, but this tool is way too expensive for engineers only to be used with dbt and creating yml's, because you are not doing this all the time.

https://www.airops.com/blog/using-ai-to-generate-yaml-entries-for-dbt-models

Who will benefit?

Every engineer using dbt Power User can benefit. But when models are documented even analyst can benefit.

Are you willing to submit PR?

• [ ] Yes I am willing to submit a PR!