Skip to main content
Solved

SQL Catalog Items

  • November 27, 2025
  • 2 replies
  • 31 views
S
Data Voyager

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

Best answer by ThomasPro

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.

2 replies

T
Data Pioneer L2
Forum|alt.badge.img+2
  • ThomasProData Pioneer L2
  • Data Pioneer L2
  • Answer
  • December 11, 2025

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.

S
S
Data Voyager

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.

Community Terms of Use & ConditionsCookie settingsAccessibility statement