Azure Cosmos DB

Read records from database collections stored in Azure Cosmos DB and perform analysis in ArcGIS Velocity.

Example

  • A researcher wants to load data from a database collection stored in Azure Cosmos DB to perform analysis in Velocity.

Usage notes

  • Your master key will be encrypted the first time you save your analytic and stored in an encrypted state.
  • A where clause can be optionally specified to restrict the records loaded from the Azure Cosmos DB container collection.

Parameters

ParameterExplanationData Type

Endpoint

Endpoint URL for the Azure Cosmos DB.

For example: https://yourCosmosDBAccountName.documents.azure.com:443/

String

Master key

The primary key for the Azure Cosmos DB.

String

Database

The name of the Azure Cosmos DB container that contains the collection of data to read.

String

Collection

The name of the Azure Cosmos DB collection within the specified container that has the desired data.

String

Where clause (optional)

Optionally specify a where clause to restrict the features loaded from the Azure Cosmos DB container collection.

Note that a simple query format should be utilized. For example, if you had a numeric field in your dataset called course, you could specify a where clause of course = 49.5845184. If you had a string field in your dataset called user_id, you could specify a where clause of user_id = 'pete1234'.

In the Azure Cosmos DB interface, these queries would look like SELECT * FROM c WHERE c.user_id = 'pete1234', however you would only need to specify user_id = 'pete1234' for this parameter in Velocity.

When querying string fields, make sure to use a single quote around text that is part of the query. For example, road_type = 'asphalt'.

String

Considerations and limitations

  • When specifying a where clause to filter string values, wrap text values in single quotes.
  • When specifying date fields, only the following configurations are supported for this data source:
    • Epoch milliseconds
    • String dates in the format (milliseconds are optional): yyyy-MM-dd HH:mm:ss[.fffffffff]