Forum Discussion
Resolver IIPostgreSQL to Lakehouse Tables - Copy Activity Timeout Issue in Microsoft Fabric Data Factory
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:
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!
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Bhargava05Hi 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.