Lineage problems with DBT + Azure SQL

Hi everyone,

I think I tried most of the solutions on the Internet - but with no successful results.

Background:

We are running dbt CLI as our source for the ETL process, and the target is Azure SQL.

Recently we started to use Datahub and one of the things we want to see is the column level lineage.

For those who are not familiar with the datahub, I will make it simply. I use power user for VSC, the same dbt models are generating column level lineage if I change my data warehouse to Snowflake, but if I do it on Azure SQL - nothing.

So, I think the source of the problem has something to do with dbt or Azure sql.

Did someone face the same issues and can help with a possible solution?

  - installed: 1.8.6
  - latest:    1.8.6 - Up to date!

Plugins:
  - fabric:    1.8.7 - Up to date!
  - sqlserver: 1.8.2 - Update available!