This topic describes how to use a DingTalk chatbot to send a notification after an asynchronous SQL statement is executed in the Data Lake Analytics (DLA) console.

If you want to use a DingTalk chatbot to send a notification after an asynchronous SQL statement is executed in the DLA console, you must contact the DLA technical team in advance to help you create and configure a DingTalk chatbot.

Syntax

  • Send a notification after an asynchronous SQL statement is executed in the DLA console:

      /*+ run_async=true, mq-notify-by=dingtalk*/  select * from xxxx .... ;
  • To prevent excessive notifications, specify the minimum running duration for an asynchronous SQL statement:

      /*+ run_async=true, mq-notify-by=dingtalk, mq-threshold-secs=100 */  select * from xxxx .... ;

    If the running duration exceeds 100 seconds (the value of the mq-threshold-secs parameter is greater than or equal to 100), the DingTalk chatbot sends a notification. Otherwise, no notifications are sent.