Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

S3 Load

Hi ,

I want to move data from s3 to redshift, but i have a issue in identity column error.

Also try with copy command , need to an explicit_ids... How to add explicit option in command

Thanks,

Mathan...

3 Community Answers

Matillion Agent  

Kalyan Arangam —

Hi Mathan,

Please can you share the error message you get?

I assume you have created a table with an identity column and then trying to load a file that should populate the rest of the columns. If so, edit the *Load Columns" property on teh S3 Load component and deselect the ID column from it.

Please share more about your use case if the above assumption is incorrect.

Best
Kalyan


Mathan Selvaraj —

Hi Kalyan,

I'm fix that issue explicit ids ,

and

I have an error like unknown boolean format.

How to rectify this boolean error.

Thanks,

Mathan...


Matillion Agent  

Kalyan Arangam —

hi Mathan,

You may need to look at your data to see which rows are causing these issues. Usually the error itself should point at the row number – if this is during the copy process.

Are you able to comment on whether you see thi sduring orchestration or transformations?

Best
Kalyan

Post Your Community Answer

To add an answer please login