Playing with Azure Search and Cryptos
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
.vscode
ClientApp
Controllers
Functions
Models
Views
wwwroot
.gitignore
Program.cs
README.md
Startup.cs
appsettings.Development.json
appsettings.json
crypto-search.csproj
npm-shrinkwrap.json
package.json
tsconfig.json
webpack.config.js
webpack.config.vendor.js

README.md

crypto-search

Playing with Azure Search and Cryptos

About

This project is taking advantage of Azure Search and Text Analytics API to analyze crypto currencies trends.

Tweets are being streamed to Event Hub, which triggers Azure Function that calls Text Analytics API to calculate sentiment of tweet. Then tweets and its sentiments are inserted into SQL Database. Azure Search index allows to effectively search through tweets. This index is being syncronized with SQL DB through integrated change tracking, and Azure Search indexer that runs on schedule.

Cognitive Search Architecture

It can be used for any topic analysis. More details in this blog post

Running

Required:

  1. Create SQL DB and table Tweets2 2 Update connection in ConfigureServices method in Startup.cs

  2. Set user and password secrets in cmd:

    • dotnet user-secrets set dbuser <SECRET>
    • dotnet user-secrets set dbpass <SECRET>
  3. Create Azure Search Service and connect to SQL DB using Indexer

  4. Update index, queryKey and service in componentDidMount function in CryptosAzs.tsx

Optional:

  1. Create Azure Event Hub
  2. Create Text Analytics Cognitive Service in Azure Portal.
  3. Create Azure Function (Event Hub trigerred) to call Text Analytics API and insert result into SQL DB. You can check CryptoSentimentEventHubTrigger.csx and CryptosBlobTriggerCSharp.csx functions for reference.
  4. You can use TwitterClientWPF to stream tweets to EventHub.