Hai i am passing column name like [appid] in sql component but i am getting Check properties for unmatched parenthesis, quotes or illegal characters error . Same way i a m running same query in redshift . In redshift its Running but in matillion its throwing error .
@SubashSambath Are you able to share the sql you have used within the sql component?
Also, do you have any components prior to the SQL Component in your transformation package, or is the SQL Component the first?
Hai Pete Thank you .. I fixed this issue
Hai Pete . Actually i stored data in super data type .. I followed following steps Step1. In sql query component i used to set case sensitive statement that is enable_case_sensitive_identifier
to
true
Step2: sequence number passed through variable
Hello @SubashSambath
I am glad to hear you fixed this, how did you resolve the issue you were met with?
Kind regards, Joe