Designing and Running Pipelines

Resolved! Join using between clause

Hi All, I am looking for directions on how to perform a join based on between clause. I would like to join these 2 sources based on Source1.Key between source2.Key Start and source2.Key End Source 1 : |Key|Name| |0|ABC0| |1|ABC1| |2|ABC2| |3|ABC3| |4...

Change certain values inside an Array

Hello, I have this json: { "a": "Hello Word", "b": 1, "c": "some", "d": 10, "nested": [{ "m": "hey", "o": 10, "p": "hello", "q": 100 }] } I am trying to ...

DBMS_OUTPUT and GTT issues running PL/SQL programs in Snaplogic

We are having issues with output when running our PL/SQL programs from Snaplogic. Many of our existing pl/sql packages use DBMS_OUTPUT to write some information about the execution of the job–like row counts, any warning messages etc. When run from ...

Does Snowflake snappack 'Bulk Load' snap support ingesting data on to snow flake managed internal stage?

Snowflake has three kinds of stages before loading data on to snowflake dbs. 1/ Supported cloud storage, 2 / Internal snowflake managed named stage 3/ default table/user stage Bulk Load Snap’s documentation says, it does support PUT command. However...

Bug in Scheduled Task

@dmiller I found one issue in scheduled task. There is “Thueday” written instead of Thursday. I am not sure if it is just an UI issue or the mapping behind the code is also pulling some wrong value.

Filter function in snaplogic

Can anyone make me understand what the below function is doing? filter((a, b, c) => c.indexOf(a) == b)

Calling a Redshift Stored procedure in Snaplogic

Hi All, Has anyone been able to call a redshift stored proc using Snaplogic, couple of items which I read on the community mentioned they were not able to do so and there is an enhancement request for the same. If anyone one has an idea regarding how...

Github integration: file dirty status, revert local changes

I’ve been playing around with the Github integration. Thank you for adding this feature! Can someone assist in figuring out how to revert local changes made to a pipeline or file in the SnapLogic GUI and restore the Github version? This use-case is ...

SnapLogic - Integration Nation

Forum Posts

Resolved! Join using between clause

Change certain values inside an Array

DBMS_OUTPUT and GTT issues running PL/SQL programs in Snaplogic

Does Snowflake snappack 'Bulk Load' snap support ingesting data on to snow flake managed internal stage?

Bug in Scheduled Task

Filter function in snaplogic

Calling a Redshift Stored procedure in Snaplogic

Github integration: file dirty status, revert local changes

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...

What account should be used for API with query par...

How to dynamically update an account?

Execute each child pipeline multiple times

Routing files from S3

Clean duplicated lines in CSV datasource

How to get all values of a key from objects in a l...

The "Pipeline execute" is changing data types?

Remove XML duplicate key from JSON list in XML for...