Share via


az kusto data-connection event-grid

Note

This reference is part of the kusto extension for the Azure CLI (version 2.15.0 or higher). The extension will automatically install the first time you run an az kusto data-connection event-grid command. Learn more about extensions.

Command group 'kusto' is experimental and under development. Reference and support levels: https://aka.ms/CLI_refstatus

Manage data connection with kusto sub group event-grid.

Commands

Name Description Type Status
az kusto data-connection event-grid create

Create a data connection.

Extension Experimental
az kusto data-connection event-grid data-connection-validation

Checks that the data connection parameters are valid.

Extension Experimental
az kusto data-connection event-grid update

Updates a data connection.

Extension Experimental

az kusto data-connection event-grid create

Experimental

Command group 'kusto' is experimental and under development. Reference and support levels: https://aka.ms/CLI_refstatus

Create a data connection.

az kusto data-connection event-grid create --cluster-name
                                           --data-connection-name --name
                                           --database-name
                                           --resource-group
                                           [--blob-storage-event-type {Microsoft.Storage.BlobCreated, Microsoft.Storage.BlobRenamed}]
                                           [--consumer-group]
                                           [--data-format {APACHEAVRO, AVRO, CSV, JSON, MULTIJSON, ORC, PARQUET, PSV, RAW, SCSV, SINGLEJSON, SOHSV, TSV, TSVE, TXT, W3CLOGFILE}]
                                           [--database-routing {Multi, Single}]
                                           [--event-grid-resource-id]
                                           [--event-hub-resource-id]
                                           [--ignore-first-record {false, true}]
                                           [--location]
                                           [--managed-identity --managed-identity-resource-id]
                                           [--mapping-rule-name]
                                           [--no-wait]
                                           [--storage-account-resource-id]
                                           [--table-name]

Required Parameters

--cluster-name

The name of the Kusto cluster.

--data-connection-name --name -n

The name of the data connection.

--database-name

The name of the database in the Kusto cluster.

--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name>.

Optional Parameters

The following parameters are optional, but depending on the context, one or more might become required for the command to execute successfully.

--blob-storage-event-type

The name of blob storage event type to process.

Property Value
Accepted values: Microsoft.Storage.BlobCreated, Microsoft.Storage.BlobRenamed
--consumer-group

The event hub consumer group.

--data-format

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

Property Value
Accepted values: APACHEAVRO, AVRO, CSV, JSON, MULTIJSON, ORC, PARQUET, PSV, RAW, SCSV, SINGLEJSON, SOHSV, TSV, TSVE, TXT, W3CLOGFILE
--database-routing

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

Property Value
Accepted values: Multi, Single
--event-grid-resource-id

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

--event-hub-resource-id

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

--ignore-first-record

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

Property Value
Accepted values: false, true
--location -l

Location. Values from: az account list-locations. You can configure the default location using az configure --defaults location=<location>.

--managed-identity --managed-identity-resource-id

Empty for non-managed identity based data connection. For system assigned identity, provide cluster resource Id. For user assigned identity (UAI) provide the UAI resource Id.

--mapping-rule-name

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

--no-wait

Do not wait for the long-running operation to finish.

Property Value
Default value: False
--storage-account-resource-id

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

--table-name

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

Global Parameters
--debug

Increase logging verbosity to show all debug logs.

Property Value
Default value: False
--help -h

Show this help message and exit.

--only-show-errors

Only show errors, suppressing warnings.

Property Value
Default value: False
--output -o

Output format.

Property Value
Default value: json
Accepted values: json, jsonc, none, table, tsv, yaml, yamlc
--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

Property Value
Default value: False

az kusto data-connection event-grid data-connection-validation

Experimental

Command group 'kusto' is experimental and under development. Reference and support levels: https://aka.ms/CLI_refstatus

Checks that the data connection parameters are valid.

az kusto data-connection event-grid data-connection-validation [--blob-storage-event-type {Microsoft.Storage.BlobCreated, Microsoft.Storage.BlobRenamed}]
                                                               [--cluster-name]
                                                               [--consumer-group]
                                                               [--data-connection-name --name]
                                                               [--data-format {APACHEAVRO, AVRO, CSV, JSON, MULTIJSON, ORC, PARQUET, PSV, RAW, SCSV, SINGLEJSON, SOHSV, TSV, TSVE, TXT, W3CLOGFILE}]
                                                               [--database-name]
                                                               [--database-routing {Multi, Single}]
                                                               [--event-grid-resource-id]
                                                               [--event-hub-resource-id]
                                                               [--ids]
                                                               [--ignore-first-record {false, true}]
                                                               [--location]
                                                               [--managed-identity --managed-identity-resource-id]
                                                               [--mapping-rule-name]
                                                               [--no-wait]
                                                               [--resource-group]
                                                               [--storage-account-resource-id]
                                                               [--subscription]
                                                               [--table-name]

Optional Parameters

The following parameters are optional, but depending on the context, one or more might become required for the command to execute successfully.

--blob-storage-event-type

The name of blob storage event type to process.

Property Value
Accepted values: Microsoft.Storage.BlobCreated, Microsoft.Storage.BlobRenamed
--cluster-name

The name of the Kusto cluster.

