<article class="blog-post">Embedding a Superset dashboard in your product is a few hours of work. Making sure that dashboard shows tenant A only tenant A&#8217;s rows, for every chart, every filter, every drill-down and every cached result, is the part that decides whether embedded analytics is a feature or an incident.Superset supports three distinct approaches. Teams often pick one because it was the first that worked, without knowing what it does not protect against. This post describes each, shows the configuration, and is specific about where it breaks. It ends with a test plan, because tenant isolation is one of the few things in analytics that you should prove rather than assume.</p>
<h2>The setting</h2>
<p>A typical embedded setup: your application authenticates its users, then asks Superset for a short-lived <strong>guest token</strong> scoped to a dashboard. The browser loads the dashboard in an iframe through the Embedded SDK, presenting that token. Superset runs the dashboard&#8217;s queries as a <strong>guest user</strong> with a fixed role and returns the results.</p>
<p>The tenant boundary can be enforced in three places along that path:</p>
<ul>
<li>In the <strong>guest token</strong>, as RLS clauses your backend attaches when it mints the token.</li>
<li>In <strong>Superset&#8217;s RLS rules</strong>, attached to the guest role and parameterised with Jinja from the token&#8217;s user attributes.</li>
<li>In the <strong>data layer</strong>, by giving each tenant its own schema or database so that no single query can span tenants.</li>
</ul>
<p>They are not mutually exclusive. The strongest deployments combine 1 or 2 with 3.</p>
<h2>Pattern 1: RLS clauses in the guest token</h2>
<p>When your backend requests a guest token, it can include <code>rls</code> clauses. Superset appends each clause to the <code>WHERE</code> of every query the dashboard runs, optionally restricted to one dataset.</p>
<div class="code-block">
<div class="code-header">json</div>
<pre><code class="language-json">POST /api/v1/security/guest_token/
{
  "user": { "username": "tenant-acme-user-42", "first_name": "Acme", "last_name": "User" },
  "resources": [{ "type": "dashboard", "id": "c1a4e2d7-...-dashboard-uuid" }],
  "rls": [
    { "dataset": 17, "clause": "tenant_id = 'acme'" },
    { "dataset": 23, "clause": "account_id IN (SELECT id FROM accounts WHERE tenant = 'acme')" }
  ]
}</code></pre>
</div>
<p>The clause is SQL. Superset wraps it in parentheses and ANDs it with whatever the chart&#8217;s own filters produce.</p>
<p><strong>Why teams like it:</strong> all tenant logic lives in your backend, next to the code that already knows who the user is. No Superset configuration per tenant. Adding a tenant is nothing.</p>
<p><strong>Where it fails:</strong></p>
<ul>
<li><strong>You are building SQL from application state.</strong> If <code>tenant_id</code> comes from anywhere the user can influence, or is interpolated without care, this is a SQL injection surface inside your security boundary. Derive the tenant identifier from your own authenticated session, never from a request parameter, and use a strict allow-list format (an integer, a UUID) rather than free text.</li>
<li><strong>Clauses without a `dataset` apply to every dataset on the dashboard.</strong> If one dataset has no <code>tenant_id</code> column, that chart errors. Worse, if a dataset has a column by that name with a different meaning, the filter silently does the wrong thing. Always scope clauses to dataset IDs, and treat a new dataset on the dashboard as a change that needs a matching clause.</li>
<li><strong>Virtual datasets.</strong> For a dataset defined by a SQL query, the RLS clause is applied to the outer query, not inside the subquery. If the inner SQL pre-aggregates across tenants, the outer filter cannot un-aggregate it. Virtual datasets used in embedded dashboards must keep tenant identifiers at their output grain.</li>
<li><strong>Chart-level SQL escape hatches.</strong> Custom SQL in ad-hoc metrics or filters still runs inside the same query and is still wrapped by the RLS clause, so this is safe. But SQL Lab and the chart data API used outside the dashboard are not covered by a dashboard-scoped token. Make sure the guest role cannot reach them.</li>
<li><strong>Token lifetime.</strong> Guest tokens default to a five-minute expiry. A token minted for tenant A and leaked is valid for tenant A&#8217;s data for that long. Keep the expiry short and mint tokens on demand, not in advance.</li>
</ul>
<h2>Pattern 2: Superset RLS rules with Jinja</h2>
<p>Superset has its own row-level security feature under Settings, Row Level Security. A rule attaches a SQL clause to one or more datasets for one or more roles. The clause can use Jinja, and in an embedded context the interesting variables are the guest user&#8217;s attributes:</p>
<div class="code-block">
<div class="code-header">sql</div>
<pre><code class="language-sql">tenant_id = (
  SELECT tenant_id FROM app_users WHERE username = '{{ current_username() }}'
)</code></pre>
</div>
<p>Assign the rule to the guest role (<code>GUEST_ROLE_NAME</code> in <code>superset_config.py</code>), and every query the guest user runs against that dataset is filtered. Your backend puts the tenant-bearing username into the token and does nothing else. Requires <code>ENABLE_TEMPLATE_PROCESSING = True</code>.</p>
<p><strong>Why teams like it:</strong> the tenant logic is declared once, in Superset, alongside the datasets it protects. Auditors can read it. A new dashboard on an existing dataset is protected automatically.</p>
<p><strong>Where it fails:</strong></p>
<ul>
<li><strong>The guest role is one role.</strong> Every embedded user shares it, so RLS rules cannot distinguish tenants by role. All the discrimination has to come through Jinja and the username, which means the username format is now part of your security model. Document it and validate it when minting tokens.</li>
<li><strong>Jinja is a template, not a parameter.</strong> <code>current_username()</code> is interpolated into SQL. Superset&#8217;s built-in functions are safe, but a rule that interpolates anything user-controlled, such as <code>url_param</code>, is not. Never use <code>url_param</code> or dashboard filter values in an RLS rule; they are user input.</li>
<li><strong>Every dataset needs a rule.</strong> A dataset added to an embedded dashboard without a rule is fully exposed. There is no default-deny. Put a check in your release process, or a script that lists embedded dashboards&#8217; datasets without RLS rules.</li>
<li><strong>Performance.</strong> The subquery runs inside every chart query. Index <code>app_users.username</code>, or precompute a mapping table, or the &#8220;secure&#8221; version of the dashboard is the slow one.</li>
<li><strong>The lookup table is inside the analytics database.</strong> Your tenant mapping now has to be replicated into the warehouse and kept current. A stale mapping is either an outage or a leak, depending on the direction of the staleness.</li>
</ul>
<style>
.as-inline-cta{display:flex;align-items:stretch;border-radius:14px;overflow:hidden;<br />background:#eaf4f6;border:1px solid #dee7ea;margin:32px 0}<br />.as-inline-cta__icon{flex:0 0 128px;background-color:#1aa9ca;<br />background-image:radial-gradient(rgba(255,255,255,.35) 1.4px,transparent 1.4px);<br />background-size:11px 11px;display:flex;align-items:center;justify-content:center;padding:20px}<br />.as-inline-cta__icon span{width:64px;height:64px;border-radius:50%;background:#fff;<br />display:flex;align-items:center;justify-content:center;box-shadow:0 2px 6px rgba(0,0,0,.12)}<br />.as-inline-cta__icon svg{width:28px;height:28px;stroke:#0f7f9c;fill:none;stroke-width:2;<br />stroke-linecap:round;stroke-linejoin:round}<br />.as-inline-cta__body{padding:22px 28px;display:flex;flex-direction:column;justify-content:center;gap:8px}<br />.as-inline-cta__body h4{font-size:19px;font-weight:700;color:#1e2246;margin:0}<br />.as-inline-cta__body p{font-size:14.5px;line-height:1.6;color:#45506b;margin:0;max-width:52ch}<br />.as-inline-cta__link{display:inline-flex;align-items:center;gap:5px;font-size:14.5px;<br />font-weight:700;color:#0f7f9c;text-decoration:none;width:max-content}<br />.as-inline-cta__link svg{width:16px;height:16px;stroke:currentColor;fill:none;stroke-width:2.4;<br />stroke-linecap:round;stroke-linejoin:round}<br />.as-inline-cta__link:hover{text-decoration:underline}<br />@media (max-width:560px){.as-inline-cta{flex-direction:column}<br />.as-inline-cta__icon{flex:0 0 auto;width:100%;padding:16px 0}}<br /></style>
<div class="as-inline-cta">
<div class="as-inline-cta__icon"></div>
<div class="as-inline-cta__body">
<h4>Picked a pattern? Now stress-test the failure mode</h4>
<p>Each RLS pattern above fails differently at real tenant counts and under caching. A Superset Embedding Feasibility Review pressure-tests your chosen pattern against your actual tenant model before it ships.</p>
<p><a class="as-inline-cta__link" href="https://www.andolasoft.com/what-we-do/superset-embedded-analytics#request" target="_blank" rel="noopener">Request an Embedding Feasibility Review</a></p>
</div>
</div>
<h2>Pattern 3: Physical isolation per tenant</h2>
<p>Give each tenant its own schema (or database) and point tenant-specific datasets at them. Superset then cannot write a cross-tenant query because no single table contains two tenants.</p>
<p>Two ways to make this work with one set of dashboards:</p>
<ul>
<li><strong>Schema-per-tenant with dataset templating.</strong> Superset datasets and SQL templates can use Jinja for the schema name, but the guest token cannot switch schemas on its own. In practice this means one dashboard copy per tenant, generated by script from a template dashboard, each pointing at tenant datasets. The export and import API makes this manageable up to a few hundred tenants.</li>
<li><strong>Database-per-tenant with connection-level identity.</strong> A separate Superset database connection per tenant, with credentials that can only see that tenant&#8217;s data. Combine with the dashboard-per-tenant approach above.</li>
</ul>
<p><strong>Why teams like it:</strong> the boundary is enforced by the database&#8217;s own permissions, not by SQL rewriting. A bug in Superset, a missed rule or a bad clause cannot cross it. Compliance conversations are shorter.</p>
<p><strong>Where it fails:</strong></p>
<ul>
<li><strong>Operational load.</strong> Hundreds of schemas, database connections and dashboard copies are a real maintenance burden. Dashboard changes must be re-propagated. Metadata database size grows with tenant count.</li>
<li><strong>Cross-tenant features are impossible by construction.</strong> Benchmarking a tenant against an anonymised peer group, a common premium feature, cannot be done inside the isolated model. You end up building a separate aggregated dataset anyway, with Pattern 1 or 2 protecting it.</li>
<li><strong>Provisioning is code you must write and maintain.</strong> New tenant means new schema, new connection, new dashboard import, all automated, all tested.</li>
</ul>
<h2>Choosing</h2>
<div class="table-responsive">
<table>
<thead>
<tr>
<th>Situation</th>
<th>Recommendation</th>
</tr>
</thead>
<tbody>
<tr>
<td>Tens to thousands of tenants, shared tables, moderate sensitivity</td>
<td>Pattern 1 (token RLS), scoped to dataset IDs, with tenant IDs taken only from the server-side session</td>
</tr>
<tr>
<td>Dashboards change often, several teams add datasets</td>
<td>Pattern 2 (Superset RLS) for default coverage, plus a release check that every embedded dataset has a rule</td>
</tr>
<tr>
<td>Regulated data, contractual isolation requirements, tenant count in the tens</td>
<td>Pattern 3 (schema or database per tenant), with Pattern 1 as a second layer</td>
</tr>
<tr>
<td>Premium cross-tenant benchmarking</td>
<td>Pattern 3 for tenant data, Pattern 1 on a separate pre-aggregated, anonymised dataset</td>
</tr>
</tbody>
</table>
</div>
<p>Whichever you choose, apply two rules universally. First, the guest role has the minimum permissions: read on the specific dashboards, nothing on SQL Lab, nothing on the chart or dataset list endpoints. Second, dashboard-level native filters and URL parameters are user experience, never security; a filter can be removed by the user, an RLS clause cannot.</p>
<h2>Caching</h2>
<p>Superset caches chart data. If two tenants&#8217; queries produce the same cache key, tenant B receives tenant A&#8217;s cached rows. Superset includes the query object, which contains the RLS clauses and the guest user context, in the cache key, so the standard patterns above are safe by design. Two things can still go wrong:</p>
<ul>
<li>A custom cache key function or a plugin that builds its own cache key and omits the RLS context.</li>
<li>A caching layer outside Superset (a CDN, a reverse proxy cache) in front of the chart data endpoint.</li>
</ul>
<p>Include a caching test in the plan below rather than reasoning about it.</p>
<h2>The test plan</h2>
<p>Isolation is testable. Run this before launch and on every change to dashboards, datasets, RLS rules or the token-minting code.</p>
<ul>
<li><strong>Two tenants, known data.</strong> Seed tenant A and tenant B with distinctive values you can search for in responses.</li>
<li><strong>Positive test.</strong> Mint a token for A, load the dashboard, capture every chart data response, assert every row belongs to A.</li>
<li><strong>Cross-tenant attempt.</strong> Using A&#8217;s token, call the chart data endpoint directly with a modified form data payload that removes or alters the tenant filter. Assert the response still contains only A&#8217;s rows.</li>
<li><strong>Dataset coverage.</strong> List every dataset referenced by every embedded dashboard. Assert each has an RLS clause in the token or an RLS rule in Superset.</li>
<li><strong>Cache test.</strong> Load the dashboard as A, then immediately as B, with identical filters. Assert B&#8217;s responses contain none of A&#8217;s distinctive values.</li>
<li><strong>Expiry.</strong> Use an expired token and assert a 401, not stale data.</li>
<li><strong>Role scope.</strong> Using a guest token, call the SQL Lab, dataset list and chart list APIs. Assert 403 on all of them.</li>
</ul>
<p>Automate it. A guest token, a couple of HTTP calls and a few assertions fit in any CI pipeline.</p>
<h2>Frequently Asked Questions</h2>
<h3>What is the safest way to isolate tenants in embedded Superset?</h3>
<p>Physical isolation, a separate database or schema per tenant, is the strongest guarantee because a mistake in a filter cannot cross a boundary that does not exist. It is also the most expensive to operate. Guest-token RLS clauses are the usual choice for SaaS at scale, and they are safe when the token is minted server-side from the authenticated session and never accepts a tenant id from the browser.</p>
<h3>Can one Superset instance safely serve many customers?</h3>
<p>Yes, and most embedded deployments do. The conditions are that the tenant identifier comes from your own session rather than from the client, that every dataset in the embedded dashboard carries the isolating clause, and that the test plan below is run on every release. A single dataset without the clause is all it takes for the guarantee to fail.</p>
<h3>Does query caching leak data between tenants?</h3>
<p>It will if the cache key does not include the tenant. Superset caches on the query and its parameters, so two tenants issuing the same logical query can share a cache entry unless the RLS clause is part of the key. This is the single most commonly missed step in a multi-tenant embed and it does not show up in functional testing.</p>
<h3>Do we need a separate database per tenant?</h3>
<p>Usually not. A shared database with a tenant column and enforced RLS is adequate for most SaaS products and far cheaper to run. Separate databases earn their cost when a contract, a regulator or a data-residency requirement demands it, or when tenant data volumes differ enough that they need separate tuning.</p>
<h2>Build It With Andolasoft</h2>
<p>Tenant isolation is one part of an embedded implementation, alongside theming, the token service, SDK integration and event wiring. Our <a href="https://www.andolasoft.com/what-we-do/superset-embedded-analytics" target="_blank" rel="noopener">embedded analytics implementation package</a> delivers all of it as a fixed scope, and it starts with a feasibility review in which the tenancy model is the first thing we look at. If your dashboards are already embedded and you want the isolation checked, the <a href="https://www.andolasoft.com/what-we-do/superset-architecture-review" target="_blank" rel="noopener">Architecture Review</a> covers RLS and role design. The broader controls are in our post on <a href="https://www.andolasoft.com/blog/data-governance-and-security-best-practices-for-superset-deployments" target="_blank" rel="noopener">governance and security for Superset deployments</a>.</p>
<p>If you are embedding Superset into a product and want the tenancy model checked before it ships, <a href="https://www.andolasoft.com/contact-us" target="_blank" rel="noopener">talk to us</a>. We will review your token service, datasets and cache configuration against the failure modes above, and give you a written plan to close any gaps.</p>
</article>


Multi-Tenant Row-Level Security in Embedded Superset: Three Patterns and When Each Fails

Table of Contents

Related Articles

Quick Links

Products

For Career

For Sales