Send Slack messages based on queries run against a Postgres database.
Send Slack messages based on query results using a channel name and API token.
Variables
Postgres Database to run the SQL Steps on.
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.
Optional SQL Query to run for each message sent. Results from the 'SQL Steps' may be used as parameters.
SQL Query to run after alerts are sent. Does not generate new alerts.
Parameters to use in your SQL Steps and Queries, if any. Refer to slide out help for more information.
Token to use to authenticate with the Slack workspace containing the channel to post in.
Channel to post the message in.
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 messages based on query results using an incoming webhook URL.
Variables
Postgres Database to run the SQL Steps on.
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.
Optional SQL Query to run for each message sent. Results from the 'SQL Steps' may be used as parameters.
SQL Query to run after alerts are sent. Does not generate new alerts.
Parameters to use in your SQL Steps and Queries, if any. Refer to slide out help for more information.
Incoming webhook URL for the channel to post in.
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'.