Converting an array to a denormalized table
This seems like it should be simple but I’m still relatively new to snaplogic and just can’t figure it out. The json coming into my Mapper snap is formatted like this:
{"record1": {"id" : "1",
...
Forum Discussion
Hello venkat475,
I'm not sure but, this might be also possible to be achieved using SnapLogic expressions and parsing / formatting workarounds.
However if you have no other option, then you can use the Script Snap and the subprocess Python module to execute UNIX command directly on the Snaplex Node.
Regards,
Aleksandar.
Hi,
I don’t understand what is the exact issue. Can any one help here please as this is on priority . It’s very urgentThanks,
VenuHi, can you try this:
When connecting to an SSL enabled PostgreSQL account, the account fails in validation. To overcome this, configure the URL properties in Account settings to establish an SSL connection with the following parameter and value:
URL property name URL property value sslmode require or try
URL property name: ssl
Value: trueHello Venu,
Your screenshot shows the “Min pool size” was reduced from the default value of 3 to 0. Can you return that value back to the default value then try again?
Documentation link for PostgreSQL account:
https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438860/PostgreSQL+AccountMany thanks !
It’s now working
