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