Forum Discussion
SQL External table in KQL database using user assigned managed identity
Hello, We would like to create an external table within the KQL database to an azure SQL database containing metadata values. Ideally we would like to use system assigned managed identities, but...
MatthiasA Can you set up a user-assigned managed identity for your Azure Data Explorer cluster, and allow the managed identity read and write permissions to the external resource. Then, use the managed identity’s credentials in the connection string for your external table.
You can also run this command to set a managed identity policy on the cluster, enabling its use with external tables.
.alter-merge policy managed_identity
Kindy see @Jose Manuel Jurado Diaz blogpost and learn microsoft
If this post helps, please consider Accepting it as the solution to help the other members find it more quickly.