Provision a warehouse

Nothing can land in your workspace until a warehouse exists, so provisioning is the first step after signing up. sanda creates the database for you; there is no host, password or database name to fill in.

Before you start

• You need to be an owner or admin. Other members see the Warehouse page but cannot provision.
• Your edition sets how many warehouses you can hold: 1 on Basic, 3 on Standard (and on a trial) and 50 on Enterprise. See sanda warehouse for the full comparison.

Create your first warehouse

What sanda sets up

While the status is provisioning, sanda:

1. creates a new PostgreSQL database in your workspace's data region;
2. creates its schemas: raw, derived, mapping, search and meta (see sanda warehouse), plus a private working area the managed sync uses;
3. creates separate logins for loading, modelling, reading and your own building, each with only the access its job needs, and stores their credentials encrypted;
4. applies your edition's limits from the first minute, so a runaway query is stopped rather than reviewed afterwards;
5. takes a first storage and compute reading, which is the baseline every later reading is measured from.

None of the credentials is shown to you. That is deliberate: the console, cherry and the sync all connect on your behalf.

Names

You do not name a warehouse. sanda names the database after your workspace:

• your first warehouse is becca_ followed by eight characters (digits and the letters a to f), for example becca_1a2b3c4d;
• each further one adds an underscore and four more, for example becca_1a2b3c4d_9f3e.

The name is what you see in the Explorer, the SQL shell and the Modelling warehouse picker.

Add another warehouse

Press New warehouse at the top of the Warehouse page. It appears once you have a warehouse of your own.

If your workspace is already at its limit, sanda tells you how many your edition holds and how many you have. Delete one you no longer need, or move to a larger edition.

Three things to know before you add another:

• Every warehouse is in your workspace's data region. A new one is created in the same region as the first, and a workspace cannot hold a warehouse anywhere else.
• Each connection lands in one warehouse. You choose it on the Configure step when you add the connection.
• The semantic fluid reads one warehouse: the newest healthy one you own. Views and tables in your other warehouses are real and readable in the Explorer and the SQL shell, but you cannot put them on the fluid.

If provisioning fails

A failed attempt leaves a card behind with the reason, rather than nothing at all. The card shows the status error and a Retry provisioning button. A healthy warehouse with no credentials on file shows the same button under the message No credentials on file.

If you would rather start again, use Delete warehouse on the failed card.

Delete a warehouse

Delete warehouse is disabled while any connection still lands in the warehouse. The card says how many, for example 3 connections land here: repoint or delete them before deleting this warehouse. Once none remain, press Delete warehouse, then Yes, delete it (or Keep it to back out).

Usage already measured stays in your billing history, and metering stops when the warehouse is deleted.