Forum Discussion

wpenfold's avatar
wpenfold
Contributor
5 years ago

How do I debug a python script in the script snap

I am using a script snap to use SSH to call a procedure on another server. The pipeline completes without error, but it’s not calling the procedure–and it’s not giving me any error messages, so I do...
script
anayak's avatar
anayak
New Contributor III
4 years ago
Copy LinkReport

I have tried JSON.stringify and Json.parse, the value is converted to JSON but not read as jsonb when run with Postgres-Insert snap. Will try bulk load and execute snaps instead. Thanks!

anayak's avatar
anayak
New Contributor III
4 years ago
Copy LinkReport

@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: