BigQuery SQL to Email Alerter

Send an alert when an SQL Query evaluates to true.

Send Email Alerts

If the SQL Query evaluates to True, send an e-mail with the content specified.

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

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.

body required

Body content of the email.

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