:hedgehog: PostHog is the leading platform for building self-driving products. Our developer tools – AI observability, analytics, session replay, flags, experiments, error tracking, logs, and more – capture all the context agents need to diagnose problems, uncover opportunities, and ship fixes. Steer it all from Slack, web, desktop, or the MCP.
Python ab-testingai-analyticsanalyticscdpdata-warehouseexperimentsfeature-flagsjavascriptproduct-analyticspythonreactsession-replaysurveystypescriptweb-analytics
import { render } from '@testing-library/react'
import { featureFlagLogic } from 'lib/logic/featureFlagLogic'
import { actionsModel } from '~/models/actionsModel'
import { groupsModel } from '~/models/groupsModel'
import { DataTableVisualization } from '~/queries/nodes/DataVisualization/DataVisualization'
import { VisualizationNode, HogQLQueryResponse, NodeKind } from '~/queries/schema/schema-general'
import { QueryContext } from '~/queries/types'
import { ChartDisplayType } from '~/types'
import { initKeaTests } from '../init'
import { setupInsightMocks, type SetupMocksOptions } from './mocks'
export const DATA_VIZ_TEST_KEY = 'sql-test-harness'
export const MONTHS = ['2025-10-01', '2025-11-01', '2025-12-01', '2026-01-01', '2026-02-01', '2026-03-01']
export const HOVER = 2
/** Minimal `[columnName, clickhouseType]` + row-major results — the same shape the
* `/query` endpoint returns, distilled to what the chart selectors read. */
export interface DataVizFixture {
columns: string[]
types: [string, string][]
results: unknown[][]
}
export function buildHogQLResponse({ columns, types, results }: DataVizFixture): HogQLQueryResponse {
return {
results,
columns,
types,
hogql: '',
hasMore: false,
} as HogQLQueryResponse
}
export function buildDataVisualizationQuery(overrides?: Partial<VisualizationNode>): VisualizationNode {
return {
source: {
kind: NodeKind.HogQLQuery,
query: 'SELECT month, pageviews FROM events GROUP BY month ORDER BY month',
},
display: ChartDisplayType.ActionsLineGraph,
...overrides,
kind: NodeKind.DataVisualizationNode,
}
}
export interface RenderDataVisualizationProps {
query?: VisualizationNode
/** Row-major fixture, fed in via `cachedResults` to skip the network. */
response: DataVizFixture
featureFlags?: Record<string, string | boolean>
readOnly?: boolean
embedded?: boolean
context?: QueryContext<VisualizationNode>
mocks?: SetupMocksOptions
}
/** Mount a SQL insight (`DataVisualizationNode`) the way the real scene does — through
* `DataTableVisualization` → `dataVisualizationLogic` → `SqlChart` → the quill chart — with
* the query result injected via `cachedResults` so nothing hits the network. */
export function renderDataVisualization(props: RenderDataVisualizationProps): ReturnType<typeof render> {
const featureFlags = props.featureFlags ?? {}
initKeaTests()
actionsModel.mount()
groupsModel.mount()
const ffLogic = featureFlagLogic()
ffLogic.mount()
ffLogic.actions.setFeatureFlags(Object.keys(featureFlags), featureFlags)
setupInsightMocks(props.mocks)
const cachedResults = buildHogQLResponse(props.response)
return render(
<DataTableVisualization
uniqueKey={DATA_VIZ_TEST_KEY}
query={props.query ?? buildDataVisualizationQuery()}
setQuery={() => {}}
cachedResults={cachedResults}
context={props.context}
readOnly={props.readOnly ?? true}
embedded={props.embedded}
/>
)
}