{"id":985119,"date":"2023-11-16T07:36:50","date_gmt":"2023-11-16T15:36:50","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/research\/?post_type=msr-video&#038;p=985119"},"modified":"2023-11-16T07:42:04","modified_gmt":"2023-11-16T15:42:04","slug":"synapse-espresso-using-openai-gpt-3-in-synapse","status":"publish","type":"msr-video","link":"https:\/\/www.microsoft.com\/en-us\/research\/video\/synapse-espresso-using-openai-gpt-3-in-synapse\/","title":{"rendered":"Synapse Espresso: Using OpenAI GPT-3 in Synapse!"},"content":{"rendered":"<p>Welcome to the 22nd video in our Synapse Espresso series!<\/p>\n<p>In this video, Thomas joins Stijn to show how we can make use of Azure OpenAI GPT-3 from within Spark in Synapse Analytics. GPT-3 is a natural language AI model and it&#8217;s able to understand text that you feed into it and then generate now text based on your input.<\/p>\n<p>For the integration between Synapse and Azure OpenAI, SynapseML is used. This open-source library simplifies the creation of scalable Machine Learning pipelines. One of the features it provides is the ability to send requests to Azure Cognitive Services using APIs. It&#8217;s this feature that allows to easily access Azure OpenAI from Synapse Analytics.<\/p>\n<p>The spark notebook showcases an example of sentiment analysis on restaurant reviews using GPT-3.<\/p>\n<p>The reviews are loaded into a dataframe and the corresponding prompts are written, the SynapseML OpenAICompletion object is defined and finally the prompts are sent to OpenAI for analysis.<\/p>\n<p>Related blog post: <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"https:\/\/techcommunity.microsoft.com\/t5\/azure-synapse-analytics-blog\/using-openai-gpt-in-synapse-analytics\/ba-p\/3751815\">https:\/\/techcommunity.microsoft.com\/t5\/azure-synapse-analytics-blog\/using-openai-gpt-in-synapse-analytics\/ba-p\/3751815<span class=\"sr-only\"> (opens in new tab)<\/span><\/a><br \/>\nSynapseML: <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"https:\/\/microsoft.github.io\/SynapseML\/\">https:\/\/microsoft.github.io\/SynapseML\/<span class=\"sr-only\"> (opens in new tab)<\/span><\/a><br \/>\nWhat is Azure OpenAI? <a class=\"msr-external-link glyph-append glyph-append-open-in-new-tab glyph-append-xsmall\" rel=\"noopener noreferrer\" target=\"_blank\" href=\"https:\/\/learn.microsoft.com\/en-us\/azure\/cognitive-services\/openai\/overview\">https:\/\/learn.microsoft.com\/en-us\/azure\/cognitive-services\/openai\/overview<span class=\"sr-only\"> (opens in new tab)<\/span><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Welcome to the 22nd video in our Synapse Espresso series! In this video, Thomas joins Stijn to show how we can make use of Azure OpenAI GPT-3 from within Spark in Synapse Analytics. GPT-3 is a natural language AI model and it&#8217;s able to understand text that you feed into it and then generate now [&hellip;]<\/p>\n","protected":false},"featured_media":985122,"template":"","meta":{"msr-url-field":"","msr-podcast-episode":"","msrModifiedDate":"","msrModifiedDateEnabled":false,"ep_exclude_from_search":false,"_classifai_error":"","msr_hide_image_in_river":0,"footnotes":""},"research-area":[13556],"msr-video-type":[],"msr-locale":[268875],"msr-post-option":[],"msr-session-type":[],"msr-impact-theme":[],"msr-pillar":[],"msr-episode":[],"msr-research-theme":[],"class_list":["post-985119","msr-video","type-msr-video","status-publish","has-post-thumbnail","hentry","msr-research-area-artificial-intelligence","msr-locale-en_us"],"msr_download_urls":"","msr_external_url":"https:\/\/youtu.be\/Qs6hspyTBz8?si=Wlh7PgGon1_zy5AE","msr_secondary_video_url":"","msr_video_file":"","_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-video\/985119","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-video"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/types\/msr-video"}],"version-history":[{"count":3,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-video\/985119\/revisions"}],"predecessor-version":[{"id":985146,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-video\/985119\/revisions\/985146"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/media\/985122"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/media?parent=985119"}],"wp:term":[{"taxonomy":"msr-research-area","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/research-area?post=985119"},{"taxonomy":"msr-video-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-video-type?post=985119"},{"taxonomy":"msr-locale","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-locale?post=985119"},{"taxonomy":"msr-post-option","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-post-option?post=985119"},{"taxonomy":"msr-session-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-session-type?post=985119"},{"taxonomy":"msr-impact-theme","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-impact-theme?post=985119"},{"taxonomy":"msr-pillar","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-pillar?post=985119"},{"taxonomy":"msr-episode","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-episode?post=985119"},{"taxonomy":"msr-research-theme","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/research\/wp-json\/wp\/v2\/msr-research-theme?post=985119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}