Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Azure Data Studio provides an experience similar to the Azure portal for viewing information about your Azure Arc resources. These views are called dashboards and have a layout and options similar to what you could see about a given resource in the Azure portal, but give you the flexibility of seeing that information locally in your environment in cases where you don't have a connection available to Azure.
Connect to a data controller
Prerequisites
- Download Azure Data Studio
- Azure Arc extension is installed
Connect
Open Azure Data Studio.
Select the Connections tab on the left.
Expand the panel called Azure Arc Controllers.
Select the Connect Controller button.
Azure Data Studio opens a blade on the right side.
Enter the Namespace for the data controller.
Azure Data Studio reads from the
kube.configfile in your default directory and lists the available Kubernetes cluster contexts. It selects the current cluster context. If this is the right cluster to connect to, use that namespace.If you need to retrieve the namespace where the Azure Arc data controller is deployed, you can run
kubectl get datacontrollers -Aon your Kubernetes cluster.Optionally add a display name for the Azure Arc data controller in the input for Name.
Select Connect.
After you connect to a data controller, you can view the dashboards. Azure Data Studio has dashboards for the data controller and any SQL managed instance resources that you have.
View the data controller dashboard
Right-click on the data controller in the Connections panel in the Arc Controllers expandable panel and choose Manage.
Here you can see details about the data controller resource such as name, region, connection mode, resource group, subscription, controller endpoint, and namespace. You can see a list of all of the managed database resources managed by the data controller as well.
You'll notice that the layout is similar to what you might see in the Azure portal.
Conveniently, you can launch the creation of a SQL managed instance by clicking the + New Instance button.
You can also open the Azure portal in context to this data controller by clicking the Open in Azure portal button.
View the SQL Managed Instance dashboards
If you have created some SQL Managed Instances, see them listed under Connections in the Azure Data Controllers expandable panel underneath the data controller that is managing them.
To view the SQL Managed Instance dashboard for a given instance, right-click on the instance and choose Manage.
The Connection panel prompts you for the login and password to connect to an instance. If you know the connection information you can enter it and choose Connect. If you don't know, choose Cancel. Either way, Azure Data Studio returns to the dashboard when the Connection panel closes.
On the Overview tab, view resource group, data controller, subscription ID, status, region, and other information. This location also provides links to the Grafana dashboard for viewing metrics or Kibana dashboard for viewing logs in context to that SQL managed instance.
With a connection to the SQL manage instance, you can see additional information here.
You can delete the SQL managed instance from here or open the Azure portal to view the SQL managed instance in the Azure portal.
If you click on the Connection Strings tab, the Azure Data Studio presents a list of pre-constructed connection strings for that instance making. Copy and paste these strings into various other applications or code.