Snap Packs
Discuss configuration of Snaps and general questions about our Snap Packs.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Sharding SQL Server DB Table

Sharding a table is a type of partitioning that separates very large table the into smaller parts for loading data in parallel into target system. For Performance improvement the table was partitioned into multiple parts with Shard Offset snap and tr...

skatpally by Former Employee
  • 1846 Views
  • 0 replies
  • 0 kudos

How to generate a unique sequence number for every document

How to generate a unique sequence number It’s very simple to generate a unique sequence number on each document being processed through a snap. Below is the screen shot and attached is the sample pipeline. Sequence_2017_02_18.slp (2.8 KB)

lkummari by Former Employee
  • 2482 Views
  • 0 replies
  • 0 kudos

Group a number of records into a JSON list

How to group a set of number of records into a JSON list? It’s very simple to prepare the data into smaller groups with specific number of records in each list by specificfying it’s group size on the snap. Below is the quick screen shot of the config...

lkummari by Former Employee
  • 1140 Views
  • 0 replies
  • 0 kudos

Converting a JSON list to an Array

How to convert Json list to Array It’s very simple to covert JSON list to Array in SnapLogic. Simply drag and drop the Snap “Json Splitter” and connect to any document format snap whose downstream is a JSON list like in the attached example, select t...

lkummari by Former Employee
  • 2154 Views
  • 0 replies
  • 0 kudos