Permissions
Setting User or Group Permissions
User permissions are first set on the individual connection then more fine-tuned permissioning can be assigned to individual users or groups within the organization, streamlining the management process. All user permissions can be modified by a Connection Admin by navigating to the Admin menu and alreing the specific permissions set for a particular connection.
Connections Roles
Permissions assigned at the connection level are considered the user's base role to the data that connection offers. The individual user’s permissions will be added to the connection-level base role that is applied to all users of that connection.
Note that there are no specific model permissions, they are set at the connection level.
Data permissions can be set at several levels, in ascending order of querying flexibility for users:
-
No Access: These users will not be able to query or view content built on this connection.
-
Viewer: These users can view dashboards built on predefined Topics.
-
Restricted Querier: These users can create and view workbooks and dashboards, but can only query through predefined Topics.
-
Querier: These users can create workbooks and dashboards, and query both modeled data (Topics) or unmodeled data (SQL) to the connection. These users cannot touch the shared model files on the connection.
-
Connection Admin: These users have Querier access to query both modeled or unmodeled data, and can additionally edit the connection model and settings, including setting other users' permission to the given connection or adjusting the default permissions. These are the only users that can touch the shared model files on a connection.
By Default, Viewer and Restricted Querier users are restricted from accessing data that is not exposed in Topics in the Shared model.
- SQL queries are restricted
- Queries built in All Views & Fields (not on Topics) will be restricted
- Additions of, or changes to, Relationships or Topics in the workbook will lead to restriction of all queries in that workbook
- Fields based purely on other modeled fields (i.e. measures created from the quick aggregation menu, or a field defined as
${field_a} + ${field_b}
) will not lead to restriction - Fields based on raw SQL (i.e. CURRENT_TIME or raw definitions pointing to
field_c
vs${field_c}
will be restricted
A Viewer or Restricted Querier attempting to access content with changes to Topics or Relationships will see a Permission Error. This can be resolved by either promoting the changes causing the restriction (and moving any All Views & Fields queries into Topics), or by enabling AccessBoost on this piece of content.
Connection and Roles Matrix
Permission | No Access | Viewer | Restricted Querier | Querier | Connection Admin |
---|---|---|---|---|---|
View names of workbooks on homepage | X | ✓ | ✓ | ✓ | ✓ |
Run Topic-based queries in a dashboard / workbook | X | ✓1,2 | ✓ | ✓ | ✓ |
Run all queries in a dashboard / workbook | X | X1 | X1 | ✓ | ✓ |
View custom SQL results | X | X1 | X1 | ✓ | ✓ |
Build / edit a dashboard / workbook | X | X | ✓ | ✓ | ✓ |
Export CSVs | X | X | ✓ | ✓ | ✓ |
Write SQL | X | X | X | ✓ | ✓ |
Stage workbook model changes (new fields) | X | X | X | ✓ | ✓ |
Edit the shared data model | X | X | X | X | ✓ |
Manage permissions to the connection | X | X | X | X | ✓ |
Manage users globally3 | X | X | X | X | X |
Content Permissions (Doesn't Currently Exist) | Working on Now | Working on Now | Working on Now | Working on Now | Working on Now |
Footnotes
-
Viewers and Restricted Queriers can only run Topic-based queries. They are not permitted to run queries defined outside of Topics, or run any query in a workbook which has altered Topic or Join Relationship definitions. In the future, escalated privileges may be granted to a specific workbook or dashboard, allowing one-off access to specific users (or all users). ↩ ↩2 ↩3 ↩4 ↩5
-
User management is controlled by global admins, not at the connection level by connection admins. ↩
-
Viewers can only access dashboards, not workbooks ↩