Skip to main content

Alerting

Send alert from BigQuery result.

Please following the steps below to setup an alert:

Alert configuration#

  • Name: name of your alert (name should be descriptive so you will find it easier later).

  • Description: you can add more information here.

  • Tags: you can put tags like team name: marketing, data (or anything that help you to find your alert quicker later on).

    info

    You can define multiple tags separated by ,

  • Schedule Time: please check out here for more information.

  • Source Connection: BigQuery project to run query.

  • Query: your query.

  • Conditions: define condition for the alert. The alert will only send records that matched defined condition(s), if it's not defined then send all records.

    note

    Field name must appear in the query result.

  • Alert Provider:

    • Telegram

Message Configuration#

  • Chat: Group chat that you have added @sc_datadex_bot into.

  • Message Header: Title of an alert.

  • Message Body: main message. If query reuslt return more than 1 results, it will display each record in each line using the provided format.

    Use column name as parameter to format message using double curly bracket {{column_name}}. And you can apply some basic formatting like:

    • Bold: <b>Your bold text here</b>

    • Italic: <i>Your italic text here</i>

      More info

      Example: query result has 2 columns: date, revenue_amount and 1 result: 2022-01-17, 1000 respectively. You can format message like:

      Revenue for {{date}} is: <b>${{revenue_amount}}</b>

      This will display as:

      Revenue for 2022-01-17 is: $1000

note

Parameter(s) must match the column name in query result.

  • Message Footer: extra information like dashboard, report link to elaborate the result.