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

Description

Send Slack messages based on queries run against a BigQuery database.

Purchasing Options

BigQuery to Slack Alerter - $49.99 /

Available Actions

Send Slack Alerts

Send Slack messages based on query results using a channel name and API token.

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

Credentials to use to connect to the Slack workspace.

channel required

Channel where the message should be posted.

message required

Message to post in the Slack channel. Results from the 'SQL Steps' can be included by column name. The entire set of results from the 'Detail Query' can be included in a code block using the variable 'detail_results_cb'.


Send Slack Alerts via Webhook

Send Slack messages based on query results using an incoming webhook URL.

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_webhook_url required

Incoming webhook URL for the channel where the message should be posted.

message required

Message to post in the Slack channel. Results from the 'SQL Steps' can be included by column name. The entire set of results from the 'Detail Query' can be included in a code block using the variable 'detail_results_cb'.