1mg Drug Data

This document provides instructions for creating, configuring, and ingesting events into the 1mg Drug Data dataset.

Step 1: Access the Obsrv Web Console

1. Use the Below link to access Obsrv webconsole

👉 https://3.150.162.32.nip.io/console

1. Login Credentials: Username: obsrv_admin Password: enDoPvTAxFSd

Step 2: Create a Dataset

1. Dataset Name: 1mg Drug Data

2. Upload this sample dataset file : https://github.com/Sanketika-Obsrv/obsrv-automation/blob/sample-datasets/datasets/1mg-drugs-datasets/drugs-data/drugs-conflict.json

Step 3: Validate and Resolve Schema Conflicts

1. Review the schema details.

2. Resolve the conflict for Overall_Rating, change the datatype to double

Step 4: Denormalize the Dataset

Master dataset is pre-created use the below details to sync. Under Denormalization Settings:

1. Dataset Field: Marketer_id

2. Master Dataset: drugs-marketer-data

3. Input Field: marketer_meta

Step 5: Add Sensitive Fields

• Select Manufacturer.email → Select Mask, Select Yes, then click Add.

• Select Manufacturer.gst_number → Select Encrypt, Select Yes, then click Add.

Step 6: Add Derived Fields

• Field Name: Discount Amount

• Transformation Expression: $round(MRP * (Discount_Percentage / 100), 2)

• Don’t Enable Dedup

Step 8: Send Events

1. Use this files to ingest the data into the dataset https://github.com/Sanketika-Obsrv/obsrv-automation/tree/sample-datasets/datasets/1mg-drugs-datasets/drugs-data