Hello,
I am just checking to clarify if you are actually speaking about Cosmos DB or not. Cosmos DB isn't typically utilized for traditional structured table-to-table calls. Instead, it usually should be handling semi-structured or unstructured data.
However, if you're looking to merge data from different collections within Cosmos DB, you can certainly achieve that with your preferred programming language. Here's a Python script demonstrating how to do it:
Code generated by ChatGPT:
from azure.cosmos import CosmosClient
# Initialize Cosmos DB client
endpoint = "your_cosmosdb_endpoint_uri"
key = "your_cosmosdb_primary_key"
client = CosmosClient(endpoint, key)
# Get database and containers
database_id = 'your_database_id'
container1_id = 'collection1_id'
container2_id = 'collection2_id'
database = client.get_database_client(database_id)
container1 = database.get_container_client(container1_id)
container2 = database.get_container_client(container2_id)
# Define SQL queries
query1 = 'SELECT * FROM c'
query2 = 'SELECT * FROM c'
# Query data from containers
items1 = list(container1.query_items(query1, enable_cross_partition_query=True))
items2 = list(container2.query_items(query2, enable_cross_partition_query=True))
# Merge results
merged_items = items1 + items2
# Display merged items
for item in merged_items:
print(item)
If this is helpful please accept answer.