Queries

yaml
type: "io.kestra.plugin.azure.storage.cosmosdb.Queries"

Examples

yaml
id: azure_storage_cosmos_queries
namespace: company.team

tasks:
  - id: cosmos_queries
    type: io.kestra.plugin.azure.storage.cosmosdb.Queries
    endpoint: "https://yourstorageaccount.blob.core.windows.net"
    tenantId: "{{ secret('AZURE_TENANT_ID') }}"
    clientId: "{{ secret('AZURE_CLIENT_ID') }}"
    clientSecret: "{{ secret('AZURE_CLIENT_SECRET') }}"
    queries:
      query-one:
        query: SELECT * FROM c
      query-two:
        query: SELECT * FROM c WHERE c.id = 'test'

Properties

containerId*string

container ID

databaseId*string

databaseId

queries*object

Definitions

io.kestra.plugin.azure.storage.cosmosdb.Queries-QueriesOptions

query*string

query

excludeRegionsarray

SubTypestring

excludeRegions

List of regions to be excluded for the request/retries. Example "East US" or "East US, West US" These regions will be excluded from the preferred regions list. If all the regions are excluded, the request will be sent to the primary region for the account. The primary region is the write region in a single master account and the hub region in a multi-master account.

feedRangePartitionKeyobject

feedRangePartitionKey

partitionKeyobject

partitionKey

partitionKeyDefinition

io.kestra.plugin.azure.storage.cosmosdb.PartitionKeyDefinition

kind*string

Possible Values

HASHRANGEMULTI_HASH

kind

Sets the partition algorithm used to calculate the partition id given a partition key

paths*array

SubTypestring

paths

Sets the item property paths for the partition key.

version*string

Possible Values

V1V2

tenantId*string

Tenant ID

clientIdstring

Client ID

Client ID of the Azure service principal. If you don't have a service principal, refer to create a service principal with Azure CLI.

clientSecretstring

Client Secret

Service principal client secret. The tenantId, clientId and clientSecret of the service principal are required for this credential to acquire an access token.

connectionStringstring

connectionString

consistencyLevelstring

DefaultSession

Possible Values

STRONGBOUNDED_STALENESSSESSIONEVENTUALCONSISTENT_PREFIX

consistencyLevel

Represents the consistency levels supported for Azure Cosmos DB client operations in the Azure Cosmos DB service.

contentResponseOnWriteEnabledbooleanstring

Defaulttrue

contentResponseOnWriteEnabled

Sets the boolean to only return the headers and status code in Cosmos DB response in case of Create, Update and Delete operations on CosmosItem. If set to false (which is by default), service doesn't return payload in the response. It reduces networking and CPU load by not sending the payload back over the network and serializing it on the client.

endpointstring

endpoint

pemCertificatestring

PEM Certificate

text

Your stored PEM certificate.
The tenantId, clientId and clientCertificate of the service principal are required for this credential to acquire an access token.

Outputs

resultsobject

SubTypearray