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 it will not work and getting syntax error
It appears that it is trying to put the first part of the email as a column
Select * from Snaplogic_space.SFDC_Leads_vw where SFDC_Leads_vw.email = ‘firstname.lastname@example.org’
Snaplogic SQL pass Value form email above to a parameter
WHERE SFDC_Leads_vw.email ==” + $Email + “”
Where $Email has a value of email@example.com
Redshift - Execute1
WHERE SFDC_Leads_vw.email =” + $Email +""
Ignore empty result
Execute during preview
Failure: Failed to execute query: SELECT * FROM Snaplogic_space.SFDC_Leads_vw WHERE SFDC_Leads_vw.email =firstname.lastname@example.org, Reason: Amazon Invalid operation: column “phubley” does not exist in sfdc_leads_vw;, Resolution: Please check sql query.
this seems so simple cannot figure out what I am doing wrong