Forum Discussion

c_decoster's avatar
c_decoster
New Contributor
2 years ago

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

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

 

1 Reply

  • bojanvelevski's avatar
    bojanvelevski
    Valued Contributor
    2 years ago

    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