One Star

Credentials used in AWS COPY query inside tRedShiftRow wrapping.

 Im using COPY command in tRedShiftRow component to load staging table form S3. In Copy query the last 2 char of the credentials are getting to next like which is making the query to fail.
Example if the credentials  is (104 char)  'aws_access_key_id=Aasdddf122345w66yuuQ;aws_secret_access_key=5sdfghjjkv6555555swer+rtwtyu+uuwurttgX21' 
than the " 21’  " comes to next line
 Please suggest 
1 REPLY
One Star

Re: Credentials used in AWS COPY query inside tRedShiftRow wrapping.

For me it looks like a bug in tRedshiftRow component the char wrapping happens after 101 char.