Timeout settings for Postgresql external catalog connection?

[ErikApption]

Is there any way to configure timeouts for external catalog connections? We are getting some timeouts with complex queries accessing a pgsql database through the catalog. We tried configuring the connection and we got this error

  │ Error: cannot update connection: CONNECTION/CONNECTION_POSTGRESQL does not support the following option(s): connectTimeout. Supported options: host,port,user,password.

[Alberto_Umana · Accepted solution]

Hello @ErikApption,

there is no direct support for a connectTimeout option in the connection settings through Unity Catalog as of now. You might need to explore these alternative timeout configurations or consider adjusting your database handling to manage complex queries more efficiently.

You can set the statement_timeout parameter for your queries. This can be done in PostgreSQL by setting it through SQL commands:

SET statement_timeout TO '5min';