- Open MySQL Workbench
- Connect to your instance of MySQL
- Create a new user
yelp_etl
, with same password as root. Give this user DBA permissions. Follow instructions
- Download the dataset from Yelp
- Copy the following files into '/YelpDataChallenge/data`
- yelp_academic_dataset_business.json
- yelp_academic_dataset_checkin.json
- yelp_academic_dataset_review.json
- yelp_academic_dataset_tip.json
- yelp_academic_dataset_user.json
- Using Windows Command Prompt, navigate to
YelpDataChallenge
- Run the following commands in this order:
dotnet restore
dotnet build
dotnet run
This step should take a while...