Notifications
Clear all

Row Identifiers for Stellite Tables  


Posts: 4
(@jordankavaldjiev)
New Member
Joined: 6 months ago

Dear Community,

Is it a good practice to declare a row identifier column for the satellites. Since the primary keys are composite, does it make sense to you to create a single column, which uniquely identifies a row in the satellite? A good practical purpose for this would be to build a tabular model on top of the vault raw layer - since tabular model does not support composite business keys as of now, it would be easier to use the row identifier columns in PIT tables.

If you have experience with this, what type would you chose for the row identifier columns?

Thanks,

Jordan

Reply
2 Replies