Mixpanel Community Icon

Home
Groups
Members

Announcements
Community Questions
Mixpanel Bot
Product Ideas
Resources

Community Guidelines

Docs & Guides
Events & Webinars
Contact Us

Powered by Tightknit

Merging Profile Properties After Switching to Snowflake

·

·

We have switched our warehouse source from Redshift to Snowflake. Now all our profile properties exist once in lowercase (Redshift) and once in uppercase (Snowflake). Can I merge these profile properties? Or clean them up in some other way?

Merging Profile Properties After Switching to Snowflake | Mixpanel Community

1 comment

· Sorted by Oldest

kapa.ai
APP
·
·
Mixpanel does not currently support merging user profile properties (profile properties) in the same way it allows merging of events or event properties via Lexicon. The documentation explicitly states: “user profile properties cannot be merged at this time” Lexicon: Merging Data.How to clean up duplicate profile properties:Recommendation: You will need to decide which version of each property (lowercase or uppercase) you want to keep, and then use the Engage API or Mixpanel-utils to remove the unwanted properties from all user profiles. There is no automated merge for profile properties with different casing; cleanup must be done by removing one and standardizing on the other.If you have a large number of profiles, scripting this cleanup via the API is recommended.Summary: - You cannot merge user profile properties in Mixpanel. - Use the Engage API or Mixpanel-utils to remove or unset unwanted properties. - Standardize property naming conventions going forward to avoid this issue.If you need more detailed guidance on using the API or Mixpanel-utils for this cleanup, let me know!
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.