Excluded table is starting table
Published 06 March 2025
A table that is being excluded is also being used as a starting table. This creates a conflicting configuration.
Why this is a problem
Excluded tables are completely ignored during subsetting, but starting tables are the entry points for data selection. A table cannot be both ignored and used as a starting point.
How to fix
Choose one of these approaches:
Option 1: Remove from starting tables
Keep the table excluded and find a different starting point:
{
"startingTables": [
// Remove the conflicting table from this array
],
"excludedTables": [
{
"schema": "dbo",
"name": "ConflictingTable"
}
]
}Option 2: Remove from excluded tables
Use the table as a starting point and allow it to be processed:
{
"startingTables": [
{
"table": {
"schema": "dbo",
"name": "ConflictingTable"
},
"filterClause": "Status = 'Active'"
}
]
// Remove from excludedTables array
}Common scenarios
Audit tables: Often excluded but sometimes needed as starting points for compliance data
Log tables: Usually excluded but may be required for specific time-based subsets
Archive tables: Typically excluded but might be starting points for historical data analysis