DSS Internal Stats Tables Relationships

neilpatel
Level 2
DSS Internal Stats Tables Relationships

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? 

1 Reply
arnaudde
Dataiker

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