Data Connections - Get

Returns a data connection.

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Kusto/clusters/{clusterName}/databases/{databaseName}/dataConnections/{dataConnectionName}?api-version=2023-08-15

URI Parameters

Name In Required Type Description
clusterName
path True

string

The name of the Kusto cluster.

Regex pattern: ^.*$

databaseName
path True

string

The name of the database in the Kusto cluster.

Regex pattern: ^.*$

dataConnectionName
path True

string

The name of the data connection.

Regex pattern: ^.*$

resourceGroupName
path True

string

The name of the resource group. The name is case insensitive.

subscriptionId
path True

string

The ID of the target subscription.

api-version
query True

string

The API version to use for this operation.

Responses

Name Type Description
200 OK DataConnection:

Successfully retrieved the specified data connection.

Other Status Codes

ErrorResponse

Error response describing why the operation failed.

Examples

KustoDataConnectionsCosmosDbGet
KustoDataConnectionsEventGridGet
KustoDataConnectionsGet

KustoDataConnectionsCosmosDbGet

Sample Request

GET https://management.azure.com/subscriptions/12345678-1234-1234-1234-123456789098/resourceGroups/kustorptest/providers/Microsoft.Kusto/clusters/kustoCluster/databases/KustoDatabase1/dataConnections/dataConnectionTest?api-version=2023-08-15

Sample Response

{
  "id": "/subscriptions/12345678-1234-1234-1234-123456789098/resourceGroups/kustorptest/providers/Microsoft.Kusto/Clusters/kustoCluster/Databases/KustoDatabase1/DataConnections/KustoDataConnection1",
  "name": "kustoCluster/KustoDatabase1/KustoDataConnection1",
  "type": "Microsoft.Kusto/Clusters/Databases/DataConnections",
  "location": "westus",
  "kind": "CosmosDb",
  "properties": {
    "tableName": "TestTable",
    "mappingRuleName": "TestMapping",
    "managedIdentityResourceId": "/subscriptions/12345678-1234-1234-1234-123456789098/resourceGroups/kustorptest/providers/Microsoft.ManagedIdentity/userAssignedIdentities/managedidentityTest1",
    "managedIdentityObjectId": "87654321-1234-1234-1234-123456789123",
    "cosmosDbAccountResourceId": "/subscriptions/12345678-1234-1234-1234-123456789098/resourceGroups/kustorptest/providers/Microsoft.DocumentDb/databaseAccounts/cosmosDbAccountTest1",
    "cosmosDbDatabase": "cosmosDbDatabaseTest",
    "cosmosDbContainer": "cosmosDbContainerTest",
    "retrievalStartDate": "2022-07-29T12:00:00.6554616Z",
    "provisioningState": "Succeeded"
  }
}

KustoDataConnectionsEventGridGet

Sample Request

GET https://management.azure.com/subscriptions/12345678-1234-1234-1234-123456789098/resourceGroups/kustorptest/providers/Microsoft.Kusto/clusters/kustoCluster/databases/KustoDatabase8/dataConnections/dataConnectionTest?api-version=2023-08-15

Sample Response

{
  "id": "/subscriptions/12345678-1234-1234-1234-123456789098/resourceGroups/kustorptest/providers/Microsoft.Kusto/Clusters/kustoCluster/Databases/KustoDatabase8/DataConnections/KustoDataConnection9",
  "name": "kustoCluster/KustoDatabase8/dataConnectionTest",
  "type": "Microsoft.Kusto/Clusters/Databases/DataConnections",
  "location": "westus",
  "kind": "EventGrid",
  "properties": {
    "ignoreFirstRecord": false,
    "storageAccountResourceId": "/subscriptions/12345678-1234-1234-1234-123456789098/resourceGroups/kustorptest/providers/Microsoft.Storage/storageAccounts/teststorageaccount",
    "eventGridResourceId": "/subscriptions/12345678-1234-1234-1234-123456789098/resourceGroups/kustorptest/providers/Microsoft.Storage/storageAccounts/teststorageaccount/providers/Microsoft.EventGrid/eventSubscriptions/eventSubscriptionTest",
    "eventHubResourceId": "/subscriptions/12345678-1234-1234-1234-123456789098/resourceGroups/kustorptest/providers/Microsoft.EventHub/namespaces/eventhubTestns1/eventhubs/eventhubTest2",
    "consumerGroup": "$Default",
    "tableName": "TestTable",
    "mappingRuleName": "TestMapping",
    "dataFormat": "JSON",
    "blobStorageEventType": "Microsoft.Storage.BlobCreated",
    "managedIdentityResourceId": "/subscriptions/12345678-1234-1234-1234-123456789098/resourceGroups/kustorptest/providers/Microsoft.ManagedIdentity/userAssignedIdentities/managedidentityTest1",
    "managedIdentityObjectId": "87654321-1234-1234-1234-123456789123",
    "databaseRouting": "Single",
    "provisioningState": "Succeeded"
  }
}

KustoDataConnectionsGet

Sample Request

