In order to connect to a Synapse SQL database, you will need a database user account with read permissions to your data. Then, in the app, enter the host, database, user and password to let Steep connect to your database.
Endpoint for your Synapse SQL pool.
Setting up a user account in Synapse SQL
We recommend that you create a new user and role specifically for Steep. This is best done by connecting to your Synapse SQL pool using Synapse Studio or your database client of choice. See below for a step-by-step guide.
1. Create user and grant access
Example SQL script below. Please replace all <brackets> with your details.
-- Create user CREATE LOGIN steep WITH PASSWORD = '<unique-password>'; CREATE USER steep FROM LOGIN steep; -- Grant access ALTER ROLE db_datareader ADD MEMBER steep;
2. Enter credentials in Steep
Copy the user and password to the corresponding fields in the database form in Steep. Test the connection to make sure things are working fine.