Hello folks! I am facing an issue with some of th...
# troubleshooting
c
Hello folks! I am facing an issue with some of the incoming Klaviyo data. One of the columns (
person__$source
) has new values which are strings, where they were originally all integers! I have been able to update the JSON schema to identify the extracted data as strings, not integers. And I have been able to update the end (Redshift) table to include the updated data type, (
varchar(256
) , for the
person__$source
column. However the pipeline now fails on the loader (target-redshift, datamill variant) as it looking to split the incoming columns! Any suggestions or help would be greatly appreciated
Splitting columns screenshots