SQL is the model.
Flynt deliberately has no semantic layer. You write one direct query; the result is cached and shared by every visual built on top of it. That is not a missing feature — it is the point. Everything below exists to make that one idea fast, polished and safe.
Connect and query
BigQuery, natively
Connect with a service account and write BigQuery SQL directly — no dialect translation, no abstraction between you and your warehouse.
Google Sheets
Pull spreadsheets in as queryable datasets for the numbers that never made it to the warehouse. More ingested sources are on the connector roadmap.
Datasets: one query, many cards
A dataset is a cached SQL result. Build any number of cards on top of it; the warehouse is queried on your schedule, not on every page view.
Scheduled refresh windows
Owners set when cached queries refresh and how much they are allowed to scan — cost guardrails live next to the schedule, where they belong.
Design something you would actually send
24 chart kinds
KPI tiles, tables, line, bar, area, pie and the rest of the essentials — plus an advanced library: gauges, sankey, treemap, funnel, heatmap, scatter and more.
Designer canvas
A free-form canvas with drag, resize, snapping, alignment guides, multi-select, z-order and zoom — for pages that need to look designed, not assembled.
Grid dashboards
When you just need it done, compose cards on a structured grid. Suites group dashboards for navigation; folders keep the library tidy.
Conditional formatting
Rules that colour values by threshold so the number that matters reads at a glance.
Governed by default
Certification
Peer review for cards and dashboards. Certified content is badged, and certified SQL feeds the metric glossary automatically.
Data dictionary
Dataset and column annotations, a metric glossary, and drift warnings: save a card whose SQL conflicts with a certified definition of the same metric and Flynt flags it — before two versions of revenue reach two different meetings.
Roles and permissions
Eight tiers from viewer to owner cover authoring, certification, governance and billing. Seat counts are managed per tier, with invite and consent flows built in.
Threshold alerts
Email alerts on metric thresholds, usage and system health, so the people who care find out first.
Sensitive data controls
Mark datasets sensitive and control who can see them — including keeping them out of pickers and the dictionary for everyone else.
Audit and backups
Audit logging on the actions that matter, encrypted daily backups, EU residency by default.