Skip to Content

Model

Set model access

Choose which rows each customer can use in embeds and data apps.

Choose which rows each customer can use in embeds and data apps.

Inside Databrain, your team’s access follows workspace roles. A model used in an embed or data app also needs a customer column or an explicit shared-table decision.

Before you start

  • You are an Admin. Other roles see Only an admin can change this. Ask an admin to pick the customer column.
  • You know which physical column identifies each customer.
  • The table is in the published model.
  • An embed or data app uses the model.

Pick a customer column

  1. Open the table in your semantic model.

  2. Find Who can see this.

    Table page for subscription_orders with the Who can see this card highlighted, saying everyone in the workspace sees all rows because no embed uses the model.
    Who can see this says who sees which rows of the table.
  3. Open Customer column.

  4. Select the column that identifies the customer for each row.

  5. Check the confirmation: Saved. Each customer sees only rows where your column matches them.

  6. Run the affected metric again in the intended customer scope.

The choice is logged with the admin who changed it. To see every table at once, open the studio’s more menu and select Who can see this. A table that is not published yet shows Publish first, then pick its column. Column counts help you inspect the data. They do not decide which column identifies a customer.

A missing customer column can also appear beside a refused metric preview. Use its column picker to repair the mapping, then run the metric again.

Mark a shared table

Use this only when every customer should see every row, such as a shared reference table.

  1. Open Who can see this for the table.
  2. Select Every customer sees all rows.
  3. Read the confirmation’s impact.
  4. Select Show to every customer only if the table contains shared data.

Every customer can use all rows from this table in embeds and data apps. The decision is logged with your name. You can change it later in the same card.

Check the customer scope

  1. Open a metric that uses the table.
  2. Choose the customer in Run as, or All clients. It shows only for Table tenancy with at least one client.
  3. Select Run.
  4. Inspect Checks for this run.

The customer selector appears for table tenancy with a configured client list. Changing the customer makes earlier results stale. Run again before relying on those checks. All clients is a preview scope, not permission to expose every customer’s rows. A missing mapping on another table can still block the query.

Next, check and publish the model.

On this page