Designing and Running Pipelines

How to implement jsonschema validation using Python script

Hi i’m trying to validate simple json data against particular json schema using python script. i’m trying to use ‘cerberus’ library of python but script snap is failing with error. How we can import external library and use it in script snap?any oth...

Parquet Reader & Writer through azure S3

For saving data in parquet format in s3 , below is the pipeline configuration. This pipeline creates meta data from the data itself , though it uses parquet data type ‘binary’ which is equivalent to string. the first mapper converts the doc into str...

How to access Hive on Private subnet AWS

Hi, I am trying to connect hive server hosted on AWS ec2 machine which is in private subnet. I am using bastion host and tunneling process to connect to hive in sql-workbench and tableau. when i am trying to do the same process in snaplogic its not w...

Error message in SMB write: 'can't encode character u'\\u2018' in position 23: ordinal not in range'

I have a File Writer Snap that needs to be able to write to a network smb drive. Since the network drive’s operating system software is a bit out of date, I’ve also been told to try the ‘cifs’ command. This is what I have in the File Write: ‘smb:\sha...

Reading compressed file and writing compressed files

Can we read a compressed password protected file and extract ? Vice versa can we read a file compress it and make it password protected?

Json Parse method

i can’t seem to get the json Parse method working when using a variable. I am trying to get the following output “customfield_11401”: [ { “value”: “1223-CUST-A1” } ] I am trying to use the following expression but getting an error. Any help is appre...

OAuth2 issues authorizing to Box

I am using REST snaps to connect to and perform functionality in Box that are not available via Box Snaps. I am having trouble establishing my OAuth2 account. I have my ‘application’ setup in Box to connect to and have the client ID and secret all se...

Triggered task - how to store data passed in querry parameter in a variable

I have created pipeline with parameter as test and created triggered task which is invoking pipeline I am calling that task using below URL https://elastic.snaplogic.com:443/api/1/rest/slsched/feed/StanfordDev/projects/gsb/test?test=jayr How can i st...

SnapLogic - Integration Nation

Forum Posts

How to implement jsonschema validation using Python script

Parquet Reader & Writer through azure S3

How to access Hive on Private subnet AWS

Error message in SMB write: 'can't encode character u'\\u2018' in position 23: ordinal not in range'

Reading compressed file and writing compressed files

Json Parse method

OAuth2 issues authorizing to Box

Triggered task - how to store data passed in querry parameter in a variable

Create a date range by hour

SOAP execute snap vs REST post/Http client snap

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