Skip to main content

Intro

You can manage DataSets and user accounts for connectors in the Data Center. Access the Data Center by selecting Data in the Domo navigation.
Screenshot 2024-06-19 at 3.09.04 PM.png
The following tabs are available:

Tab

Icon

Description

Data Warehouse

S ee a three-dimensional visual representation of all DataSets in your Domo broken down by connector.

DataSets

View and manage DataSets added to Domo. For any DataSet, you can access a Details page that provides additional options.

DataFlows

Create and manage DataFlows, DataSets created by combining and transforming two or more input DataSets.

Accounts

Manage accounts used for connecting DataSets to Domo.

Beast Mode Manager

View and manage Beast Modes created on your Cards.

Data Science

View the Data Science Home Page to find the tools you need.

More

View additional options that are enabled in your instance.

You can click the icon to show the names of the above tabs.

Data Warehouse

The Data Warehouse in Domo provides a three-dimensional visual representation of all DataSets in your Domo, broken down by connector, along with data currently flowing into and between them. DataSets for each connector type are represented as stacks on a rotating palette. You can configure the order and height of the connector stacks to indicate different metrics. For example, you could sort the connector stacks by number of rows but have the height of the individual stacks represent the number of DataSets. For more information about The Data Warehouse, see Using The Data Warehouse to Manage Data . In the Data Warehouse tab you have access to a toolbar that provides shortcuts for opening the DomoR installation page .

DataSets and DataFlows tabs

The DataSets and DataFlows tabs list DataSets and DataFlows, respectively, in your Domo instance. In these tabs you can To access Jupyter, you need one of the following two grants enabled: Create Jupyter Workspace or Manage Jupyter Workspace. You can add these grants to a custom Domo role.
  • Create Jupyter Workspace — Allows a user to create, edit, and delete Jupyter Workspaces to which they have access.
  • Manage Jupyter Workspace (Jupyter Admin) Allows a user to view, edit, and delete any Jupyter Workspaces in the instance. This grant is needed to enable workspace sharing for other users.
To use the File Share feature of Jupyter Workspaces, you need one of the following two grants enabled: Create Fileshare Directories or Manage Fileshare Directories. You can add these grants to a custom Domo role.
  • Create Fileshare Directories — Allows a user to create, edit, and delete File Share directories to which they have access.
  • Manage Fileshare Directories — Allows you to view, edit, and delete any File Share directory in this instance.

Enable Jupyter

To start using Jupyter, a Jupyter Admin must enable the feature for your instance. Admins can follow the steps below:
  1. In the navigation header, go to More > Admin.
  2. In the Features menu, select Jupyter.
  3. Activate the feature by adjusting the toggle next to Jupyter Account Inactive.
Your account is activated.
  1. After activating the account, choose the account plan you want:
  • The Default account plan allows all users access to Jupyter and gives all users unlimited usage.
  • The Manual account plan allows specific users access to Jupyter and gives you the option to configure usage limits.
computetierlimit_2_copy.png
  1. Select a Compute Tier Limit. To learn more about tier limits, contact your Domo account team.
  2. Select Save.
Jupyter is enabled, and workspaces can be created.

Access Jupyter Workspaces

In the navigation header, select Data. The Data Center displays. In the left navigation, select More > Jupyter Workspaces.
access jupyter workspaces.jpg

Jupyter Workspaces Tasks

The next sections describe certain tasks within Jupyter Workspaces, including creating a workspace, enabling workspace sharing, sharing a workspace, viewing instances in a shared workspace, running a workspace, editing a workspace, and deleting a workspace.

Create a Workspace

To create a workspace, Jupyter must be enabled for your instance. See the headings for Required Grants and Enable Jupyter for instructions.
  1. In the navigation header, select Data.
  2. In the left side rail, select More > Jupyter Workspaces.
  3. Select + New Workspace . The Create Jupyter Workspace modal displays.
  4. Customize the workspace by configuring the following:
  • In the Name and Description fields, enter a workspace name and optional description.
  • Enter values in the Kernel, Compute Tier Limit, and Timeout fields.
  • (Optional) Select Input DataSets
  • (Optional) Select Output DataSets
  • (Optional) Add an Account. In this step, you can add a third-party account, such as your Google account, to reference in your workspace.
  • (Optional) Add a File Share. See Create a File Share for instructions.
    Note: If you share your workspace with other users, they can see third-party accounts referenced in the workspace. However, they cannot read any account keys or values. To share an account with a user, navigate to Data > Accounts. Input and Output DataSets are also shared with Co-Owners.
The following table describes options to be configured when creating a new workspace:

Option

Description

Name

The name of the Jupyter workspace

The following characters are not supported in the name:

Description

Optional description to provide more details about the workspace

Computer Tier Limit

The computer size that is allocated to the workspace and any data flows that are associated with this workspace

Timeout

The amount of time with no user activity in the Jupyter UI before the workspace automatically stops.

Kernel

Python or R Kernels are available

Start workspace on successful creation

Once created, the process to start the workspace will be performed

Input DataSets

Optional Domo data sources that are available to use in the Jupyter workspace

Output DataSets

Optional DataSets that are available to write data as part of the Jupyter processing

Account

Optional third-party account(s) to reference in your workspace

File Share

Optional avenue to share files within your workspace. To learn more, see the headings for Create a File Share and Use a File Share .

  1. Select Save.
The new workspace is created and added to a list of workspaces on the main Jupyter page.

Enable Workspace Sharing

In order for a workspace to be shared, an Admin or user with the Manage Jupyter Workspace grant must enable sharing.
  1. From the Jupyter Workspaces list, navigate to the workspace you wish to share.
  2. Hover to the right of the workspace. The Manage Workspace menu displays.
  3. Select the Manage Workspace menu and choose Enable Sharing.
The Enable Sharing modal displays.
  1. Select Continue and Confirm. By selecting Confirm, you are acknowledging the risks associated with sharing notebooks and workspaces.
In the Workspace Sharing column, the status is Enabled. The workspace can now be shared with other users by admins or the workspace owner.

Share a Workspace

In order for a workspace to be shared, an Admin or user with the Manage Jupyter Workspace grant must enable sharing. See Enable Workspace Sharing.
  1. From the Jupyter Workspaces list, navigate to the workspace you wish to share.
  2. Hover to the right of the workspace. The Manage Workspace menu displays.
  3. Select the Manage Workspace menu and choose Share this Workspace.
The Manage Sharing modal displays.
  1. Enter the recipient’s name, select the appropriate permissions, and select Add.
  2. Select Save.
The workspace is shared with the recipient(s). They can now add instances to the workspace, and the status of those instances can be viewed in the Status column on the main Jupyter page.
Important:
  • Simultaneous editing is not supported. Please check with other users before editing the same file.
  • If you share your workspace with other users, they can see third-party accounts referenced in the workspace. However, they cannot read any account keys or values. Input and Output DataSets are also shared with Co-Owners.

View Instances in a Shared Workspace

When a workspace is shared, other users can add an instance to the workspace. In the image below, the workspace has sharing enabled and has been shared with one other user.
Screen_Shot_2022-10-12_at_11.56.21_AM.png
To see which instances are running in the workspace, select others.
Screen_Shot_2022-10-12_at_11.56.21_AM.png
In the image below, only one instance is running in the workspace.
Screen_Shot_2022-10-12_at_12.29.41_PM.png

Run a Workspace

  1. From the Jupyter Workspaces list, select the workspace you want to run.
The Start this Workspace modal displays.
  1. Select Start.
Screen_Shot_2022-10-12_at_11.52.53_AM.png
The workspace will load for several seconds. This is normal.
Screen_Shot_2022-10-12_at_12.39.17_PM.png
  1. After the workspace is done loading, select the workspace title.
The workspace opens, and the notebook can be edited.
Screen_Shot_2022-10-12_at_12.43.30_PM.png
If two users edit the same file, the File Changed modal displays. You can overwrite changes the other user made or revert your changes.
Screen_Shot_2022-10-12_at_11.50.37_AM_copy.png

Edit a Workspace

  1. From the Jupyter Workspaces list, locate the workspace you wish to edit.
  2. Hover to the right of the workspace. The Manage Workspace menu displays.
  3. Select the Manage Workspace menu and choose Edit.
The Edit Jupyter Workspace modal displays.
  1. Add new specifications to the workspace and select Save.
The workspace is updated with new details.

Delete a Workspace

  1. From the Jupyter Workspaces list, navigate to the workspace you wish to delete.
  2. Hover to the right of the workspace. The Manage Workspace menu displays.
  3. Select Manage Workspace menu and choose Delete.
The Delete Test? modal displays.
  1. Confirm that you wish to delete the workspace by selecting the Delete button.
The workspace is deleted. This action cannot be undone.

File Sharing

You can create and add a File Share to your Jupyter Workspace. The following headings describe how to create a File Share, add it to your workspace, and delete a File Share from your workspace.

Create a File Share

Follow these steps to create a File Share to use in Jupyter Workspaces. See the heading for Use a File Share to learn how to connect a File Share with Jupyter Workspaces.
  1. In the Domo navigation header, select Data.
  2. In the left side rail, select More > File Share.
  3. Select + New File Share. The Create a File Share modal displays.
    create a file share modal.jpg
  4. Customize the File Share by configuring the following:
    • In the Name and Description fields, enter a File Share name and optional description.
    • In the Default Mount Point field, enter a path. This can be whatever you would like.
  5. Select Save to create the new File Share.

Use a File Share

Note: If the workspace is already running and you add a File Share, you must restart the workspace before the File Share displays in the list.
The process outlined below allows you to use a File Share that you have created. To learn how to make a File Share, see the heading for Create a File Share. While you are creating or editing a Jupyter Workspace, you can add a File Share that you have created. Follow the steps below to add a File Share in the Create Jupyter Workspace or Edit Jupyter Workspace modal. To learn how to access these modals, see the headings for Create a Workspace and Edit a Workspace.
  1. In the File Share section of the modal, select Add File Share.
  2. In the search field, search for and locate the File Share you want to add to the workspace.
  3. Select the File Share.
  4. The File Share displays in the modal. By default, the Mount Point is the default Mount Point, and the checkbox for Use default is checked. To use a different Mount Point, uncheck the Use default checkbox and expand the list to select the Mount Point you want to use.
    file share default.png
    mount path.png
  5. Select Save Workspace.
The File Share is added to the workspace and can also be viewed in the File Browser in Jupyter Notebooks.
Screenshot 2023-06-07 at 2.37.54 PM.png

Delete a File Share

  1. Access the Create Jupyter Workspace or Edit Jupyter Workspace modal. To learn how to access these modals, see the headings for Create a Workspace and Edit a Workspace.
  2. In the File Share section of the modal, identify the File Share you want to delete and select the kebab menu.
  3. Select Delete.
    select kebab menu.png
The File Share is deleted from the workspace.

Jupyter Notebooks

A Jupyter notebook is a file that consists of one or more cells. In these cells, you can write and format text, as well as write code using Python or R programming languages. When you execute the contents of a cell, the resulting output associated with the text or code displays directly in the notebook. The output can take various forms such as text, figures, tables, and images. You can add, edit, move, duplicate, re-run, and delete cells within a notebook at your discretion. You can also run cells sequentially to perform different phases of your project one after the other. For example, the first cell in your notebook could contain code to read in your DataSet; the second cell could then contain code that specifies what analysis to run on the DataSet. See Cells to learn about the types of cells, how to add them to a notebook, and how to execute them. Because a Jupyter notebook file can display executable code and the associated code output, along with explanatory text and images, a notebook can serve as a complete record of your interactive session. You can save a Jupyter notebook to your Jupyter workspace, enabling you to access your notebook and its contents in the future. Jupyter notebooks are internally JSON files and are saved with the.ipynb extension. You can also download a notebook from your workspace and save it elsewhere or share it.
Note: You can create and save multiple Jupyter notebooks within a single Jupyter workspace.
This image displays an example of a Jupyter notebook.
example jupyter notebook.png
In the File Browser in Jupyter Notebooks, you can navigate between notebooks and even see associated File Shares.
Screenshot 2023-06-07 at 2.37.54 PM.png

Edit Jupyter Notebooks

Important: To edit a notebook, you first have to create and then start (or run) a workspace. See Create a Workspace and Run a Workspace for more information.

Create a Notebook

Follow these steps to create a notebook:
  1. In the Jupyter workspace, select File > New > Notebook. The Select Kernel modal displays.
    file new notebook.png
  2. Press Select. A notebook named Untitled.ipynb opens in the main work area. The untitled notebook also displays in the File Browser in the workspace side panel.
    untitled notebook.jpeg

