Skip to main content
Microsoft Idea

Core

New

Ability To Turn On/Off Auto Assume Referential Integrity in Fabric Optimization

Vote (1) Share
Alex McPherson's profile image

Alex McPherson on 22 Mar 2024 12:45:49

In current Fabric SQL Endpoint optimization, the process is evaluating relationships and turning on Assume Referential Integrity. This is a very dangerous setting for my data as we tend to have some duplicates entered every year by mistake that we always have to clean up. Please provide an option to toggle this on/off in optimization settings.