Deepnote
IntegrationsPricing
Join usDocsSign in

Getting started

Deepnote documentation

Environment

Integrations

SQL Server (Azure SQL)

SQL Server (Azure SQL)

Available to teams on Pro and Enterprise plans

With the SQL Server integration, you can leverage the capabilities of Deepnote's SQL blocks to query your SQL Server instances. But wait, there's more! Using the SQL Server integration, you can actually connect to SQL Server, Azure SQL, as well as Azure Synapse. That way, regardless of which Microsoft product you prefer, you'll be able to connect natively through Deepnote.

spaces%2FtfH69m1V6bYYvquUay8O%2Fuploads%2FcVlARDHsJZRaOa8ROQI3%2FCleanShot%202022-07-29%20at%2018.12.27%402x.png

Deepnote's SQL Server integration allows data teams to efficiently query their data, extract relevant data, and start analyzing and modeling in the comfort of their known notebook environment. In addition, switching between Azure SQL, SQL Server, and Azure Synapse, won't require you to rewrite any SQL statements; all that's needed is switching the SQL block's assigned integration.

How to connect to SQL Server (or Azure SQL, or Azure Synapse)

To create the integration, you'll need a few things:

  • Hostname: The hostname of the server you are trying to connect to. Check out this section of Microsoft's docs for more details.
  • Port: The port on the server of interest you are trying to connect to. Usually, the default is port 1433. Take a look at the Microsoft SQL Server docs for more details.
  • Username: Your username. More in Microsoft's docs here.
  • Password: The password for the specified username.
  • Database: The name of the database you would like to connect to.

If your connection is protected, you might need to whitelist Deepnote's IP addresses. Read more here.

How to use

Once created, you'll be able to connect the SQL Server integration to any project within your workspace through the right-hand sidebar. The SQL Server integration comes with custom SQL Server SQL blocks that help streamline your analytics efforts. You can also convert any existing SQL block to a SQL Server block.

As with all SQL blocks, the query results will be saved as a Pandas DataFrame and stored in the variable specified in the SQL block.

Next steps

Jump right into Deepnote & learn more about SQL blocks in this A/B testing template. You can also save yourself some setup work by hitting the Duplicate button in the top-right corner to start exploring on your own!

Still need help? Deepnote's community of over 5,000 data enthusiasts and professionals is always there for you. Post any questions into the Q&A channel here.

Deepnote
Product
© 2022 Deepnote. All rights reserved.