Warehouse overview

The Warehouse is where you manage and view information about the Datasets and Tables you have in Summer.

Datasets are made up of Tables, and Tables are where the data you query lives. Each Dataset and Table has a schema. A Dataset’s schema is a list of the Tables contained within. A Table’s schema lists all its columns and key information about each column.

You can view each Table’s schema by expanding the Dataset row and clicking the Table name. The Table schema includes the following information for each column:

• Name
• Type
• Primary Key
• Nullable

Primary Key refers to whether the column is used to identify unique rows when updating the data in the Table. Nullable refers to whether the column can be null or not.

In Queries, to access a Table within a Dataset, you’ll use the dot syntax, e.g. dataset.table.

Sample Datasets and Tables

When you login to Summer you’ll have two sample datasets and tables that you can explore the platform with.

Dataset: icecream Table: products

Sample Query:

SELECT name, rating
FROM icecream.products

Dataset: icecream_reviews Table: reviews

Sample Query:

SELECT brand, AVG(stars::INT) as average_rating
FROM icecream_reviews.reviews
GROUP BY brand
ORDER BY average_rating DESC

Managing Warehouse access

You can set permissions for Datasets and Tables within your Warehouse view.

Click the icon in the Sharing column for any Dataset or Table to open its Share settings. Here you can set the access level for both your entire Org or individuals Users.

The permission levels available are,

Private — Only applicable to your Org’s permission — Ensures no one in your Org can see or use this item without being granted individual User access.

Viewer — Enables viewing the item in the Warehouse, inspecting the schema and permission settings, and querying in the Workspace.

Editor — All the permissions of Viewer, adding the ability to edit the item. Editing Datasets and Tables is currently not supported in app.

Admin — Grants full access to the item. All permissions in Editor plus the ability to control permissions and delete. Deleting Datasets and Tables is currently not supported in app.