Welcome, Guest Login

Support Center

Text Output

Last Updated: Jan 11, 2017 03:24PM UTC

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".


Property Setting Description
Name Text The descriptive name for the component.
Schema Select Select 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 name Text The table or view to unload to S3.
S3 URL Location Text The URL of the S3 bucket to load the data into.
S3 Object Prefix Text Create data files in S3 beginning with this prefix. The format of the output is
Delimiter Text Defaults to a comma - seperator string between values.
Compress Data Select Whether or not the resultant files are to be compressed.
Null As Text Replace NULL in the input data with the specified string in the output.
Output Type Select CSV - 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 Files Select If set, multiple files will be created each containing up to the maximum number of rows specified.
Row limit per file Integer Maximum number of rows per file.
Header Select Defaults to Yes, include a header line at the top of each file with column names.
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found