Column Descriptions from MS SQL Server

[KAKuznetsov]

Hi!

How can I import column description from extended properties MS SQL ?

For example, sql server tables have descriptions at sys.extended_properties

mssql+pymssql connection does not load column description automatically.

Descriptions i can see with query:

select
db_name() as [database_name]
,s.name as [schema_name]
,a.name as [table_name]
,c.name as [column_name]
, p.value AS [column_description]
from
sys.tables a
join sys.all_columns c on a.object_id=c.object_id
join sys.schemas s on s.schema_id=a.schema_id
left JOIN sys.extended_properties AS p ON p.major_id=a.object_id AND p.minor_id=c.column_id AND p.class=1 and p.name = 'MS_Description'
where a.name = 'lot'
and s.name = 'datamart'

How can i load column description into open-metadata db automatically?