Dynamic Range Partition on Azure SQL Managed Instance

[Bikematt]

I am trying to use dynamic range partitioning on an Azure SQL managed instance source as part of a copy data activity.  The documentation found here suggests that you can use a custom query and dynamic range partitioning without specifying the "Partition Column Name" field.  However, when I do this in my pipeline, I get the following error: 

"Code": 22317,
"Message": "ErrorCode=SqlParallelEmptyPartitionColumnNameForQuery,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The partition column name needs to provided when using query.,Source=Microsoft.DataTransfer.ClientLibrary,'",

Has anyone else run into this? The error seems to contradict the documenation...

[v-prasare]

We are following up once again regarding your query. Could you please confirm whether you have raised ideas forum with Microsoft?

If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

[Bikematt]

Yes, I just submitted an idea to have the "partition column name" field show as required when a custom query is used in the copy data step.

[v-prasare]

Thanks for the confirmation.  you feedback is truely valueble to our community, you have already submitted the ideas forum, Microsoft IDEAS forum team can take care this, for now will close the thread, and please fell free to add new thread if needed. Please continue to use community forum.

Thanks,

Prashanth Are

[v-prasare · Accepted solution]

Hi @Bikematt, 

I’d encourage you to submit your detailed feedback and ideas via Microsoft's official feedback channels, such as the Microsoft Fabric Ideas .

Feedback submitted here is often reviewed by the product teams and can lead to meaningful improvement and PG team will update the documentation. you insights will true valueble to our community

Thanks,

Prashanth Are

MS fabric community support

[Vinizx3]

Hi,

Have you already tried specifying the partition column? Is the pipeline still failing?

[Bikematt]

Just ran a test. It does work when a partition column is specified. Seems like the documentation needs to be updated to make it more clear that you can't leave the partition column name field blank when writing a custom query.