Great post for two reasons

First, the writing quality and the chic formatting aesthetic are nothing short of excellent. The instructions are crisp and complete. The screenshots are all scaled to the same size (nothing zoomed in or out)-and no ugly annotations.

Second, the technical detail with every step is worth applauding. It is the type of article for which I come to Medium.

Must read for data engineers doing anything on Redshift with dbt.

--

--

Very interesting piece! I haven't come across systems using 6NF. A comparison between Data Vault and 6NF would be interesting. There must be a significant trade-off between agility and organization.

From Anchor Modeling's website:

The technique incorporates the natural conecpts of objects, attributes and relationships making it easy to use and understand. It is based on the sixth normal form, resulting in a highly decomposed implementation, which avoids many of the pitfalls associated with traditional database modeling.

--

--

Kovid Rathee

I write about tech, Indian classical music, literature, and the workplace among other things. 1x engineer on weekdays. https://kovidrathee.medium.com/membership