topic Re: PostgreSQL to Lakehouse Tables - Copy Activity Timeout Issue in Microsoft Fabric Data Factory in Pipelines

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

Bhargava05 — Wed, 18 Dec 2024 19:37:34 GMT

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!

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

Anonymous — Thu, 19 Dec 2024 08:22:34 GMT

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.

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

Bhargava05 — Tue, 07 Jan 2025 21:27:02 GMT

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