Rename a Notebook

You can rename a notebook either from the main work area or from the File Browser, depending on whether the notebook is open or closed. Select the appropriate option below:
  • Notebook open — In the main work area, right-click the title of the notebook to display the notebook options and select Rename Notebook. The Rename File dialog displays. Enter a new name for the notebook and select Rename.
    rename notebook.png
  • Notebook closed — In the File Browser, right-click the title of the notebook that you want to rename to display the file options, then select Rename. Enter a new name for the notebook. For a DataSet, you can view information about the DataSet, including the connector, the name, the owner, the number of rows and columns in the DataSet, the number of cards being powered by the DataSet, the total number of times these cards have been viewed, and the amount of time since the DataSet was last updated. You can also preview or delete a DataSet. For a DataFlow, you can view information about the DataFlow, including the name, owner, number of input and output DataSets, number of runs vs. success rate, and the amount of time since the DataFlow was last run. Both tabs include options for searching with or without filters, applying quick filters, saving favorite filters, and sorting the DataSets/DataFlows in the list.
  • add DataSets and DataFlows From either tab you can…
  • visually identify DataSets needing attention DataSets with errors do not run as scheduled until errors are resolved.  Domo lets you know when a DataSet cannot run successfully by displaying the error on the DataSet in the Data Center and in the Accounts page, and by sending the owner of the DataSet an alert that describes the error and links to the DataSet.
The following screenshot points out the most important parts of the DataFlows and DataSets tabs. (This screenshot is specifically from the DataFlows tab, but the only difference between the two tabs is different information in the rows.)
data_center_new.png
You can learn about these components in the following table:

Name

Description

Search

Lets you search for the desired DataSet/DataFlow in the list. This search draws from a variety of metadata, including name, connector, owner, tags, status, and more. You can refine your search by doing any of the following:

  • Clicking a recommended filter. These may appear when you enter a search term or part of search term in the field.

    data_center_recommended_filters.png
  • Adding a custom filter. You do this by clicking Add Filter , selecting the desired filter from the list, then entering the filter criteria as required. For example…
    • If you selected Owned By , you would be prompted to enter the owner of the DataSet or DataFlow you wanted to view.

    • If you selected DataFlow Type , you would be prompted to select the desired DataFlow type from a list.

    • If you selected Last Updated , you would be prompted to specify whether the DataFlow or DataSet was last updated on, before, or after the given date, then select the date itself.

  • Changing the sort used in the list. You do this by clicking in the menu in the top right corner of your search results (shown as “Relevance” in the above screenshot) then choosing the desired sort type.

    For DataSets, you can sort by relevance, name, number of cards, number of rows, last run date, or status (broken DataSets are shown first).

    For DataFlows, you can sort by relevance, creation date, last modified date, name, status (broken DataFlows are shown first), success rate, or last run date.

Add Filter Lets you filter the DataSets or DataFlows in the list. This option is described in more detail in the entry for “Search,” above.
Favorite Filter icon

Lets you save the current filter configuration. When you click this icon, you are prompted to enter a unique name for the filter. When you save the new filter, the star icon turns gray and the filter appears under Favorite Filters in the panel on the left side of the screen. You can then click this filter anytime to apply it.

You can remove a saved filter by clicking the gray star icon and then choosing Remove .

You can also do a “Save As” on a saved filter. This is useful when you make changes to an existing filter and want to keep both filters. To do this, you click on the gray star icon, enter the new filter name in the name field, click Update , then select Save As New Filter .

These options are also available via the Favorite Filters area in the panel on the left side of the screen. If you mouse over a filter here, a gear icon displays. Clicking this icon reveals the following options:

  • Rename . Lets you rename a saved filter.

  • Duplicate . Lets you do a “Save As” on the filter. When you save the filter in this way, a second version of the filter appears in the list, with the word “copy” appended to it. You can rename it if you want using the Rename option described above.

  • Delete . Removes the filter.

Sort

Lets you sort the DataSets or DataFlows in the list. This option is described in more detail in the entry for “Search,” above.

Quick Filters/Favorite Filters

Lets you quickly apply any prebuilt filters ( Quick Filters ) or saved filters ( Favorite Filters ).

Available Quick Filters include the following:

  • All DataSets/All DataFlows . Removes all filters from the list. This is a good way to “reset” the list after you have applied many filters.

  • Recently run . Filters to show only those DataSets/DataFlows that have been run in the last several days.

  • Owned by you . Filters to show only those DataSets/DataFlows you are the owner of.

  • Needs attention . Filters to show only those DataSets/DataFlows in a broken state (indicated by a red exclamation point on the DataSet/DataFlow in the list).

Favorite Filters are those filter configurations you have saved. These are described in more detail in the entry for “Favorite Filter icon,” above.

DataSets/DataFlows

Display information about each DataSet or DataFlow. For DataSets, this information includes the name, connector, owner profile picture, number of rows and columns, number of cards powered by the DataSet, any tags, and the last update time. For DataFlows, the information includes the name, owner, number of input and output DataSets, number of runs versus the success rate, any tags, and the last run time.

For each DataSet or DataFlow, you can do the following:

  • Click the photo to open a user avatar card with information, including a list of groups to which the user belongs, card view statistics, and a Follow button so you can follow this user in Buzz.

  • Click the DataSet or DataFlow name to open the details view for the DataSet or DataFlow, which provides additional options. For example, for a DataSet, you can see a preview of the data, cards being powered by the DataSet, a run history, and so on.

  • Mouse over the row to reveal a wrench icon that provides access to various options for interacting with this DataSet or DataFlow. These options are listed in the entry for “Options,” beow.

  • Add search tags to this DataSet or DataFlow so you can more easily find it later. This is described in more detail in the entry for “Add Tag,” below.

  • Take bulk actions on DataSets or DataFlows. You can select an initial DataSet or DataFlow to take action on by mousing over the row then clicking the checkbox that appears in the top left corner of that row. This pops up a blue bar along the top of the screen with new options. From here you can do all of the following:

    • Select more DataSets/DataFlows by mousing over them and checking their checkboxes.

    • Select all DataSets/DataFlows currently appearing in the list by clicking Select All in the blue bar.

    • Tag selected DataSets/DataFlows by clicking the icon on the right side of the blue bar. For more information about tagging, see the entry for “Add Tag” in this table.

    • Apply additional actions by clicking the icon on the right side of the blue bar then selecting the desired option:

      • Run Now . This executes all of the selected DataSets or DataFlows.

      • Change Owner. This allows you to select a new owner for the selected DataSets or DataFlows. For more information, see Changing the Owner of a DataFlow .

      • Delete . This allows you to delete all of the selected DataSets or DataFlows. To delete DataSets you must have an “Admin” security profile or be the DataSet owner. For more information, see Disabling or Deleting a DataFlow .

