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?

Welcome to all new members, here's some links and information to help you get started! 𝗤𝘂𝗶𝗰𝗸 𝗟𝗶𝗻𝗸𝘀 𝘁𝗼 𝗴𝗲𝘁 𝘀𝘁𝗮𝗿𝘁𝗲𝗱 - For an introduction to this community → Explore the Welcome Pack - New-ish to Fabric? → Check out our Fabric Foundation module - Studying for the DP-600? → Check out the DP-600 Module and the DP-600 category - Studying for the DP-700? → Check out the DP-700 Module and the DP-700 category - Want to get hands-on? → Check out Fabric Dojo 𝗛𝗼𝘄 𝘁𝗼 𝗲𝗻𝗴𝗮𝗴𝗲 𝘄𝗶𝘁𝗵 𝘁𝗵𝗲 𝗰𝗼𝗺𝗺𝘂𝗻𝗶𝘁𝘆? - Share your knowledge and experience! Even if you're relatively new to Fabric, or the community, your opinion and experiences are valued here! A great way to earn your first point(s) is to introduce yourself in the thread below 👇😀 Thank you for engaging and joining us on this exciting learning journey! 🙏 Will