Designing and Running Pipelines

Kafka Consumer Snap

Hi I wanted to read all the records from the kafka queue in first run and then latest records from the queue from kafka consumer snap.I start reading for the first time from the queue,what setting of ‘seek type’ and ‘auto offset reset’ should I use i...

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

SnapLogic - Integration Nation

Forum Posts

Kafka Consumer Snap

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

Change all Keys in JSON structure to lowercase

How to read .xlsb file

Append input data vertically

Difference between 2 dates

Find unmatched data using join

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap

Parsing CSV file

Data Validator Pattern error