Designing and Running Pipelines

String to Char Array

Good Day Everyone, How do you convert a string datatype to a char Array datatype in order to do a SQL Server Lookup where the field being searched is of char(10) format? The data being entered is of string format eg. “A345”. However this error is ret...

Dataware housing ID generation process needed suggestion

Hi Experts, We are trying to build data warehouse via snaplogic. Whenever there is same record pulled from source (Big data system) we should have same ID generated and when there is new record then new id has to be generated. Since this is decommiss...

Resolved! How to generate dynamic file name by using pipeline execute

We’re using pipeline execute to run the tasks in parallel by check Reuse executions to process documents and changed Pool Size. But in the pipeline execute called pipeline, it will generate a log file as an output. How do we generate different file n...

Resolved! Convert Rows to Columns

I’m trying to convert row values into columns. Can anyone suggest me how should I approach to resolve this?

Question: Unable to pass Schema and table name as Parameters to Select Snaps

When passing the Schema name as parameter, I can see the value in preview but snap is complaining that it is null.

Viewing SQL generated by a Snap

Is there a way I can view the exact SQL that is generated by a pipeline? I am debugging a pipeline that uses the Oracle - Execute snap. The results from the generated SQL are not what I am expected and I would like to be able to see what statement i...

Selecting set of required fields only to update in Snowflake Bulk Upsert

Hello, I am trying to do a simple Upsert from Stage to ODS table in the Snowflake DB. The Source and target tables are both in the Snowflake DB. I am using the Snowflake Bulk Upsert Snap to do the Merge. I have a mapper to map the Columns to the Bulk...

API for task scheduling

we have a need here where we need to allow a task schedule change from external application, does snaplogic supports such requests ? is there any API available to change the task schedule ? Mostly schedule change will encompass following - task sched...

SnapLogic - Integration Nation

Forum Posts

String to Char Array

Dataware housing ID generation process needed suggestion

Resolved! How to generate dynamic file name by using pipeline execute

Resolved! Convert Rows to Columns

Question: Unable to pass Schema and table name as Parameters to Select Snaps

Viewing SQL generated by a Snap

Selecting set of required fields only to update in Snowflake Bulk Upsert

API for task scheduling

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...

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...