Is it possible to automate trusting an Azure Data Explorer database connection?

Hello, thank you for taking the time to help with this issue.

Are you sure this is not some company/network/firewall/browser related feature?

This pop-up is unrelated to any company/network/firewall/browser-related feature.

I have reproduced the behavior on the following browsers:

1. Firefox
2. Chrome

Which tool is giving this message? Is it the web interface towards the Database explorer/query editor?

Yes, it is the Data Explorer web interface. See screenshot showing pop-up:

Please provide information about the steps you have taken, the guide you follow, and the errors you receive.

Steps to reproduce:

1. As an admin in Azure, set up a Data Explorer database and user account
   1. Create a cluster in Data Explorer
   2. Create a new Azure Active Directory user
   3. Grant the user permission to read the cluser
   4. Create a new database in the cluster
2. Open a new incognito tab in your browser
3. In the incognito tab, open the Data Explorer database via URL (replace the bash variables with the cluster, region and database names): https://dataexplorer.azure.com/clusters/$CLUSTER_NAME.$REGION/databases/$DATABASE_NAME
4. Log in to the user created in step 1
5. Click either "Yes" or "No" on the "Stay signed in?" pop-up
6. The connection list-related pop-up will now be visible. If you click on "Cancel" instead of "Trust", then the database will not show up in Data Explorer

I did not receive any errors. This seems to be expected behavior. The problem is that when my users choose to click on "Cancel", then the database will not show up for them and it breaks their user experience. Since the user account in step 1b was created expressly for them to access the database created in 1d, then it does not make sense to ask them whether they wish to trust the connection. I would like to automate things so that the connection to the database is trusted for their user account.

Which security feature are you describing?

I am describing the pop-up from step 6 which can be seen in the screenshot.

Hello @42726446,

thank you for the very elaborate explanation.

I just tried this myself and I get the same messsage:

This is new to me too.

It seems part of the new make-over of the web ui.

The documentation does not provide extra information and I see no portal settings related to this.

My best guess this is standard behavior and not manageable.

Off topic: have you tried creating multiple databases (one for every user) inside the same cluster? This means only one cluster is paid for and the ingest and query compute is shared over all users.

@Sander van de Velde | MVP Thank you for the reply. It's a bit disappointing that this isn't manageable.

have you tried creating multiple databases (one for every user) inside the same cluster?

Yes, this is how I currently do it since the clusters are very expensive and take an extremely long time to come online after being created.