Configure Azure SQL Accounts

Overview

You can configure your accounts in SnapLogic using the Designer or Manager. You can create Azure SQL accounts to connect to Azure SQL data sources in your Pipelines.

Snap-account compatibility

The Snaps in the Azure SQL Snap Pack work with different accounts per the following table:

Snaps Azure SQL Account Azure SQL Entra Account Azure SQL Entra Dynamic Account Azure SQL Dynamic Account
Azure SQL - Bulk Extract Tick Icon Tick Icon Tick Icon Tick Icon
Azure SQL - Bulk Load Tick Icon Tick Icon Tick Icon Tick Icon
Azure SQL - Execute Tick Icon Tick Icon Tick Icon Tick Icon
Azure SQL - Stored Procedure Tick Icon Tick Icon Tick Icon Tick Icon
Azure SQL - Table List Tick Icon Tick Icon Tick Icon Tick Icon
Azure SQL - Update Tick Icon Tick Icon Tick Icon Tick Icon
PolyBase Bulk Load Tick Icon Cross Icon Cross Icon Tick Icon

Account encryption

Standard Encryption If you are using Standard Encryption, follow the High sensitivity settings under Enhanced Encryption.
Enhanced Encryption If you have the Enhanced Account Encryption feature, the following describes which fields are encrypted for each sensitivity level selected for this account:
  • High: Password, Azure storage account key.
  • Medium + High: Username, Password, Azure storage account key, Azure storage account name.
  • Low + Medium + High: All account fields.

See Also