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.
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.
Refer to the Query-backed Data Source Tutorial for more details about creating data sources backed by relational databases such as Azure SQL.