For a DataFlow, you can also mouse over the “Inputs/Outputs” data to show all of the input and output DataSets for this DataFlow.

Add Tag

Lets you add search tags to this DataSet or DataFlow so you can easily find it later by searching for those tags. When you click Add tag , a dialog appears with a list of existing tags. (If no tags have yet been added for your company, this list appears blank.)

data_center_tags_dialog.png

You can then do either of the following:

  • Add existing tags to the DataSet or DataFlow by clicking them in the list. Any tags that have already been added appear blue. You can filter the tags in the list by entering the desired tag name in the Search and add tags field.

  • Add a new tag to the DataSet or DataFlow by entering the tag name in the Search and add tags field. If the tag does not yet exist, it appears alone in the list area with the “Create new tag” designation. You can then click it to add it to the DataSet or DataFlow.

You can remove a tag from a DataSet or DataFlow by clicking the “x” next to the tag while in this dialog.

You can also access the tagging functionality by doing any of the following:

  • Selecting View Tags in the options menu for a DataSet or DataFlow in the list view.

  • Selecting Tags in the options menu for a DataSet or DataFlow details view.

  • Clicking Add tag under the DataSet name in the details view (DataSets only).

You can add tags to multiple DataSets or DataFlows at once by selecting the DataSets or DataFlows (by checking their checkboxes), clicking to open the tagging dialog, then adding tags as desired. For more information about this dialog, see the entry for “Add Tag” in this table.

While in the list view for a DataSet or DataFlow, if you click a tag, the list filters to show only DataSets and DataFlows with that tag.

Options icon

Displays a menu of options for the DataSet or DataFlow. Appears when you mouse over the row for a DataSet or DataFlow.

For a DataSet, available options are as follows:

  • View Details . Opens the Details view for this DataSet. In this view you can see an overview of the DataSet, previews of the cards powered by the DataSet, and a run history.

  • View Tags . Opens the tag dialog for this DataSet. For more information, see “Add Tag” in this table.

  • Preview . Opens a preview of the data in this DataSet.

  • Delete . Deletes this DataSet. You can delete DataSets owned by other users only if you have an “Admin” security role or a custom role with the “Manage DataSets” privilege enabled. For information about custom roles, see Managing Roles .

For a DataFlow, available options are as follows:

  • Details . Opens the Details view for this DataFlow. In this view you can set scheduling options, view input and output DataSets, see the run history, and access a list of previous versions of the DataFlow.

  • Edit . Opens the editor for the DataFlow.

  • View Tags . Opens the tag dialog for this DataFlow. For more information, see “Add Tag” in this table.

  • Run . Runs this DataFlow, which updates the input and output DataSets. For more information, see Running a DataFlow .

  • Disable . Disables the DataFlow, preventing DataSets powered by the DataFlow from running. For more information, see Disabling or Deleting a DataFlow .

  • Notifications . Lets you choose whether you want to receive email notifications when the DataFlow fails to update. For more information, see Configuring Notifications for Failed DataFlows .

  • Create Copy . Does a “Save As” on this DataFlow. Copied DataFlows can be renamed, edited, saved, and run independently of their original DataFlow. For more information, see Copying a DataFlow .

  • Delete . Deletes this DataFlow. You can delete DataFlows owned by other users only if you have an “Admin” security role or a custom role with the “Manage DataFlows” privilege enabled. For information about custom roles, see Disabling or Deleting a DataFlow .

Important: If you delete a DataSet that powers any cards, the cards display a “Data not loading” message.

Tips:
  • You can view DataSets for a specific third-party application or data provider from the Launcher page.
  • In the Profile page, you can view all of the DataSets owned by a user.

View Details

When you click the name of a DataSet or click > View Details , a page appears showing details for the DataSet. This page is divided into a number of tabs. Some of these tabs appear for every DataSet you view, while others only appear for specific user roles and connector types. These tabs are Overview, C ards , History , Settings , Data Lineage , and Personalized Data Permissions . For more information, see Adding a DataSet Using a Connector . Video - Domo Interface - DataSet Details
  • The Overview tab includes four tiles that show you the number of cards powered from this DataSet, the number of users it is being shared with, the number of DataSets built from the connector, and the number of DataFlows created from the DataSet. All of these tiles also provide “jump-off points” to other actions in Domo using this DataSet.
  • The Cards tab contains previews of cards powered by the DataSet.
  • The History tab shows the run history for the DataSet and only appears if the DataSet has run history data.
  • The Settings tab lets you change the connector configuration options for the DataSet. It only appears if you are the DataSet owner or have an “Admin” security role or a custom role with the “Manage DataSets” privilege enabled.
  • The Data Lineage tab shows you the lineage for this DataSet.
  • The Personalized Data Permissions tab allows you to set PDP policies on the DataSet and does not appear unless you are the DataSet owner or have an “Admin” security role or a custom role with the “Manage DataSets” privilege enabled.
For more information, see Connecting to Data with Connectors .

General options

The following screenshot shows the details view for a sample DataSet called “College Enrollment.” All of the options called out here are available in all tabs.
DataSet_Overview_Tab.png
You can learn about these components in the following table:

Name

Description

Connector

The connector for this DataSet. For more information about connectors, see Configuring Each Connector .

DataSet description

A description of this DataSet. You can add or change a description by selecting Edit Name & Description in the Options menu then entering the desired description.

DataSet name

The name of this DataSet. You can add or change a name for a DataSet by selecting Edit Name & Description in the Options menu then entering the desired name.

Number of columns and rows

A size indicator for the DataSet.

Add tag option Lets you add search tags to this DataSet. If any tags have already been added, they appear here. Adding tags is described in more detail in the previous table.

Most recent update time

Indicates when this DataSet was last refreshed. For more information, see Setting the Expected Update Frequency for a DataSet .

Owner

