Create a Logical Data Model from the Output Stage

If you upload data from a data warehouse (for example, Snowflake or Redshift) and use the Output Stage as a source for loading data to your workspaces (see Automated Data Distribution v2 for Data Warehouses), you can generate a logical data model (LDM) based on the structure of tables and/or views in your Output Stage and then publish the generated LDM to the selected workspace. The types of LDM elements are recognized based on the Output Stage naming convention (see Naming Convention for Output Stage Objects in Automated Data Distribution v2 for Data Warehouses).

Steps:

  1. From the Data Integration Console (see Accessing Data Integration Console), click the Data sources tab.
  2. In the list of the Data Sources on the left, click the Data Source pointing to the data warehouse (and the Output Stage in this warehouse) that you want to use as a basis for creating an LMD. The screen with the Data Source details appears.
  3. Click the menu button, then click Publish into workspace
     You are prompted to select the workspace that you want to publish the LDM to.
  4. Select the workspace, and click Select. You are prompted to choose the mode of publishing. The Preserve data mode is selected by default.
  5. Choose the publishing mode, and click Publish. For the full information about each mode, see Publish a Logical Data Model. The publishing process starts. When the publishing completes, you see a message that the LDM has been published. Close this message.