Read timed out | socket_timeout does not work

[KrisAnTis-Group]

We have problems with Read timed.
We use Metriql to bundle dbt, ClickHouse, Metriql, Google Data Studio technologies.

We have set our configurations after the update (1e6c717) в

'connection_parameters': {
                        'connect_timeout': 40 * 1000,
                        'socket_timeout': 5 * 60 * 1000,
                    },

However, it didn't help. We use a simple query for testing:

select sleepEachRow(3) from numbers(25)

Which returns the following query from the database (used by DBeaver with increased socket_timeout settings):

However, attempting to evaluate this query using metriql returns an error:

curl --location --request POST 'https://metriql.****.io/api/v0/query' \
--header 'Authorization: Basic ***REPLASE***=' \
--header 'Content-Type: application/json' \
--data-raw '{
    "type": "sql",
    "report": {
        "query": "select sleepEachRow(3) from numbers(25)"
    }
}'

We get the following response:

{
    "id": "****",
    "startedAt": "2022-06-20T08:27:19.707825Z",
    "duration": 30.036700000,
    "user": "****",
    "source": null,
    "status": "failed",
    "update": {
        "state": "FINISHED",
        "info": {
            "reportType": "sql",
            "query": {
                "query": "select sleepEachRow(3) from numbers(25)",
                "queryOptions": null,
                "variables": null,
                "reportOptions": null
            },
            "compiledQuery": "select sleepEachRow(3) from numbers(25)"
        },
        "nodes": 1,
        "percentage": null,
        "elapsedTimeMillis": null,
        "totalBytes": null,
        "processedBytes": null
    },
    "result": {
        "metadata": null,
        "result": null,
        "error": {
            "message": "Read timed out, server ClickHouseNode(addr=***:8123, db=****)@846585128, Cause: Read timed out",
            "sqlState": "07000",
            "errorCode": 159,
            "errorLine": null,
            "charPositionInLine": null
        },
        "properties": {
            "limit": 1000,
            "query": "select sleepEachRow(3) from numbers(25)"
        },
        "responseHeaders": null
    }
}