Amazon SageMaker Unified Studio assets

The SageMaker Unified Studio integration for metadata uses a specific subset of asset types. These are available out of the box. For more information on asset attributes or metadata synchronized per asset type, go to Synchronized Amazon SageMaker Unified Studio data.

The same asset, relation, and attribute types are used for both Amazon Redshift and AWS Glue data sources.

Asset type Description
Technology Asset 
System

Executable software that you can buy commercially off the shelf (COTS), or build internally, to automate one or more business functions that help run a business smoothly and efficiently.

Examples: CRM, ERP, EDW
Technology Asset 
Database

A collection of data that is systematically organized or structured, to make it easy to create, update, and query the information.

Examples: Ora_DGC_V45, SalesDB2020
Data Asset  Data Structure 
Schema

An asset that contains the location of specific data. It provides all the details that are required for setting up a connection to a database or server.
Data Asset  Data Structure 
Table

An implementation of data entities in columns and rows, in a given database system. It is the basic structure of a relational database.

Examples: Account_tbl, CUST_ADDR9i
Data Asset  Data Structure 
Database View

A Database View is a virtual table based on the result-set of an SQL statement.
Data Asset  Data Element 
Column

An atomic unit of data that can be stored in a database table.

Examples: FST_NM, EMPID

SageMaker Unified Studio diagram view

Steps

  1. Open the asset page.
  2. Click the Diagram tab.
    The diagram is shown in the default diagram view.
  3. Click to add a new view.
  4. Select the Text option below the diagram view name.
    The diagram view text editor is shown.
  5. Copy the code from the Show JSON code section below and paste it in the diagram view text editor.
  6. Click Save.
  7. Edit the name and description of the diagram view as needed.
Copy 
{
  "nodes": [
    {
      "id": "System",
      "type": {
        "id": "00000000-0000-0000-0000-000000031302"
      }
    },
    {
      "id": "Database",
      "type": {
        "id": "00000000-0000-0000-0000-000000031006"
      }
    },
    {
      "id": "Schema",
      "type": {
        "id": "00000000-0000-0000-0001-000400000002"
      }
    },
    {
      "id": "Table",
      "type": {
        "id": "00000000-0000-0000-0000-000000031007"
      }
    },
    {
      "id": "Database View",
      "type": {
        "id": "00000000-0000-0000-0001-000400000009"
      }
    },
    {
      "id": "Column",
      "type": {
        "id": "00000000-0000-0000-0000-000000031008"
      }
    }
  ],
  "edges": [
    {
      "from": "System",
      "to": "Database",
      "label": "",
      "style": "arrow",
      "type": {
        "id": "00000000-0000-0000-0000-000000007054"
      },
      "roleDirection": true
    },
    {
      "from": "Database",
      "to": "Schema",
      "label": "",
      "style": "arrow",
      "type": {
        "id": "00000000-0000-0000-0000-000000007024"
      },
      "roleDirection": true
    },
    {
      "from": "Schema",
      "to": "Table",
      "label": "",
      "style": "arrow",
      "type": {
        "id": "00000000-0000-0000-0000-000000007043"
      },
      "roleDirection": true
    },
    {
      "from": "Schema",
      "to": "Database View",
      "label": "",
      "style": "arrow",
      "type": {
        "id": "00000000-0000-0000-0000-000000007043"
      },
      "roleDirection": true
    },
    {
      "from": "Table",
      "to": "Column",
      "label": "",
      "style": "arrow",
      "type": {
        "id": "00000000-0000-0000-0000-000000007042"
      },
      "roleDirection": false
    },
    {
      "from": "Database View",
      "to": "Column",
      "label": "",
      "style": "arrow",
      "type": {
        "id": "00000000-0000-0000-0000-000000007042"
      },
      "roleDirection": false
    }
  ],
  "showOverview": false,
  "enableFilters": true,
  "showLabels": true,
  "showFields": true,
  "showLegend": true,
  "showPreview": true,
  "visitStrategy": "completeGraph",
  "layout": "HierarchyTopBottom",
  "maxNodeLabelLength": 50,
  "maxEdgeLabelLength": 30,
  "layoutOptions": {
    "compactGroups": false,
    "componentArrangementPolicy": "topmost",
    "edgeBends": true,
    "edgeBundling": true,
    "edgeToEdgeDistance": 5,
    "minimumLayerDistance": "auto",
    "nodeToEdgeDistance": 5,
    "orthogonalRouting": true,
    "preciseNodeHeightCalculation": true,
    "recursiveGroupLayering": true,
    "separateLayers": true,
    "webWorkers": true,
    "nodePlacer": {
      "barycenterMode": true,
      "breakLongSegments": true,
      "groupCompactionStrategy": "none",
      "nodeCompaction": false,
      "straightenEdges": true
    }
  }
}