topic Re: Dynamic Range Partition on Azure SQL Managed Instance in Data Engineering

Dynamic Range Partition on Azure SQL Managed Instance

Bikematt — Tue, 17 Jun 2025 19:33:35 GMT

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...

Re: Dynamic Range Partition on Azure SQL Managed Instance

Vinizx3 — Wed, 18 Jun 2025 11:04:21 GMT

Hi,

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

Re: Dynamic Range Partition on Azure SQL Managed Instance

Bikematt — Wed, 18 Jun 2025 16:20:55 GMT

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.

Re: Dynamic Range Partition on Azure SQL Managed Instance

v-prasare — Thu, 19 Jun 2025 13:04:48 GMT

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

Re: Dynamic Range Partition on Azure SQL Managed Instance

v-prasare — Mon, 23 Jun 2025 11:43:27 GMT

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.

Re: Dynamic Range Partition on Azure SQL Managed Instance

Bikematt — Mon, 23 Jun 2025 17:06:35 GMT

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.

Re: Dynamic Range Partition on Azure SQL Managed Instance

v-prasare — Thu, 26 Jun 2025 13:36:42 GMT

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