The Schema Watcher
When a column of a database is renamed, whatever the Semantic Layer says about it silently stops being true. The Schema Watcher notices: once a day it reads each Data Source’s schema, its tables, columns and their types, and compares it with the day before. It only notices: it never changes the Semantic Layer itself.
A Data Source that can’t be reached that day is skipped, not reported as changed.
Who gets a notice
Section titled “Who gets a notice”When the schema changed, a schema notice goes to the users who may create Context Change Requests on the Data Source, whether that Right was granted to them or to a Group they belong to. Nobody else sees it, Tenant admins included: the Right “Manage Roles and Rights” alone brings no notice.
Where notices show
Section titled “Where notices show”- In the Data Studio, Data Sources shows how many schema changes wait for you, and the list marks each changed Data Source with Schema changed.
- On the Data Source’s page, the notices show above its tabs, newest first.
- In the Web App, the app switcher counts them on the Data Studio, next to the requests waiting for your review.
Each notice says when the change was found and sums it up, such as 2 columns added, 1 column removed. Select Show what changed for the tables and columns added or removed and the types changed, table by table, with the first 50 changes.
Fix with agent
Section titled “Fix with agent”Select Fix with agent. The Web App opens on Start with the Data Source ticked and a first message in the message field that loads the Schema Change Fix Skill with the Data Source and the change. Send it, and the agent compares the schema with the Data Model and the entries that name the changed tables and columns, and proposes the fix as a Context Change Request.
Fix with agent also needs access to the Data Source. Without it, you read and dismiss the notice, which says so.
Dismiss a notice
Section titled “Dismiss a notice”Select Dismiss when a change needs no fix, or once it is fixed. It disappears for you only: everyone else who got it dismisses it for themselves.
Notices are deleted with their Data Source.