Skip to main content
Question

why does Celonis use Snowflake schema instead of Star schema?

  • September 3, 2023
  • 1 reply
  • 9 views

Forum|alt.badge.img+6
why does Celonis use Snowflake schema instead of Star schema?

1 reply

  • Level 1
  • September 4, 2023

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.