Prerequisites
- Appropriate permissions:
nx1_semantic_adminornx1_semantic_modeller - An existing domain created using DataHub
- A previously ingested dataset within a DataHub domain
Create a semantic model
- Web portal
- REST API
Perform these steps to create a semantic model.
- Log in to NexusOne.
- On the top navigation bar, hover your mouse over Catalog & Models and then select Semantic Models.
- At the top right corner of the page, click Create Model.
- Enter a model name.
- Select a DataHub domain.
- Optional: Describe the purpose of the semantic model.
- Select a catalog and schema.
- 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
- 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.
- Select one or more source tables from the list.
- 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
- Enter a SQL command to define the semantic model.
- Click Create Model.