Uploads data (or the result of a query as files) to an FTP server. Supports several connection types like FTP, SFTP or FTPS.
load:
conn_id: sftp
type: ftp
folder: myserver.com/some/folder
compression: gzip
destination_format: csv
| property | type | mandatory | description |
|---|---|---|---|
conn_id | string | no | Connection string as handed to you by the Onesecondbefore team. Default is no connection string for FTP servers that don't require authorization. |
type | enumerator(ftp, sftp) | yes | .ftp = FTP server
sftp = SFTP server |
folder | string | no | Default is empty. Contains the folder to upload to on the server. |
compression | enumerator (gzip, deflate) | no | Only use if the extract type is a database (query). Type of compression. Use deflate only with AVRO file format. |
destination_format | enumerator (csv, json, avro) | no | Only use if the extract type is a database (query). Default is json. Format of the extracted data. |