BigQuery to Email Alerter

Send messages based on the results of SQL Steps executed against a BigQuery data warehouse.

Send Email Alerts

Send e-mail messages based on the results of a set of SQL Steps.

Variables

Source Parameters

target_db required

Credentials to use to access the BigQuery Cloud Data Warehouse.

sql_steps required

SQL Steps to run. Last statement result can be multiple rows and columns. Result must have a "sendalert" column that contains a True or False value.

detail_sql_query

Optional SQL Query to run for each message sent. Results from the 'SQL Steps' may be used as parameters.

post_sql_query

SQL Query to run after alerts are sent. Does not generate new alerts.

user_params

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

Email Parameters

smtp_connection required

Credentials to use to access the server that will send the email messages.

alt_from

If this field is blank, the e-mail address associated with the Username specified in the SMTP Server 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.

body required

Body content of the email.

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