Starting table is static data table error

A table is being defined as a starting table and a static data table. It can only be one.

How to fix

Problem example:

{
  "startingTables": [
    {
      "table": {
        "schema": "dbo",
        "name": "Users"
      },
      "filterClause": "Status = 'Active'"
    }
  ],
  "staticDataTables": [
    {
      "schema": "dbo",
      "name": "Users"        // Same table defined in both sections
    }
  ]
}

Choose one approach for each table:

Option 1 - Starting table (follows relationships):

{
  "startingTables": [
    {
      "table": {
        "schema": "dbo",
        "name": "Users"
      },
      "filterClause": "Status = 'Active'"
    }
  ]
}

Option 2 - Static data table (includes all data):

{
  "staticDataTables": [
    {
      "schema": "dbo",
      "name": "Users"
    }
  ]
}



Didn't find what you were looking for?