Can DBT work with XML data?

Archive
1

Just started exploring DBT, and I would like to pair it with SnowFlake autoingest. The files that would mainly be processed are XMLs and I was wondering if DBT can extract data from an XML as SnowFlake does with XMLGET?

The reason I don’t want to extract the XML data using SnowFlake it is because the autoingest feature doesn’t support more complex queries.

2

dbt is designed to do transformations in-database (essentially cobble together a bunch of SQL code and run it), and for this kind of thing it’s probably better to rely on the functionality the database provides