Computed Join Query Diff
Permissions
Any user with at least Reporter permission on the parent datastore can view the History section and open the Query Diff for a Computed Join. See Computed Join Permissions for the full matrix.
Computed Joins include a Query Diff view in the History section of the container's Overview tab that compares the previous and updated values of a tracked SQL clause. Use it to review changes, troubleshoot regressions, and see who changed what and when.
Tracked Fields
The Query Diff dialog opens for changes to these three SQL fields:
| Field | What it captures |
|---|---|
| Select Clause | Changes to the projected columns |
| Where Clause | Changes to the post-join filter |
| Group By Clause | Changes to the grouping configuration |
Other Computed Join changes (for example, Join Type, the join key fields and prefixes, Description, Owner, Tags, Additional Metadata, freshness or volumetric tracking, incremental settings, and renames) are still recorded in the History section, but appear as a plain text change line instead of a side-by-side diff.
The Diff Dialog
The diff is recorded after a change is saved; it is not a pre-save preview. When a revision changes a tracked SQL clause, the History section shows a small View {Clause} Changes button next to the change entry (for example, View Select Clause Changes). Clicking it opens a dialog titled {Clause} Changes with two side-by-side editors:
- From shows the previous value with removed portions highlighted in red.
- To shows the new value with added portions highlighted in green.
The diff is computed at the character level on the raw SQL text. Reformatting (extra whitespace, line breaks, comment changes) shows up as a difference even when the SQL is semantically identical.
The dialog footer shows an Updated by label with the user's name and avatar, followed by the timestamp of the change.
If a tracked field has no prior value (the first time it was set), the dialog opens with a single read-only editor instead of the From/To split, and the dialog title omits " Changes".
For step-by-step instructions on opening the diff, see View Query Diff.