Spaces

This topic covers the space entity of Dremio Sonar. A space is a directory in which views are saved. Spaces provide a way to group datasets by common themes such as a project, purpose, department, or geographic region. Spaces (including a user’s home space) can be further organized by creating a hierarchy of folders.

Home Space

Each user has a home space that can be used to upload local files or experimentation. A user’s home space and the contents of it are private to the user by default. To view your home space, click on the Home Space (house) icon and your username in the Data panel.

Examples

Spaces that are structured by purpose might look like this:

The number that is in the Spaces navigation panel next to each space (for example 9 for the Business space) indicates the number of views in each space (this includes datasets that are stored within a folder in the space).

Paths

Paths are a dot-separated list that indicate the location of a dataset, starting with the name of the source or space in which that dataset resides, followed by any folders or data source structures, and ending in the name of the dataset. A path is used to qualify the dataset when referencing it in a query.

Examples

In the example dataset path reporting.usage.onprem_deployment.daily_usage:

• reporting is the name of the space
• usage and onprem_deployment are folders within the space
• daily_usage is the name of the view

In the example dataset path Sales.Transactions.North-America.salesNY:

• Sales is the name of the space
• Transactions and North-America are folders within the space
• salesNY is the name of the view

Viewing All Spaces

To view all spaces, go to the Datasets page and click Spaces near the top-left corner.

Adding a Space

To add a space:

1. On the Datasets page, click the + button in the Spaces navigation or the Add Space button in the top-right corner.

2. In the Add Space dialog, for Name, enter a unique name.

3. (Optional) For Privileges, enter the name of the user name or role that you want to grant access to. Then click the Add to Privileges button. The added user or role will be displayed in the Users table.

4. (Optional) For the users or roles in the Users table, toggle the green checkmark for each privilege you want to grant for the space that is being created. To remove an added privilege, click the green checkmark.

5. Click Save.

Adding a Folder

To add a folder:

1. On the Datasets page, navigate to the space where you want to add the folder.
2. Click the + button near the top-right corner and select New Folder from the dropdown.
3. In the Add Folder dialog, for Folder Name, enter a unique name.
4. Click Save.

Pinning a Space or Source

By default, spaces and sources are listed alphabetically. Pinned items get moved to the top of the list and are indicated with a (Pin) icon, although pinned items are not saved if you open a new browser or clear the cache.

To pin a space, hover over the space name in the Spaces navigation and click the pin icon that appears. To unpin a space, click the Pin icon again.

Removing a Space

To remove a space:

1. On the Datasets page, click Spaces. A list of spaces is displayed.
2. Hover over the space and click the More (…) icon that appears next to the space.
3. From the list of actions, select Remove Space.
4. Confirm that you want to remove the space.

Removing a Folder

To remove a folder:

1. On the Datasets page, navigate to the folder you want to remove.
2. Hover over the folder and click the More (…) icon that appears next to the folder.
3. From the list of actions, select Remove Folder.
4. Confirm that you want to remove the folder.