Azure - Cosmos DB (DATA-FUNDA-03)

Role: Data Engineer of a bike manufacture company

Main Objective: Employ Azure non-relational database and storage, and file-sharing services.

Part 01

Objective: Explore Azure CosmosDB

Setup containers: A Blob container "images" for storing product images; another for storing product quality data.

Setup file shares: All files under the directory "complains" and "manufacturing" can be shared among ones who have the access granted .

Part 02

Objective: Upload existing data about product information, stored in JSON format, and query useful information from the data.

1. Upload successful. (Details skipped)

2. Query: extract the product name, color, list price, ... of all products which has its subcategory as "Mountain Bikes". Do the same thing for "Road Bikes" also.

3. Query: Counts the number of models belong to Touring Bike

Apply another syntax for numeric output:

4. Query: See how many touring bikes are in stock.

Part 03

Objective: Upload product images onto Azure Blob storage, documents onto Azure File Shares.