Forum Discussion

Ranga's avatar
Ranga
New Contributor
8 years ago

UUID Lookup in Postgresql

Hi,

I have a requirement to perform lookup between uuid data type columns. Used PostgreSQL - Lookup snap but getting data type mismatch issue. Later replaced with In-Memory Lookup snap, before performing lookup converted uuid column to string using Mapper snap. while validation able to see expected lookup results but when i execute the pipeline In-Memory Lookup snap failed.

Pipeline sample:

Conversion used in both mapper snaps:

Error occured for In-Memory Lookup snap :

Can anyone suggest us how to resolve this issue or Is there is any other way to perform lookup between uuid data type columns