Data Productivity Cloud Pipeline

Author: Matillion
Date Posted: Jun 3, 2024
Last Modified: Nov 29, 2024

Sentiment Analysis with OpenAI GPT 4o

Perform sentiment analysis on your data using OpenAI GPT 4o.

This set of Data Productivity Cloud pipelines performs sentiment analysis on a set of product review data using the OpenAI GPT 4o Large Language Model (LLM).

Image ofSentiment Analysis with OpenAI using GPT 4o — Sentiment Analysis with OpenAI using GPT 4o

How to run the pipelines

Start with Sentiment Analysis - Call OpenAI GPT-4o, as shown in the screenshot above. It does two things:

Runs Sentiment Analysis - Acquire Review Data to create a set of product review data in a database table named stg_sample_reviews
Run the actual sentiment analysis using the LLM, creating a new database table named stg_sample_reviews_gpt_4o

Once it has finished, open Sentiment Analysis - Comparison, as shown in the screenshot below.

Image ofVerifying Sentiment Analysis with OpenAI using GPT 4o — Verifying Sentiment Analysis with OpenAI using GPT 4o

Use Sample Data while the Comparison component is highlighted, to check how the AI-generated sentiment score matches the original numeric star rating of the review.

Downloads

Licensed under: Matillion Free Subscription License

Download Sentiment-Analysis-OpenAI-GPT-4o-Turbo_Databricks.zip
- Target: Databricks
Download Sentiment-Analysis-OpenAI-GPT-4o-Turbo_Redshift.zip
- Target: Redshift
Download Sentiment-Analysis-OpenAI-GPT-4o-Turbo_Snowflake.zip
- Target: Snowflake

Installation Instructions

How to Install a Data Productivity Cloud Pipeline