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

Description

Send an Slack alert when an last statement of sql query evalutes to true. Uses Jinja Templates from results to render messages.

Available Actions

Check Alert

If an SQL statement evalulates to True, send an alert

Variables

target_db required

Database where you want to run the script on.


slack_token required

Token used to Authenticate with slack.


Slack Parameters
channel required

Channel the message is being sent to

message required

Message to be sent to slack channel

sql_query required

SQL Query/Queries to run. Last statement can return multiple rows and columns. Must have a "sendalert" column which returns True/False. Email will be sent when "sendalert" evaluates to True


post_sql_query

SQL Script or steps to run after sending of e-mails. Does not send alerts.


user_params

If in your sql you use any parameters then you need to create a parameter list here. Case Sensitive.