Azure SQL

Configure an Azure SQL database connection

1. Open the New Azure SQL connection dialog.

   1. Open the Attached data tool from the left-hand sidebar.

   2. Switch to the Databases tab. You will see the list of all database connections available from the respective workspace.

   3. Click New database.

      

   4. In the New database connection dialog, select Azure SQL.

   1. In the sidebar on the Home page, select the workspace where you want to create an Azure SQL connection.

   2. In the workspace resources, select Data and switch to the Databases tab.

      

   3. Click New database connection at the top right.

   4. In the dialog, select Azure SQL.

      

2. On the General tab, select the connection type.

   • default: to connect by specifying the Host, Port, and Database.

   • URL only: to connect by providing the URL of a pre-built connection.

3. (For default) In the Port field, type the port of Azure SQL Databse. The default port is 1433.

4. Under Authentication, select an authentication method:

   • User & Password: to use your login and password

   • No auth: to connect without authentication required

5. In the User and Password fields, specify your credentials if required by the selected authentication method.

6. Based on the selected connection type:

   • In the Database field, type the name of the database to which you want to connect.

   • In the URL field, provide the URL of the pre-built connection you want to establish.

7. (Optional) For other options (SSH tunneling, scope inspection, or additional connection parameters), switch to the respective tab of the dialog and follow one of these procedures.

8. Click the Test connection button at the bottom of the dialog.

9. Once the connection is successfully tested, click the Create and close button.

Attach the connection to a notebook