Subchapter 103.12

Example Person Property Taxonomy

references/example-person-property-taxonomy.mdMarkdown630 BView on GitHub

Person property taxonomy (sample values for person properties)

Sample values for specific person properties:

Example Person Property Taxonomy · Querying PostHog Data · PostHog/skills · Skills Docs

SELECT
    groupArray(5)(prop),
    count(),
    prop_index
FROM
    (SELECT
        DISTINCT prop_index,
        toString(prop_value) AS prop
    FROM
        persons
    ARRAY JOIN arrayEnumerate([toString(properties.email), toString(properties.$initial_browser)]) AS prop_index, [toString(properties.email), toString(properties.$initial_browser)] AS prop_value
    WHERE
        isNotNull(prop_value)
    ORDER BY
        created_at DESC)
GROUP BY
    prop_index
ORDER BY
    prop_index ASC
LIMIT 50000