If Fabric Mirroring lost Constraints

[cfccai]

Hello

Recently I am exploring Fabric Mirroring, which is really fast and continueslly for data integration. 

While I am wondering if Mirror bring the constraints from source database tables, as we need the primary key to do merge operation in Spark for next (aggregation) steps.

Mirror will repliate the source database tables into Warehouse in Microsoft OneLake. But seems like it will only copy the table schema and the data, not constraints. 

I have a simple test: 

• I have Azure SQL database table 'Customer' which has Primary key.

• After Mirroring, cannot see any constraints of the replicated table. Table dbo_customer is the one right after the Mirroring, without any transformation/operation. 
• 

Just wanted to double confirm that, if Mirroring lost all the constraints of the source tables?

Can anyone help to have a check. Thanks a lot.

[v-nikhilan-msft · Accepted solution]

Hi @cfccai 
Thanks for using Fabric Community.
Mirroring replicates the 'data'. Constraints and security constructs on the tables are not moved. So just to confirm, the constraints are NOT lost, they are never moved, we only move the data. The constraints are required at write time surely, and mirroring creates a read-only version of the data (at which point the constraints should be enforced).
This is by design, but we are always looking for feedback on the product, so encourage you if you give your feedback here: Home (microsoft.com)

Hope this helps. Please let me know if you have any further questions.

[cfccai]

Thanks for your explain. This is helpful. 

[v-nikhilan-msft]

Hi @cfccai 
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.

[v-nikhilan-msft]

Hi @cfccai 
We haven’t heard from you on the last response and was just checking back to see if your query got resolved. Otherwise, will respond back with the more details and we will try to help.
Thanks

[v-nikhilan-msft]

Hi @cfccai 
We haven’t heard from you on the last response and was just checking back to see if your query got resolved. Otherwise, will respond back with the more details and we will try to help.
Thanks