FTP Destination

Possible parameters:

/data_source/data_table_title/report_type/YYYY/MM/DD/timestamp

• data_source is a data provider, integration, connector
• data_table_title is an object that contains all extraction orders with the same granularity (dimensional schema)
• report_type is a set of such fields as metrics, properties, dimensions, etc.
• timestamp is the date and time when data load started

If you use /YYYY/MM/DD settings, the data will be added to folders daily. Each new record will not delete the previous one, even for data that contains no date.

Note: A forward slash ( / ) means that you need to enter the root path.

Possible formats:

• csv
• csv+gzip
• json
• json+gzip
• parquet
• avro

Possible parameters:

filename-YYYY-MM-DD

• filename is the same as destination table name

Note: you cannot use DD for partition by month

• filename-YYYY-MM-DD – for partition by day
• filename-YYYY-MM – for partition by month

Also, you can use “_” instead of “-” or do not use any symbols at all, for example:

• filenameYYYY-MM-DD
• filenameYYYYMMDD

Possible delimiters that can separate data in your file:

• comma
• semicolon
• tab

Possible ways of splitting data:

• Day
• Month

Possible parameters:

• Require explicit FTP over TLS (FTPS)
• Explicit FTP over TLS if available (FTPS)
• Plain FTP (insecure)

Select Yes for Use static IP option if you allow Improvado to connect your database by the static IPs mentioned on the Destination connection page.

Select No if you have permitted access to your database from any IP. In this case, Improvado will connect your database using dynamic IPs not listed on the Destination connection page.

The "Use binary strings" determines whether string fields are encoded in binary format when loading data.

Recommended setting: "No" (default).