GraphtyLove/azure_cosmosDB_python

Code to interact with Azure CosmosDB python SDK. Becode Accenture Project.

Azure CosmosDB

In this repo, you will find code to interact in python with Azure CosmosDB.

Why?

It has been created for the purpose of a Use-Case project in a BeCode AI class. (Bouman4)

Provide read access to learners

To provide a read-only access to the learners you can give them the credentials that are stored in:

Azure -> CosmosDB -> <Your Cosmos instance> -> Keys -> Read-Only Keys.

The PRIMARY READ-ONLY CONNECTION STRING should be enough, but you can also provide the URI and the PRIMARY READ-ONLY KEY.

Installation

In order for the project to run, you need to:

Install python 3.9.2

Install the requirements with:

pip install -r requirements.txt

Then you need to create a .env file at the root of the project and add the following keys:

DB_NAME=<YOUR DB NAME> # You need to create this one in: `Azure` -> `CosmosDB` -> <your Cosmos Instance> -> `Create`
DB_URL=<YOUR DATABSE URL> # See Azure portal: `Azure` -> `CosmosDB` -> <your Cosmos Instance> -> `Keys` -> `URI`
DB_SECRET=<YOUR PRIMARY KEY> # See Azure portal: `Azure` -> `CosmosDB` -> <your Cosmos Instance> -> `Keys`-> `PRIMARY KEY`

Files

Data

The data are divided in 6 .csv files:

• ODL_ALLERGY.csv
• ODL_ALLERGY_CUSTOMER.csv
• ODL_ORDER.csv
• ODL_ORDER_ITEM.csv
• ODL_ORDERABLES.csv
• ODL_RESTAURANT.csv

Import data

In import_data.py you will find the code used to import the data (.csv format) in CosmosDB.

Read Database

In read_database.py you will find the code used to read a table from the databse in CosmosDB.

Resources

To write this code I used some resources:

• This article but it seams outdated. I used to for the global logic but the code wasn't working with the latest Azure-Cosmos python SDK. I had to look into the Microsoft documentation to correct it.
• The Azure-Cosmos official documentation. Which is really great!
• How to query CosmosDB in python using SQL

Who?

Written by Maxim Berge the 14/03/2022.