Configuring available server connections for a workspace

When you create a database connection for a live connection database, or export data to an external database, you select the server connection to use.

From the Server Connections section of the workspace settings page, you manage the available server connections for the workspace.

Server Connections section of workspace settings with a defined server connection.

When you create a server connection during database connection configuration or data export, Fabricate automatically adds the server connection to the list.

Adding a server connection

From the Server Connections list, to add a server connection:

Selecting the platform and providing name

1. Click Add Server Connection.

New Server Connection panel to create a server connection

1. From the Platform dropdown list, select the server platform.

2. On the New Server Connection panel, in the Name field, provide a name to use to identify the server connection.

Connection details

Platforms other than Databricks

For platforms other than Databricks:

1. In the Host field, provide the hostname for the server.

2. In the Port field, provide the port to connect through.

3. In the Username field, provide the username to use to make the connection.

4. In the Password field, provide the password.

Databricks

For Databricks:

1. In the Host field, provide the host where the database is located.

2. From the Credential Type dropdown list, select the type of authentication to use. The options are:

   • Service Principal

   • Personal Access Token

3. For Service Principal authentication:

   1. In the Client ID field, provide the client identifier.

   2. In the Secret field, provide the secret that is associated with the client identifier.

4. For Personal Access Token authentication, in the Access Token field, provide the access token to authenticate to the database.

5. In the Warehouse ID field, provide the data warehouse for the data.

Testing and saving the connection

1. To test the server connection, click Test Connection.

2. To save the server connection, click Create Server Connection.

Editing a server connection

To edit a server connection:

1. Click the Edit option for the server connection.

1. On the connection details panel, update the connection information. Note that if you are not changing the password or a Databricks secret for the server connection, then leave the Password or Secret field empty.

2. To test the updated configuration, click Test Connection.

3. To save the changes, click Save Changes.

Deleting a server connection

You cannot delete a server connection that is either:

• Used in a database connection for a live connection database.

• The server connection for a database export target. Before you can delete the server connection, you must remove the export target.

From the Server Connections list, to delete a connection, click its Delete option.