Search Results for

    Show / Hide Table of Contents

    Raw data entity provided a user-friendly UI for user to configure the raw data from external sources. User can create their own raw data by establishing connection to external sources or by uploading csv files from local storage. Once the data is successfully extracted and stored in Data Analytic storage, Data scientist explore the data using specialized methods and visualize it through charts to gain insights. After acquiring all the necessary information for the experiment, they are ready to proceed to the next steps of training ML models.

    Clicking on one of Data models will redirect the user to a screen lists all raw data associated with that particular “Data model”.

    Below table show the description of raw data configurable items.

    Configurable Items Description
    Upload Choose File Select a file from user local storage. The file should be in CSV format
    Query DB DB Type Select type of database server:
    • SQL Server – Microsoft SQL server
    Connection String

    This provides the necessary information to establish a connection with the server.

    For format of a SQL Server connection string, refer to: https://www.connectionstrings.com/sql-server/

    Query String Query to retrieve data from an external database
    Asset Health Subscription Subscription of DM includes assets with associated data
    Project DM project encompass asset with associated data
    Asset from DM that contain data
    Start Date Specify a point in the past to indicate the starting point for data retrieval
    End Date Specify a point in the past to indicate the ending point for data retrieval
    Interval

    Convert time interval

    • None: retain the original data
    • 1 minute: align the timestamp into 1-minute interval
    • 5 minute: align the timestamp into 5 minute interval
    • ...
    Aggregation Aggregate the original data if the interval is not set to none.
    Asset attributes utilized for data retrieval
    Data structure Type

    Convert time interval

    • device_id – indicate that this column data includes id of device/asset
    • timestamp – indicate that this column data include timestamp
    • feature – indicate that this column data includes value data
    Data Type

    Type of data columns:

    • text
    • int
    • bool
    • double
    • float
    In This Article
    Back to top Generated by Asset Health Insights