Skip to main content
Domo Knowledge Base

Encrypting and Decrypting Workbench 4 Data

Version 3


You can encrypt columns of data in your DataSet in Workbench 4. After the DataSet has been pulled into Domo, it can only be decrypted in a Sumo table, by users who have been given special access in the Data Access Management settings for the DataSet. For more information about Sumo, see Understanding Sumo cards

For a white paper discussing Workbench's encryption capability, click here: Whitepaper_Domo+Data+Security+and+Encryption+Draft.pdf 

To encrypt a column of data for a DataSet in Workbench 4,

  1. In the Accounts pane, select the DataSet job in which you want to encrypt data.

  2. In the Transforms grouping in the Buttons toolbar at the top of the Workbench window, click Add New.

  3. In the Transform Type menu, select Encrypt then click Next.

  4. Click Finish.
    An Encrypt item is added under Transforms for this DataSet job.

  5. Click on the new Encrypt item under Transforms.

  6. In the Encrypted Columns menu, check the boxes for all columns you want to encrypt.

  7. (Optional) Turn on Obfuscate Values if you want the data in the selected columns to be obfuscated.
    Data that is obfuscated cannot be reconstituted into a readable state.

  8. For each user who should have decryption capabilities, do the following:

    1. Locate the user in the User Access list.

    2. Click the ellipsis (...) in the Disabled field.
      Data Password dialog opens.

    3. Set Access Enabled to "On."

    4. Enter a password in the Password field and reenter it in the Confirm field.

    5. Click Save.

  9. Click Save in the DataSet Jobs grouping in the Buttons toolbar at the top of the Workbench window. 

To decrypt a data column you encrypted in Workbench 4,

  1. Open the Sumo editor or Details view for the DataSet with the encrypted column.
    For more information, see Understanding Sumo cards.

  2. Click the  icon on the left side of the screen.

    This icon only appears if you have enabled decryption for this DataSet for your user following the instructions in the previous section.
    A dialog appears requesting your password.

  3. Enter the password you entered in step 5-e in the previous section.

  4. Click Unlock.

You must go through this decryption process every time you access the card, even if you save the decrypted card while in the Edit view.