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:
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;