SFTP Connector

  • 28Views
  • Last Post 4 weeks ago
  • Topic Is Solved
0
votes
Jennifer Prusak posted this 4 weeks ago

Once I add an SFTP Conection how do I query the data? When I go to select a conector the SFTP doesn't show in the avaliable options. I am trying to connect it to a google sheet.

1
votes
Nataliia Nikulina posted this 4 weeks ago

Hello Jennifer,   

Thank you for contacting Skyvia Support team.   

Skyvia Query is an online SQL client and query builder tool that allows querying and managing cloud and relational data with SQL statements. You can enter SQL statements via code editor or compose SELECT statements with a visual query builder. SFTP can't be used in queries as this is file storage. For your scenario, you can create an Import Package to transfer data from SFTP to Google Sheets. Import package is a specific kind of package, which loads data to a cloud CRM or a relational database. Data can be imported from a cloud CRM, relational database, or CSV files. Note that connection to Google Sheets should be created prior to a package creation.

Follow a couple of links below to know more:  

https://docs.skyvia.com/data-integration/import/import-package.html

https://docs.skyvia.com/connectors/cloud-sources/googlesheets_connections.html

https://docs.skyvia.com/query/index.html   Let us know if you have any further questions.  

 

Best regards,

Nataliia,

Customer Support Engineer 

  • Supported by
  • Jennifer Prusak
Close