Appearance
Connect to Azure Synapse
Supersimple connects to dedicated SQL pools in Azure Synapse Analytics. Serverless SQL pools aren't supported in the self-serve setup flow.
A paused dedicated SQL pool rejects connections, so make sure the pool is running before you test the connection.
1. Create a read-only database user
Supersimple can sign in with SQL authentication or with a Microsoft Entra service principal. Use a service principal if your workspace has Microsoft Entra-only authentication enabled, since SQL logins are then disabled.
For SQL authentication, create a login in the master database:
sql
CREATE LOGIN supersimple WITH PASSWORD = '<strong password>';Then, in your dedicated SQL pool database, create a user for the login and give it read access:
sql
CREATE USER supersimple FROM LOGIN supersimple;
GO
EXEC sp_addrolemember 'db_datareader', 'supersimple';For a service principal:
- In the Azure portal, register an application under Microsoft Entra ID → App registrations.
- In the application, create a client secret under Certificates & secrets and copy its Value.
- Make sure your Synapse workspace has a Microsoft Entra admin. Connect to your dedicated SQL pool database with a Microsoft Entra account that's allowed to create users, such as that admin, and run:
sql
CREATE USER [supersimple-app] FROM EXTERNAL PROVIDER;
GO
EXEC sp_addrolemember 'db_datareader', 'supersimple-app';Replace supersimple-app with your application's display name.
The db_datareader role grants read access to every table in the database. To limit Supersimple to specific schemas, grant SELECT on each schema instead, for example GRANT SELECT ON SCHEMA::dbo TO supersimple;.
2. Configure network access
Allow connections from the following IP addresses:
35.228.195.20435.228.203.89
Configuration steps:
- In the Azure portal, open your Synapse workspace and go to Networking under Security
- Add a firewall rule for each IP address above, using the same address as the start and end IP
- Save the rules
Workspace firewall rules apply to all of the workspace's public endpoints, including dedicated SQL pools. If you use a standalone dedicated SQL pool (formerly SQL DW), add the rules on its logical server's Networking page instead.
3. Set up connection in Supersimple
Provide the following information in the Supersimple connection setup page:
- Host: The dedicated SQL endpoint, such as
your-workspace.sql.azuresynapse.net. You can find it as Dedicated SQL endpoint on your workspace's Overview page. For a standalone dedicated SQL pool, use the server name, such asyour-server.database.windows.net. - Port: Leave empty to use the default port
1433 - Database: The name of your dedicated SQL pool
- Authentication method: SQL authentication or Service principal
For SQL authentication, enter the Username and Password of the login you created.
For a service principal, enter:
- Tenant ID: The Directory (tenant) ID from the application's overview page
- Client ID: The Application (client) ID from the application's overview page
- Client secret: The secret's Value, not its secret ID
