Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Now that you have created the connection to your remote SFTP instance, the next step is getting the data from your SFTP server into Treasure Data. You can set up an ad hoc one time transfer or a recurring transfer at a regular interval. In this section, you specify source details as described in the following steps.

...

Enter SFTP Server details.

...

If there are no errors with the connection, you see a preview of the data to be imported. If you are unable to see the preview, read more. If you have issues viewing the preview, contact support.

...

Select the Treasure Data target database and table that you want to import your data to. You can create a new database or table using the Create new database or Create new table check boxes checkboxes.

  • Mode: Append – Allows you to add records into existing table.

  • Mode: Replace – Replace the existing data in the table with the data being imported.

  • Partition key Seed: Choose the long or timestamp column that you would like to use as the partitioning time column. If you do not specify a time column, the upload time of the transfer is used in conjunction with the addition of a time column.

...

Data Transfer Frequency

You can choose to run the transfer only one time or schedule it to run on a given frequency of your choosing.

...