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

Description

Send an alert when an SQL Query evaluates to true. Slack and Email targets supported.

Purchasing Options

SQL Alerter - $0.0 / month

Available Actions

Send Email

If the SQL Query evaluates to True, send an e-mail with the content specified.

Variables

Email Parameters
smtp_connection required

SMTP Server to use.

alt_from

If this field is blank, the e-mail address associated with the Username specified in the SMTP connection will be used.

to required

Address to place in the To field of the e-mail.

cc

Address to place in the Cc field of the e-mail.

bcc

Address to place in the Bcc field of the e-mail.

subject required

Subject content of the email.

body required

Body content of the email.


Database Parameters
target_db required

Database to run the SQL Query on.

sql_query required

SQL Query to run which must evaluate to True or False.


Post to Slack

If the SQL Query evaluates to True, post a message to a Slack channel with the content specified.

Variables

Slack Parameters
slack_token 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.


Database Parameters
target_db required

Database to run the SQL Query on.

sql_query required

SQL Query to run which must evaluate to True or False.