Designing and Running Pipelines

Data Loading Strategy

Hi, I have been working with SQL server database as target. The loading strategy we use is to trruncate and load the fresh data every day. But we dont have any option for this in SQL Server Insert snap. As a result I need to put SQL server execute sn...

Eloqua Snap: Adding A Variable

I am using the Eloqua snap to extract multiple of the Core Object Types. I would like to create a variable so I could reuse the pipeline but I can give it is a drop down. Any idea how to run it with a variable? Open to other work arounds too…

Resolved! Drop first record

Hi All, I have a variable number of records coming from a mapper and will always want to drop the first. Is there an easy way to do this? Thanks, Mark

Passing Date as parameter to child pipeline which is google analytic snap

Hi, I’am trying to pass date as parameter to child snap(which is google analytic snap) and receive the value in startdate and enddate filed on the Snap, however I’m unable to retrieve the same.

Reading and Writing Data to Azure Blob Storage and Azure Data Lake Store

Organizations have been increasingly moving towards and adopting cloud data and analytics platforms like Microsoft Azure. In this first in a series of Azure Data Platform blog posts, I’ll get you on your way to making your adoption of the cloud platf...

Math.pow vs. decimal exponents

Hello, We’ve been trying to implement a calculation using a decimal exponent into Math.pow Each time the exponent is a decimal and not strictly an integer, we get 1 as a result. Current result is the following Math.pow(2,2) gives 4 Math.pow(2,3) give...

Directory Browser - Sub Directories

Is there a way to scan a directory (including sub-directories) for files? I just need a list of files with the complete path. We are using SFTP to access the folder. Directory Browser doesn’t appear to have that option Thanks, Ignatius

Error while reading a Box file

I’m trying to read a csv file from Box ,but ive encountered a weird behavior that I just cant find a resolution to. This is the error in the Box read snap: Failure: Error downloading the file: %s, Reason: Exception while reading binary data from the ...

SnapLogic - Integration Nation

Forum Posts

Data Loading Strategy

Eloqua Snap: Adding A Variable

Resolved! Drop first record

Passing Date as parameter to child pipeline which is google analytic snap

Reading and Writing Data to Azure Blob Storage and Azure Data Lake Store

Math.pow vs. decimal exponents

Directory Browser - Sub Directories

Error while reading a Box file

Transpose columns(Dynamic) into rows.

Is migrating of REST Snap to Http Client still man...

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