Using JSON Property for User Profile Linking in Datawarehouse Connector
When linking user profiles using the Datawarehouse Connecotor feature, is it possible to use the json property as well as the event profile linkage?
Hi Natsuki I., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> đź‘‹
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
Based on the provided knowledge sources, I don't have enough specific information to fully answer your question about using JSON properties for user profile linkage with the Datawarehouse Connector feature. However, I can provide some relevant information about user profiles and the Warehouse Connectors feature in Mixpanel:1. Mixpanel's Warehouse Connectors allow you to sync data from your data warehouse into Mixpanel, including user profile data Warehouse Connectors.2. When setting up a User Profile sync using Warehouse Connectors, you need to specify a User ID column, which serves as the primary key for linking profiles Warehouse Connectors.3. Mixpanel supports various data types for user properties, but there are some limitations. For example, Lists and Objects (like Snowflake's ARRAY and OBJECT types) are not supported for Profile History tables Warehouse Connectors.4. User profiles in Mixpanel are joined to events based on the Distinct ID, which is Mixpanel's identifier for a user User Profiles.While these points provide some context about user profiles and Warehouse Connectors, they don't specifically address using JSON properties for profile linkage. If you need more detailed information about this specific capability, you may want to consult Mixpanel's documentation directly or contact their support team.
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.