Designing and Running Pipelines
Discuss how to use the SnapLogic platform.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Redshift bulk load have high input time

Hi Team, Could you please suggest why Redshift bulk load have high input time and how can we solve this issue. We are fetching data from SQL Server and inserting into redshift. Source records count : 59473885 Please refer to Pipeline execution stati...

Abhi by New Contributor
  • 652 Views
  • 0 replies
  • 0 kudos

Resolved! JSON returns Column Names separately from the Rows

I have a REST API that returns something like the following: entity": { “items”: [ { “tableName”: “mytable” “count”: 7995 “columnNames”: [ “c1”,“c2”,“c3”,“c4” ] “rows”: [ [r1c1value,r1c2value,r1c3value,r1c4value],[r2c1value,r2c2value,r2c3value,r2c4va...

Garrett by New Contributor II
  • 4879 Views
  • 7 replies
  • 2 kudos

SQL Server Insert snap really slow

I’m writing ~ 200M records into a SQL DB but at the current rate (56,000 records over 2 hrs) I’ll be here a long time before it finishes. Wondering if I’m missing something in the setup or if there is something that needs to be tweaked elsewhere.

msalter by New Contributor II
  • 2630 Views
  • 3 replies
  • 1 kudos