Standard Skill: Model a Data Source
Model a Data Source is a Standard Skill: it keeps a Data Source’s Data Model true to its database and to what you know about it. The agent loads it when you ask it to model a Data Source, to add a table, a join or a measure to its Data Model, or to bring the model up to date after the database changed. To pick it yourself, type / and choose model-a-data-source.
After the agent created or changed tables in a Managed Database, it offers to update the Data Model with this Skill, so that the model follows the database.
What the agent does
Section titled “What the agent does”- It reads the current model. Without one, it drafts a first model with Schema Bootstrap instead.
- It compares it with the database and lists what differs: new, removed or retyped tables and columns, and parts of the model whose source is gone.
- It settles the change with you. It asks what the schema can’t tell, one question at a time with its recommended answer first. It checks a new key for uniqueness and a new join for rows without a partner. For a new measure, it runs the query and shows you the result, and adds the measure only if you confirm the number looks right.
- It writes the whole model, keeping what still holds, and removes nothing whose source still exists unless you asked for it.
- It proposes it as a Context Change Request, with an explanation of why the model changes and the open questions. Terms, Rules or Verified Queries you told it about along the way can go into the same request.