Lumera Logo
Start Free
The Lumera Engine

The mechanics of trusted self-serve.

Learn how Lumera combines semantic query translation with strict analytics governance to build SQL charts everyone can trust.

Compiler Status Governed
Plain English Question

“What is our gross sales last quarter?”

↓ Compiler Mapping ↓
Generated SQL (Validated)SELECT SUM(gross_sales) FROM core_billing WHERE status = 'completed';
SYSTEM_VERIFICATION_LOG.TXT
[NLP] Mapping token 'monthly growth' to metric 'mrr'
[NLP] Identified range: 'previous 6 months'
[SQL] Generated SELECT date_trunc('month', created_at), SUM(mrr_amount)...
Language

Natural-Language Query Engine

Our query translation compiler maps conversational questions into high-performance SQL. It supports filters, ranges, and synonyms (e.g., mapping 'earnings', 'sales', and 'revenue' to the same metric).

  • Resolves multi-level group-bys and aggregates
  • Translates complex time ranges (e.g. 'previous half vs same time last year')
  • Filters by values using indexed warehouse metadata
SYSTEM_VERIFICATION_LOG.TXT
[UI] Detected 2 columns: 'month' (date), 'revenue' (numeric)
[UI] Suggesting type: Area Chart
[UI] Mapping XAxis -> month, YAxis -> revenue
[UI] Colors: primary=violet, secondary=amber
Visualization

Visual Formatter & Auto-Charts

No need to manually pick chart types. Lumera analyzes the output data structure and automatically renders the optimal visualization (Line, Stacked Area, Bar, Cohort, or Table).

  • Interactive hover states, tooltips, and legends
  • Responsive charts that fit inside any dashboard grid
  • Export raw results to CSV, PNG, or JSON at any time
SYSTEM_VERIFICATION_LOG.TXT
[GOV] Validating schema constraints on Snowflake DB...
[GOV] Metric 'revenue' matches definition formula 'gross_sales - refunds'
[GOV] Access approved. Execution token generated.
Governance

Governed Metrics Layer

Stop the duplicate revenue calculations. The metrics layer enforces consistent definitions defined by your analytics engineers using YAML schemas, SQL templates, or dbt.

  • Centrally manages key metrics: MRR, Churn, LTV, ROI
  • Validates and inspects SQL generation before warehouse run
  • Allows rollbacks, git versioning, and logs audit trails
SYSTEM_VERIFICATION_LOG.TXT
[CRON] Schedulers triggered at 08:00 UTC
[ALERT] Checking threshold: 'weekly signup' >= 1200
[SLACK] Posting JSON response block payload to channel #analytics-feed
Distribution

Slack Alerts & Scheduling

Deliver data where decisions are made. Schedule hourly reports, generate password-protected public links, or set automated alert triggers.

  • Direct Slack message integration & PDF email attachments
  • Custom thresholds alerts (e.g. alert if MRR drop exceeds 5%)
  • API hooks to trigger workflows when a metric changes

Enterprise-Grade Security & Performance

Lumera connects securely to your stack without compromising data privacy.

Read-Only Connection

Lumera only runs SELECT statements. We never write back to, modify, or delete your source data structures.

End-to-End Encryption

Connections are encrypted with TLS 1.3. We support SSH tunnels, VPC peering, and secure reverse proxy.

No Raw Data Storage

We do not ingest or store your transaction tables. We cache query metadata for rendering, but raw customer data remains in your DB.

Ready to explore?

Start querying your databases in minutes with our sandbox free plan.

Create Free Account