Models Dashboards Insights · Querying PostHog Data · PostHog/skills · Skills Docs

Models Dashboards Insights · Querying PostHog Data · PostHog/skills · Skills Docs

Column	Type	Nullable	Description
`id`	Integer	NOT NULL	Dashboard id.
`team_id`	Integer	NOT NULL
`name`	String	NOT NULL	Dashboard name.
`description`	String	NOT NULL	Dashboard description.
`created_by_id`	Integer	NULL	User who created the dashboard.
`created_at`	DateTime	NOT NULL	When the dashboard was created.
`deleted`	Integer	NOT NULL	1 if the dashboard has been deleted, 0 otherwise.
`filters`	JSON	NOT NULL	JSON dashboard-level filters applied to all tiles.
`variables`	JSON	NOT NULL	JSON dashboard-level template variables.

Column	Type	Nullable	Description
`id`	Integer	NOT NULL	Insight id.
`short_id`	String	NOT NULL	Short URL-safe id used in insight links.
`team_id`	Integer	NOT NULL
`name`	String	NOT NULL	Insight name.
`description`	String	NOT NULL	Insight description.
`filters`	JSON	NOT NULL	Legacy JSON filter-based insight definition.
`query`	JSON	NOT NULL	JSON query (HogQL query schema) defining the insight.
`query_metadata`	JSON	NOT NULL	JSON metadata derived from the query.
`deleted`	Integer	NOT NULL	1 if the insight has been deleted, 0 otherwise.
`saved`	Integer	NOT NULL	1 if explicitly saved by a user, 0 if a transient/auto-created insight.
`favorited`	Integer	NOT NULL	1 if the insight is marked as a favorite, 0 otherwise.
`created_at`	DateTime	NOT NULL	When the insight was created.
`created_by_id`	Integer	NULL	User who created the insight.
`last_modified_at`	DateTime	NOT NULL	When the insight definition was last changed.
`last_modified_by_id`	Integer	NULL	User who last modified the insight.
`updated_at`	DateTime	NOT NULL	When the row was last updated (any field).