Welcome to the Azure Synapse Connector setup guide!
Create a Savant User in Azure Synapse
We recommend creating a specific user and role for Savant with permission to access the required table in Azure Synapse. If you already have a user and role created with appropriate permissions, you can skip this step.
CREATE LOGIN {savant_login} WITH PASSWORD = {password};
CREATE USER {savant_user} FOR LOGIN {savant_login};
Grant Permissions in Azure Synapse
Grant the Savant user privileges to access all tables. Run these commands to grant permissions to the Savant role:
EXEC sp_addrolemember 'db_datawriter', {savant_user};
GRANT CREATE TABLE, CREATE SCHEMA, SELECT, INSERT, ALTER, UPDATE, DELETE, ADMINISTER DATABASE BULK OPERATIONS TO {savant_user};
Check Permissions in Azure Synapse
Run these commands to check privileges to the Savant role:
SELECT roles.principal_id AS RolePrincipalID
, roles.name AS RolePrincipalName
, database_role_members.member_principal_id AS MemberPrincipalID
, members.name AS MemberPrincipalName
FROM sys.database_role_members AS database_role_members
JOIN sys.database_principals AS roles
ON database_role_members.role_principal_id = roles.principal_id
JOIN sys.database_principals AS members
ON database_role_members.member_principal_id = members.principal_id;
GO
Getting Started in Savant
Once you’ve completed the steps above, follow these steps in Savant:
Go to the Systems page and click Add System
Select the Azure Synapse connector and click Next
Enter your system information and credentials from above
Click Authenticate and then Confirm