GET https://management.azure.com/subscriptions/12345678-1234-1234-1234-123456789098/resourceGroups/kustorptest/providers/Microsoft.Kusto/clusters/kustoCluster/databases/KustoDatabase8/dataConnections/dataConnectionTest?api-version=2023-08-15

Sample Response

{
  "id": "/subscriptions/12345678-1234-1234-1234-123456789098/resourceGroups/kustorptest/providers/Microsoft.Kusto/Clusters/kustoCluster/Databases/KustoDatabase8/DataConnections/dataConnectionTest",
  "name": "kustoCluster/KustoDatabase8/dataConnectionTest",
  "type": "Microsoft.Kusto/Clusters/Databases/DataConnections",
  "location": "westus",
  "kind": "EventHub",
  "properties": {
    "eventHubResourceId": "/subscriptions/12345678-1234-1234-1234-123456789098/resourceGroups/kustorptest/providers/Microsoft.EventHub/namespaces/eventhubTestns1/eventhubs/eventhubTest1",
    "consumerGroup": "$Default",
    "tableName": "TestTable",
    "mappingRuleName": "TestMapping",
    "dataFormat": "JSON",
    "eventSystemProperties": [],
    "compression": "None",
    "managedIdentityResourceId": "/subscriptions/12345678-1234-1234-1234-123456789098/resourceGroups/kustorptest/providers/Microsoft.ManagedIdentity/userAssignedIdentities/managedidentityTest1",
    "managedIdentityObjectId": "87654321-1234-1234-1234-123456789123",
    "databaseRouting": "Single",
    "retrievalStartDate": "2022-07-29T12:00:00.6554616Z",
    "provisioningState": "Succeeded"
  }
}

Definitions

Name Description
blobStorageEventType

The name of blob storage event type to process.

compression

The event hub messages compression type

CosmosDbDataConnection

Class representing a CosmosDb data connection.

DatabaseRouting

Indication for database routing information from the data connection, by default only database routing information is allowed

ErrorAdditionalInfo

The resource management error additional info.

ErrorDetail

The error detail.

ErrorResponse

Error response

EventGridDataConnection

Class representing an Event Grid data connection.

eventGridDataFormat

The data format of the message. Optionally the data format can be added to each message.

EventHubDataConnection

Class representing an event hub data connection.

eventHubDataFormat

The data format of the message. Optionally the data format can be added to each message.

IotHubDataConnection

Class representing an iot hub data connection.

iotHubDataFormat

The data format of the message. Optionally the data format can be added to each message.

ProvisioningState

The provisioned state of the resource.

blobStorageEventType

The name of blob storage event type to process.

Name Type Description
Microsoft.Storage.BlobCreated

string

Microsoft.Storage.BlobRenamed

string

compression

The event hub messages compression type

Name Type Description
GZip

string

None

string

CosmosDbDataConnection

Class representing a CosmosDb data connection.

Name Type Description
id

string

Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}

kind string:

CosmosDb

Kind of the endpoint for the data connection

location

string

Resource location.

name

string

The name of the resource

properties.cosmosDbAccountResourceId

string

The resource ID of the Cosmos DB account used to create the data connection.

properties.cosmosDbContainer

string

The name of an existing container in the Cosmos DB database.

properties.cosmosDbDatabase

string

The name of an existing database in the Cosmos DB account.

properties.managedIdentityObjectId

string

The object ID of the managed identity resource.

properties.managedIdentityResourceId

string

The resource ID of a managed system or user-assigned identity. The identity is used to authenticate with Cosmos DB.

properties.mappingRuleName

string

The name of an existing mapping rule to use when ingesting the retrieved data.

properties.provisioningState

ProvisioningState

The provisioned state of the resource.

properties.retrievalStartDate

string

Optional. If defined, the data connection retrieves Cosmos DB documents created or updated after the specified retrieval start date.

properties.tableName

string

The case-sensitive name of the existing target table in your cluster. Retrieved data is ingested into this table.

type

string

The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

DatabaseRouting

Indication for database routing information from the data connection, by default only database routing information is allowed

Name Type Description
Multi

string

Single

string

ErrorAdditionalInfo

The resource management error additional info.

Name Type Description
info

object

The additional info.

type

string

The additional info type.

ErrorDetail

The error detail.

Name Type Description
additionalInfo

ErrorAdditionalInfo[]

The error additional info.

code

string

The error code.

details

ErrorDetail[]

The error details.

message

string

The error message.

target

string

The error target.

ErrorResponse

Error response

Name Type Description
error

ErrorDetail

The error object.

EventGridDataConnection

Class representing an Event Grid data connection.

Name Type Default Value Description
id

string

Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}

kind string:

EventGrid

Kind of the endpoint for the data connection

location

string

Resource location.

name

string

The name of the resource

properties.blobStorageEventType

blobStorageEventType

The name of blob storage event type to process.

properties.consumerGroup

string

The event hub consumer group.

properties.dataFormat

eventGridDataFormat

The data format of the message. Optionally the data format can be added to each message.

