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.
- Last Post 4 weeks ago
- Topic Is Solved
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/query/index.html Let us know if you have any further questions.
Customer Support Engineer