[GitHub] [superset] ducchetrongminh commented on issue #12729: [SIP] Support star schemas

[GitBox <gi...@apache.org>]

ducchetrongminh commented on issue #12729:
URL: https://github.com/apache/superset/issues/12729#issuecomment-924186508


   I would love to see this feature go live, not sure if there is any progress. The description above is good enough, I just want to share my case.
   Currently, I am using dbt for transformation, and I am following the star schema practice. Then I will visualize on Metabase. This approach works well because we have 1 central dimension table, as well as storage optimizing. 
   If I go with Superset, I will need to create 1 flat table. Some issues with the flat table are:
   - storage: the dimension data will be duplicated and redundancy
   - no benefit from incremental processing: when there is change in dimension table, I will need to refresh the whole flat table. If we support star schema, the fact table can remain unchanged
   - slow on filter values: it is faster to fetch 30k customer names compared to 100mil customer names (but only 30k distinct name)


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org