Shows who owns this DataSet. You can click a user’s photo to see an avatar card with his or her basic information and a Go To Profile button that provides access to the Profile page. For more information about the Profile page, see Profile Page Layout .

DataSet Overview

Shows how this DataSet is being used.

Tabs

Let you switch between the tabs in the details page for the DataSet. Information about each tab is provided later in this section.

Edit Webform

Edit Webform (Webforms only). Lets you edit the data for this Webform. For more information, see Uploading a webform .

Open with menu

Provides access to a number of options for the DataSet. Some options may not appear, depending on the Connector and your security role.

Options icon

Provides access to a number of options for the DataSet. Some options may not appear, depending on the Connector and your security role.

  • Edit Name & Description. Lets you open a dialog in which you can change the name and description of this DataSet.

  • Tags . Lets you add search tags to this DataSet. Adding tags is described in more detail in the previous table.

  • Notifications . Lets you subscribe to or unsubscribe from email notifications for the DataSet.
  • Request certification . Lets you request the DataSet be certified.
  • Chart color rules . Lets you apply color rules to the columns in this DataSet. For more information, see Setting Color Rules for a Chart .
  • Share DataSet . Lets you share the DataSet with users.
  • Export data . Lets you export this DataSet to an Excel or CSV file. For more information, see Exporting DataSets .

  • Run Now. Updates the DataSet, causing any connected cards to be updated as well.

  • Delete. Deletes the DataSet. You can delete a DataSet only if you are the owner or have an “Admin” security profile or a custom role with the “Manage DataSets” privilege enabled. For more information about security profiles, see Managing Roles .

Overview tab

In the Overview tab you can see how the DataSet is being used, the number of Cards powered from this DataSet, the number of users it is being shared with, the number of DataFlows created from the DataSet, and the number of Alerts on the DataSet. All of these tiles also provide “jump-off points” to other actions in Domo using this DataSet. The following screenshot shows an example of these tiles in the Overview tab for a typical DataSet.
Overview_Tab.png
“Jump-off points” for these tiles are as follows:
  • View Full Impact opens the Lineage tab for the DataSet.
  • Create A Visualization opens the Analyzer for this DataSet so you can build a chart or table from it. For more information about Analyzer, see Analyzer Overview .
  • Share This DataSet opens the menu to share the DataSet with users.
  • Tidy Up This DataSet opens the interface for building an ETL DataFlow using this DataSet.
  • Create A New Alert opens the interface for creating an Alert on the DataSet.

Data tab

In the Data tab, you can do all of the following:
  • View all of the rows in the DataSet, and sort and filter to show the data interests you.
  • See statistics for individual columns or for the entire DataSet.
  • Change the order of columns in the DataSet.
  • Rename columns in the DataSet.
  • Add or edit column descriptions.
  • Add search tags for columns.
The Data tab is made up of three subtabs — Table , Schema , and Stats . You can switch between the subtabs by clicking the desired subtab name in the upper right corner of the Data tab.
Data_Subtabs.png
In all three subtabs, you can search for and filter to a specific column or columns in the DataSet by entering the desired column name in the Search Columns field.
Search.png
You can enlarge the column pane to fill the whole screen by clicking or restore it to its original size by clicking . You can Show column statistics/Hide column statistics by clicking . This allows you to show or hide the “filter charts” that appear at the top of the column pane in the Table subtab. Appears in the Table subtab only.

Table subtab

In the Table subtab, you can see all of the columns in your DataSet. Options are available for searching, sorting, and filtering so you can find the data you need. The following screenshot shows the components of the Table subtab:
Table_Layout.png
You can learn about these components in the following table:
Name Description

Sort button

Lets you sort the values in a given field in ascending or descending alphanumerical order. Sorts are “nested” based on the order in which you apply them. The numeral beneath the sort icon tells you the priority of this column in your sort.

For example, if a user first applied an ascending sort to the “Transaction ID” column, all of the rows in the DataSet would be ordered in numerical order. If he then applied an ascending sort to the “SKU” column, the groupings of rows for each SKU would be ordered numerically. If he finally applied a third sort, descending, to the “Zip Code” column, those values would be sorted in descending order for each transaction-SKU grouping.

The following screenshot shows an example of this behavior:

Sort_Example.png

Info button

Shows the description for this column, if you have added one in the Schema subtab.

Data type icon Indicates the data type for this column. indicates a numeric (value) column, indicates a date or date-time column, and indicates a string column. For more information about data types, see Understanding Chart Data .
Filter chart

Lets you filter the data in the DataSet based on the values in a given column. Different chart types appear for columns depending on the data type for that column.

For text (string) columns, a horizontal bar appears, divided into segments for each unique name in the column. You can filter the data in the DataSet to a particular name by clicking on that section in the bar. (Names appear as hovers when you mouse over a section.) In the following example, the user could filter the DataSet to show only the data for “Delivery Truck” by clicking on the corresponding bar.

data_tab_table_bar.png

For date/date-time and value columns, a vertical bar chart with a horizontal slider appears. You can filter the data in the DataSet to show dates or values above or below a certain threshold by sliding the bar accordingly. In the following example, the user could filter the DataSet to show only values of .05 or higher by sliding the bar to “.05.”

data_tab_table_slider.png

Schema subtab

In the Schema subtab, you can reorder the columns in your DataSet, add descriptions and tags, etc. The following screenshot shows the components of the Schema subtab:
Schema_Tab.png
You can learn about these components in the following table:

Name

Description

Search field

Lets you search for and filter to a specific column or columns in the DataSet.

Reorder icon

Lets you change the order of columns in this DataSet by clicking and dragging a column into the desired position. Note that this option is only available for the “Index” column, and only when sorting has been applied to that column. So, for example, you could not sort by column name and then click and drag to reorder columns.

Sort button

Lets you apply an ascending or descending sort to the column. Note that this sort only changes the order of column names in the Schema subtab so you can more easily find what you’re looking for. It does not change the actual order of columns in the DataSet. If you want to change the column order, use the Reorder icon.

Column description

Lets you enter a description for a column or edit an existing description.

Column tags

Lets you enter search tags for this column. For more information about tags, see the table under DataSets and DataFlows Tabs .

Stats subtab In the Stats subtab, you can see Domo-generated statistics for the columns in your DataSet. For numeric and date/date-time columns, you can correlate the columns against other numeric columns in the DataSet, and for text columns, you can see the highest aggregated values for the sum or count of any selected column. The following screenshot shows the components of the Schema subtab:
Stats_Subtab.png
You can learn about these components in the following table:

