Issues building a query passing A parameter syntax

I know this is a very simple solution however I connect figure out the syntax in SL. I can pass this in a stored procedure on redship but when building it in my Pipeline using the Redshift execute i...