Edit, repair or delete a saved connection
Project Admins change saved connections on the Connections page: go to Data, click the Connections tab and click a connection to open its details. From there you can edit its sign-in, repair it, delete it, or copy a managed database's credentials. For the list itself, see Manage saved connections.
Actions on a connection
| Button | What it does |
|---|---|
| Edit connection | Opens the connection form to change its details, such as a new password, key or sign-in. Built-in connectors only. When you save, Mammoth shows, for example, "Connection Sales Postgres updated". |
| Delete (bin icon) | Deletes the connection. See Delete a connection. |
| Show credentials | Mammoth-managed PostgreSQL and Google BigQuery only. See Get a Mammoth-managed database's credentials. |
Fix a connection that needs attention
The Connectors launcher lists failing connections under Needs attention, with a reason: key expired or unreachable. Click one: the Connections page opens with that connection selected, and:
| Connection | What opens |
|---|---|
| A built-in connector | The Edit connection form, to enter a new key or sign in again |
| A connection the agent built (a REST API) | A new draft, whose chat asks for the key again |
| A Mammoth-managed connection | "Mammoth manages this connection's credentials, so there is nothing to repair here." |
| Any, if you are not a Project Admin | "Only a project admin can repair this connection." |
Delete a connection
- Open the connection and click the delete (bin) icon.
- Read the dialog, titled with the connection's name, such as Delete connection “Sales Postgres”?. It lists what stops working.
- Click Delete connection.
| Listed item | What happens |
|---|---|
| Imports | Each dataset "Stops refreshing. Rows already imported are kept." |
| Exports | Each task "Stops delivering. Rows already delivered stay in the destination." |
| Stored credentials | "You’d re-enter these to reconnect" |
Deleting a connection never deletes data, datasets or pipelines. Its credentials are removed, and everything that used it becomes unconfigured until you point it at another connection. Mammoth confirms, for example, "Connection Sales Postgres deleted. 3 usages are now unconfigured." If nothing uses it, the dialog says "Nothing is using this connection."
A deleted connection does not go to Trash, so you can't restore it: create it again instead. Mammoth-managed connections have no delete button; Mammoth removes one by itself when the last published View that uses it is deleted.
Get a Mammoth-managed database's credentials
Mammoth creates a managed connection when you export a View to a Mammoth-managed PostgreSQL or Google BigQuery database. To connect an outside tool (for example, a BI tool) to that database:
- Open the managed connection and click Show credentials (Project Admins only).
- The Database credentials dialog lists the values. For PostgreSQL: the host, port, username, password and database. For Google BigQuery: the dataset, the service account's email and a link to the service account key.
- Click Copy all to copy them.
Troubleshooting connections
| Symptom | Cause | Fix |
|---|---|---|
| Buttons are disabled, with a permission banner | You are not a Project Admin | Ask a Project Admin to add or change the connection, or to give you Admin access |
| "This workspace is in view-only mode, so connections can't be created or changed. Choose a plan to continue working." | The workspace has no active plan | Choose a plan (see Billing and plans) |
| Health shows Error | The key expired, the source refused it, or Mammoth couldn't reach it | Click Edit connection and enter a new key, or check your firewall (see Allow Mammoth through your firewall) |
| Datasets stopped refreshing after a delete | Deleting a connection leaves its datasets unconfigured | Point them at another connection |
| A link dataset shows Last fetch failed | "The link answered 404" or "The link could not be reached" | Check the URL still returns the file (see Import from a URL) |
For more connection problems, see Troubleshooting.
Related
- Manage saved connections: the list, filters, health and drafts.
- Allow Mammoth through your firewall: fix unreachable connections.
- Send data to a database or BI tool: exports that create managed connections.
- Projects: who is a Project Admin.
Something wrong? support@mammoth.io