Designing and Running Pipelines

How to check if Query returns empty?

Hi, I have a sql execute snap that can return no values. I have the pipeline continuing if there is no values. What is the best way to identify if the query returns empty? I have added a “select count(*)…” off of the query before running the main qu...

How to pass source column name as parameter and then get its value?

Hi, I have defined a parameter col1 =$col_name. Now I want to use this in mapper expression. Once it is replaced it should behave like a source input column and its value should source input value. In the below screenshot, I have used same col_name c...

Resolved! Snaplogic configurations

Do we need to subscribe for groundplex again if we initially took only cloudplex subscription with snaplogic? Who need to maintain Groundplex and Cloudplex, do we have an option? can anyone answer this questions .That would help me a lot.

Task Execute Being Phased Out

I have a master pipeline that runs whenever a payroll is complete. This pipeline will kick off 10 integrations that send files to various vendors. I currently have the pipeline configured to use Pipeline Execute to run all of these in parallel. Ho...

Resolved! SQL Injection question

Hi, what is the mechanism in Snaplogic to prevent SQL injection, e.g. for Oracle. Do snaps, e.g. Oracle select, prevent SQL injection? Thanks

Create and load table for different files from same pipeline

Hi I have multiple different files with different structure. My pipeline should read each file, identify the column names, column length and data type and create the table in given db connection. Once table is created it should be loaded with data pr...

String to Date conversion

Hi, I have a CSV file which has a date column with date and null, while converting the string to date using the Date.parse function getting NaN for null values. This works for the value which is date, if the value is null this is throwing NaN. How to...

About the Asset, User, & Security Management category

Submit queries here related to managing your organization, including controlling user permissions, projects and security settings, configuring user and Snaplex notifications, and account data encryption levels.

SnapLogic - Integration Nation

Forum Posts

How to check if Query returns empty?

How to pass source column name as parameter and then get its value?

Resolved! Snaplogic configurations

Task Execute Being Phased Out

Resolved! SQL Injection question

Create and load table for different files from same pipeline

String to Date conversion

About the Asset, User, & Security Management category

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

Deleting multiple files at once from SFTP folder

SQS -pipeline stalling

Best Approach for Handling CSV Import with Truncat...

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...