PostgreSQL to Lakehouse Tables - Copy Activity Timeout Issue in Microsoft Fabric Data Factory

[Bhargava05]

Hello,

I’m encountering a TimeoutException when using the Copy Activity in Microsoft Fabric Data Factory to transfer data from PostgreSQL to a Lakehouse.

The error message is:

This worked in Azure Data Factory (ADF) when I included connection parameters in the linked service configuration. However, I’m unable to find an option to include such connection parameters in Fabric Data Factory.

Could someone advise on how to configure connection parameters, such as timeouts or other settings, in Fabric Data Factory? Is there a workaround to resolve this timeout issue?

Thank you!

[Bhargava05]

Hi @v-kongfanf-msft  Thanks for you reply.

I don't see such a parameter as Query timeout in my source configurations of my copy activity.

Below is the snippet of the same for your reference.

[v-kongfanf-msft · Accepted solution]

Hi @Bhargava05 ,

Check if the configured query timeout is valid after the extension.

Alternatively, you can refer to the following documentation on configuring PostgreSQL for copy activity:

Configure PostgreSQL in a copy activity - Microsoft Fabric | Microsoft Learn

Class NpgsqlCommand | Npgsql Documentation

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.