Querying Azure Synapse Analytics Data
Prerequisites:
REVOKE
users' access to raw tablesGRANT
users' access to the Immuta schema
Query data
Click the Data menu in Synapse Studio.
Click the Workspace tab.
Expand the databases, and you should see the dedicated pool you specified when configuring the integration.
Expand the dedicated pool and you should see the Immuta schema you created when configuring the integration.
Select that schema.
Select New SQL script and then Empty script.
Run your query (note that Synapse does not support LIMIT and the SQL is case sensitive). It should look something like this: