Adding a Physical Data Model

Physical models are created by selecting the tables and columns you want to include from the data source.

  • You can create more than one physical model from one data source (connection). For example, a model for a system administrator will include the system tables from the data source, while the model created for end users will have the required data tables from the same data source.
  • You cannot use multiple data sources to create a physical model.

To create a physical model, perform these actions:

  1. On the Metadata Insights menu bar, click Model.
    The Logical Model tab is displayed by default.
  2. Click the Physical Model tab.
  3. Click the Add Physical Model button . You can also choose to create a new model by copying an existing model and renaming it:
    1. Select the check box next to the existing model and click on the Copy Model button .
    2. If necessary, rename the model on the Copy Physical Model page.
    3. Click the Save button.
      For more information, see Editing a Physical Model.
  4. In the Name field, enter a name for the model.
  5. In the Source connection type field, choose the type of data source that you want to model, then select the specific data source in the Source connection name field.

    The Source connection name field displays the data sources defined for the selected connection type. For example, if you select Apache Cassandra in the Source connection type field, the Source connection name field lists all the Apache Cassandra data sources you have defined in the system.

    In case you have not already defined a connection or want to create a new connection for this physical model, you can do this using the Add Data Sources page. Access this page through the Data Sources tab or via Management Console module.

  6. Click Fetch Metadata.
  7. Select the data you want to include.

    To select a table or view, check the box in the Include column for the table or view you want to include. To select all the tables listed in the page, select the Include check-box in the header row. When you select a table, all its columns are included in the model.

    To select specific columns to include in the model, hover over the table containing the columns you want and click the Select columns button that appears.

    You can search for tables based on their name or type using the Filter field above the list of tables. For example, if you want to view only those tables that have names containing the word "new", enter new in the filter field. Similarly, you can filter out tables based on their type. However, you can use only one of the filter criteria, either name or type.

  8. Click Save.

The new model is created and listed on the Physical Models tab of the Modeling page.