I'm trying to load data from a clickhouse instance to Qlik, and I'm keep getting empty result 0 lines fetched
I'm using Qlik Cloud
I tested the query in curl
curl -X POST -u xxx:yyy "https://host:port/?database=database" \ > -H "Content-Type: text/plain" \ > -H "Accept: application/json" \ > --data-binary "SELECT 1 AS test_value FORMAT JSON"
I'm getting usual results
when configuring the REST connector I'm setting the URL to https link method to POST our auth the query goes to the body I'm adding header parameters like Name - Accept; Value - text/plain etc Always HTTPS is also turned on
the connection works in the load script i have
LIB CONNECT TO 'clickhouse test'; TestSimple: SQL SELECT "test_value" FROM JSON (wrap on) "data";
what ever i do the result is always the same 0 lines fetched
