Skip to content

You are viewing documentation for Immuta version 2024.1.

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

Querying Azure Synapse Analytics Data

Audience: Data Users

Content Summary: This page offers a tutorial on how to query data within the Azure Synapse Analytics integration.

Prerequisites:

Query Data

  1. From Synapse Studio click on the Data menu on the left.
  2. Click on the Workspace tab.
  3. Expand databases and you should see the dedicated pool you specified when configuring the integration.
  4. Expand the dedicated pool and you should see the Immuta schema you created when configuring the integration.
  5. Select that schema.
  6. Select New SQL script and then Empty script.
  7. Run your query (note that Synapse does not support LIMIT and the SQL is case sensitive). It should look something like this:

    SELECT TOP 100 * FROM immuta_schema.backing_database_backing_table;