Loading

Data 360: Error "Invalid SQL detected" when using NOT IN operator in Streaming Data Transform

Publiceringsdatum: Oct 30, 2025
Beskrivning

When a NOT IN operator is used in a streaming data transform SQL query to exclude records, a syntax error starting "ERROR: Invalid SQL detected, check syntax..." is returned.

Additionally, using a LEFT JOIN to exclude records is also not supported in streaming data transforms and will return the following syntax error:

Error : Lefts Joins are not supported in Data Transforms
Lösning

As streaming data transforms do not currently support NOT IN or LEFT JOIN, the only alternative is to use the inequality operator (i.e. <>). For example:

SELECT *
FROM Employees
WHERE ID <> '123'
AND ID <> '456'
Knowledge-artikelnummer

002056689

 
Laddar
Salesforce Help | Article