.delete policy managed_identity command

Deletes the ManagedIdentity policy of the cluster or the specified database.

Warning

Be careful when deleting the ManagedIdentity policy, as doing so will cause failures in all flows that rely on this policy. For example, if the policy allowed accessing Azure Storage via External Tables by authenticating via a managed identity, then deleting this policy will cause failures for queries that involve this external table, and also for operations that export to this external table.

Permissions

You must have AllDatabasesAdmin permissions to run these commands.

Syntax

.delete cluster policy managed_identity

.delete database DatabaseName policy managed_identity

Learn more about syntax conventions.

Parameters

Name Type Required Description
DatabaseName string ✔️ The name of the database.

Returns

The command deletes the cluster's or database's ManagedIdentity policy, and then returns the output of the corresponding .show managed identity policy command.

Example

.delete database MyDatabase policy managed_identity