Since we didn't previously save the tweet scores at all, we will need to create a new SQL table.
Let's explore the following steps to create the TweetTextScore table:
- Open the Visual Studio SQL Server Explorer and connect to the TextScoreDB database (alternatively, browse to Azure Portal and then navigate to SQL Databases -> TextScoreDB ->Tools -> Query Editor).
- In the new query window, run the following code to create the TweetTextScore table that will store the tweet text and it's score:
CREATE TABLE TweetTextScore ( ID INT IDENTITY(1,1) PRIMARY KEY, [Date] DATETIME NOT NULL DEFAULT GETUTCDATE(), Username VARCHAR(255) NOT NULL, TweetText VARCHAR(255) NOT NULL, TextSentimentScore FLOAT NOT NULL );