Skip to content

Enable Azure Synapse Analytics Integration

Audience: System Administrators

Content Summary: This page provides a tutorial for enabling the native Azure Synapse Analytics integration in Immuta. For an overview of the access pattern, see the Data Access Patterns documentation.

Additional Tutorials Contents:

  • Update an Azure Synapse Analytics Instance
  • Remove an Azure Synapse Analytics Instance

Add the Integration

  1. Click the App Settings icon in the left sidebar.
  2. Click Native Integrations in the left panel.
  3. Click the +Add Native Integration button and select Azure Synapse Analytics from the dropdown menu.
  4. Complete the Host, Port, Immuta Database, and Immuta Schema fields.

    Azure Synapse Analytics Config Modal

  5. Opt to check the Enable Impersonation box and customize the Impersonation Role name as needed. This will allow users to natively impersonate another user.

  6. Opt to update the User Profile Delimiters. This will be necessary if any of the provided symbols are used in user profile information.

  7. Set up the connection Automatically or Manually.

    Automatic Setup

    Enter the privileged user credentials.

    Manual Setup

    Download the linked bootstrap.sql file and manually configure the Azure Synapse Analytics environment.

  8. Click Test Azure Synapse Analytics Connection.

  9. Once the credentials are successfully tested, click Save.

Additional Tutorials

  1. Click the App Settings icon in the left sidebar.
  2. Navigate to the Native Integrations section and click the down arrow next to the Azure Synapse Analytics Integration.
  3. Edit the field you want to change. Note any field shadowed is not editable, and the integration must be disabled and re-installed to change it.
  4. Enter Username and Password.

    Immuta requires temporary, one-time use of credentials with specific permissions.

    When performing edits to an integration, Immuta requires temporary, one-time use of credentials of a Superuser or a user with the following permissions:

    • Manage GRANTS

    Alternatively, you can download the Edit Script and run it in Azure Synapse Analytics.

  5. Click Validate Credentials.

  6. Click Save.
  7. Click Confirm.
  1. Click the App Settings icon in the left sidebar.
  2. Navigate to the Native Integrations section and click the down arrow next to the Azure Synapse Analytics Integration.
  3. Click the checkbox to disable the integration.
  4. Enter the username and password that were used to initially configure the integration and click Validate Credentials.
  5. Click Save.
  6. Click Confirm.