az kusto database
Note
This command group has commands that are defined in both Azure CLI and at least one extension. Install each extension to benefit from its extended capabilities. Learn more about extensions.
This command group has been deprecated and will be removed in a future release. Use '"az extension add -n kusto" to install the supported Kusto extension' instead.
Manage Azure Kusto databases.
Azure CLI commands for Kusto are now an extension. Execute "az extension add -n kusto" to install the extension. The original core module for Kusto is no longer supported.
Commands
Name | Description | Type | Status |
---|---|---|---|
az kusto database add-principal |
Add Database principals permissions. |
Extension | Experimental |
az kusto database create |
Create a Kusto database. |
Core | Deprecated |
az kusto database create (kusto extension) |
Create a database. |
Extension | Experimental |
az kusto database delete |
Delete a Kusto database. |
Core | Deprecated |
az kusto database delete (kusto extension) |
Deletes the database with the given name. |
Extension | Experimental |
az kusto database list |
List a Kusto database. |
Core | Deprecated |
az kusto database list (kusto extension) |
Returns the list of databases of the given Kusto cluster. |
Extension | Experimental |
az kusto database list-principal |
Returns a list of database principals of the given Kusto cluster and database. |
Extension | Experimental |
az kusto database remove-principal |
Remove Database principals permissions. |
Extension | Experimental |
az kusto database show |
Get a Kusto database. |
Core | Deprecated |
az kusto database show (kusto extension) |
Returns a database. |
Extension | Experimental |
az kusto database update |
Update a Kusto database. |
Core | Deprecated |
az kusto database update (kusto extension) |
Updates a database. |
Extension | Experimental |
az kusto database wait |
Wait for a managed Kusto database to reach a desired state. |
Core | Deprecated |
az kusto database wait (kusto extension) |
Place the CLI in a waiting state until a condition of the kusto database is met. |
Extension | Experimental |
az kusto database add-principal
Command group 'kusto' is experimental and under development. Reference and support levels: https://aka.ms/CLI_refstatus
Add Database principals permissions.
az kusto database add-principal [--cluster-name]
[--database-name]
[--ids]
[--resource-group]
[--subscription]
[--value]
Examples
KustoDatabaseAddPrincipals
az kusto database add-principal --cluster-name "kustoclusterrptest4" --database-name "KustoDatabase8" --value name="Some User" type="User" app-id="" email="user@microsoft.com" fqn="aaduser=some_guid" role="Admin" --value name="Kusto" type="Group" app-id="" email="kusto@microsoft.com" fqn="aadgroup=some_guid" role="Viewer" --value name="SomeApp" type="App" app-id="some_guid_app_id" email="" fqn="aadapp=some_guid_app_id" role="Admin" --resource-group "kustorptest"
Optional Parameters
The name of the Kusto cluster.
The name of the database in the Kusto cluster.
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.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
The list of Kusto database principals.
Usage: --value role=XX name=XX type=XX fqn=XX email=XX app-id=XX
role: Required. Database principal role. name: Required. Database principal name. type: Required. Database principal type. fqn: Database principal fully qualified name. email: Database principal email if exists. app-id: Application id - relevant only for application principal type.
Multiple actions can be specified by using more than one --value argument.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
az kusto database create
This command is implicitly deprecated because command group 'kusto database' is deprecated and will be removed in a future release. Use '"az extension add -n kusto" to install the supported Kusto extension' instead.
Create a Kusto database.
az kusto database create --cluster-name
--name
--resource-group
[--hot-cache-period]
[--no-wait]
[--soft-delete-period]
Examples
create a Kusto Database.
az kusto database create --cluster-name myclustername -g myrgname -n mydbname --soft-delete-period P365D --hot-cache-period P31D
Required Parameters
The name of the cluster.
The name of the database.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Optional Parameters
Amount of time that data should be kept in cache.Duration in ISO8601 format (for example, 100 days would be P100D).
Do not wait for the long-running operation to finish.
Amount of time that data should be kept so it is available to query. Duration in ISO8601 format (for example, 100 days would be P100D).
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
az kusto database create (kusto extension)
Command group 'kusto' is experimental and under development. Reference and support levels: https://aka.ms/CLI_refstatus
Create a database.
az kusto database create --cluster-name
--database-name
--resource-group
[--no-wait]
[--read-only-following-database]
[--read-write-database]
Examples
Kusto ReadWrite database create or update
az kusto database create --cluster-name "kustoclusterrptest4" --database-name "KustoDatabase8" --read-write-database location="westus" soft-delete-period="P1D" --resource-group "kustorptest"
Required Parameters
The name of the Kusto cluster.
The name of the database in the Kusto cluster.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Optional Parameters
Do not wait for the long-running operation to finish.
Class representing a read only following database.
Usage: --read-only-following-database hot-cache-period=XX location=XX kind=XX
hot-cache-period: The time the data should be kept in cache for fast queries in TimeSpan. location: Resource location. kind: Required. Kind of the database.
Class representing a read write database.
Usage: --read-write-database soft-delete-period=XX hot-cache-period=XX location=XX kind=XX
soft-delete-period: The time the data should be kept before it stops being accessible to queries in TimeSpan. hot-cache-period: The time the data should be kept in cache for fast queries in TimeSpan. location: Resource location. kind: Required. Kind of the database.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
az kusto database delete
This command is implicitly deprecated because command group 'kusto database' is deprecated and will be removed in a future release. Use '"az extension add -n kusto" to install the supported Kusto extension' instead.
Delete a Kusto database.
az kusto database delete [--cluster-name]
[--ids]
[--name]
[--resource-group]
[--subscription]
[--yes]
Optional Parameters
The name of the cluster.
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.
The name of the database.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Do not prompt for confirmation.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
az kusto database delete (kusto extension)
Command group 'kusto' is experimental and under development. Reference and support levels: https://aka.ms/CLI_refstatus
Deletes the database with the given name.
az kusto database delete [--cluster-name]
[--database-name]
[--ids]
[--no-wait]
[--resource-group]
[--subscription]
[--yes]
Examples
KustoDatabasesDelete
az kusto database delete --cluster-name "kustoclusterrptest4" --database-name "KustoDatabase8" --resource-group "kustorptest"
Optional Parameters
The name of the Kusto cluster.
The name of the database in the Kusto cluster.
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.
Do not wait for the long-running operation to finish.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Do not prompt for confirmation.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
az kusto database list
This command is implicitly deprecated because command group 'kusto database' is deprecated and will be removed in a future release. Use '"az extension add -n kusto" to install the supported Kusto extension' instead.
List a Kusto database.
az kusto database list --cluster-name
--resource-group
Examples
List a Kusto database. (autogenerated)
az kusto database list --cluster-name MyCluster --resource-group MyResourceGroup
Required Parameters
The name of the cluster.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
az kusto database list (kusto extension)
Command group 'kusto' is experimental and under development. Reference and support levels: https://aka.ms/CLI_refstatus
Returns the list of databases of the given Kusto cluster.
az kusto database list --cluster-name
--resource-group
Examples
KustoDatabasesListByCluster
az kusto database list --cluster-name "kustoclusterrptest4" --resource-group "kustorptest"
Required Parameters
The name of the Kusto cluster.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
az kusto database list-principal
Command group 'kusto' is experimental and under development. Reference and support levels: https://aka.ms/CLI_refstatus
Returns a list of database principals of the given Kusto cluster and database.
az kusto database list-principal --cluster-name
--database-name
--resource-group
Examples
KustoDatabaseListPrincipals
az kusto database list-principal --cluster-name "kustoclusterrptest4" --database-name "KustoDatabase8" --resource-group "kustorptest"
Required Parameters
The name of the Kusto cluster.
The name of the database in the Kusto cluster.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
az kusto database remove-principal
Command group 'kusto' is experimental and under development. Reference and support levels: https://aka.ms/CLI_refstatus
Remove Database principals permissions.
az kusto database remove-principal [--cluster-name]
[--database-name]
[--ids]
[--resource-group]
[--subscription]
[--value]
Examples
KustoDatabaseRemovePrincipals
az kusto database remove-principal --cluster-name "kustoclusterrptest4" --database-name "KustoDatabase8" --value name="Some User" type="User" app-id="" email="user@microsoft.com" fqn="aaduser=some_guid" role="Admin" --value name="Kusto" type="Group" app-id="" email="kusto@microsoft.com" fqn="aadgroup=some_guid" role="Viewer" --value name="SomeApp" type="App" app-id="some_guid_app_id" email="" fqn="aadapp=some_guid_app_id" role="Admin" --resource-group "kustorptest"
Optional Parameters
The name of the Kusto cluster.
The name of the database in the Kusto cluster.
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.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
The list of Kusto database principals.
Usage: --value role=XX name=XX type=XX fqn=XX email=XX app-id=XX
role: Required. Database principal role. name: Required. Database principal name. type: Required. Database principal type. fqn: Database principal fully qualified name. email: Database principal email if exists. app-id: Application id - relevant only for application principal type.
Multiple actions can be specified by using more than one --value argument.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
az kusto database show
This command is implicitly deprecated because command group 'kusto database' is deprecated and will be removed in a future release. Use '"az extension add -n kusto" to install the supported Kusto extension' instead.
Get a Kusto database.
az kusto database show [--cluster-name]
[--ids]
[--name]
[--resource-group]
[--subscription]
Examples
Get a Kusto database. (autogenerated)
az kusto database show --cluster-name MyCluster --name MyDatabase --resource-group MyResourceGroup
Optional Parameters
The name of the cluster.
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.
The name of the database.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
az kusto database show (kusto extension)
Command group 'kusto' is experimental and under development. Reference and support levels: https://aka.ms/CLI_refstatus
Returns a database.
az kusto database show [--cluster-name]
[--database-name]
[--ids]
[--resource-group]
[--subscription]
Examples
KustoDatabasesGet
az kusto database show --cluster-name "kustoclusterrptest4" --database-name "KustoDatabase8" --resource-group "kustorptest"
Optional Parameters
The name of the Kusto cluster.
The name of the database in the Kusto cluster.
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.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
az kusto database update
This command is implicitly deprecated because command group 'kusto database' is deprecated and will be removed in a future release. Use '"az extension add -n kusto" to install the supported Kusto extension' instead.
Update a Kusto database.
az kusto database update --soft-delete-period
[--add]
[--cluster-name]
[--force-string]
[--hot-cache-period]
[--ids]
[--name]
[--no-wait]
[--remove]
[--resource-group]
[--set]
[--subscription]
Examples
create a Kusto Database.
az kusto database update --cluster-name myclustername -g myrgname -n mydbname --soft-delete-period P365D --hot-cache-period P30D
Required Parameters
Amount of time that data should be kept so it is available to query. Duration in ISO8601 format (for example, 100 days would be P100D).
Optional Parameters
Add an object to a list of objects by specifying a path and key value pairs. Example: --add property.listProperty <key=value, string or JSON string>
.
The name of the cluster.
When using 'set' or 'add', preserve string literals instead of attempting to convert to JSON.
Amount of time that data should be kept in cache.Duration in ISO8601 format (for example, 100 days would be P100D).
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.
The name of the database.
Do not wait for the long-running operation to finish.
Remove a property or an element from a list. Example: --remove property.list <indexToRemove>
OR --remove propertyToRemove
.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Update an object by specifying a property path and value to set. Example: --set property1.property2=<value>
.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
az kusto database update (kusto extension)
Command group 'kusto' is experimental and under development. Reference and support levels: https://aka.ms/CLI_refstatus
Updates a database.
az kusto database update [--cluster-name]
[--database-name]
[--ids]
[--no-wait]
[--read-only-following-database]
[--read-write-database]
[--resource-group]
[--subscription]
Examples
Kusto ReadWrite database create or update
az kusto database update --cluster-name "kustoclusterrptest4" --database-name "KustoDatabase8" --read-write-database location="westus" soft-delete-period="P1D" --resource-group "kustorptest"
Optional Parameters
The name of the Kusto cluster.
The name of the database in the Kusto cluster.
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.
Do not wait for the long-running operation to finish.
Class representing a read only following database.
Usage: --read-only-following-database hot-cache-period=XX location=XX kind=XX
hot-cache-period: The time the data should be kept in cache for fast queries in TimeSpan. location: Resource location. kind: Required. Kind of the database.
Class representing a read write database.
Usage: --read-write-database soft-delete-period=XX hot-cache-period=XX location=XX kind=XX
soft-delete-period: The time the data should be kept before it stops being accessible to queries in TimeSpan. hot-cache-period: The time the data should be kept in cache for fast queries in TimeSpan. location: Resource location. kind: Required. Kind of the database.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
az kusto database wait
This command is implicitly deprecated because command group 'kusto database' is deprecated and will be removed in a future release. Use '"az extension add -n kusto" to install the supported Kusto extension' instead.
Wait for a managed Kusto database to reach a desired state.
If an operation on a database was interrupted or was started with --no-wait
, use this command to wait for it to complete.
az kusto database wait [--cluster-name]
[--created]
[--custom]
[--deleted]
[--exists]
[--ids]
[--interval]
[--name]
[--resource-group]
[--subscription]
[--timeout]
[--updated]
Optional Parameters
The name of the cluster.
Wait until created with 'provisioningState' at 'Succeeded'.
Wait until the condition satisfies a custom JMESPath query. E.g. provisioningState!='InProgress', instanceView.statuses[?code=='PowerState/running'].
Wait until deleted.
Wait until the resource exists.
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.
Polling interval in seconds.
The name of the database.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Maximum wait in seconds.
Wait until updated with provisioningState at 'Succeeded'.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
az kusto database wait (kusto extension)
Command group 'kusto' is experimental and under development. Reference and support levels: https://aka.ms/CLI_refstatus
Place the CLI in a waiting state until a condition of the kusto database is met.
az kusto database wait [--cluster-name]
[--created]
[--custom]
[--database-name]
[--deleted]
[--exists]
[--ids]
[--interval]
[--resource-group]
[--subscription]
[--timeout]
[--updated]
Examples
Pause executing next line of CLI script until the kusto database is successfully created.
az kusto database wait --cluster-name "kustoclusterrptest4" --database-name "KustoDatabase8" --resource-group "kustorptest" --created
Pause executing next line of CLI script until the kusto database is successfully updated.
az kusto database wait --cluster-name "kustoclusterrptest4" --database-name "KustoDatabase8" --resource-group "kustorptest" --updated
Pause executing next line of CLI script until the kusto database is successfully deleted.
az kusto database wait --cluster-name "kustoclusterrptest4" --database-name "KustoDatabase8" --resource-group "kustorptest" --deleted
Optional Parameters
The name of the Kusto cluster.
Wait until created with 'provisioningState' at 'Succeeded'.
Wait until the condition satisfies a custom JMESPath query. E.g. provisioningState!='InProgress', instanceView.statuses[?code=='PowerState/running'].
The name of the database in the Kusto cluster.
Wait until deleted.
Wait until the resource exists.
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.
Polling interval in seconds.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Maximum wait in seconds.
Wait until updated with provisioningState at 'Succeeded'.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.