topic Re: Error When Copying Data from Databricks Metastore to Lakehouse – 'uriString' Value Cannot Be Null in Pipelines

Error When Copying Data from Databricks Metastore to Lakehouse – 'uriString' Value Cannot Be Null

LituRout — Mon, 04 Aug 2025 06:44:31 GMT

Hi Community,

I’m encountering an error while working with a pipeline for copying data from Azure Databricks metastore to Lakehouse using Microsoft Fabric (Data Factory pipeline):

ErrorCode=InvalidParameter,
Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,
Message=The value of the property 'uriString' is invalid: 'Value cannot be null. Parameter name: uriString'.,
Source='',
Type=System.ArgumentNullException,
Message=Value cannot be null. Parameter name: uriString,
Source=System,

Note: The connection to Databricks is successful, and I’m able to preview the data without any issues. Staging is also enabled in the pipeline.

Has anyone faced a similar issue? It seems like a required URI parameter is missing or incorrectly passed, but I couldn’t pinpoint exactly where this is happening.

Any guidance on possible causes or how to trace and resolve this would be highly appreciated.

Re: Error When Copying Data from Databricks Metastore to Lakehouse – 'uriString' Value Cannot Be Null

vanessafvg — Mon, 04 Aug 2025 18:43:58 GMT

what does your copy job to ie source to a table or a file?

have you switched off staging and tried it without just to isolate where the issue is happening.

if you are copying into a table, how do you create the table?

Re: Error When Copying Data from Databricks Metastore to Lakehouse – 'uriString' Value Cannot Be Null

v-menakakota — Wed, 06 Aug 2025 04:47:29 GMT

Hi LituRout ,
Thanks for reaching out to the Microsoft fabric community forum.

Could you please confirm if the copy activity writes to a Lakehouse table or a file in the Lakehouse?

Also, is the target table pre-created, or are you allowing the pipeline to auto-create it during the run?

Once we have that, we will be able sort the issue.

Best Regards,
Community Support Team

Re: Error When Copying Data from Databricks Metastore to Lakehouse – 'uriString' Value Cannot Be Null

LituRout — Wed, 06 Aug 2025 04:54:27 GMT

Hi v-menakakota ,

It writes to Lakehouse Table.

The target table is not pre-created, I am allowing the pipeline to auto-create it during the run.

Re: Error When Copying Data from Databricks Metastore to Lakehouse – 'uriString' Value Cannot Be Null

v-menakakota — Wed, 06 Aug 2025 06:28:33 GMT

Hi LituRout ,

The error message shows something is missing or not properly generated when the pipeline tries to create the table on its own. Sometimes, the Lakehouse sink expects certain details like the table name or folder path, and if those aren’t clearly defined, it can lead to this kind of issue.

To help us narrow it down, could you try manually creating the target table in the Lakehouse before running the pipeline? This will help us check if the problem is specifically related to the table being auto-created by the pipeline.
Can you try it once.

Best Regards,
Community Support Team

Re: Error When Copying Data from Databricks Metastore to Lakehouse – 'uriString' Value Cannot Be Null

Murtaza_Ghafoor — Wed, 06 Aug 2025 19:20:42 GMT

The error means the pipeline is missing a required URI string—most likely a table path or link in the Lakehouse sink. It often happens when the system attempts auto-create but lacks necessary metadata. Predefining the target table and validating parameter values usually resolves this issue.

Re: Error When Copying Data from Databricks Metastore to Lakehouse – 'uriString' Value Cannot Be Null

LituRout — Fri, 08 Aug 2025 11:20:43 GMT

Hi v-menakakota,

I tried manually creating the target table in the Lakehouse and as well as the warehouse before running the pipeline. Still the pipeline failed and same error showed-up.

Re: Error When Copying Data from Databricks Metastore to Lakehouse – 'uriString' Value Cannot Be Null

Murtaza_Ghafoor — Fri, 08 Aug 2025 13:00:34 GMT

@LituRout please try following action items and let me know the results

Step Action

Confirm Copy sink is targeting a Lakehouse table, not a file path.
If relying on auto-creation, try pre-creating the table manually.
Review dataset parameters and linked service configuration—make sure all URIs (e.g. storage container or table path) are populated.
Inspect pipeline run output and debug logs to pinpoint where uriString is missing or null. Enable debug mode in ADF.
Test preview on source and sink datasets independently to confirm valid connection and metadata.

Re: Error When Copying Data from Databricks Metastore to Lakehouse – 'uriString' Value Cannot Be Null

v-menakakota — Mon, 11 Aug 2025 05:31:47 GMT

Hi LituRout ,

I would also take a moment to thank Murtaza_Ghafoor  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Thank you.

Re: Error When Copying Data from Databricks Metastore to Lakehouse – 'uriString' Value Cannot Be Null

v-menakakota — Thu, 14 Aug 2025 07:16:01 GMT

Hi LituRout ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Thank you.

Re: Error When Copying Data from Databricks Metastore to Lakehouse – 'uriString' Value Cannot Be Null

v-menakakota — Mon, 18 Aug 2025 04:31:32 GMT

Hi LituRout ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Thank you.