setting-up-warehouse-properties
Installation
SKILL.md
Setting up warehouse properties
Warehouse properties write columns from a warehouse table or materialized view onto matching people or groups,
on the schedule that table already syncs on. They replace a cron that sends $set identify events.
The mapping is the whole job. Most tables worth mapping are wide, so the work is deciding which columns become
properties and what they are called — not making many API calls. One source carries the entire mapping:
custom-property-sources-create takes the complete column_property_map in a single request, so never loop
per column.
When to use this skill
- "Sync my
postgres.customer_attributescolumns to person properties" - "We send a daily identify job from our warehouse, can PostHog pull it instead?"
- "Map this table to people" / "reverse ETL into PostHog"
- The user is looking at Data → Warehouse properties and wants a whole table mapped
Use setting-up-a-data-warehouse-source instead when the table is not in the warehouse yet. This skill starts
once the data is syncing.