User Connections allow secure storage of database and git credentials for easy access in SqlDBM projects. Multiple connections can be defined when working on multiple engagements to allow discrete storage of environment credentials.

User Connections are currently available for all modelers and those with Data Preview add-on. For those who do not have Data Preview enabled, please note that "Managing connections from a project" is currently unavailable for a git connection. (coming soon)

Connections can be accessed from the Dashboard or inside the project menu.

Navigate to the "Account" menu from the Dashboard and click on "User connections" to manage user connections.

From here, create new connections or maintain existing ones

Connections can also be managed from inside a project. To access, click on the blue SqlDBM menu on the top left of the screen and select "Settings and conventions." Next, select "User connections."

Next, select "User connections."

On this screen, you will be able to set an active connection from a list of existing connections or create a new one.

To create a new connection, click the "Create connection" button in the "User connections" Account menu or project settings.

Name your connection and add database and git credentials.

Provide the (development) credentials to your account

Next, select the default database and schema.

These will be used to determine a default location for project objects but can be changed as part of project settings.

On this screen, provide the repository type, URL, and personal token and click "Create".

From the "three-dot" menu to the right of each connection, connections can be edited or deleted.

User connections provide quick access to database credentials and git integrations in the relevant parts of a project.

Please explore the related articles below for in-depth details of how these features work in conjunction with user connections.