Skip to main content
why does Celonis use Snowflake schema instead of Star schema?

A snowflake schema is a type of database schema that is used to store data in a more complex format than the star schema. 

Personaly, I like transform the complex data in a star schema, because is more simple for understand and has more performance. 

But, sometimes is not possible to do this, for exemple in cases that data transformations needs a lot of processing to joint the data. Then, a way can be use the snowsflake. 


Reply