Forum Discussion

asepuri's avatar
asepuri
New Contributor II
9 years ago

Problem Accessing file(SFTP) using File Reader Snap

Hi All,

Am trying to create two pipelines with below information,

  1. 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,

  1. 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

7 Replies

  • shuo's avatar
    shuo
    New Contributor
    4 years ago

    it works well! Thank you!

  • deepak_shaw's avatar
    deepak_shaw
    Contributor
    4 years ago

    Hi @cjhoward18 ,
    Thanks for the valuable suggestions, however, I need further help on the same lines:
    I tried to use the same method in mapper snap which copied all node as is, How I can select a few of them. I need to have repetitive node ‘InvoiceLine’ and need to select few fields after group by and change the name. The repetitive nodes should be like below screen:

    and I’m using your suggestion as below screenshot:

    Can you please suggest how to fix it?
    Thanks,
    Deepak Shaw.