Name

Description

Search field

Lets you search for and filter to a specific column or columns in the DataSet.

Column stats row

Shows statistics for a given column.

Statistics for date/numeric column

Shows automatically-generated statistics for a numeric or date/date-time column. Available statistics include minimum, maximum, average, median, upper and lower quartile, and standard deviation.

Statistics for string column

Shows automatically-generated statistics for a string column. Available statistics include shortest string, longest string, and average length.

Correlations chart

Shows correlations for numeric and date/date-time columns. For the given numeric or date/date-time column, you can select any other numeric column and see how the two columns correlate.

Aggregations chart

Shows the five highest aggregated values of the given column from the selected column. If the selected column is numeric, the values are summed; otherwise the values are counted. For example, in the above screenshot, the user has chosen to view the five highest aggregated sales values for the “Customer Name” column. He does this by selecting “Sales” in the Aggregations dropdown for the “Customer Name” column.

Cards tab

The following screenshot shows the components of the Cards tab:
Cards_Tab.png
You can learn about these components in the following table:
Name Description

Connected Cards

All cards powered by this DataSet. You can click on a card to see the Details view for that Card.

Tip: You can view Cards powered by a specific third-party application or data provider from the Launcher page.

Switch cards to a different DataSet option

Allows you to move all of the Cards powered by this DataSet to another DataSet. This option appears if you are the owner of the DataSet, depending on the DataSet type. For more information, see Connecting Cards to a Different DataSet .

Add Card option

Lets you power up a Card using the DataSet. Select the DataSet from the list to use it in powering a card. By default, the Card is added to the Overview page in Domo. This option may not appear, depending on the DataSet type. For more information about this option, see Powering a Visualization Card with Data .

History tab

In the History tab, you can see a listing of all of the times this DataSet has been updated. This tab shows the start and end times for all updates, the amount of time the update took (duration), whether the update was scheduled or manual, and the result of the update (successful or failed). You can also see the amount of time that has transpired since the last successful run, the average update duration, and the overall success rate. Finally, for any history item, several actions are available by mousing over the row and clicking the wrench icon. The following screenshot shows an example of a History tab for a DataSet called “Compensation Costs”:
History_Tab.png
Action items available by clicking the wrench icon are as follows:
  • Preview updated rows . Displays the rows in the DataSet that were changed when this update occurred.
  • Download . Downloads the data in this version of the DataSet as a flat text file that can be opened in an Internet browser or word processor.
  • Delete this update . Deletes this version of the DataSet from your history.
  • Revert to this point . Reverts the DataSet to this version.
Actions are available only for successful updates.

Settings tab

In the Settings tab for a DataSet, you have access to the options used to set up this DataSet, similar to the view that appears when you initially configure a connector DataSet. Click a row to open up the settings in that row for viewing and editing. Settings categories may differ between connectors. For more information about connector configuration options, see Adding a DataSet Using a Data Connector .
Settings_Tab.png

Data Lineage tab

In the Data Lineage tab for a DataSet, you can see the DataSets that have been combined and/or transformed through DataFlows or DataFusion to yield this DataSet. The Data Lineage interface in Data Center is the same as that used for a DataSet in Analyzer. For more information, see Viewing the Lineage of a DataSet in Analyzer .

Personalized Data Permissions (PDP) tab

Personalized Data Permissions (PDP) allow you to create a customized experience for each Domo user through the definition of Entitlement Policies. Using Entitlement Policies, you can filter data in a DataSet for specified users and/or groups. For more information, see Personalized Data Permissions (PDP) . The following screenshot points out the most important parts of the PDP tab:
PDP_Tab.png
You can learn about these components in the following table:

Name

Description

Search field

Lets you search for existing policies that have been added to this DataSet.

Policy row

Shows information about a policy, including its name, the rows of data it provides access to, and the groups and users the policy has been applied to.

Enable PDP toggle

Activates/deactivates this PDP policy.

Impact button

Opens a list of cards and alerts that will be affected by PDP policies on this DataSet.

Add Policy button

Lets you add a new PDP policy to this DataSet. For more information about adding a PDP policy, see Personalized Data Permissions (PDP) .

View Details (DataFlows)

When you click the name of a DataFlow or click > View Details , a page appears showing details for the DataFlow. This page is divided into tabs—​​ Settings , DataSet s , History , and Versions . For more information about these tabs, see Viewing DataFlow Details .

Editor view (MySQL and Redshift DataFlows)

The following screenshot shows you the main components of the Create / Edit DataFlow view for a MySQL or Redshift DataFlow.
dataflow_layout.png
You can refer to the following table to learn more about each component:

Name

Description

DataFlow Type & Info

When collapsed, this panel displays the type of DataFlow and the schema.

When expanded (by clicking ), this panel displays information about the RDS instance for this DataFlow, including the host name, schema, user name, password, and port number. You can copy and paste this information into any SQL tool, including Workbench.

DataFlow Name & Description

Allows you to specify a name and description for this DataFlow.

Input DataSets

Allows you to select one or more existing DataSets for use in creating DataFlows. You can choose as many input DataSets as you want. For any given transform or output, you can use one, some, or all of the DataSets you select here. This is essentially a storage area for DataSets you may potentially use. You cannot manipulate data in the DataSets at this stage. You also cannot select the same input DataSet twice in the same DataFlow.

Note: Input DataSets in a DataFlow must already exist in Domo; you cannot upload new DataSets in the Create DataFlow view. For information about uploading new DataSets to Domo, see Adding a DataSet Using a Data Connector .

You can click an input DataSet you have added to see a preview of the DataSet.

Transforms

Allows you to manipulate data in your input DataSets using SQL statements before you make your final manipulations in the Output DataSets stage. The Transforms stage is optional. All input DataSets you have selected are available for use in transforms.

Output DataSets

Allows you to specify how your input DataSets are to be combined to produce one or more output DataSets. This interface is almost the same as that of Transforms. However, while adding transforms is optional, the Output DataSets stage is required; otherwise you cannot save your DataFlow. All input DataSets and transforms you have selected/created for this DataFlow are available to be used in your Output DataSet SQL.

Save buttons

