#25. Azure Data Factory - Copy records to COSMOS database

Azure Cosmos DB is a globally distributed, multi-model, noSQL database. This video explains the steps to create a Cosmos account, a table and then we explain how to load data to the cosmos table. We also see the way we can query the cosmos table by writing a SQL based query.

[@umamaheswarc8227]

Explanation is clear and nice. Thank you

[@AllAboutBI]

Glad it was helpful! :-)

[@vidyab6025]

You are doing such an amazing job. Every sessions are very useful for beginners. I found it's quite easy to understand ADF after watching your videos. Keep it up!!

[@kirubababu7127]

Thank you Mam

[@namangupta7111]

Mam , You are doing a tremendous job , Thanks for all the video.
I'm pretty sure , Soon you will reach a good no subscriber and likes :) :)

[@AllAboutBI]

Thanks so much Naman 🙏

[@villagevinodam277]

Good one mam

[@AllAboutBI]

Thank you

[@tsentertainments4710]

Good information

[@Rafian1924]

Awesome mam.

[@RaviRaj-ok3fu]

hello mam, Mostly we write data into cosmos, it will has lot of nested column structure so how will you address his.

[@sureshareti2843]

Please do all videos for Azure data factory

[@AllAboutBI]

Sure

[@sureshareti2843]

@@AllAboutBI tq

[@manasamanchala-bw4lr]

Hi Mam!
How do we do the same copy activity from SQL Graph DB to Azure Cosmos DB using Gremlin API?
Do you have any video related to it?

[@sureshareti2843]

Nice Madam

[@user-jn3ju8er6n]

What is COSOMS Scope Script?
Where should we use the COSMOS Scope Script?

[@chinmaykshah]

Hello Mam, can you guide or prepare video SQL to cosmos migration , also how to combined multiple sql columns into json then send to cosmos or azure search index?

[@sujanbhattacharya6029]

I need to load large json file (size > 16 MB) from blob to cosmosdb. Can you provide some guidance how to achieve that?

[@shanthikrishnan8606]

Hi, how can we compare the source SQL and target COSMOS

[@shyamg7371]

hello mam , I tried same method in Azure mongoDb api with Data Factory with blob storage but while querying in cosmoDb i got an error has
JSON reader was expecting a value but found 'db'.
How to resolve this error ?Do you have any idea about that mam

[@mandlaanilbabu]

Thank you mam, here copying one table for suppose i want copy the multiple tables what is the procedure?

[@AllAboutBI]

check out video #62 ?

[@saran0446]

how to do Upsert Operation based a KeyColumn ?

[@shyampasunoori3581]

Hi i am getting cross partition error while taking max(_ts) value

[@Chuukwudi]

Do you have 1114 as part of your password?

[@ramanareddy7789]

Can u gudie me how can we from ADLS to CosmosDB

[@abhishekkumar-es1wl]

Hi ma'am, When I am trying to copy heavy data from Cosmos DB from 1 db to another then it's failing after 300000 records. Also taking lot of time. Any idea how to resolve the issue?