Postgresql Execute doesn't show the result (SELECT query)

[c_decoster]

Hello, 

I'm trying to do a complexe PostgreSQL SELECT so i'm trying to use the Execute snap. (here is the snap settings : 

)

We can see in the pipeline execution statistics that he found the result i need (when i do this query in pgadmin i have the same amount of row (990)).

But i can't gather the data, neither in the pre-view, or in a mapper.
What can i do to get the data i need ? 

Thanks in advance, 

Decoster Corentin

[bojanvelevski]

Hi @c_decoster,

I would say you should check the data you're trying to retrieve. Sometimes, the data is saved as an SQL composite-type value, and requires to be converted to a readable JSON so Snaplogic can consume it, with functions like array_to_json, or row_to_json, etc.

This url might be helpful: how-row_to_json-function-works-in-postgresql 

Regards,

Bojan