Manual relationship table with no name
Published 06 March 2025
A manual relationship is defined with no table name.
How to fix
Add the missing name
property to either the source or target table in your manual relationship.
Problem example:
{ "manualRelationships": [ { "sourceTable": { "schema": "dbo" // Missing "name" property }, "sourceColumns": ["CustomerId"], "targetTable": { "schema": "dbo", "name": "Customers" }, "targetColumns": ["Id"] } ] }
Fixed:
{ "manualRelationships": [ { "sourceTable": { "schema": "dbo", "name": "Orders" // Added missing name }, "sourceColumns": ["CustomerId"], "targetTable": { "schema": "dbo", "name": "Customers" }, "targetColumns": ["Id"] } ] }