Skip to main content
You can create a semantic model in NexusOne to turn datasets into business-friendly insights. After creating a semantic mode, it becomes a draft that’s submitted for review, approved by an administrator, and then deployed.

Prerequisites

  • Appropriate permissions: nx1_semantic_admin or nx1_semantic_modeller
  • An existing domain created using DataHub
  • A previously ingested dataset within a DataHub domain

Create a semantic model

Perform these steps to create a semantic model.
  1. Log in to NexusOne.
  2. On the top navigation bar, hover your mouse over Catalog & Models and then select Semantic Models.
  3. At the top right corner of the page, click Create Model.
  4. Enter a model name.
  5. Select a DataHub domain.
  6. Optional: Describe the purpose of the semantic model.
  7. Select a catalog and schema.
  8. Select a table scope. Three table scope options are available:
    • All tables: NexusOne considers all tables
    • Include only: You manually include specific tables
    • Exclude: You manually exclude specific tables
  9. Optional: Select Match from Catalog to allow CrewAI to scan the domain catalog and auto-fill source tables, columns, and SQL based on your model definition.
  10. Select one or more source tables from the list.
  11. Click Add Column to manually enter new columns. When entering a column, enter the following:
    • Column name
    • Business name
    • Data type
    • Source table
    • Source column
  12. Enter a SQL command to define the semantic model.
  13. Click Create Model.
After creating the semantic model, its status appears as a Draft for later review by an administrator.

Additional resources

For an overview of the Semantic Models feature, refer to Semantic Models overview.