dc-cube-definition

Define secure Drizzle Cube definitions with per-tenant SQL filters.

Updated Jan 12, 2026
One-click install
npx skills add https://github.com/cliftonc/drizzle-cube-plugin --skill dc-cube-definition
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: dc-cube-definition
Source: https://github.com/cliftonc/drizzle-cube-plugin/tree/main/skills/dc-cube-definition
Command: npx skills add https://github.com/cliftonc/drizzle-cube-plugin --skill dc-cube-definition

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Creating robust, security-aware Drizzle Cube definitions is challenging. This skill guides engineers to structure cubes with consistent security filters, accurate measures, and correct joins to support multi-tenant analytics across departments.

Core Features & Use Cases

  • Secure cube definitions with per-tenant SQL filters to isolate data.
  • Rich definitions for measures and dimensions with proper typing and primary keys.
  • Joins and relationships support star/schema patterns and cross-cube analytics.

Quick Start

Create a new cube using defineCube, set a securityContext-based sql filter, define a few measures and dimensions, and declare a few joins to related cubes. Then integrate the cube into your semanticLayer and verify access controls by executing a sample query within a restricted security context.

Frequently Asked Questions about dc-cube-definition

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I define secure Drizzle Cube definitions for multi-tenant analytics?

Drizzle Cube definitions require a mandatory securityContext in the cube SQL to isolate tenant data. This approach applies consistent security filters alongside defined measures, dimensions, and joins to support multi-tenant analytics across departments.

What is the best way to enforce row-level security filters in a Drizzle Cube semantic layer?

The best way to enforce row-level security filters in a Drizzle Cube semantic layer is by applying a mandatory securityContext within the cube SQL. This isolates data per tenant and ensures consistent access controls across all defined measures and dimensions.

Can I define cross-cube joins and relationships in Drizzle Cube?

Yes, you can define cross-cube joins in Drizzle Cube. The definition structure supports various join patterns including star and schema configurations, enabling cross-cube analytics while maintaining secure per-tenant SQL filters across related cubes.

How do I structure measures and dimensions with proper typing when defining a cube?

You structure measures and dimensions with proper typing when defining a cube by using the defineCube function. This guides you to create rich definitions that include accurate typing and primary keys alongside your security context and joins.

Does Drizzle Cube support multi-tenant security contexts for isolating departmental data?

Yes, Drizzle Cube supports multi-tenant security contexts for isolating departmental data. It enforces a mandatory security context in the cube SQL, creating consistent security filters to isolate data across different departments and domains.

How do I verify access controls after integrating a secure cube into the semantic layer?

You verify access controls after integrating a secure cube into the semantic layer by executing a sample query within a restricted security context. This tests whether the mandatory per-tenant SQL filters correctly isolate data across domains.