Text Output
    • Dark
      Light

    Text Output

    • Dark
      Light

    Article Summary

    This article is specific to the following platforms - Redshift.

    Text Output Component

    This component creates text files on a specified Amazon S3 bucket, and loads them with data from an Amazon Redshift table or view.

    The data can be output to multiple files based on a "per file row count".

    Note:This component is similar in effect to the 'S3 Unload' component. Since Text Output pulls the data through the Matillion ETL instance, this component offers some added functionality (such as adding column headers to each file). However, S3 Unload unloads data in parallel directly from Redshift to S3 and so tends to be faster.


    Properties

    PropertySettingDescription
    NameTextA human-readable name for the component.
    SchemaSelectSelect the table schema. The special value, [Environment Default] will use the schema defined in the environment. For more information on using multiple schemas, see this article.
    Table nameTextThe table or view to unload to S3.
    S3 URL LocationTextThe URL of the S3 bucket to load the data into.
    S3 Object PrefixTextCreate data files in S3 beginning with this prefix. The format of the output is:
    <prefix>_<file-number>
    DelimiterTextDefaults to a comma-separator string between values.
    Compress DataSelectWhether or not the resultant files on the S3 Bucket are to be compressed into a gzip file.
    Null AsTextReplace NULL in the input data with the specified string in the output.
    Output TypeSelectCSV: If the value contains the specified delimiter, newline or double quote, then the String value is returned enclosed in double quotes. Any double quote characters in the value are escaped with another double quote.
    Escaped: inserts backslashes to escape delimiter, newline or backslash.
    Multiple FilesSelectIf set, multiple files will be created each containing up to the maximum number of rows specified.
    Row limit per fileIntegerMaximum number of rows per file.
    HeaderSelectDefaults to Yes, include a header line at the top of each file with column names.