Microsoft.Kusto clusters/databases 2023-08-15

Bicep resource definition

The clusters/databases resource type can be deployed with operations that target:

For a list of changed properties in each API version, see change log.

Resource format

To create a Microsoft.Kusto/clusters/databases resource, add the following Bicep to your template.

resource symbolicname 'Microsoft.Kusto/clusters/databases@2023-08-15' = {
  location: 'string'
  name: 'string'
  kind: 'string'
  // For remaining properties, see Microsoft.Kusto/clusters/databases objects
}

Microsoft.Kusto/clusters/databases objects

Set the kind property to specify the type of object.

For ReadOnlyFollowing, use:

{
  kind: 'ReadOnlyFollowing'
  properties: {
    hotCachePeriod: 'string'
  }
}

For ReadWrite, use:

{
  kind: 'ReadWrite'
  properties: {
    hotCachePeriod: 'string'
    keyVaultProperties: {
      keyName: 'string'
      keyVaultUri: 'string'
      keyVersion: 'string'
      userIdentity: 'string'
    }
    softDeletePeriod: 'string'
  }
}

Property values

KeyVaultProperties

Name Description Value
keyName The name of the key vault key. string
keyVaultUri The Uri of the key vault. string
keyVersion The version of the key vault key. string
userIdentity The user assigned identity (ARM resource id) that has access to the key. string

Microsoft.Kusto/clusters/databases

Name Description Value
kind Set to 'ReadOnlyFollowing' for type ReadOnlyFollowingDatabase. Set to 'ReadWrite' for type ReadWriteDatabase. 'ReadOnlyFollowing'
'ReadWrite' (required)
location Resource location. string
name The resource name string

Constraints:
Pattern = ^.*$ (required)
parent In Bicep, you can specify the parent resource for a child resource. You only need to add this property when the child resource is declared outside of the parent resource.

For more information, see Child resource outside parent resource.
Symbolic name for resource of type: clusters

ReadOnlyFollowingDatabase

Name Description Value
kind Kind of the database 'ReadOnlyFollowing' (required)
properties The database properties. ReadOnlyFollowingDatabaseProperties

ReadOnlyFollowingDatabaseProperties

Name Description Value
hotCachePeriod The time the data should be kept in cache for fast queries in TimeSpan. string

ReadWriteDatabase

Name Description Value
kind Kind of the database 'ReadWrite' (required)
properties The database properties. ReadWriteDatabaseProperties

ReadWriteDatabaseProperties

Name Description Value
hotCachePeriod The time the data should be kept in cache for fast queries in TimeSpan. string
keyVaultProperties KeyVault properties for the database encryption. KeyVaultProperties
softDeletePeriod The time the data should be kept before it stops being accessible to queries in TimeSpan. string

Quickstart samples

The following quickstart samples deploy this resource type.

Bicep File Description
Azure Digital Twins with Time Data History Connection This template creates an Azure Digital Twins instance configured with a time series data history connection. In order to create a connection, other resources must be created such as an Event Hubs namespace, an event hub, Azure Data Explorer cluster, and a database. Data is sent to an event hub which eventually forwards the data to the Azure Data Explorer cluster. Data is stored in a database table in the cluster
Create a database watcher This sample creates a database watcher for Azure SQL and configures its data store, SQL targets, and managed private endpoints
Deploy Azure Data Explorer DB with Cosmos DB connection Deploy Azure Data Explorer DB with Cosmos DB connection.
Deploy Azure Data Explorer db with Event Grid connection Deploy Azure Data Explorer db with Event Grid connection.
Deploy Azure Data Explorer db with Event Hub connection Deploy Azure Data Explorer db with Event Hub connection.

ARM template resource definition

The clusters/databases resource type can be deployed with operations that target:

For a list of changed properties in each API version, see change log.

Resource format

To create a Microsoft.Kusto/clusters/databases resource, add the following JSON to your template.

{
  "location": "string",
  "name": "string",
  "kind": "string"
  // For remaining properties, see Microsoft.Kusto/clusters/databases objects
}

Microsoft.Kusto/clusters/databases objects

Set the kind property to specify the type of object.

For ReadOnlyFollowing, use:

{
  "kind": "ReadOnlyFollowing",
  "properties": {
    "hotCachePeriod": "string"
  }
}

For ReadWrite, use:

{
  "kind": "ReadWrite",
  "properties": {
    "hotCachePeriod": "string",
    "keyVaultProperties": {
      "keyName": "string",
      "keyVaultUri": "string",
      "keyVersion": "string",
      "userIdentity": "string"
    },
    "softDeletePeriod": "string"
  }
}

Property values

KeyVaultProperties

Name Description Value
keyName The name of the key vault key. string
keyVaultUri The Uri of the key vault. string
keyVersion The version of the key vault key. string
userIdentity The user assigned identity (ARM resource id) that has access to the key. string

Microsoft.Kusto/clusters/databases

