Sharing tables and columns

As an administrator, you can share view or edit access to any table.

By default, when a table is loaded using the ThoughtSpot Loader, ODBC, or JDBC, it is only visible to administrators. Tables imported from a Web browser are visible to administrators and the user who uploaded it. Administrators and owners can share Can View or Can Edit privileges on tables with other users, who can further share them with others.

When you share a table, you can share the entire table, or specific columns. For column level security (CLS), share only specific columns.

Permissive or strict sharing

Use caution when sharing tables, because any objects created from that table will have dependencies on it and its underlying structure. Objects created from tables can include worksheets, views, answers, and pinboards. This means that if a user wants to drop or modify a table, any object that depends upon it must be edited or removed first, to remove the dependency.

For this reason, it is a best practice to only grant the Edit permission on a table to a small number of users. If you want to prevent shares from also revealing the columns regardless of where it appears (worksheets, answers, and pinboards), you can ask ThoughtSpot Support to enable a stricter behavior.

You can share a table or multiple tables from the Data tab, or share a single table from within the table that you want to share.

Share from the Data tab

To share a table, worksheet, or view from the Data tab, follow these steps. You can also share multiple objects at a time from the Data tab.

  1. Click Data on the top navigation bar.

  2. Hover over the dataset you want to share and select it by clicking the empty checkbox that appears.

  3. Click Share.

    Share the data

  4. If you are sharing a table, select Entire Table or Specific Columns. To use Column Level Security (CLS), select Specific Columns, and only share the columns the users or groups should have access to.

    Specify sharing type

  5. If you select Specific Columns, select the column(s) you want to share, and add the users or groups you want to share the column(s) with. Use this option for Column Level Security (CLS). If you select Entire Table, skip to step 6.

    You cannot click multiple columns at once. You must input the users or groups with whom you want to share for each column.
  6. Click + Add users or groups and select the users and groups with whom you want to share.

    Add users or groups

  7. Specify permissions.

Share from within the dataset

To share a table, worksheet, or View from within the dataset, follow these steps.

  1. Navigate to the dataset you want to share.

  2. Click the More icon more options menu icon, and then click Share.

    Share the data

  3. Select the users or groups with whom you want to share. + You can only share the entire dataset. You cannot share individual columns. To share individual columns, share a table from the Data tab. You cannot share individual columns for worksheets or views.

  4. Specify permissions.

Specify permissions

  1. Configure the level of access by selecting from the dropdown list. You can select:

    • Can View to provide read-only access. This enables viewing the data source’s data. If the data source is a table, Can View also enables defining worksheets based on that data.

    • Can Edit to allow modification. This enables renaming, modifying, or deleting the entire data source and adding or removing its columns.

      Specify permissions
  2. Click Add.

  3. Click Done.

  4. The Share settings updated notification appears on the bottom of your screen.

    Share settings updated