Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Output JSON field to postgres database taking too long >256 characters

vujennyfer
8 - Asteroid

Hello, 

I am trying to output a table with a JSON field to a postgres database and it is taking far too long than if I just created the JSON build in SQL. Have others run into this issue? Attached is a sample workflow. In my actual data, the JSON/data column has a red triangle and warning that says 'This cell has >256 characters'. The goal is to have an ETL workflow convert the final flat file into a JSON format to upload to a database efficiently.

 

Let me know if I can clarify anything!

0 REPLIES 0
Labels