Name Description Value
apiVersion The api version '2023-08-15'
kind Set to 'ReadOnlyFollowing' for type ReadOnlyFollowingDatabase. Set to 'ReadWrite' for type ReadWriteDatabase. 'ReadOnlyFollowing'
'ReadWrite' (required)
location Resource location. string
name The resource name string

Constraints:
Pattern = ^.*$ (required)
type The resource type 'Microsoft.Kusto/clusters/databases'

ReadOnlyFollowingDatabase

Name Description Value
kind Kind of the database 'ReadOnlyFollowing' (required)
properties The database properties. ReadOnlyFollowingDatabaseProperties

ReadOnlyFollowingDatabaseProperties

Name Description Value
hotCachePeriod The time the data should be kept in cache for fast queries in TimeSpan. string

ReadWriteDatabase

Name Description Value
kind Kind of the database 'ReadWrite' (required)
properties The database properties. ReadWriteDatabaseProperties

ReadWriteDatabaseProperties

Name Description Value
hotCachePeriod The time the data should be kept in cache for fast queries in TimeSpan. string
keyVaultProperties KeyVault properties for the database encryption. KeyVaultProperties
softDeletePeriod The time the data should be kept before it stops being accessible to queries in TimeSpan. string

Quickstart templates

The following quickstart templates deploy this resource type.

Template Description
Azure Digital Twins with Time Data History Connection

Deploy to Azure
This template creates an Azure Digital Twins instance configured with a time series data history connection. In order to create a connection, other resources must be created such as an Event Hubs namespace, an event hub, Azure Data Explorer cluster, and a database. Data is sent to an event hub which eventually forwards the data to the Azure Data Explorer cluster. Data is stored in a database table in the cluster
Create a cluster a database

Deploy to Azure
This template allows you to create a cluster and a database.
Create a database watcher

Deploy to Azure
This sample creates a database watcher for Azure SQL and configures its data store, SQL targets, and managed private endpoints
Deploy Azure Data Explorer DB with Cosmos DB connection

Deploy to Azure
Deploy Azure Data Explorer DB with Cosmos DB connection.
Deploy Azure Data Explorer db with Event Grid connection

Deploy to Azure
Deploy Azure Data Explorer db with Event Grid connection.
Deploy Azure Data Explorer db with Event Hub connection

Deploy to Azure
Deploy Azure Data Explorer db with Event Hub connection.

Terraform (AzAPI provider) resource definition

The clusters/databases resource type can be deployed with operations that target:

  • Resource groups

For a list of changed properties in each API version, see change log.

Resource format

To create a Microsoft.Kusto/clusters/databases resource, add the following Terraform to your template.

resource "azapi_resource" "symbolicname" {
  location = "string"
  name = "string"
  kind = "string"
  // For remaining properties, see Microsoft.Kusto/clusters/databases objects
}

Microsoft.Kusto/clusters/databases objects

Set the kind property to specify the type of object.

For ReadOnlyFollowing, use:

{
  kind = "ReadOnlyFollowing"
  properties = {
    hotCachePeriod = "string"
  }
}

For ReadWrite, use:

{
  kind = "ReadWrite"
  properties = {
    hotCachePeriod = "string"
    keyVaultProperties = {
      keyName = "string"
      keyVaultUri = "string"
      keyVersion = "string"
      userIdentity = "string"
    }
    softDeletePeriod = "string"
  }
}

Property values

KeyVaultProperties

Name Description Value
keyName The name of the key vault key. string
keyVaultUri The Uri of the key vault. string
keyVersion The version of the key vault key. string
userIdentity The user assigned identity (ARM resource id) that has access to the key. string

Microsoft.Kusto/clusters/databases

Name Description Value
kind Set to 'ReadOnlyFollowing' for type ReadOnlyFollowingDatabase. Set to 'ReadWrite' for type ReadWriteDatabase. 'ReadOnlyFollowing'
'ReadWrite' (required)
location Resource location. string
name The resource name string

Constraints:
Pattern = ^.*$ (required)
parent_id The ID of the resource that is the parent for this resource. ID for resource of type: clusters
type The resource type "Microsoft.Kusto/clusters/databases@2023-08-15"

ReadOnlyFollowingDatabase

Name Description Value
kind Kind of the database 'ReadOnlyFollowing' (required)
properties The database properties. ReadOnlyFollowingDatabaseProperties

ReadOnlyFollowingDatabaseProperties

Name Description Value
hotCachePeriod The time the data should be kept in cache for fast queries in TimeSpan. string

ReadWriteDatabase

Name Description Value
kind Kind of the database 'ReadWrite' (required)
properties The database properties. ReadWriteDatabaseProperties

ReadWriteDatabaseProperties

Name Description Value
hotCachePeriod The time the data should be kept in cache for fast queries in TimeSpan. string
keyVaultProperties KeyVault properties for the database encryption. KeyVaultProperties
softDeletePeriod The time the data should be kept before it stops being accessible to queries in TimeSpan. string