Hi,I have 2 input streams, i used inner join and fetched the matching data, also to capture the unmatched data i used- Unmatched data to error view option.I am able to find the get the unmatched/additional records from the left path. How can i get th...
Hi All, I am looking to simply parse out the snaps used in a pipeline using the metadata read snap. However, I am having trouble getting the output of the snap_map.property_map.info.label.value to display correctly out of the mapper. I tried to set t...
I went through all of the training, but no where does it tell you how to import a schema. It was always already available. I have a CSV file in S3 and am reading, then csv parser, then mapper. The mapper is where I am having problems. I manually a...
Hi all, I have a question regarding the list snap. Does it only list projects that the owner of the pipeline has access to? If we wanted to grab all project pipelines that exist across all of the employees of an organization or team. Is there a way t...
Hi, I have flat files where the header rows are not fixed example file content : abc.txtaabbcc1|2|3|4where aa ,bb,cc are header rows and I do not want to load them , my data starts at 1 where | is my delimiternumber of header lines is not fixed ,abo...
Hello, can someone please help with this? I was to extract each of the { "securityAlt":[...], "security":[...]} section out of the main array, and store each record on oracle table under a field. So for this below example, I want to insert the 12 obj...
Hi, I am seeing what seems to be maybe a limitation of the SCD2 snap. I am using the SCD2 snap to load some Snowflake columns named as such: <parent>.<key>. So for example this could be something like PERSON.PHONE which pertains to the following in a...
Hi, I am seeing what seems to be maybe a limitation of the SCD2 snap. I am using the SCD2 snap to load some Snowflake columns named as such: <parent>.<key>. So for example this could be something like PERSON.PHONE which pertains to the following in a...