properties.databaseRouting

DatabaseRouting

Single

Indication for database routing information from the data connection, by default only database routing information is allowed

properties.eventGridResourceId

string

The resource ID of the event grid that is subscribed to the storage account events.

properties.eventHubResourceId

string

The resource ID where the event grid is configured to send events.

properties.ignoreFirstRecord

boolean

A Boolean value that, if set to true, indicates that ingestion should ignore the first record of every file

properties.managedIdentityObjectId

string

The object ID of managedIdentityResourceId

properties.managedIdentityResourceId

string

The resource ID of a managed identity (system or user assigned) to be used to authenticate with event hub and storage account.

properties.mappingRuleName

string

The mapping rule to be used to ingest the data. Optionally the mapping information can be added to each message.

properties.provisioningState

ProvisioningState

The provisioned state of the resource.

properties.storageAccountResourceId

string

The resource ID of the storage account where the data resides.

properties.tableName

string

The table where the data should be ingested. Optionally the table information can be added to each message.

type

string

The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

eventGridDataFormat

The data format of the message. Optionally the data format can be added to each message.

Name Type Description
APACHEAVRO

string

AVRO

string

CSV

string

JSON

string

MULTIJSON

string

ORC

string

PARQUET

string

PSV

string

RAW

string

SCSV

string

SINGLEJSON

string

SOHSV

string

TSV

string

TSVE

string

TXT

string

W3CLOGFILE

string

EventHubDataConnection

Class representing an event hub data connection.

Name Type Default Value Description
id

string

Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}

kind string:

EventHub

Kind of the endpoint for the data connection

location

string

Resource location.

name

string

The name of the resource

properties.compression

compression

None

The event hub messages compression type

properties.consumerGroup

string

The event hub consumer group.

properties.dataFormat

eventHubDataFormat

The data format of the message. Optionally the data format can be added to each message.

properties.databaseRouting

DatabaseRouting

Single

Indication for database routing information from the data connection, by default only database routing information is allowed

properties.eventHubResourceId

string

The resource ID of the event hub to be used to create a data connection.

properties.eventSystemProperties

string[]

System properties of the event hub

properties.managedIdentityObjectId

string

The object ID of the managedIdentityResourceId

properties.managedIdentityResourceId

string

The resource ID of a managed identity (system or user assigned) to be used to authenticate with event hub.

properties.mappingRuleName

string

The mapping rule to be used to ingest the data. Optionally the mapping information can be added to each message.

properties.provisioningState

ProvisioningState

The provisioned state of the resource.

properties.retrievalStartDate

string

When defined, the data connection retrieves existing Event hub events created since the Retrieval start date. It can only retrieve events retained by the Event hub, based on its retention period.

properties.tableName

string

The table where the data should be ingested. Optionally the table information can be added to each message.

type

string

The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

eventHubDataFormat

The data format of the message. Optionally the data format can be added to each message.

Name Type Description
APACHEAVRO

string

AVRO

string

CSV

string

JSON

string

MULTIJSON

string

ORC

string

PARQUET

string

PSV

string

RAW

string

SCSV

string

SINGLEJSON

string

SOHSV

string

TSV

string

TSVE

string

TXT

string

W3CLOGFILE

string

IotHubDataConnection

Class representing an iot hub data connection.

Name Type Default Value Description
id

string

Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}

kind string:

IotHub

Kind of the endpoint for the data connection

location

string

Resource location.

name

string

The name of the resource

properties.consumerGroup

string

The iot hub consumer group.

properties.dataFormat

iotHubDataFormat

The data format of the message. Optionally the data format can be added to each message.

properties.databaseRouting

DatabaseRouting

Single

Indication for database routing information from the data connection, by default only database routing information is allowed

properties.eventSystemProperties

string[]

System properties of the iot hub

properties.iotHubResourceId

string

The resource ID of the Iot hub to be used to create a data connection.

properties.mappingRuleName

string

The mapping rule to be used to ingest the data. Optionally the mapping information can be added to each message.

properties.provisioningState

ProvisioningState

The provisioned state of the resource.

properties.retrievalStartDate

string

When defined, the data connection retrieves existing Event hub events created since the Retrieval start date. It can only retrieve events retained by the Event hub, based on its retention period.

properties.sharedAccessPolicyName

string

The name of the share access policy

properties.tableName

string

The table where the data should be ingested. Optionally the table information can be added to each message.

type

string

The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

iotHubDataFormat

The data format of the message. Optionally the data format can be added to each message.

Name Type Description
APACHEAVRO

string

AVRO

string

CSV

string

JSON

string

MULTIJSON

string

ORC

string

PARQUET

string

PSV

string

RAW

string

SCSV

string

SINGLEJSON

string

SOHSV

string

TSV

string

TSVE

string

TXT

string

W3CLOGFILE

string

ProvisioningState

The provisioned state of the resource.

Name Type Description
Canceled

string

Creating

string

Deleting

string

Failed

string

Moving

string

Running

string

Succeeded

string