Connect to a SQL Server big data cluster with Azure Data Studio

THIS TOPIC APPLIES TO:yesSQL Server noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

This article describes how to connect to a SQL Server 2019 big data cluster (preview) from Azure Data Studio.

Prerequisites

Connect to the cluster

To connect to a big data cluster with Azure Data Studio, make a new connection to the SQL Server master instance in the cluster. The following steps describe how to connect to the master instance using Azure Data Studio.

  1. From the command line, find the IP of your master instance with the following command:

    kubectl get svc master-svc-external -n <your-big-data-cluster-name>
    

    Tip

    The big data cluster name defaults to mssql-cluster unless you customized the name in a deployment configuration file. For more information, see Configure deployment settings for big data clusters.

  2. In Azure Data Studio, press F1 > New Connection.

  3. In Connection type, select Microsoft SQL Server.

  4. Type the IP address of the SQL Server master instance in Server name (for example: <IP Address>,31433).

  5. Enter a SQL login User name and Password.

    Tip

    By default, the user name is SA and, unless changed, the password corresponds to the MSSQL_SA_PASSWORD environment variable used during deployment.

  6. Change the target Database name to one of your relational databases.

    Connect to the master instance

  7. Press Connect, and the Server Dashboard should appear.

With the February 2019 release of Azure Data Studio, connecting to the SQL Server master instance also enables you to interact with the HDFS/Spark gateway. This means that you do not need to use a separate connection for HDFS and Spark that the next section describes.

  • The Object Explorer now contains a new Data Services node with right-click support for big data cluster tasks, such as creating new notebooks or submitting spark jobs.

  • The Data Services node also contains an HDFS folder for HDFS exploration and performing actions such as Create External Table or Analyze in Notebook.

  • The Server Dashboard for the connection also contains tabs for SQL Server big data cluster and SQL Server 2019 (Preview) when the extension is installed.

    Azure Data Studio Data Services Node

Next steps

For more information about SQL Server 2019 big data clusters, see What are SQL Server 2019 big data clusters.