Azure Cosmos DB
An Azure NoSQL database service for app development.
1,513 questions
Cosmos DB copy in ADF comes from two regions instead of one region
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 78%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Salomon Henriquez
106
Reputation points Microsoft Employee
I have one ADF instance in West US region and I have a Cosmos DB in East US.
When running a copy activity in ADF from Cosmos to Azure SQL, I see the copy comes from East US and West US regions. The copy should come just from East US.
Could this beavior be caused beuase of the location of the ADF?
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 48%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Harishga 5,420 Reputation points Microsoft Vendor2024-06-26T04:52:25.71+00:00 Hi @Salomon Henriquez
Welcome to Microsoft Q&A platform and thanks for posting your question here.When you run a copy activity in Azure Data Factory from Cosmos DB to Azure SQL, you expect the data to move only within the East US region. However, if you’re seeing the activity also in the West US region, it’s likely because of how the Integration Runtime is set up. The IR is what moves the data, and it can use resources from different regions.
If your IR isn’t specifically set to use the East US, it automatically uses resources from both the East and West US. This can happen even if your data stores are in just one region. Also, your network setup, like your Azure Virtual Network, can change the path of the data movement. Plus, if you’re using a self-hosted IR, it needs to be able to reach both the source (Cosmos DB) and the destination (Azure SQL).
To fix this, you should check your IR settings in ADF. Make sure it’s set to use resources mostly in the East US. This way, you can avoid moving data across regions.
I hope this information helps you. Let me know if you have any further questions or concerns.
-
Harishga 5,420 Reputation points Microsoft Vendor
2024-06-27T08:03:23.4633333+00:00 Hi @Salomon Henriquez
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help. -
Harishga 5,420 Reputation points Microsoft Vendor
2024-06-27T09:08:27.6333333+00:00 @Salomon Henriquez
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment