Can I include table/column descriptions in a Collibra Catalog data source?

Hi Jeffrey,

Depending on the data source and driver that you are using to ingest the physical data dictionary, you should be able to ingest the table and column descriptions.

Edwin:
Is there any documentation on how to add other metadata properties to the Data Source?
Thanks…

Here is an article for Oracle data source.
https://support.collibra.com/hc/en-us/articles/360010145697-How-to-import-table-and-column-descriptions-from-Oracle-Data-Source-ingestion-with-Collibra-Catalog-

Could you please list which data sources you are trying to ingest?

Thank you!

Arvind:
I’m ingesting standard SQL Server schemas using the generic JDBC SQL 2014 driver. This article refers to Oracle Bring-Your-Own-Drivers, so isn’t much help for this exercise. I don’t see a way to modify the Schema Refresh dialog to include other SQL Server metadata properties.

Jeff,
Oracle was an example and I wasn’t sure which database you were using. Could you please let me know where comments are stored on SQL server?

Is it via extended properties?

What’s your SQL query to see comments on table or column level?

Great stackoverflow article. I didn’t create the schema so don’t know what they used for table/column comments. I’ll ask around.
Thanks!!!

Hi Jeffrey,

What additional SQL Server metadata properties that you want to ingest to Collibra?

It may be best to talk to Collibra Support if this is feasible.

We want table descriptions and column descriptions. I’ll open a ticket.
Thanks…

@jeffrey.evoy were you able to get this working? It looks like Collibra has fixed the issue in 2021.02.01 release and you should be able to import descriptions from table and columns. Descriptions from system will go to new attribute called’ Description from source system’.

I tested it on one of my sql server and was able to import description at table and column level. I’m using Collibra provided driver from market place. As my SQL server is storing value in extended property, I used ‘Other’ property of driver with this value.

Other=TableExtendedProperty=MS_Description;ColumnExtendedProperty=MS_Description;

Thanks!