Sftp
Prerequisites
- The Server with SFTP connection type support
- The Server host
- The Server port
- Username-Password/Public Key Access Rights
Setting up the Sftp connector
| No | Item | Required | Example | Notes |
|---|---|---|---|---|
| 1 | User Name | Yes | The server user | |
| 2 | Host Address | Yes | www.host.com 192.0.2.1 | The server host address |
| 3 | Port | Yes | 22 | The server port |
| 4 | Authentication | Yes | The server authentication method Refer to the documentation in the form while using the connector Password AuthenticationSSH Key Authentication | |
| 5 | File types | No | csv,json csv | Coma separated file types. Currently only 'csv' and 'json' types are supported. |
| 6 | Folder Path | No | /logs/2022 | The directory to search files for sync |
| 7 | File Pattern | No | log-([0-9]{4})([0-9]{2})([0-9]{2}) - This will filter files which log-yearmmdd | The regular expression to specify files for sync in a chosen Folder Path |
Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.