Data flow and process for PA

[Casey4]

Are Scores stored in PA tables the same thing as snapshots?

or do the snapshots turn into scores?

Confused deploying these PA widgets.. where is the data stored, where does it come from? are there staging tables?

[HrishabhKumar]

Hi @Casey4 ,

I've tried to answer each of your question one by one, Take a look and see if it helps:

1. Are Scores stored in PA tables the same thing as snapshots?

Answer: No, scores and snapshots are not the same thing in ServiceNow Performance Analytics.

• Scores: These are the calculated values for specific indicators at specific points in time. Scores are stored in the pa_scores table and are used to populate widgets and dashboards.
• Snapshots: While not a separate concept explicitly named in ServiceNow, "snapshots" can be thought of as the data collected at a particular point in time during a data collection job. This collected data is used to calculate scores.

2. Do the snapshots turn into scores?

Answer: Yes, you can think of it this way: the data collected during a "snapshot" (data collection job) is processed and used to calculate the scores. The scores are then stored in the pa_scores table.

3. Where is the data stored?

Answer: The data is stored in various Performance Analytics tables in ServiceNow:

• pa_scores: Stores the calculated scores for indicators.
• pa_snapshots: Used during data collection to temporarily hold snapshot data.
• pa_indicators: Stores definitions of indicators.
• pa_indicators_data: Stores specific data points related to indicators.
• Other related tables: Such as pa_collectors (data collection jobs), pa_datasets (collected data), and more.

4. Where does the data come from?

Answer: The data for Performance Analytics comes from defined indicator sources. Indicator sources can be:

• Database tables: Data directly from ServiceNow tables.
• Database views: Custom views combining data from multiple tables.
• Scripts: Custom scripts to gather specific data.

5. Are there staging tables?

Answer: ServiceNow does not explicitly use "staging tables" in the same sense as traditional ETL processes. However:

• Temporary storage: During data collection, data is temporarily held in the context of the data collection job before scores are calculated and stored in the pa_scores table.
• Intermediate tables: There might be intermediate tables or contexts where data is processed, but these are not typically exposed or managed directly by users.

Thanks,

Hope this helps.

If my response proves helpful please mark it helpful and accept it as solution to close this thread.

[AndersBGS]

Hi @Casey4 ,

Yes, scores are stored in PA table which is the output of a snapshot. You can always from an automated indicator look up the scores from the single indicator.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Bedst regards 

Anders