Forum Discussion
@pmanchevski When I use Bulk Load, the auto-increment process_id column can’t be left empty but it does allow loading jsonb data. If I use Insert snap, then JSON.stringify() does make a json string but Inser Snap reads it implicitly as varchar/text and I have no way to typecast in the Insert Snap.
Also, as the data is coming from an excel file where $(all of the excel file data) is used in a column in the table, I’m not sure how to load the data as JSONB using the execute or insert snap.
Here’s the mapper fields:
followed by Insert:
Never mind, was able to resolve by casting to jsonb using the execute snap. Thanks!
- Senthilnaga913 years agoNew Contributor III
Can you pls share your pipeline design to have more clarity ?
Related Content
- 10 days ago
- 8 years ago