Clickhouse concat string : Select statement did not produce a ResultSet for native query

Hi,
I try to generate one column by concatenate String and column name from table.
Here is my query :

SELECT 
CONCAT('https://my-url/', line_id, '&date=', toString(now()::date - 1), '&timezone=Europe%2FParis') AS "Troubleshooter link"
FROM my_table_in_clickhouse 

Metabase l'error : Select statement did not produce a ResultSet for native query. However, this query works in another tool like Dbeaver.
Someone can give me a hand ?

You haven’t posted diagnostic info, so we can’t help with just that error

Here is the Logs in Troubleshooting

{}, stringArgs=[Parse error at line 3, column 131.  Encountered: :, -- Metabase:: userID: 4 queryType: native queryHash: 6c4db185dbf6e0c45f950d52bf122567bd80faeb10a9225e20fa29a912d840d1
SELECT 
CONCAT('https://my-url/', line_id, '&date=', toString(now()::date - 1) , '&timezone=Europe%2FParis') AS "Troubleshooter link"
FROM my_table_in_clickhouse], throwable=null]
[794ac30b-1a21-4f29-8f8e-017ae086b420] 2023-02-23T11:57:01+01:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: Select statement did not produce a ResultSet for native query
{:database_id 36,
 :started_at #t "2023-02-23T10:57:00.951734Z[UTC]",
 :via
 [{:status :failed,
   :class clojure.lang.ExceptionInfo,
   :error "Error executing query: Select statement did not produce a ResultSet for native query",
   :stacktrace
   ["--> driver.sql_jdbc.execute$execute_reducible_query$fn__55242.invoke(execute.clj:502)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:499)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:494)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
    "driver.sql_jdbc$fn__86202.invokeStatic(sql_jdbc.clj:54)"
    "driver.sql_jdbc$fn__86202.invoke(sql_jdbc.clj:52)"
    "query_processor.context$executef.invokeStatic(context.clj:59)"
    "query_processor.context$executef.invoke(context.clj:48)"
    "query_processor.context.default$default_runf.invokeStatic(default.clj:67)"
    "query_processor.context.default$default_runf.invoke(default.clj:65)"
    "query_processor.context$runf.invokeStatic(context.clj:45)"
    "query_processor.context$runf.invoke(context.clj:39)"
    "query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)"
    "query_processor.reducible$identity_qp.invoke(reducible.clj:9)"
    "query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___52619.invoke(cache.clj:220)"
    "query_processor.middleware.permissions$check_query_permissions$fn__48140.invoke(permissions.clj:109)"
    "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__51564.invoke(mbql_to_native.clj:23)"
    "query_processor$fn__54095$combined_post_process__54100$combined_post_process_STAR___54101.invoke(query_processor.clj:212)"
    "query_processor$fn__54095$combined_pre_process__54096$combined_pre_process_STAR___54097.invoke(query_processor.clj:209)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52540$fn__52545.invoke(resolve_database_and_driver.clj:35)"
    "driver$do_with_driver.invokeStatic(driver.clj:75)"
    "driver$do_with_driver.invoke(driver.clj:71)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52540.invoke(resolve_database_and_driver.clj:34)"
    "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__48575.invoke(fetch_source_query.clj:353)"
    "query_processor.middleware.store$initialize_store$fn__48763$fn__48764.invoke(store.clj:11)"
    "query_processor.store$do_with_store.invokeStatic(store.clj:44)"
    "query_processor.store$do_with_store.invoke(store.clj:38)"
    "query_processor.middleware.store$initialize_store$fn__48763.invoke(store.clj:10)"
    "query_processor.middleware.normalize_query$normalize$fn__52812.invoke(normalize_query.clj:22)"
    "query_processor.middleware.constraints$add_default_userland_constraints$fn__49845.invoke(constraints.clj:53)"
    "query_processor.middleware.process_userland_query$process_userland_query$fn__52751.invoke(process_userland_query.clj:145)"
    "query_processor.middleware.catch_exceptions$catch_exceptions$fn__53123.invoke(catch_exceptions.clj:167)"
    "query_processor.reducible$async_qp$qp_STAR___44978$thunk__44980.invoke(reducible.clj:100)"
    "query_processor.reducible$async_qp$qp_STAR___44978.invoke(reducible.clj:106)"
    "query_processor.reducible$async_qp$qp_STAR___44978.invoke(reducible.clj:91)"
    "query_processor.reducible$sync_qp$qp_STAR___44989.doInvoke(reducible.clj:126)"
    "query_processor$process_userland_query.invokeStatic(query_processor.clj:331)"
    "query_processor$process_userland_query.doInvoke(query_processor.clj:327)"
    "query_processor$fn__54142$process_query_and_save_execution_BANG___54151$fn__54154.invoke(query_processor.clj:342)"
    "query_processor$fn__54142$process_query_and_save_execution_BANG___54151.invoke(query_processor.clj:335)"
    "query_processor$fn__54186$process_query_and_save_with_max_results_constraints_BANG___54195$fn__54198.invoke(query_processor.clj:354)"
    "query_processor$fn__54186$process_query_and_save_with_max_results_constraints_BANG___54195.invoke(query_processor.clj:347)"
    "api.dataset$run_query_async$fn__68893.invoke(dataset.clj:69)"
    "query_processor.streaming$streaming_response_STAR_$fn__40096$fn__40097.invoke(streaming.clj:162)"
    "query_processor.streaming$streaming_response_STAR_$fn__40096.invoke(streaming.clj:161)"
    "async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:65)"
    "async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:63)"
    "async.streaming_response$do_f_async$task__19006.invoke(streaming_response.clj:84)"],
   :error_type :invalid-query,
   :ex-data
   {:sql
    "-- Metabase:: userID: 4 queryType: native queryHash: 6c4db185dbf6e0c45f950d52bf122567bd80faeb10a9225e20fa29a912d840d1\nSELECT \nCONCAT('https://my-url', line_id, '&date=', toString(now()::date - 1) , '&timezone=Europe%2FParis') AS \"Troubleshooter link\"\nFROM my_table_in_clickhouse",
    :params nil,
    :type :invalid-query}}],
 :error_type :invalid-query,
 :json_query
 {:type "native",
  :native
  {:query
   "SELECT \nCONCAT('https://my-url/', line_id, '&date=', toString(now()::date - 1) , '&timezone=Europe%2FParis') AS \"Troubleshooter link\"\nFROM my_table_in_clickhouse,
   :template-tags {}},
  :database 36,
  :parameters [],
  :middleware {:js-int-to-string? true, :add-default-userland-constraints? true}},
 :status :failed,
 :class clojure.lang.ExceptionInfo,
 :stacktrace
 ["--> driver.sql_jdbc.execute$fn__55162.invokeStatic(execute.clj:369)"
  "driver.sql_jdbc.execute$fn__55162.invoke(execute.clj:365)"
  "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:375)"
  "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invoke(execute.clj:372)"
  "driver.sql_jdbc.execute$execute_reducible_query$fn__55242.invoke(execute.clj:500)"
  "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:499)"
  "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
  "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:494)"
  "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:486)"
  "driver.sql_jdbc$fn__86202.invokeStatic(sql_jdbc.clj:54)"
  "driver.sql_jdbc$fn__86202.invoke(sql_jdbc.clj:52)"
  "query_processor.context$executef.invokeStatic(context.clj:59)"
  "query_processor.context$executef.invoke(context.clj:48)"
  "query_processor.context.default$default_runf.invokeStatic(default.clj:67)"
  "query_processor.context.default$default_runf.invoke(default.clj:65)"
  "query_processor.context$runf.invokeStatic(context.clj:45)"
  "query_processor.context$runf.invoke(context.clj:39)"
  "query_processor.reducible$identity_qp.invokeStatic(reducible.clj:12)"
  "query_processor.reducible$identity_qp.invoke(reducible.clj:9)"
  "query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___52619.invoke(cache.clj:220)"
  "query_processor.middleware.permissions$check_query_permissions$fn__48140.invoke(permissions.clj:109)"
  "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__51564.invoke(mbql_to_native.clj:23)"
  "query_processor$fn__54095$combined_post_process__54100$combined_post_process_STAR___54101.invoke(query_processor.clj:212)"
  "query_processor$fn__54095$combined_pre_process__54096$combined_pre_process_STAR___54097.invoke(query_processor.clj:209)"
  "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52540$fn__52545.invoke(resolve_database_and_driver.clj:35)"
  "driver$do_with_driver.invokeStatic(driver.clj:75)"
  "driver$do_with_driver.invoke(driver.clj:71)"
  "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52540.invoke(resolve_database_and_driver.clj:34)"
  "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__48575.invoke(fetch_source_query.clj:353)"
  "query_processor.middleware.store$initialize_store$fn__48763$fn__48764.invoke(store.clj:11)"
  "query_processor.store$do_with_store.invokeStatic(store.clj:44)"
  "query_processor.store$do_with_store.invoke(store.clj:38)"
  "query_processor.middleware.store$initialize_store$fn__48763.invoke(store.clj:10)"
  "query_processor.middleware.normalize_query$normalize$fn__52812.invoke(normalize_query.clj:22)"
  "query_processor.middleware.constraints$add_default_userland_constraints$fn__49845.invoke(constraints.clj:53)"
  "query_processor.middleware.process_userland_query$process_userland_query$fn__52751.invoke(process_userland_query.clj:145)"
  "query_processor.middleware.catch_exceptions$catch_exceptions$fn__53123.invoke(catch_exceptions.clj:167)"
  "query_processor.reducible$async_qp$qp_STAR___44978$thunk__44980.invoke(reducible.clj:100)"
  "query_processor.reducible$async_qp$qp_STAR___44978.invoke(reducible.clj:106)"
  "query_processor.reducible$async_qp$qp_STAR___44978.invoke(reducible.clj:91)"
  "query_processor.reducible$sync_qp$qp_STAR___44989.doInvoke(reducible.clj:126)"
  "query_processor$process_userland_query.invokeStatic(query_processor.clj:331)"
  "query_processor$process_userland_query.doInvoke(query_processor.clj:327)"
  "query_processor$fn__54142$process_query_and_save_execution_BANG___54151$fn__54154.invoke(query_processor.clj:342)"
  "query_processor$fn__54142$process_query_and_save_execution_BANG___54151.invoke(query_processor.clj:335)"
  "query_processor$fn__54186$process_query_and_save_with_max_results_constraints_BANG___54195$fn__54198.invoke(query_processor.clj:354)"
  "query_processor$fn__54186$process_query_and_save_with_max_results_constraints_BANG___54195.invoke(query_processor.clj:347)"
  "api.dataset$run_query_async$fn__68893.invoke(dataset.clj:69)"
  "query_processor.streaming$streaming_response_STAR_$fn__40096$fn__40097.invoke(streaming.clj:162)"
  "query_processor.streaming$streaming_response_STAR_$fn__40096.invoke(streaming.clj:161)"
  "async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:65)"
  "async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:63)"
  "async.streaming_response$do_f_async$task__19006.invoke(streaming_response.clj:84)"],
 :card_id nil,
 :context :ad-hoc,
 :error "Select statement did not produce a ResultSet for native query",
 :row_count 0,
 :running_time 0,
 :ex-data
 {:sql
  "-- Metabase:: userID: 4 queryType: native queryHash: 6c4db185dbf6e0c45f950d52bf122567bd80faeb10a9225e20fa29a912d840d1\nSELECT \nCONCAT('https://my-url', line_id, '&date=', toString(now()::date - 1) , '&timezone=Europe%2FParis') AS \"Troubleshooter link\"\nFROM my_table_in_clickhouse",
  :driver :clickhouse},
 :data {:rows [], :cols []}}

Works for me. As mentioned by Luis post diagnostic info

And what version of the clickhouse plugin are you running?