Auto Update SQL Catalog Item

Ataccama treats SQL Catalog items as its own separate artifact. If metadata upstream is refreshed, I believe you will have to manually update the downstream catalog item.

I am assuming when you say that the metadata upstream changes, rules / business terms are being updated. The best way to catch those downstream is to create detection rules that will find downstream columns to apply those changes 

yes everytime we need to publish to get all the source columns for SQL CI

How is your current query structured for the SQL CI?

select col1, col2 where object = “abc” if in source col2 is deleted, then SQL CI should be auto updated, but it is not.

Just clarifying - If within the parent table, the source column, “col2” is deleted. The SQL CI will not reflect this, because it is its own artifact that has no real dependency on the upstream parent table. You will have to manually edit the SQL CI in order to reflect those changes. Ataccama on the backend treats them as their own independent artifacts if that makes sense. The only way it would detect that, would be if it was a normal catalog item where it is just selecting all from that table. When it is a normal catalog item, ataccama recognizes that a column is gone, and will remove it from the catalog. But, SQL CI do not behave this way unfortunately