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