dbt with parquet files in azure data lake as source

I have an azure environment where I want to use dbt pipelines for my ETL/ELT
Source will be parquet files in azure data lake and destination will be azure sql database.

Is this something that works out of the box with dbt? Do I need specific pluginsg/packages? Are there known issues/limitations?

I have some experience in dbt but only using database connections.

I understand that file as source is not supported out of the box
a workaround might be to create external tables on top of the parquet files

1 Like