Skip to content

You are viewing documentation for Immuta version 2.8.

For the latest version, view our documentation for Immuta SaaS or the latest self-hosted version.

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.

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.