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"]
}
]
}