Loading

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

Дата публикации: Oct 30, 2025
Описание

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
Решение

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'
Номер статьи базы знаний

002056689

 
Загрузка
Salesforce Help | Article