My snowflake query works fine in snowflake, but I get a "Invalid limit value provided" within UiPath

Help Activities
, ,
1

I’m using the snowflake connector to query SQL code. This has worked great for other queries, but for this query I get a weird error:

image

This is the query:

SELECT
    o.TESTER AS mmd_Load_Number,
    o.Cust210 AS tmw_leg_number,
    rs.sequence,
    o.Lhama,
    MAX(CASE WHEN rsr.type = 'Customer_TyperTester' THEN rsr.value END) AS tmw_location_id,
    MAX(CASE WHEN rsr.type = 'EDI' THEN rsr.value END) AS tmw_stop_number,
    MAX(CASE WHEN rsr.type = 'PalletsIn' THEN rsr.value END) AS pallets_in,
    MAX(CASE WHEN rsr.type = 'PalletsOut' THEN rsr.value END) AS pallets_out
FROM
    route_stops AS rs
JOIN
    route_stop_references AS rsr ON rs.route_stop_id = rsr.route_stop_id
JOIN
    load_stops_route_stops AS lsrs ON rs.route_stop_id = lsrs.route_stop_id
JOIN
    loads AS l ON lsrs.load_id = l.load_id
JOIN
    load_audits AS la ON lsrs.load_id = la.load_id
JOIN
    orders AS o ON l.load_id = o.load_id
WHERE
    la.new_value = 'COMPLETE'
    AND la.triggered_at_utc > DATEADD(DAY, -8, CURRENT_DATE)
    AND o.Lhama ILIKE 'Food%'
    AND (rsr.type = 'Customer_TyperTester'
         OR (rsr.type = 'EDI' AND rsr.value LIKE '000%')
         OR rsr.type ILIKE 'Pallets%')
    AND rsr.route_stop_id IN (SELECT route_stop_id FROM route_stop_references WHERE type ILIKE 'Pallets%')
GROUP BY
    o.TESTER,
    o.Cust210,
    rs.sequence,
    o.Lhama;