Forum Discussion

Roger667's avatar
Roger667
New Contributor III
3 years ago
Solved

Unable to write salesforce data to s3 in parquet format

I Using saleforce read snap to read data and write to s3 in parquet format but getting error due to 'picklist' data type which is not compatible to parquet. How to handle such datat types problem
  • manichandana_ch's avatar
    manichandana_ch
    3 years ago

    Hi Roger667 

    Could you please check your SF read snap and make sure the 'Match datatype' is checked.

    Thanks !

Roger667's avatar
Roger667
New Contributor III
3 years ago

HI manichandana_ch 
Thanks for solving the buffer issue. This Worked but this led to another error. The parquet is not able to write boolean data types even though i have it in the excel file. It is identifying Boolean columns as string even tough i  can see in the metadata that those columns are not string but boolean

manichandana_ch's avatar
manichandana_ch
New Contributor III
3 years ago

Hi Roger667 

Could you please check your SF read snap and make sure the 'Match datatype' is checked.

Thanks !