Synapse link snapshot data missing partitions

Rob 6

We're using synapse link to replicate dataverse data through to synapse.

The live tables are working okay, but the snapshot data for some tables is missing some partitions. Column 3 in image 1 below is the counts.

As you can see in the second image, we're missing some partitions e.g. 2019-11. We know they should appear as their respective csvs exist in the underlying snapshot folders and contains the missing records that appear in the standard external table sql object.

What's going on here?

KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2022-10-28T02:28:37.397+00:00

Hello @Rob ,

Thanks for the question and using MS Q&A platform.
This issue seems strange and needs a deeper investigation. If you have a support plan, could you please file a support ticket and do share the SR# with us here for tracking it internally. In case if you don't have a support plan, please let me know here.

Thank you
Rob 6 Reputation points

2022-10-28T08:53:06.693+00:00

Thanks for the reply @KranthiPakala-MSFT

I've raised the support request: 2210280030000998 as requested
KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee

2022-10-28T15:06:39.353+00:00

Thank you for sharing the details @Rob ! Please feel free to share the root cause and resolution details here once the issue is resolved from the SR as it could be helpful to other reading this thread.

Thanks