--- title: "Data Destination - Treasure Data" slug: "data-destination-treasure-data" updated: 2024-09-19T08:17:03Z published: 2024-09-19T08:17:03Z canonical: "documents.trocco.io/data-destination-treasure-data" --- > ## Documentation Index > Fetch the complete documentation index at: https://documents.trocco.io/llms.txt > Use this file to discover all available pages before exploring further. # Data Destination - Treasure Data ## 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](/docs/data-destination-treasure-data#%E8%BB%A2%E9%80%81%E3%83%A2%E3%83%BC%E3%83%89%E3%81%AB%E3%81%A4%E3%81%84%E3%81%A6) mode, see [About Transfer Modes](/docs/data-destination-treasure-data#%E8%BB%A2%E9%80%81%E3%83%A2%E3%83%BC%E3%83%89%E3%81%AB%E3%81%A4%E3%81%84%E3%81%A6) 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. |