Send Slack messages based on queries run against a Redshift database.
Send Slack messages based on query results using a channel name and API token.
Variables
Credentials to use to connect to the Redshift Database.
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.
Credentials to use to connect to the Slack workspace.
Channel where the message should be posted.
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
Credentials to use to connect to the Redshift Database.
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'.