Hi @Christian_Ostrem I don't believe we do Have you tried adding a limit to the query? Are you able to successfully run a hardcoded query like select 1?
Do you have any table names you can test that don't have special characters _ or capital letters? Usually table names with capital letters need to be wrapped in double quotes - select * from "MainGroup"
Are you using the JDBC resource type? Is the "Test connection" on the resource successful?
Hi @Tess , I have now tested the things mentioned. The test connection is successful.
Its not possible to run select 1, select * from "MainGroup" or show tables.
I dont know i you are you have written the connector code your self or used a library but it seems like retool is trying to set max_execution_time before the query is run. This is only allowed if you have set readonly flag as 2 in the clickhouse configuration.
Its possible to change readonly flag in clickhouse but that also means that we need to restart the service. This is a bit of pain for us since there is millions of transactions happening everyday. There responsible person dosent like to "experiment" with live databases. If you can confirm that this is the issue I can probably convince them to do the change since the i no way around. Depending on what you can do on your side.
There is a library (grafana) on github who has addressed this issue.
max_execution_time is set by clickhouse-go client and it's expected as you have query timeout set. For some reason, it didn't work in previous versions. I will investigate it.
What is important, your user has to have readonly flag set as 2. Permissions for Queries | ClickHouse Docs
Otherwise, ClickHouse will reject your queries as expected.
Probably, it should be included in sort of documentation.
Possible values:
0 — Read, Write, and Change settings queries are allowed.
1 — Only Read data queries are allowed.
2 — Read data and Change settings queries are allowed.