You can't use this until you register with us!




Description

Execute SQL Steps against a Redshift Cluster and optionally store the results in a desired location.


Purchasing Options



Available Actions

Run SQL Script with Date Parameters

Execute an SQL Script with the date range parameters specified.


Variables

Database Parameters
target_db required

Database to run the SQL Script or Query on.

sql_steps required

SQL Script to run. Statements are separated by a semicolon.

user_params

Parameters to use in your SQL Query or Script, if any. Refer to slide out help for more information.


Range
range_start_point required

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.

range_end_point_query

SQL Query to use to determine the end point of the data to process.

process_increment required

This Task will process your data in increments. Set a value in this field to determine the size of each increment.


Run SQL Script with Integer Parameters

Execute an SQL Script with the integer range parameters specified.


Variables

Database Parameters
target_db required

Database to run the SQL Script or Query on.

sql_steps required

SQL Script to run. Statements are separated by a semicolon.

user_params

Parameters to use in your SQL Query or Script, if any. Refer to slide out help for more information.


Range
range_start_point required

Integer where the processing of your sequentially sorted data should begin. This field will automatically be updated after each increment is processed.

range_end_point_query required

SQL Query to use to determine the end point of the data to process.

process_increment required

This Task will process your data in increments. Set a value in this field to determine the size of each increment.


Export Data Natively with Date Parameters

Export data from Redshift using the native UNLOAD command and date range parameters.


Variables

Database Parameters
target_db required

Database to run the SQL Script or Query on.

sql_steps required

SQL Query to run. Only one SQL step is allowed.

user_params

Parameters to use in your SQL Query or Script, if any. Refer to slide out help for more information.


Range
range_start_point required

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.

range_end_point_query

SQL Query to use to determine the end point of the data to process.

process_increment required

This Task will process your data in increments. Set a value in this field to determine the size of each increment.


S3 Info
s3_bucket_connection required

S3 Bucket where the exported data will be stored.

s3_path required

Folder path from the Folder Path Prefix in the S3 Bucket Connection to the folder where the data will be exported.


File/Formatting Options
file_name required

Name of the file that will be created with the exported data.

file_extension

Extension added after the File Name. It will be added before any extension added from the Compression selection.

compression required

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.

append_date required

Enable to append the creation datetime after the File Name and before any extensions.

delimiter required

Delimiter you want to use to separate columns. Default is tab delimited.

null_as

The string you want to use to indicate a null value. Default is nothing.

add_quotes required

Enable to wrap strings in quotes. Recommended for source data values containing double quote characters or the delimiter character.

escape

Enable to prepend a backslash in front of special characters.

max_size

Specify a size limit for individual files, between 5 MB and 6.2 GB. Specify a decimal number followed by MB or GB.

allow_overwrite required

Enable to overwrite existing files with the same name as a file being created. Disable to trigger Task failure.

parallel required

Enable to create multiple export files at the same time.


Export Data Natively with Integer Parameters

Export data from Redshift using the native UNLOAD command and integer range parameters.


Variables

Database Parameters
target_db required

Database to run the SQL Script or Query on.

sql_steps required

SQL Query to run. Only one SQL step is allowed.

user_params

Parameters to use in your SQL Query or Script, if any. Refer to slide out help for more information.


Range
range_start_point required

Integer where the processing of your sequentially sorted data should begin. This field will automatically be updated after each increment is processed.

range_end_point_query required

SQL Query to use to determine the end point of the data to process.

process_increment required

This Task will process your data in increments. Set a value in this field to determine the size of each increment.


S3 Info
s3_bucket_connection required

S3 Bucket where the exported data will be stored.

s3_path required

Folder path from the Folder Path Prefix in the S3 Bucket Connection to the folder where the data will be exported.


File/Formatting Options
file_name required

Name of the file that will be created with the exported data.

file_extension

Extension added after the File Name. It will be added before any extension added from the Compression selection.

compression required

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.

append_date required

Enable to append the creation datetime after the File Name and before any extensions.

delimiter required

Delimiter you want to use to separate columns. Default is tab delimited.

null_as

The string you want to use to indicate a null value. Default is nothing.

add_quotes required

Enable to wrap strings in quotes. Recommended for source data values containing double quote characters or the delimiter character.

escape

Enable to prepend a backslash in front of special characters.

max_size

Specify a size limit for individual files, between 5 MB and 6.2 GB. Specify a decimal number followed by MB or GB.

allow_overwrite required

Enable to overwrite existing files with the same name as a file being created. Disable to trigger Task failure.

parallel required

Enable to create multiple export files at the same time.


Create HTML

Create an HTML representation of a portion of a table.


Variables

Database Parameters
target_db required

Database to run the SQL Script or Query on.

sql_steps required

SQL Query to run. Only one SQL step is allowed.

user_params

Parameters to use in your SQL Query or Script, if any. Refer to slide out help for more information.


Range
range_start_point required

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.

range_end_point_query

SQL Query to use to determine the end point of the data to process.


Table Format Options
columns

Optional list of column names, separated by comma, with no spaces, to include only a subset of columns. Leave blank to include all columns.

show_dimensions

Enable to include a paragraph with the total number of rows and columns.

header

Enable to include a row with the Column names.

index_names

Enable to include a row with the index column names.

index

Enable to include a column with the number of each row.

bold_rows

Enable to render row labels in bold font.

max_rows required

Maximum number of rows to include in the HTML table. Specify 0 to include all rows.

max_cols required

Maximum number of columns to include in the HTML table. Specify 0 to include all columns.

col_space

Number of pixels to use as the minimum column width.

border required

Width of the HTML table border. Specify 0 for no border.

escape

Convert characters to ensure safe HTML sequences are rendered.

render_links

Convert URL strings in the data to HTML links.

na_rep

String to use to represent Not a Number values. Leave blank to use NaN.

decimal

Character to use to separate whole numbers from partial numbers.

justify

How the column titles in the HTML tables should be justified (Left, Right, Center). Leave blank for right justification.


Destination Options
html_output_table_name required

Name of the table, in schema.table format, where the HTML will be stored.

create_table_if_dne required

Enable to create the Target Table if it does not already exist.

html_field_size

Specify the maximum number of characters for HTML column if the table is automatically created.