Have there been any formal studies conducted that compare the DV2 approach with other modeling approaches on aspects such as:
- Number of tables created
- Amount of storage space used
- Amount of processing (compute) to load and to query
The first impacts maintenance and usability. The more tables, more complexity for developers and advanced users to manage and query properly.
The other two impact costs. If we are to use DV2 on Snowflake, is this modeling approach increasing or decreasing costs and by how much?
I'm hoping formal studies have been done. I look forward to learning what is known.