We are using Foundry code repositories for SQL transforms, and when raising pull requests for SQL files (350+ lines), the Files changed view does not show a full diff. Instead, Foundry displays a message like “Large diffs are not shown by default”, and when expanding the file, only the final (right-hand) version of the SQL is shown - the original/left-hand side is blank.
This makes it very difficult to review changes, as we can’t see what was removed or modified across the whole file, only the final state. In tools like Azure DevOps, we’re able to view a complete side-by-side or unified diff for the entire file within the PR itself, which is much more reviewer-friendly.
Given that our SQL files are large and frequently rewritten (e.g. converting T-SQL to Foundry/Spark SQL), is there:
-
A way to force Foundry PRs to show the full file diff for large SQL files?
-
A configuration or best practice to improve diff visibility?
-
Or is this a known limitation of the Foundry PR UI?
we’d like to understand if there’s a supported way to review full SQL diffs directly in Foundry PRs.