SQL Catalog Items

Question

Hi All,

We have a few SQL Catalog Items that represent data in a way that the users find intuitive (compared to the awkward way the data is stored in the source system). However, whenever I update the SQL in anyway, like to add or remove a column/attribute, all field definitions, terms, etc are removed. They can be seen in the previous version of the Catalog Item, but I have to either restore the old Catalog Item or re-enter all the definitions.

Is there a way to update the SQL behind SQL Catalog Items and not impact the unchanged attributes?

Thanks for any help you can provide.

Regards

Stu

ThomasPro · Accepted Answer

I do not believe so for the fact that I believe Ataccama views this as a “new” catalog item since the underlying query that builds the catalog item has changed. I do not believe the metadata will follow this “new” version. However, you can map business terms to detection rules to help with restoring the metadata attached to the catalog item.

stuart.campbell · Answer

Thanks Thomas - your reasoning makes sense about why it wouldn’t maintain the metadata. I decided to push the results of the SQL output to our Data Warehouse and have created a standard Catalog Item and removed the SQL Catalog Item.

I appreciate you taking the time to reply. Have a great weekend.

Sign up

Login to the Ataccama Community

Scanning file for viruses.

This file cannot be downloaded