Hello, we have a SQL Server instance with a lot of...
# feature-requests
n
Hello, we have a SQL Server instance with a lot of metadata descriptions stored as mssql column comments. I dont see a way to get those comments loaded as actual comments in datahub. Is that a feature request or something I am missing on how to implement?
plus1 1
m
I was under the impression that we automatically pull those comments. Is that not happening?
f
We are facing the same situation with our SQL Server databases. The columns and table descriptions don't get loaded in Datahub.
n
Correct, I am not seeing those descriptions pulling in.
m
looks like this is a bug we should look into. /cc @orange-night-91387
👀 1
b
We also have the same condition in our SQL Server Databases and this new feature would help us a lot. These info are stored in the _sys.extended_properties_ system table, with a link to the object. We are willing to help in this issue.
plus1 2
m
that would be great @busy-television-64784
if you could figure out how to expand on the init script to add comments and then how to expand the source to get those comments, that would be awesome
n
@busy-television-64784 I think that join to the sys table should be fairly cheap and performant. I think there is also a system view that does that all for you per table, but I cant recall it right now.
b
Ok, but unfortunately I only will be available to do that by next week.
Hello @mammoth-bear-12532, should we open an issue on github about this?
m
Hi @busy-television-64784: yes please do!
b
I opened the issue #4524 . I hope I did it correctly, as it was my first opened issue in this project.
m
thank you @busy-television-64784
f
I've redo the ingestion of SQL Server databases in version 0.8.33 of datahub and now the column and table descriptions are been loading sucessfully. Thank you all for the support!
plus1 1