Skip to content

Azure SQL Data Source Creation Tutorial

Audience: Data Owners

Content Summary: This guide details configuring an Azure SQL data source in Immuta. To explore data source creation guides for other storage technologies, see the object-backed and query-backed guides.

Overview

Immuta supports Azure SQL data sources via the Microsoft SQL Server data source handler.

The process for creating an Azure SQL data source is nearly identical to the process for creating a standard Microsoft SQL Server data source. The only additional requirement is to add the argument below to the Additional Connection String Options when creating your data source.

Database=<your desired database name>

Refer to the screenshot below for an example of how to fill out the Connection Information step when creating an Azure SQL data source in Immuta.

Azure SQL Connection Information

Connecting to Read-Only Replicas

If your Azure SQL Database supports read-only replicas (such as Azure SQL Hyperscale), you can specify ApplicationIntent=ReadOnly in your connection string to ensure that all Immuta user queries are directed to read-only replicas. Although not strictly required, read-only connections are considered a best practice when creating an Immuta data source. An example configuration is shown below.

Azure SQL Connection Information Read Only

Refer to the Query-backed Data Source Tutorial for more details about creating data sources backed by relational databases such as Azure SQL.