(Couldn't find a post on this, but I apologize if there is already one out there.)
To speed up my queries, I have been trying to filter my data earlier in my workflows by...
- Selecting the fields I need in the "Input Data" tool instead of the "Select" tool
- Adding simple WHERE clauses in the "SQL Editor" interface in the "Input Data" tool
The WHERE clauses in particular really seem to help, so I have been trying to use more of them, but I have noticed that they do not seem to work when I am specifying rows with a string instead of a number:
Does anyone know why that is, or how I can troubleshoot this error?
