SQL Alert Email Functionality question

Hello, I am working on SQL Alert based on a critical business metric. I wanted to know if I can customize Alert Email content and also attach a report the email. Any suggestions here?

Thanks,

Jessie

5replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Jessie, great question! There are a couple ways to approach this:

    1. Set a Quality Check to your email report. This establishes a condition that must be met in order for the email report to not send. I've linked more information on this here for reference. In your case here, you can set your alert to ensure the KPI value is not attention-worthy. If this non-attention-worthy condition is met, the scheduled email report will not send.
    2. You can create a normal SQL Alert, and then in the "Description" on the right hand side of the SQL Alert editor, include a link to the dashboard

    Reply Like
  • Thanks Neha, That worked. Can you let me know if I can embed a SQL alert report into the email?

    Reply Like
      • Neha Kumar
      • Solutions Engineer
      • Neha_Kumar
      • 4 mths ago
      • Reported - view

      Jessie Could you describe the format you're looking to see? Would love to learn about what you're envisioning

      Reply Like
  • Neha Kumar

    I am looking embed a single dashboard widget which is a table with 5 columns & atmost 10 rows. Or I could send an dashboard.png email similar to the email generated from the "Dashboard Preferences" --> "Email Reports" option. Let me know if any of these 2 options are feasible.

    Reply Like
      • Neha Kumar
      • Solutions Engineer
      • Neha_Kumar
      • 4 mths ago
      • Reported - view

      Jessie  We currently don't support either of those options, though you can definitely include a link to the desired chart in the description to your SQL alert. I've provided your suggestions above to our product team here, as I agree that having that functionality would definitely be useful!

      Reply Like
Like Follow
  • 4 mths agoLast active
  • 5Replies
  • 148Views
  • 2 Following