Skip to content
  • There are no suggestions because the search field is empty.

Dataflows amount (Business Rule)

Applies to
Platform: Microsoft SQL Server · Snowflake · Snowflake dbt · Databricks · Databricks dbt · Fabric Lakehouse · Fabric Warehouse · Oracle

This business rule checks the number of dataflows of a model object. It raises an error, which blocks generation in the client until you fix it. The rule ID is ID-10000.

Message

The client shows an error with this text on the model object. <model object name> and <type> stand for its name and type, <amount> for the allowed number, for example exactly 1 or above or equal to 1.

Model object '<model object name>' of type '<type>' has the wrong amount
of dataflows defined. The amount of dataflows should be <amount>.

On the model object card, point to the error icon to see this message with the rule ID: Error ID-10000. The Generate Artifacts page lists the message without the ID.

Error popup of a Current View card with Error ID-10000 and the message details

Cause

The model object has fewer or more dataflows than its type allows:

  • Exactly one: Stage, Store Composite, Core Composite, Mart Composite, Mart Out, Mart Hierarchy Flatten, PIT, Current View, History View, RawVault Composite, Vault Out, Hierarchy Flatten and the Business Vault variants of these Data Vault types.
  • At least one: Store Entity, Entity, Fact, Mart Dimension, Mart Fact, Reference Table and the Hub, Link and satellite types of Data Vault.

Fix

  1. Open Manage Term Mappings of the model object.
  2. Delete the extra dataflows, or add a dataflow to a model object without one, see Delete a Dataflow and Add a Dataflow. The error disappears.

Check the result

The error icon is gone from the model object, and generation is no longer blocked by it.

Example

In a Data Mart project on Microsoft SQL Server, the Mart Out dataflow_multi_cached_mo gets a second dataflow. The client shows:

Model object 'dataflow_multi_cached_mo' of type 'Mart Out' has the wrong
amount of dataflows defined. The amount of dataflows should be exactly
1.

Related articles