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.

Available Actions

Run SQL Script

Execute an SQL Script with the 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.

user_range

JSON formatted data used to generate parameters to specify a subset of data to process. Refer to slide out help for more information.


Export Data Native

Export data from Redshift using the native UNLOAD command.

Variables

Database Parameters
target_db required

Database to run the SQL Script or Query on.

sql_steps required

SQL Query 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.

user_range

JSON formatted data used to generate parameters to specify a subset of data to process. Refer to slide out help for more information.


S3 Info
aws_connection required

AWS keys used to access to the S3 Bucket.

s3_bucket required

S3 Bucket where the exported data will be stored.

s3_path required

Folder path to the location where the data will be exported.


File/Formatting Options
file_name required

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

append_date required

Enable to append the creation datetime to the end of the filename.

compression required

Type of compression to apply to the file containing the exported data. Default is gzip.

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.