Applies to
Platform: Microsoft SQL Server · Snowflake · Snowflake dbt · Databricks · Databricks dbt · Fabric Lakehouse · Fabric Warehouse · Oracle
This business rule warns when the name of a model object contains a period, a backslash or a slash. It raises a warning, and generation continues. The rule ID is ID-10049.
Message
The client shows a warning with this text on the model object. <model object name> and <type> stand for its name and type.
Model object '<model object name>' of type '<type>' has problematic characters in the name. This could cause problems during generation, deployment or load.
On the model object card, point to the warning icon to see this message with the rule ID: Warning ID-10049. The Generate Artifacts page lists the message without the ID.
Cause
The model object name contains ., \ or /. Other characters, such as % or a space, do not raise this warning. The rule checks all model object types except Source.
Fix
- Open Edit Model Object, see Edit a Model Object.
- Rename the model object without
.,\and/, for example with an underscore instead, and save. The warning disappears.
Renaming a model object also renames terms named after it. Renaming an Entity renames its identity term, for example scd_0_SK to scd_zero_SK. Renaming a Hub renames the terms named after it in related model objects, such as Driving Key Links and Link Satellites; the identity term of a Hub, Hub_HK, does not carry the Hub's name. Terms with these characters in their names raise the warning of Model object has term with problematic characters in name (Business Rule).
Check the result
The warning icon is gone from the model object.
Example
In a Data Mart project on Microsoft SQL Server, the Mart Composite gets the name common.salestransaction_doubled. The client shows:
Model object 'common.salestransaction_doubled' of type 'Mart Composite' has problematic characters in the name. This could cause problems during generation, deployment or load.