Best practices for loading data into Star Schema with Semantic model?

Morning,

I'm currently in the middle of a Fabric trial where we're trying out a bunch of use cases.

We've just hit a bit of a hurdle and I am wondering if there is already a guide available somewhere.

We've created a basic star schema in a warehouse (that we've called our Gold Warehouse) and loaded some data in. Initially in our pipeline we were just dropping and recreating the tables (for ease) using CTAS statements..

Then when we went on to playing around with the semantic model, that broke our pipeline because of the FKs it created.

This is where we hit a bit of a dead end. We're trying to resist using DELETE statements for speed reasons. But techniques such as programmatically dropping the constraints and re-adding them or partition switching seem to be off the table.

Curious to know if there is a guide or what everyone else is doing?

1 comment