Designing and Running Pipelines

All Python Function is not working in Script task

I have perfectly executed python code in my computer. However, same code does not execute in Script task. For instance, I used parse() function to format datetime. parse(“2017-08-27T00:00:00.000”).date() works in my computer, but not in script task....

Using Azure Storage/Azure Blob Storage

I am trying to create an Azure Blob Reader but I keep encountering this error: Error: Directory not found or access denied: wasb:///storage@janoswsl.blob.core.windows.net/; Reason: com.snaplogic.snaps.hadoop.BinaryAzureAccount cannot be cast to com....

Proper syntax for file reader snap - network file

Hi, I am on a windows box. I have a network file, file://fs01-hou/Common/RDMetric/CARType.xls, that I can access from Chrome. However, I can’t seem to get the correct syntax for the file reader snap Any help is highly appreciated Daisy

Subpipeline - Lookup

We have a requirement to do a lookup on a db table and get additional attributes. This lookup is being done in a sub-pipeline. We would ideally like to load the lookup data into memory and do an in-memory lookup instead of querying the database for e...

Identity column value after merge or insert in SQL Server

Is there a way to get the identity column value from SQL Server after a merge or insert without doing a select again?

Not able to get input schema for attachment field in Email sender snap

Hi, I am using Email sender snap in my pipeline, I am able to get the input view data from the input snap in Email sender snap without any problem for the fields like ‘to, from, subject etc…’ Howerver I am not able to get the input view data for Atta...

Resolved! How to generate a HTML file with Snaplogic

Hi, I want to dynamically generate a html file with Snaplogic. What are the best snaps to do this? Its best to have the ability to dynamically change the content of the html when pipeline is running. Thanks

Parquet without Hadooplex

Has anyone come up with a “simple” process to convert files to Parquet format without the need to use a Hadooplex and without going through HDFS. I would like to read a text file from S3 and convert it to Parquet back onto S3.

SnapLogic - Integration Nation

Forum Posts

All Python Function is not working in Script task

Using Azure Storage/Azure Blob Storage

Proper syntax for file reader snap - network file

Subpipeline - Lookup

Identity column value after merge or insert in SQL Server

Not able to get input schema for attachment field in Email sender snap

Resolved! How to generate a HTML file with Snaplogic

Parquet without Hadooplex

Best Approach for Handling CSV Import with Truncat...

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?