Send SQL Results to MS Teams Using Python
Step 1: Open teams and go to create new team page Step 2: Click on Join or Create a team Step 3: Click on create a team and select build a team from scratch Step 4: Select kind of team Step 5: Provide team name as shown in bellow Click on create Step 6: Add member if required Step 7: Click on 3 dots (...) and select connectors as shown in bellow Step 8: Select Incoming Webhook and configured as shown in bellow Setup incoming webhook name as shown and click on create Copy webhook url and put into mentioned python script Step 9: Python script import pymsteams import pandas as pd import numpy as np import pyodbc server = 'ServerName' database = 'msdb' username = 'LoginName' password = 'Password' cnxn = pyodbc.connect( 'DRIVER={ODBC Driver 17 for SQL Server};SERVER=' +server+ ';DATABASE=' +database+ ';UID=' +username+ ';PWD=' + password) cursor = cnxn.cursor() query = "select top 10 [name],[type_desc],create_date from msd...