News for hackers. Stuff that matters.

A comment on Reverse Snowflake Joins. Parent comment

Re:Reverse Snowflake Joins by burnoutgal on Thursday March 31, 2022 @11:51AM (#30868563)
There's lots of python libraries for graph visualization, it's probably force-directed layout or something else similar.

The name is indeed a reference to data warehouse design, where you normally have heavily normalized data in a snowflake schema. The Kimball book is the canonical one on data warehouse design.

[ Parent | on HN ]
Re:Reverse Snowflake Joins by daveloyall on Thursday March 31, 2022 @04:24PM (#30871816)
Yep. This app, revj, uses Graphviz for layout. So, sure, force-directed layout.

The layout/rendering of the graphs isn't interesting to me, but parsing a SQL statement and extracting the relationship data is.

[ Parent | on HN ]