Contents x
    Data Destination - Treasure Data
      • Print
      • PDF
      Contents

      Data Destination - Treasure Data

        • Print
        • PDF
        Article summary

        summary

        Help page for ETL Configuration of Data Setting to Treasure Data.

        constraints

        • none in particular

        Setting items

        STEP1 Basic settings

        item nameindispensabledefault valueContents
        Treasure Data Connection ConfigurationYes-From the Treasure Data Connection Configuration that has been registered in advance, select the one that has the necessary permissions for this ETL Configuration.
        databaseYes-Enter the Database Name for Data Destination.
        tableYes-Enter the name of the Data Destination table.
        time columnNo-Specify the name of the time column to be used for the index.
        Automatic table generationYesCreate if table does not existSelect whether or not to automatically create the table specified in Table if it does not exist.
        transfer modeYesPostscript (APPEND )Select the transfer mode.
        For details about each transfer mode, see About Transfer Modes below.

        STEP2 Output Option

        item namedefault value
        File Split Size16,384
        Whether or not to abort the transfer if an invalid record is found.No, sir.
        Default time zoneUTC
        Maximum number of retries20
        Initial retry count in milliseconds1,000
        Maximum retry interval in milliseconds90,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.
        Was this article helpful?
        What's Next