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.
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.
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.