https://community.qlik.com/t5/Talend-Studio/Salesforce-to-Amazon-Redshift-Only-2-5-rows-s/m-p/2220395#M14814 Is there a faster way to do the initial upload of all salesforce data into redshift? Tue, 27 Oct 2015 16:24:52 GMT Anonymous 2015-10-27T16:24:52Z https://community.qlik.com/t5/Talend-Studio/Salesforce-to-Amazon-Redshift-Only-2-5-rows-s/m-p/2220394#M14813 I'm currently syncing up various salesforce objects with my redshift cluster. I am currently just doing accounts and only getting ~2.5 rows/s.&nbsp; <BR />I am not linking all columns only about 20 but still if I need to do this for all of my objects in salesforce it would take forever. Additionally doing a daily update of records would be troublesome as well.&nbsp; <BR />The current linkage is: tSalesforceInput &gt; tMap &gt; tRedshiftOutput <BR />My output is set to "action on table: drop and create table" (this is the only way I got it to work... not sure why create table did not) and "action on data: insert or update".&nbsp; <BR />I am trying to get all of my objects into my redshift db before I start setting up regular update queries but I was quite surprised at this speed. Any tips or help would be greatly appreciated.&nbsp; <BR />Thanks, <BR />Brian Sat, 16 Nov 2024 10:58:29 GMT https://community.qlik.com/t5/Talend-Studio/Salesforce-to-Amazon-Redshift-Only-2-5-rows-s/m-p/2220394#M14813 Anonymous 2024-11-16T10:58:29Z https://community.qlik.com/t5/Talend-Studio/Salesforce-to-Amazon-Redshift-Only-2-5-rows-s/m-p/2220395#M14814 Is there a faster way to do the initial upload of all salesforce data into redshift? Tue, 27 Oct 2015 16:24:52 GMT https://community.qlik.com/t5/Talend-Studio/Salesforce-to-Amazon-Redshift-Only-2-5-rows-s/m-p/2220395#M14814 Anonymous 2015-10-27T16:24:52Z