In the post titled, Decomposing path into steps in Property Graphs, we looked at how ONE ROW PER STEP can be used to unnest / flatten a path in Graph. Now let’s explore how ONE ROW PER STEP can also be used to surface the connection types in the Graphs. We will start with our Social Network Graph. Note that Saqib is friends with Angela, whereas Angela and Scott are co-workers. Also Scott and Uroosa are friends. Now let’s say we want to identify this connection type i.e. friend vs co-worker,...