Allow you to save this DataFlow. Two separate buttons are available: Save and Save and Run . Save saves changes you have made to this DataFlow and adds it to the DataFlows listing in the Data Center but does not generate a DataSet (or, if you are editing an existing DataFlow, it does not update the output DataSets). Save and Run saves changes to the DataFlow and adds it to the DataFlows listing in the Data Center and runs the script for the DataFlow to output a DataSet (or update the output DataSets if it has already been created).

For more information about DataFlows, see SQL DataFlows .

Editor view (Magic ETL DataFlows)

For times when you need to transform your DataSets before you can make compelling visualizations, you can use Magic ETL DataFlows to transform multiple DataSets into a new DataSet that you can use to power up cards.
Tip: ETL means Extract, Transform, and Load, which refers to a process in database warehousing for extracting data, transforming it into proper format or structure for querying and analyzing purposes, and loading it into the target data warehouse. In Magic ETL DataFlows, your DataSets are extracted and loaded automatically, and transformed based on actions in the Magic ETL DataFlow.
Magic ETL DataFlows let you visually define and sequence operations to transform your Domo DataSets—without learning SQL or leaving Domo. For information about the Magic ETL DataFlow tiles, see all of the following: ETL DataFlow Example
ETL_Example.png
The UI for ETL DataFlows consists of the following elements:

Element

Description

Action pane

Contains the transform tile you can drag and drop into the canvas to use in transforming data.

For more information, see the following topics:

Canvas

Contains your transformation flow—the sequence of tiles to perform on input DataSets to save as an output DataSet. You connect tiles to sequence them and select tiles to configure them.

Lets you preview the transform tile.

Lets you schedule the Magic ETL DataFlow to run whenever the specified input DataSets change.

Lets you show or hide the Magic ETL DataFlow checklist, which shows a list of things to do before you can save a Magic ETL DataFlow.

ETL DataFlow checklist

The checklist shows a list of things to do before you can save a Magic ETL DataFlow. You can show the checklist by clicking at the top of the canvas. The following example illustrates essential tasks to perform before saving a Magic ETL DataFlow.
ETL_Checklist.png
Essential tasks include the following: For more information about DataFlows, see Viewing Dataflow Details .

Accounts tab

In the Accounts tab, you can manage third-party system accounts associated with DataSets in Domo. You can view accounts associated with DataSets; add, edit, or delete accounts; and associate DataSets with another account.
Tip: By creating accounts to data source systems, you can specify and maintain your credentials in one central place, then create DataSets in Domo using the account—without having to specify your credentials to the data source system.
In the Accounts tab, you can
  • add user accounts for different connectors (similar to a DSN)
  • view a list of user accounts you have added
  • disconnect accounts you have added
  • share accounts with other users
  • see DataSets you have access to
  • transfer DataSets from one account to another account
  • change account associations
  • rename accounts
  • visually identify DataSets needing attention
  • edit credentials for accounts that require manual authentication (as opposed to those that use OAuth)
The following screenshot calls out the most important parts of the Accounts tab:
accounts_tab2.png
You can learn about these components in the following table:

Name

Description

Search box Lets you filter the accounts in the list.

Add Account button

Lets you add a new user account to this list.

Add Federated button

Lets you add a Federated account to this list.

Assign Someone button

Lets you assign someone to create an account for a specific Connector.

Connector accounts

Provide information and options for all accounts you have used to connect to data sources, including the account name, the usernames or handles you use to connect, and options such as share, reconnect, etc.

For each account, you can ado the following:

  • Click an account to open a panel in which you can edit the account information. For all accounts, you can edit the name. For non-OAuth accounts (those in which you must authenticate manually), you can also edit the account credentials.

  • Mouse over the DataSets item to see a list of DataSets powered by this account. These are categorized according to whether they are owned by you or another user. You can click a DataSet to open the Details view for that DataSet. You can also transfer ownership of the account to another user or change the account credentials for multiple DataSets.

  • Mouse over the account to display the Options icon.

Options icon

Lets you access various options for working with this account, including the following:

  • Edit account . Lets you edit the name and credentials for this account.

  • Share account . Lets you share user accounts with others so they can access the DataSets through the connector.

  • Reconnect . Lets you reconnect any connectors that use oAuth for authentication. If the connector requires manual authentication, this icon does not appear.

  • Delete account . Lets you remove an account, in which case any associated DataSets depending on the account to power up cards may stop functioning.

For more information about managing user accounts, see Managing User Accounts for Connectors .

Beast Mode Manager tab

In the Beast Mode Manager tab in the Data Center, you can view statistics on Beast Mode usage as well as perform various actions, such as editing formulas, locking and unlocking calculations, deleting unwanted calculations, and so on. The following screenshot calls out the most important parts of the main screen (Overview) of the Beast Mode Manager tab:
beast_mode_manager_layout_overview.png
You can learn about these components in the following table:

Name

Description

List of calculations

Shows all of the calculations in your Domo instance you have access to see. You can filter the list by entering search keywords in the Search Beast Modes field; by filtering on certain criteria such as name, owner, or status (valid or invalid); or by clicking on a card in the Dashboard.

If you are the calculation owner or have a role with the Manage All Cards, Pages and Apps (App Studio) grant enabled, you can also select calculations in this list. When you select calculations, a wrench menu appears at the top of the list. This menu contains actions you can apply to calculations in bulk, such as locking/unlocking calculations, changing calculation owners, and duplicating calculations to other DataSets.

Filter button

Lets you filter the calculations in the list by any of a variety of criteria, including Beast Mode type (Card of DataSet), locked or unlocked status, owner, etc.

Dashboard

Shows cards for various Beast Mode-related statistics, such as the total number of Beast Mode calculations, the number saved to a DataSet, the number not being used in a Card, etc. You can click on a card to filter the calculations list accordingly; for example, clicking “Locked” filters the list to show all calculations that have been locked.

Add Beast Mode button

Lets you add a calculation to a selected DataSet.

If you click on a calculation in the list on the left, a details view for that calculation appears. Here you can see information specific to the calculation and access additional options. The following screenshot points out the most important parts of this view:
beast_mode_manager_calc_details.png
You can learn about these components in the following table:

Name

Description

Calculation data type

Shows the data type for this calculation, such as String, Number, Date, etc. For more information about data types, see Understanding Chart Data .

