Help for SAP Data Hub Cockpit

Profile Data

Profile your data to learn more about your data, and where it might be lacking information.

Context

You can access the profiled data in several ways.
  • From the Cockpit Overview page, click the charts in the Discovery tile under Service KPIs.
  • From the Cockpit Overview page, click Recent Profile Results in the Discovery tile under Quick Links.
  • From the Discovery page, you can see the profiled files.
  • From the Discovery page, click Profiled Data.
At this time, profiling is only supported for these systems and connections. To view the supported cloud connections, see Setup Cloud Profiling Storage.
System Connection
SAP HANA SAP HANA SQL
SAP Vora

HDFS

Vora Catalog

Cloud connections (S3, GCS, WASB, and so on)

Procedure

  1. From the Cockpit Overview page under Quick Links, click Explore Connections under the Discovery tile.
  2. Navigate to the connection and folder that contains the object that you want to profile. Select an object within a connection, and then click Start of the navigation pathProfiling Next navigation step Start ProfilingEnd of the navigation path. Click the refresh icon in the upper, right corner to update the status of the profiling.
  3. (Optional) You can click the Refresh icon to see the status of your Profiled tasks. Click the status to provide additional information.

    In the Profiling Status dialog, depending on the status, you may find some of this information.

    Profiling Status Description
    Profiling The object is in process for the first time.
    Profiled The object profiling is complete.
    Profiled (not loaded) The object profiling is complete, and the fact sheet has not been viewed.
    Profiled (out-of-date) The object profiling is complete, and the object has been modified since the last profile.
    Profiled (not loaded, out-of-date) The object profiling is complete, the fact sheet has not been viewed, and the object has been modified since the last profile.
    Not Profiled The object can be profiled, but has not been profiled yet.
    Not Supported The object cannot be profiled.
    Regenerating The object being profiled after having been profiled previously.
    Error The object profiling was canceled by the user, or could not be completed due to one or more errors.
    Option Description
    Profiling Status Indicates whether the object has been profiled.
    Name Name of the object.
    Type Type of object.
    Started During processing, the date and time when the object began profiling is listed.
    Completed If the object was profiled, the date and time is listed.
    Runtime The amount of time it took to process the object.
    Profile History Shows up to five of the previous runs. If the indicator is green, then the object was profiled and loaded into the fact sheet. When orange, then the object was profiled, but may be out of date, or the fact sheet was not loaded. When red, then there was an error during processing, or the user canceled profiling. Error messages are shown at the bottom of the dialog. Click the message for more information.
    Supported If the object is not a supported profiling type, then you will see 'No'. If you believe that the object is supported, click Check Support.
    Fact Sheet Indicates whether the fact sheet has been loaded.
    Start Profiling Begin profiling the object.
    Cancel Profiling When an object is processing, click to stop the profiling.
    Clear History The profiling status of up to five previous processing attempts is shown in the Profile History option. Selecting this option clears the entire history associated with the profiling attempts on this object. If you clear the history, you cannot view the trend chart in the fact sheet.
    Check Support If the Supported option indicates that the object is not able to be profiled, click to double-check. For example, if you have an object named customer_data.scv and the file extension is supposed to be .csv, then clicking this option may change the Supported option to 'Yes'.
    View Fact Sheet Loads and displays the fact sheet, which includes metadata about the profiled object.
  4. Click Profiled Data.
  5. In the Date Range Filter option, choose one of the options to filter the amount of profiled data that is displayed. The applied filter is shown at the top of the page.
    • Last Week: Last seven days of profiling (default).
    • Last Month: Last 30 days of profiling.
    • Custom Date Range: Type a starting and ending date, or click the calendar icon to choose dates and times (down to the minute) from a calendar.
    • All: All profiled data from the most recent profile to the first object that was profiled.
  6. Filter the results by status (click the Completed, Active, or Error tabs) or by typing the object name in Filter Names.
  7. To view detailed information about each profiled object, select one object and then click Fact Sheet. Likewise, you can view the Metadata, Preview the data, Cancel an active profiling task, and launch another Profile task by clicking those buttons.