create or replace table t_17146(
        data variant,
        user_id int,
        created_at timestamp
);

 
SELECT     data,
          user_id,
          created_at
FROM      t_17146
WHERE     data::STRING LIKE '%xxx%' QUALIFY row_number() OVER (
          PARTITION BY user_id
          ORDER BY  created_at DESC
          )=1
LIMIT     1;

error: APIError: QueryFailed: [1006]Unable to get field named "1". Valid fields: ["0", "4"]