Hi @Reddyp
Stored Procedure: To use stored procedure in Test connection/Account aggregation settings, select the Use Stored Procedure checkbox in Test Connection Query Settings /Account Query Settings Panel. For more details please refer JDBC configuration guide
Query: If you are using query then, in your test connection query, use “Select * from user_table” instead of “Select * from user_table()”
Error message : You are getting Timeout error which occurs when it is taking more time to establish the connection. You can increase timeout setting to a higher value (by default it is 30) & retry.
API & Syntax to increase timeout value:
URL:
PATCH /sources/{id}
[id} – External ID of the JDBC source
Header:
authorization: bearer token
Content-Type: application/json- patch +json
Request body:
[
{
“op”: “add”,
“path”: “/connectorAttributes/healthCheckTimeout”,
“value”: 60
}
]