I'm trying to speed up my experiment assignment query by using the

{{experimentId}}

sql template. When I save it I get the following error though. I'm assuming because the experimentId is empty when it tests the query?

That's right. Are you using

LIKE '{{ experimentId }}'

in your query, rather than

=

? That may help here.

Ah thank you, that makes the error go away. I assume it slows down the query a bit though? Guess it would still be faster than not having the filter. I'll experiment