DSS Internal Stats Tables Relationships

neilpatel

I am trying to build a project to capture project history and performance stats using the internal stats datasets available within DSS. Is there a diagram that shows the relationships between the tables?

For example,

Flow Actions -> Jobs

Flow Actions -> Scenarios

Flow Actions -> Cluster

Commits - Looks like a stand alone table.

Alternatively, should each of these tables be considered independently?

arnaudde

Hello,
You have informations about what each table represents at this page in the doc.

Here are some common keys between the tables.

- "Jobs" and "Scenario" tables share the "scenario_id" and "scenario_run_id" keys
- "Object states" and "Jobs" tables share the "job_id" key
- "Object states"and "Scenario" tables share the "scenario_id" and "scenario_run_id" keys

For instance if you want to have extra information on jobs that are scenario runs you might want to join "Jobs" and "Scenario" tables on the "scenario_run_id" key.

Best,
Arnaud