In this short video, I explain how to call the Azure Cognitive Services – Text Analytics API from SQL Server by using T-SQL and Python in a Stored Procedure. In the demo, I first cover the prerequisite steps and create a view to prep data in JSON format. Then, I use the Sentiment Analysis API to score unstructured text and save the API result(s) for further ML. Sentiment analysis can help you develop applications to reduce churn, improve customer satisfaction, and display customer feedback in real-time. See bonus resources below.
— Hiram Fleitas (@HiramFleitas) August 28, 2019