BigQuery SQL to Slack Alerter

Send an alert when an SQL Query evaluates to true.

Send Slack Alerts

If the SQL Query evaluates to True, send slack messages 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.

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.

Slack Parameters

slack_connection required

Token to use to authenticate with the Slack workspace containing the channel to post in.

channel required

Channel to post the message in.

message required

Message to post in the Slack channel.

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