Dnirmania


Powershell Script - Azure cosmos DB(SQL API)

Scripts contains 4 following functions. Users can create 3 different script from this for inserting, fetching and deleting a document.
1. Function Generate-MasterKeyAuthorizationSignature - This function is used to create connection to Azure cosmos DB. This function codes were taken from Technet.
2. Function Post-CosmosDb - Insert single document in azure cosmos DB. Same function can be used to perform bulkinsert. This function code was taken from following article. To make it useful i made some modification in it.
(https://www.systemcenterautomation.com/2018/06/cosmos-db-rest-api-powershell/)
3. Function Get-CosmosDocument - Fetch single document from azure cosmos DB. Same function can be used to fetch all documents from Cosmos DB.
4. Function Delete-CosmosDbDocument - Delete single document from cosmos DB. Same function can be used to delete more than one document with some additional codes.

To use any of the function like Post,Get, Delete. you have to comment the other 2 function call. If you are using all 3 functions(Post,Get, Delete), Be cautious while using them.

2020-05-11 (first published: )

1,054 reads

Blogs

Snowflake in Azure

By

Being aligned to a global cloud like Microsoft Azure you have choices. Whether that...

Regression Testing SQL Saturday Naming

By

I started a poll today on the naming for future SQL Saturdays. You can...

Daily Coping 9 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Mercado Español de Muebles de Lujo

By IreneGarcia8285

Informes de Expertos (IDE) latest report, titled “Mercado Español de Muebles de Lujo, Informe...

Mercado Latinoamericano de los Medicamentos Oncológicos Genéricos

By IreneGarcia8285

Informes de Expertos (IDE) latest report, titled “Mercado Latinoamericano de los Medicamentos Oncológicos Genéricos,...

Kick starting Extended Events

By VoldemarG

We have no prior experience of using XE. Yes, our DBA group uses server...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers