Star Schema and Snowflake Schema? Why is it not a thing in DOMO?

verytiredgirl
verytiredgirl Member
edited October 17 in Other Ideas

It's a very common and even a recommended practice to do data warehousing design when you're analyzing/visualizing data but why is it not a thing in DOMO? It seems like you have to create 1 whole big and gigantic FACT Table every time you want to analyze something when you're working with an enterprise data level. And what makes it even worst is, most of the time, you don't just use 1 big and gigantic table for all the cards/visuals. Then you have to do ETLs to create say 5 big and gigantic tables for other cards.

Not to mention, the main reason why Star and Snowflake Schema are recommended over 1 Fact table is because well faster query performance and obviously a more structured data organization.

Tagged:
1
1 votes