IMPORTANT: This article covers setup of warehouse for load data from Improvado, not customer data warehouse from which data is being extracted. This article doesn't cover setup of customer data warehouse for Data Prep as well.
Required information:
Possible parameters:
See the credentials options below.
Supported SSH key algorithms:
Possible parameters:
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.
Possible formats:
Possible parameters:
IMPORTANT: you cannot use {{ DD }} for partition by month
Also, you can use “_” instead of “-” or do not use any symbols at all, for example:
Possible ways of splitting data:
Select Yes for Use static IP option if you allow Improvado to connect your database by the following static IPs only:
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 above.
If you choose “SFTP auth by login/password” auth type, you must provide the following information:
If you choose “SFTP auth by Improvado public key” auth type, you must provide the following information:
Add Improvado SSH public key to your SFTP server (in ~/.ssh/authorized_keys file).
You can copy Improvado public SSH key on the right-hand side of the SFTP connection page.
If you choose “SFTP auth by private key” auth type, you must provide the following information:
Upload your SSH private key generated by following command, e.g.: