Problem Accessing file(SFTP) using File Reader Snap

Question

Hi All,
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: ftpuser@52.86.106.54: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!
-Arun

dmiller · Answer

In the 4.x code line, there isn’t a ‘CSV Read/Write’ Snap. File Read to CSV Parser is the correct configuration. Performance issues may require Support to investigate.
I don’t believe the Google Spreadsheet Reader reads CSV files, but I will double check with Development.

asepuri · Answer

Thanks!!
Even I tried below as per the file reader snap documentation,

For google drive access,
Can we use REST snap pack for accessing csv files on google drive. Is this the right approach now??

asepuri · Answer

Mapper Snap properties for above reply on the pipeline

dmiller · Answer

To use $filename in the File field, you need to toggle on the expression button (=). Without it, it is treated as a string.

asepuri · Answer

That worked but it takes me back to validation which runs forever,

Should I email customer support(support@snaplogic.com) to check for any performance issues.

Forum Discussion

Problem Accessing file(SFTP) using File Reader Snap

Recent Discussions

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?