Am trying to create two pipelines with below information,
- Loading a csv file from sftp onto sql server - Created a pipeline containing below objects and problem is validation takes forever. Is this the correct snap or should I use ‘CSV Read/Write’ snap for it or suspect something is wrong with account settings?
SFTP Account created as Basic Auth,
User Name: firstname.lastname@example.org:22
File location path(sftp) which I verified is working when trying to access from browser,
- Loading a csv file from google drive onto sql server.
Tried using google spreadsheet reader snap and could only see excel files but not csv. Is this the correct snap or should I use REST snap pack for it.
Thanks in advance!