Which chart types are supported?

Ten: BAR and HBAR for category comparisons, LINE and AREA for trends, SCATTER for bivariate clouds, PIE for share-of-whole, HISTOGRAM for distribution shape, HEATMAP for two-axis density, RADAR for multi-KPI comparisons, and CANDLESTICK for OHLC time series.

What does CREATE CHART return?

An SVG string, returned as a regular query result. The same SVG renders in the DeltaForge GUI, in notebooks, in pipeline output, and anywhere a client can display vector graphics.

Which modifiers shape the chart output?

TITLE and SUBTITLE for headings, XLABEL and YLABEL for axis labels, LEGEND for series legends, SMOOTH for line smoothing, BINS for histogram bucketing, VALUES to print data labels, and GROUP BY to split a single SELECT into multiple series.

How is a chart defined alongside its query?

The chart definition lives in the same SQL file as the SELECT that feeds it. The chart renders directly from the lakehouse with no glue code.

Visualization

Charts as SQL

CREATE CHART wraps a query and returns SVG. Ten chart types, one grammar. The chart definition lives in the same SQL file as the query that feeds it.

BAR, HBAR, LINE, AREA, SCATTER, PIE, HISTOGRAM, HEATMAP, RADAR, CANDLESTICK

SVG output, returned as a query result

Modifiers: TITLE, SUBTITLE, XLABEL, YLABEL, LEGEND, SMOOTH, BINS, VALUES, GROUP BY

The shapes you reach for most

Comparisons, distributions, trends, and a few specialty charts

Comparisons

Bar and horizontal bar for category comparisons. Pie for share-of-whole.

Trends over time

Line and stacked area for ordered axes. Series come from a single SELECT, pivot with GROUP BY.

Distributions and density

Histogram for shape, heatmap for two-axis density, scatter for bivariate cloud.

Specialty

Radar for multi-KPI comparisons, candlestick for OHLC time series.

The whole chart is one statement

A SELECT inside, axes and titles outside

CREATE CHART BAR FROM (
  SELECT category, ROUND(SUM(revenue), 2) AS rev
  FROM retail.sales_daily
  GROUP BY category
  ORDER BY rev DESC
) X category Y rev
TITLE 'Revenue by Category'
VALUES ON;

Render where the data lives

Try the chart gallery demo in the GUI.

Get Community License Read Documentation