Property Value
Parameter group: Resource Id Arguments
--consumer-group

The event hub consumer group.

--data-connection-name --name -n

The name of the data connection.

--data-format

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

Property Value
Accepted values: APACHEAVRO, AVRO, CSV, JSON, MULTIJSON, ORC, PARQUET, PSV, RAW, SCSV, SINGLEJSON, SOHSV, TSV, TSVE, TXT, W3CLOGFILE
--database-name

The name of the database in the Kusto cluster.

Property Value
Parameter group: Resource Id Arguments
--database-routing

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

Property Value
Accepted values: Multi, Single
--event-grid-resource-id

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

--event-hub-resource-id

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

--ids

One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.

Property Value
Parameter group: Resource Id Arguments
--ignore-first-record

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

Property Value
Accepted values: false, true
--location -l

Location. Values from: az account list-locations. You can configure the default location using az configure --defaults location=<location>.

--managed-identity --managed-identity-resource-id

Empty for non-managed identity based data connection. For system assigned identity, provide cluster resource Id. For user assigned identity (UAI) provide the UAI resource Id.

--mapping-rule-name

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

--no-wait

Do not wait for the long-running operation to finish.

Property Value
Default value: False
--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name>.

Property Value
Parameter group: Resource Id Arguments
--storage-account-resource-id

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

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

Property Value
Parameter group: Resource Id Arguments
--table-name

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

Global Parameters
--debug

Increase logging verbosity to show all debug logs.

Property Value
Default value: False
--help -h

Show this help message and exit.

--only-show-errors

Only show errors, suppressing warnings.

Property Value
Default value: False
--output -o

Output format.

Property Value
Default value: json
Accepted values: json, jsonc, none, table, tsv, yaml, yamlc
--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

Property Value
Default value: False

az kusto data-connection event-grid update

Experimental

Command group 'kusto' is experimental and under development. Reference and support levels: https://aka.ms/CLI_refstatus

Updates a data connection.

az kusto data-connection event-grid update [--blob-storage-event-type {Microsoft.Storage.BlobCreated, Microsoft.Storage.BlobRenamed}]
                                           [--cluster-name]
                                           [--consumer-group]
                                           [--data-connection-name --name]
                                           [--data-format {APACHEAVRO, AVRO, CSV, JSON, MULTIJSON, ORC, PARQUET, PSV, RAW, SCSV, SINGLEJSON, SOHSV, TSV, TSVE, TXT, W3CLOGFILE}]
                                           [--database-name]
                                           [--database-routing {Multi, Single}]
                                           [--event-grid-resource-id]
                                           [--event-hub-resource-id]
                                           [--ids]
                                           [--ignore-first-record {false, true}]
                                           [--location]
                                           [--managed-identity --managed-identity-resource-id]
                                           [--mapping-rule-name]
                                           [--no-wait]
                                           [--resource-group]
                                           [--storage-account-resource-id]
                                           [--subscription]
                                           [--table-name]

Optional Parameters

The following parameters are optional, but depending on the context, one or more might become required for the command to execute successfully.

--blob-storage-event-type

The name of blob storage event type to process.

Property Value
Accepted values: Microsoft.Storage.BlobCreated, Microsoft.Storage.BlobRenamed
--cluster-name

The name of the Kusto cluster.

Property Value
Parameter group: Resource Id Arguments
--consumer-group

The event hub consumer group.

--data-connection-name --name -n

The name of the data connection.

Property Value
Parameter group: Resource Id Arguments
--data-format

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

Property Value
Accepted values: APACHEAVRO, AVRO, CSV, JSON, MULTIJSON, ORC, PARQUET, PSV, RAW, SCSV, SINGLEJSON, SOHSV, TSV, TSVE, TXT, W3CLOGFILE
--database-name

The name of the database in the Kusto cluster.

Property Value
Parameter group: Resource Id Arguments
--database-routing

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

Property Value
Accepted values: Multi, Single
--event-grid-resource-id

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

--event-hub-resource-id

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

--ids

One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.

Property Value
Parameter group: Resource Id Arguments
--ignore-first-record

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

Property Value
Accepted values: false, true
--location -l

Location. Values from: az account list-locations. You can configure the default location using az configure --defaults location=<location>.

--managed-identity --managed-identity-resource-id

Empty for non-managed identity based data connection. For system assigned identity, provide cluster resource Id. For user assigned identity (UAI) provide the UAI resource Id.

--mapping-rule-name

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

--no-wait

Do not wait for the long-running operation to finish.

Property Value
Default value: False
--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name>.

Property Value
Parameter group: Resource Id Arguments
--storage-account-resource-id

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

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

Property Value
Parameter group: Resource Id Arguments
--table-name

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

Global Parameters
--debug

Increase logging verbosity to show all debug logs.

Property Value
Default value: False
--help -h

Show this help message and exit.

--only-show-errors

Only show errors, suppressing warnings.

Property Value
Default value: False
--output -o

Output format.

Property Value
Default value: json
Accepted values: json, jsonc, none, table, tsv, yaml, yamlc
--query

JMESPath query string. See http://jmespath.org/ for more information and examples.

--verbose

Increase logging verbosity. Use --debug for full debug logs.

Property Value
Default value: False