Manual relationship table with no name

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





Didn't find what you were looking for?