incident_metric table integration

[Siva Teja1]

Hi Team,

We are currently working on a integration project where a read access to be provided on incident_metric table(View). This view has around 10 Million records as of now. The data will be pushed to a database where the data is been used by a XYZ tool for sentiment analysis.

Is that a good practice to create a Table API over this view ? Since we have 10 M records will it create performance issues ?

If we are to provide read access on this view how many records for transaction can we provide to database team ?

@Ankur Bawiskar Please share your views

Regards

Siva Teja

[Jaspal Singh]

Hi Siva,

You can try below approach.

1. Extract data in excel & share it as an initial data dump for incident_metric table.

2. Once done APIs shared can be used to get only incremental (updated/ created in last 24 hours or so).

This will avoid performance issues (if any) & also ease work a bit from both the ends.

[Siva Teja1]

Hi Jaspal,

Thanks for your answer, but can we expose full incident_metric view to DB team ?

Wont it create a performance issue even they are extracting incremental load ?

Regards

Siva Teja

[Jaspal Singh]

but can we expose full incident_metric view to DB team ? -- Yes

Wont it create a performance issue even they are extracting incremental load ? -- Schedule the load to be pulled off business hours. Also, the load will have less data if you expose all records instead of incremental load.

[Siva Teja1]

Hi Jaspal,

Schedule the load to be pulled off business hours - Is this from ServiceNow end or from DB teams end ?

When an read access is given to DB team via table API they can pull it round the clock as per my understanding. Do we have option to mitigate it ? (By scheduling the load to be pulled in off business hours)

Regards