1. Go to database settings
Get started by selecting Connect your database in the get-started guide, or navigate to the Database screen in settings.
Settings → Database
2. Select database type
Once on the Database settings page, choose the type of database you want to connect to. Steep supports the following databases: BigQuery, MySQL, PostgreSQL, Redshift, Snowflake, SQL Server and Synapse SQL.
3. Fill in connection details
See below for how-to guides on connecting to your specific database.
BigQuery →
MySQL →
PostgreSQL →
Redshift →
Snowflake →
SQL Server →
Synapse SQL →4. Test and save
Before saving your changes, let's test your connection to make sure everything is in order. Tap the Continue button in the Test Connection box.
Any errors will be shown in the box. Correct them and run the test again.
When you get a success message, just hit the save button to continue.
5. IP whitelist
To allow connections to a non-public database, you might need to whitelist (allowlist) Steep’s IP adress. Steep runs all outgoing queries from the following IP adress:
34.78.69.173
Add this IP to your whitelist and test the connection to make sure that it works. See your cloud provider’s docs for information on how to set up IP whitelisting.
IP whitelisting is often needed for connections to MySQL, Postgres, Redshift, SQL Server and Synapse SQL, depending on your cloud settings.