Execute SQL Steps against a Redshift Cluster and optionally store the results in a desired location.
Execute an SQL Script with the date range parameters specified.
Variables
Database to run the SQL Script or Query on.
SQL Script to run. Statements are separated by a semicolon.
Parameters to use in your SQL Query or Script, if any. Refer to slide out help for more information.
Datetime stamp where the processing of your sequentially sorted data should begin. Formatted as YYYY-MM-DD HH:MM:SS in the UTC time zone. This field will automatically be updated after each increment is processed.
SQL Query to use to determine the end point of the data to process.
This Task will process your data in increments. Set a value in this field to determine the size of each increment.
Execute an SQL Script with the integer range parameters specified.
Variables
Database to run the SQL Script or Query on.
SQL Script to run. Statements are separated by a semicolon.
Parameters to use in your SQL Query or Script, if any. Refer to slide out help for more information.
Integer where the processing of your sequentially sorted data should begin. This field will automatically be updated after each increment is processed.
SQL Query to use to determine the end point of the data to process.
This Task will process your data in increments. Set a value in this field to determine the size of each increment.
Export data from Redshift using the native UNLOAD command and date range parameters.
Variables
Database to run the SQL Script or Query on.
SQL Query to run. Only one SQL step is allowed.
Parameters to use in your SQL Query or Script, if any. Refer to slide out help for more information.
Datetime stamp where the processing of your sequentially sorted data should begin. Formatted as YYYY-MM-DD HH:MM:SS in the UTC time zone. This field will automatically be updated after each increment is processed.
SQL Query to use to determine the end point of the data to process.
This Task will process your data in increments. Set a value in this field to determine the size of each increment.
S3 Bucket where the exported data will be stored.
Folder path from the Folder Path Prefix in the S3 Bucket Connection to the folder where the data will be exported.
Name of the file that will be created with the exported data.
Extension added after the File Name. It will be added before any extension added from the Compression selection.
Type of compression to apply to the file containing the exported data. A selection other than None will add a gz or bz2 extension after the File Extension. Default is gzip.
Enable to append the creation datetime after the File Name and before any extensions.
Delimiter you want to use to separate columns. Default is tab delimited.
The string you want to use to indicate a null value. Default is nothing.
Enable to wrap strings in quotes. Recommended for source data values containing double quote characters or the delimiter character.
Enable to prepend a backslash in front of special characters.
Specify a size limit for individual files, between 5 MB and 6.2 GB. Specify a decimal number followed by MB or GB.
Enable to overwrite existing files with the same name as a file being created. Disable to trigger Task failure.
Enable to create multiple export files at the same time.
Export data from Redshift using the native UNLOAD command and integer range parameters.
Variables
Database to run the SQL Script or Query on.
SQL Query to run. Only one SQL step is allowed.
Parameters to use in your SQL Query or Script, if any. Refer to slide out help for more information.
Integer where the processing of your sequentially sorted data should begin. This field will automatically be updated after each increment is processed.
SQL Query to use to determine the end point of the data to process.
This Task will process your data in increments. Set a value in this field to determine the size of each increment.
S3 Bucket where the exported data will be stored.
Folder path from the Folder Path Prefix in the S3 Bucket Connection to the folder where the data will be exported.
Name of the file that will be created with the exported data.
Extension added after the File Name. It will be added before any extension added from the Compression selection.
Type of compression to apply to the file containing the exported data. A selection other than None will add a gz or bz2 extension after the File Extension. Default is gzip.
Enable to append the creation datetime after the File Name and before any extensions.
Delimiter you want to use to separate columns. Default is tab delimited.
The string you want to use to indicate a null value. Default is nothing.
Enable to wrap strings in quotes. Recommended for source data values containing double quote characters or the delimiter character.
Enable to prepend a backslash in front of special characters.
Specify a size limit for individual files, between 5 MB and 6.2 GB. Specify a decimal number followed by MB or GB.
Enable to overwrite existing files with the same name as a file being created. Disable to trigger Task failure.
Enable to create multiple export files at the same time.
Create an HTML representation of a portion of a table.
Variables
Database to run the SQL Script or Query on.
SQL Query to run. Only one SQL step is allowed.
Parameters to use in your SQL Query or Script, if any. Refer to slide out help for more information.
Datetime stamp where the processing of your sequentially sorted data should begin. Formatted as YYYY-MM-DD HH:MM:SS in the UTC time zone. This field will automatically be updated after each increment is processed.
SQL Query to use to determine the end point of the data to process.
Optional list of column names, separated by comma, with no spaces, to include only a subset of columns. Leave blank to include all columns.
Enable to include a paragraph with the total number of rows and columns.
Enable to include a row with the Column names.
Enable to include a row with the index column names.
Enable to include a column with the number of each row.
Enable to render row labels in bold font.
Maximum number of rows to include in the HTML table. Specify 0 to include all rows.
Maximum number of columns to include in the HTML table. Specify 0 to include all columns.
Number of pixels to use as the minimum column width.
Width of the HTML table border. Specify 0 for no border.
Convert characters to ensure safe HTML sequences are rendered.
Convert URL strings in the data to HTML links.
String to use to represent Not a Number values. Leave blank to use NaN.
Character to use to separate whole numbers from partial numbers.
How the column titles in the HTML tables should be justified (Left, Right, Center). Leave blank for right justification.
Name of the table, in schema.table format, where the HTML will be stored.
Enable to create the Target Table if it does not already exist.
Specify the maximum number of characters for HTML column if the table is automatically created.