Overview
Azure Cosmos DB is Microsoft's globally-distributed multi-model NoSQL database. The Automize Cosmos DB connector covers databases, containers (collections), document CRUD, queries, and stored procedures via the Core (SQL) API.
- Regions: Multi-region by default. Each account can span multiple Azure regions with sub-second replication.
- Plans: Pay-per-RU/s (request units) or Serverless. APIs: Core (SQL), MongoDB, Cassandra, Gremlin, Table. Connector targets Core SQL API.
Setting up the connection
Auth type: Bearer Token.
- Azure Portal → Cosmos DB account → Keys → copy Primary Key OR use Entra ID for RBAC.
- For bearer auth, app registration → grant Cosmos DB Data Contributor on the account.
- In Automize → Settings → Connectors → Azure Cosmos DB. Paste endpoint + token.
Find your credentials at https://portal.azure.com/.
Rate limits
RU-based throttling per container. 429 if you exceed provisioned RU/s – connector backs off + retries.
Data model
Hierarchy:
Account ─── Databases ─── Containers ─── Documents ─── Items
└─ Stored Procedures (server-side JS)Available operations
16 operations available. Click any row to jump to its detail.
| Operation | Category | What it does |
|---|---|---|
| Create Collection | General | Create a new collection |
| Create Database | General | Create a new database |
| Create Document | General | Create a new document |
| Delete Collection | General | Delete a collection |
| Delete Database | General | Delete a database |
| Delete Document | General | Delete a document |
| Execute Stored Procedure | General | Execute a stored procedure |
| Get Collection | General | Get collection details |
| Get Database | General | Get database details |
| Get Document | General | Get a document by ID |
| List Collections | General | List collections in a database |
| List Databases | General | List all databases |
| List Documents | General | List documents in a collection |
| List Stored Procedures | General | List stored procedures in a collection |
| Query Documents | General | Query documents using SQL syntax |
| Replace Document | General | Replace an existing document |
Operations
Create Collection
Create a new collection
| Parameter | Required | Type | Description |
|---|---|---|---|
Db Id db_id | Yes | text |
Create Database
Create a new database
| Parameter | Required | Type | Description |
|---|---|---|---|
Id id | No | text |
Create Document
Create a new document
| Parameter | Required | Type | Description |
|---|---|---|---|
Db Id db_id | Yes | text | |
Coll Id coll_id | Yes | text |
Tips
- Auto-generates id if not provided. partition_key required (matches the container's partition path).
Delete Collection
Delete a collection
| Parameter | Required | Type | Description |
|---|---|---|---|
Db Id db_id | Yes | text | |
Coll Id coll_id | Yes | text |
Delete Database
Delete a database
| Parameter | Required | Type | Description |
|---|---|---|---|
Db Id db_id | Yes | text |
Delete Document
Delete a document
| Parameter | Required | Type | Description |
|---|---|---|---|
Db Id db_id | Yes | text | |
Coll Id coll_id | Yes | text | |
Doc Id doc_id | Yes | text |
Tips
- Requires document id + partition_key.
Execute Stored Procedure
Execute a stored procedure
| Parameter | Required | Type | Description |
|---|---|---|---|
Db Id db_id | Yes | text | |
Coll Id coll_id | Yes | text | |
Sproc Id sproc_id | Yes | text |
Get Collection
Get collection details
| Parameter | Required | Type | Description |
|---|---|---|---|
Db Id db_id | Yes | text | |
Coll Id coll_id | Yes | text |
Get Database
Get database details
| Parameter | Required | Type | Description |
|---|---|---|---|
Db Id db_id | Yes | text |
Get Document
Get a document by ID
| Parameter | Required | Type | Description |
|---|---|---|---|
Db Id db_id | Yes | text | |
Coll Id coll_id | Yes | text | |
Doc Id doc_id | Yes | text |
List Collections
List collections in a database
| Parameter | Required | Type | Description |
|---|---|---|---|
Db Id db_id | Yes | text |
List Databases
List all databases
No input parameters.
List Documents
List documents in a collection
| Parameter | Required | Type | Description |
|---|---|---|---|
Db Id db_id | Yes | text | |
Coll Id coll_id | Yes | text |
Tips
- Pages 100 per call. Use continuation token for next.
List Stored Procedures
List stored procedures in a collection
| Parameter | Required | Type | Description |
|---|---|---|---|
Db Id db_id | Yes | text | |
Coll Id coll_id | Yes | text |
Query Documents
Query documents using SQL syntax
| Parameter | Required | Type | Description |
|---|---|---|---|
Db Id db_id | Yes | text | |
Coll Id coll_id | Yes | text |
Replace Document
Replace an existing document
| Parameter | Required | Type | Description |
|---|---|---|---|
Db Id db_id | Yes | text | |
Coll Id coll_id | Yes | text | |
Doc Id doc_id | Yes | text |
FAQ
- Why are my queries slow?
- Cross-partition scans cost more RUs + slower. Always pass partition_key when known. Composite indexes for multi-field queries.
- RU/s provisioning?
- Minimum 400 RU/s per container. Autoscale option scales up to your max. Monitor + tune via Azure Portal.