Calculation owner Shows the owner of this calculation. By default, Beast Mode calculations on a DataSet are owned by the DataSet owner and calculations on a Card are owned by the Card owner. You can change the owner of a Beast Mode calculation by selecting Change owner in the options menu.
Tab navigation Lets you switch between the three views of the details view for this calculation. Summary , shown in the screenshot, provides an overview of the calculation. Cards displays all Cards this calculation is used in. Data shows the calculated column together with the column(s) it is derived from.
Parent DataSet Shows the parent DataSet for the calculation or, if the calculation is found on a Card rather than a DataSet, it shows the parent DataSet for the Card. You can click on the DataSet to open its details view .
Options menu

Provides access to actions you can take on this calculation, including the following:

  • Create Beast Mode . Lets you add another Beast Mode calculation to the parent DataSet for this calculation.

  • Edit formula . Opens the Beast Mode editor for the calculation so you can make changes to the formula. You can also open the editor by mousing over the formula in the Overview tab and clicking the pencil icon.

  • Lock . Locks this calculation so that the formula can only be edited by the owner or an Admin-level user.

  • Unlock . Unlocks the calculation if it has been locked. This can only be done by the owner of an Admin-level user.

  • Change owner . Lets you select a new owner for the calculation. You must be the owner or an Admin-level user to do this.

  • Buzz owner . Lets you send a Buzz message to the calculation owner. For more information about Buzz, see Chatting in Buzz .

Dashboard Shows you statistics for this calculation, including the number of Cards using the calculation, the total number of views of the Card, and the last update date.
Location Shows the Card or DataSet this calculation is built on. You can jump to the details view for the Card or DataSet by clicking on the link.
Formula Shows the formula for this Beast Mode calculation. You can edit the calculation by mousing over it and clicking the pencil icon. For more information about editing Beast Mode, see Transforming Data Using Beast Mode .
Video - Data Center Overview
  • domo.write_dataframe(df, output_dataset)
  • domo.write_dataframe(df, output_dataset, update_method=“REPLACE”)
  • domo.write_dataframe(df, output_dataset, update_method=“APPEND”)
  • domo.write_dataframe(df, output_dataset, update_method=“UPSERT”, update_key=column_name)
  • domo.write_dataframe(df, output_dataset, update_method=“PARTITION”, partition_name=’Example Name’)
Note: If no update_method is provided, the default functionality is a REPLACE method. If you want to change the update_method back to REPLACE from another method, you need to explicitly set the update_method to REPLACE, and Jupyter overrides the last set method. When performing a UPSERT update_method, the data cannot have duplicate values in the update\_key column, or the UPSERT fails.
For information on which update method to use, see our DataSet Update Methods article.

Use Accounts

Third-party accounts can be referenced in a Jupyter Notebook using the domojupyter library. This library provides useful functionality to interact with Domo within Jupyter. Before account keys and values can be accessed, your workspace must have an account. If you are creating a new workspace, see the earlier section, Creating a Workspace. If your workspace already exists but doesn’t have a third-party account attached, follow the steps below:
  1. In Jupyter Workspaces, locate your workspace from the list. You can search and filter by owner.
  2. Hover over your workspace. The Manage Workspace menu displays.
  3. Select the Manage Workspace menu and choose Edit.
The Edit Jupyter Workspace modal displays.
  1. In the Edit Jupyter Workspace view, select Accounts > Add Account and select a third-party account.
  2. After making your selection, select Save Workspace.
The workspace has a third-party account set up. Keys and values can now be read into a Jupyter Notebook using the domojupyter library.
  1. The following commands can be used to get account information:
  • domo.get_account_property_value('account') will return the specific value assigned to a property on your account.
  • domo.get_account_property_value('account',account_properties[0]) will return all properties that exist in an account.
See the example below, where ‘S3Account’ is the account being referenced:
Screen_Shot_2022-10-17_at_4.03.43_PM.png

Install and Use Libraries

Libraries can be installed in the Jupyter workspace by opening a terminal and executing the appropriate commands. An example command to install the Seaborn library is conda install seaborn -y. Once installed, these libraries can be imported and used within the Jupyter Notebooks. See the example below:
installingandusinglibraries.png

Usage Monitoring

You can monitor Jupyter usage within Domo. As a prerequisite, you need to be assigned either the default Admin role or a custom role with the View Usage Metrics and Manage Jupyter Workspaces grants. Follow the steps below to create a custom role with usage-based billing access.
  1. Clone an existing role such as the default Admin role.
  2. Remove any grants from the cloned role that are not needed for a billing admin.
  3. Add the View Usage Metrics and Manage Jupyter Workspaces grants to this role.
You can learn more about creating custom roles in our article on Managing Custom Roles. After you create the role, follow these steps to view your usage:
  1. In the navigation header, go to More > Admin .
  2. On the Admin screen in the Company settings menu, select Usage.
  3. Go to the Jupyter Compute tab.
    jupyter-compute-usage.png

FAQ

Plugins are not currently supported.
Please contact your Customer Success Manager (CSM) or Account Executive (AE) for the most up-to-date information on the trial experience of Jupyter.
Yes, we have a team of experienced data scientists ready to help as needed. Please contact your Account Executive (AE) for more information.
First, you must stop the workspace. You may then change the kernel in the Domo workspace edit view.
Yes. When you hover over a workspace, the Manage Workspaces menu displays. Choose Restore Kernel Defaults from the options. All instances must be stopped to fulfill this action.
If you want to do any kind of data exploration or analysis (such as load a DataSet, develop data science models or machine learning pipelines, create custom data tables or figures, or write transformed data back into Domo) in a notebook, you need experience with either R or Python.
Domo’s Jupyter integration allows users to install third-party libraries. However, Domo does not natively support every third-party library. Some third-party libraries may require more effort on the user’s end to install, configure, and troubleshoot.
Domo supports integrating and maintaining git repositories within the Jupyter Workspaces interface. After you complete integration, you can repeatedly push updates (including updated Jupyter notebook files) from Jupyter Workspaces to the GitHub repository you select using standard Git operations. See Use Jupyter Workspaces with GitHub for more information.
At this time, we have no plans to deprecate any of our Python versions.
Right now, trial Jupyter customers only have access to four tiers. Customers on consumption should have nine tiers for Jupyter, each with a different CPU allocation.
Jupyter does not have the ability to run continuously.
At this time, we do not have any support for copilot. We are looking into this to determine its feasibility and where it could fit on the roadmap.Experiencing issues? See the Jupyter Troubleshooting Guide or contact support@domo.com for assistance.