Managed Databases

A Managed Database is a PostgreSQL database in our infrastructure that belongs to your Tenant alone, for data that has no database of its own yet, such as a CSV export, a file the Sandbox wrote or an Integration’s result. It comes with a Data Source of the same name, through which the agent creates tables in it, loads data into it and queries it.

You find Managed Databases in the Data Studio, under Managed Databases.

Create a Managed Database

You need the Right “Create Data Sources and Managed Databases”. Admins hold it.

1. In the Data Studio, open Managed Databases and select Create Managed Database.
2. Give it a name, and optionally a description for the agent: what it holds and when to use it.
3. Select Create.

The new Managed Database starts empty. Its Data Source appears under Data Sources with the label “Managed Database”, and you hold all three Rights on it. Grant other users access to it as to any Data Source. Managed Databases count towards your Tenant’s limit of 100 Data Sources.

Its Data Source is always Query tool only: its password never leaves our platform, and code in the Sandbox can’t connect to it. You don’t see or replace its connection string.

What the agent may do in it

Through its Data Source, the agent may create tables, load data, change data and delete it, as far as the users who ask it have access. It loads CSV and Parquet files of up to 50 MB from the asking user’s own Personal Drive into a table, without asking first: see Put a file into a Managed Database. Only the Managed Database’s own database user can reach it: no other Tenant’s database user and no other Managed Database’s can connect to it.

How much it holds

The list shows each Managed Database’s size and when it was created. If the size can’t be read for the moment, the list says so; try again later. There is no fixed size limit; we watch the total and get in touch if a database grows very large.

Delete a Managed Database

If you have access to it and the Right “Create Data Sources and Managed Databases”, select Delete under it. The dialog says what happens before you confirm:

• the database is dropped, with every table and row in it;
• its Data Source is deleted with its Query Log, and the agent can no longer query it;
• Cards in Conversations stay readable, with the data they showed;
• Cards on Dashboards show “Data Source deleted” and can’t be refreshed.

Deleting can’t be undone. Its Data Source can only be deleted with it: the Data Sources list offers Edit for it, but no Delete or Replace connection string.

Creating and deleting a Managed Database are recorded in the Audit Log. When your Tenant is off-boarded, its Managed Databases are deleted with its other data.