summary
Help page for ETL Configuration of Data Setting to Treasure Data.
constraints
- none in particular
Setting items
STEP1 Basic settings
| item name | indispensable | default value | Contents |
|---|---|---|---|
| Treasure Data Connection Configuration | Yes | - | From the Treasure Data Connection Configuration that has been registered in advance, select the one that has the necessary permissions for this ETL Configuration. |
| database | Yes | - | Enter the Database Name for Data Destination. |
| table | Yes | - | Enter the name of the Data Destination table. |
| time column | No | - | Specify the name of the time column to be used for the index. |
| Automatic table generation | Yes | Create if table does not exist | Select whether or not to automatically create the table specified in Table if it does not exist. |
| transfer mode | Yes | Postscript (APPEND ) |
Select the transfer mode. For details about each transfer mode, see About Transfer Modes below. |
STEP2 Output Option
| item name | default value |
|---|---|
| File Split Size | 16,384 |
| Whether or not to abort the transfer if an invalid record is found. | No, sir. |
| Default time zone | UTC |
| Maximum number of retries | 20 |
| Initial retry count in milliseconds | 1,000 |
| Maximum retry interval in milliseconds | 90,000 |
About transfer mode
| mode (musical mode, mode of probability distribution, state of physical system) | Details |
|---|---|
Postscript (APPEND ) |
Append to the table. Appends data directly to an existing table specified by the table. |
All cases washed (REPLACE) |
The table will be washed. First, create a temporary table and upload the data. After data is uploaded to the temporary table, the existing table specified in the table is replaced by the temporary table. In this case, the schema of the existing table is not migrated to the replaced table. |
All cases washed (TRUNCATE ) |
The table will be washed. First, create a temporary table and upload the data. After data is uploaded to the temporary table, the existing table specified in the table is replaced by the temporary table. The schema of the existing table is then added to the replaced table. |