Redshift HTML to Email Sender

Use pre-generated HTML stored in Redshift to send an e-mail with HTML tables.

Send Email

Run the specified SQL queries to obtain the information needed to generate an e-mail with data in HTML tables.

Variables

Database Parameters

target_db required

Credentials to access the Redshift Database with the information for the e-mail content.

html_sql required

SQL Query to retrieve the HTML template for the body of the e-mail message.

tables_sql_step required

SQL Query to retrieve the HTML tables to add to the body of the e-mail message.

pointer required

Value where the processing of your sequentially sorted data should begin.

range_end_point_query required

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

user_params

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

Email Parameters

smtp_connection required

SMTP Server to use.

alt_from

If this field is blank, the e-mail address associated with the Username specified in the SMTP connection will be used.

to required

Addresses to place in the To field of the e-mail. Multiple values must be separated by commas.

cc

Addresses to place in the Cc field of the e-mail. Multiple values must be separated by commas.

bcc

Addresses to place in the Bcc field of the e-mail. Multiple values must be separated by commas.

subject required

Subject content of the email.

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