How to send SQL Query Results in Teams notification in Grid Format using Azure Data factory or Azure Synapse

Rajasekaran, Rajkumar 0 Reputation points
2023-11-16T05:52:13.64+00:00

Hi ,

I need to Send the SQL Query Results from Azure Data Factory or Synapse Using Web Activity.

I've have the incoming webhooks created ready. My Result set is shown below.

User's image

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,402 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,615 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AnnuKumari-MSFT 31,146 Reputation points Microsoft Employee
    2023-11-16T06:53:20.3833333+00:00

    Hi Rajasekaran, Rajkumar ,

    Welcome to Microsoft Q&A platform and thanks for posting your query here. I understand that you are trying to send the SQL Query results in tabular format via teams notification using web activity in ADF /Synapse pipelines. Please let me know if that is not the correct understanding about your query.

    You can use logic app to create well-formatted custom HTML Email and send the notification via teams connector present in logic app. You can use web activity to call the logic app via ADF/ Synapse pipelines.

    Kindly follow this blogpost to create the logic app : How to send a well-formatted HTML notification , however instead of outlook connector, kindly use teams connector .

    User's image

    To call logic app via web activity, kindly watch out the following video for implementation: How to Send Email from Azure Logic Apps

    Hope it helps. Kindly accept the answer by clicking on Accept answer button. Thankyou

    0 comments