Alarm 360 Installation

You are here:

RIAALARMS data model

The data from this table will be used to:

  • calculate mean probability for each node/tuple based on alarm’s confidence score values
  • The below sample SQL query may be referred to for creating the riatuple table. The database to use will be Phoenix.

    CREATE TABLE IF NOT EXISTS riaalarms (
        tid VARCHAR NOT NULL,
        aid VARCHAR NOT NULL,
        upts BIGINT NOT NULL,
        crts BIGINT,
        pt VARCHAR,
        agr VARCHAR,
        lob VARCHAR,
        acs DOUBLE,
        tckid VARCHAR,
        descr VARCHAR,
        CONSTRAINT PK PRIMARY KEY (tid, aid, upts)
    );

Payload format:

interface AlarmInstance {
  alarmId: string;
  created: number;
  updated: number;
  tupleId: string;
  rootId: string;   // may not be needed
  description: string;
  confidenceScore: number;
  incidentCreated: boolean;
  incidentType: string;
}
Follow me

Latest posts by Rohit Raina (see all)

Close Menu