RAW SQL Step Throwing Error?

Toa_Lihkan

Greetings,

I'm using a RAW SQL step to fetch accounts based upon certain criteria. However, when I began testing, I was running into an error as soon as I add any sort of "WHERE" clause. The error is something like "Error message: Invalid column name". I'm trying to connect to an SQL DB. Am I doing something wrong? Here's what test query looks like:

gregory_Decisions

Hello!

That error message is most likely indicative of a syntax error. You'll want to be sure you use single quotes around variables (even those passed-in from the flow) when making a SQL query. Your query should run if you were to type this:

SELECT * FROM entity_account

WHERE account_id = 'your variable'

Hope this helps!

-Gregory