cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to execute Redshift Script with comments in it using Redshift Execute

Shrabanti
New Contributor II

Hi All,
I am using redshift execute to run a redshift script .
While I am able to run the script when every redshift query is enclosed in double quote,
but the script is failing when I am adding comments to that.
Would like to know how to write comment in redshift script so that it can be acceptable in “Redshift Execute”.

2 REPLIES 2

vineesha
Employee
Employee

Hi,
the following example would give an idea on how to write the comments,
Screen Shot 2021-01-22 at 9.39.21 AM

the comments should be enclosed in double hyphens(–)

Shrabanti
New Contributor II

Thank you Vineesha. It worked.