[Feature] <title> supporting XML conversion to dbt seeds

[aadishsanghvi]

Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt functionality, rather than a Big Idea better suited to a discussion

Describe the feature

I have a big use case where I want to convert incoming nested XML data into rows as columns of my database. Basically replicating what dbt seeds does for CSV, the same feature for XML data as well.

This feature makes sense for DBT because traditional ETL enterprise tools like Informatica, Pentaho and NiFi have already been offering this for the longest time.

Describe alternatives you've considered

Alternatives I have considered involved writing custom python scripts that convert XML to CSV, but the problem with this is XML schema for the file needs to be prior known. We need a solution that does this conversion regardless of the schema. You can find this implemented in spreadsheet tools like MS Excel and LibreOffice Calc.

Who will this benefit?

Anyone who has a use case to import XML data into their data pipelines.

Are you interested in contributing this feature?

Yes I would be happy to

Anything else?

No response