Interesting...It worked perfectly with a Cluster 18.0 Beta and 16.4 LTS, but I can only use this in notebooks, not in SQL queries and dashboards and it's very limiting for my use case.

I tried all the SQL Warehouses: Classic/Serverless/Pro and Preview/Current and none worked.
I also enabled all the preview features and tried to run the raw query, it worked, but it's a very inconvenient to ask my team to write all this code in every query:

select *
from remote_query(
  my_conn,
  service_name => 'my_svc',
  query =>
'''
SELECT *
FROM my_schema.my_table
WHERE dt_updated > DATE\'2026-01-01\'
'''
);