Skip to content

Multiple-Schema Permissions

This page describes the permissions required for each step of the multi-schema source datastore creation flow.

Role Requirements

All steps in the multi-schema workflow require the Manager role (or higher: Admin). This is enforced at the endpoint level — users with Member or Editor roles cannot access the multi-schema flow.

Step Minimum Role Description
Discover Catalogs Manager List available databases/projects from a connection.
Discover Schemas Manager List available schemas within a catalog.
Validate Schemas Manager Test connectivity for selected schemas before creation.
Bulk Create Datastores Manager Create multiple datastores from selected schemas.
Create Group (inline) Manager Create a new datastore group during the bulk creation flow.
Link Enrichment (after creation) Member + Editor team permission Link an enrichment datastore to each created datastore individually.
Unlink Enrichment Admin Remove the enrichment link from a datastore.

Team Permissions

In addition to the role requirement, team-level permissions are enforced when datastores are created:

  • The user must have Editor permission in at least one of the teams assigned to the new datastores.
  • If the bulk create request specifies teams the user is not a member of, the creation will fail with an authorization error.
  • If no teams are specified, the datastore is assigned to the public team — the user must have Editor permission on the public team for the creation to succeed.

Note

Teams specified in the bulk create request that do not exist yet are automatically created. However, the user must still have Editor permission in at least one of the resulting teams.

Connection Permissions

There are no connection-level permissions for schema discovery. Any user with the Manager role can discover catalogs and schemas from any connection in the workspace — the only gate is the role requirement.

Info

This differs from datastore access, which is gated by team membership. A user can discover schemas from a connection even if they do not have access to existing datastores using that connection.

Permission Flow Summary

graph TD
    A[User initiates multi-schema flow] --> B{Has Manager role?}
    B -->|No| C[Access denied]
    B -->|Yes| D[Discover catalogs & schemas]
    D --> E[Validate selected schemas]
    E --> F[Bulk create datastores]
    F --> G{User has Editor permission<br/>in assigned teams?}
    G -->|No| H[Creation fails:<br/>AuthUnauthorizedException]
    G -->|Yes| I[Datastores created successfully]
    I --> J{Link enrichment?}
    J -->|Yes| K{Member role +<br/>Editor team permission?}
    K -->|No| M[Link fails:<br/>AuthUnauthorizedException]
    K -->|Yes| L[Enrichment linked]
    J -->|No| L
    L --> N[Done]

UI Behavior Without Permission

Scenario What the User Sees
User is below Manager role The multi-schema options do not appear in the Add Source Datastore flow. The user can only create single datastores.
User has Manager role but no Editor team permission Bulk creation fails with an authorization error after clicking Finish.
User has Manager role but is not in specified teams Bulk creation fails — the user must be a member of at least one of the teams specified in the request.