Mixpanel Community Icon

How can I view or export my project's current data model overview?

·
·

How can I view or export my project's current data model overview?

  • Avatar of kapa.ai
    kapa.ai
    APP
    ·
    ·

    Hi Yanisa S., 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

  • Avatar of kapa.ai
    kapa.ai
    APP
    ·
    ·

    To view or export your project's current data model overview in Mixpanel, you have a couple of options:1. Lexicon: Mixpanel's Lexicon feature provides an overview of your project's data model. You can view details about events, properties, user profiles, and more in the Lexicon. To access this:- Navigate to your project's Lexicon - Here you can see information about events, properties, user profiles, lookup tables, formulas, and behaviorsThe Lexicon allows you to view query volumes for events and properties, which can help you understand which parts of your implementation are most valuable. You can sort this data to discover which events and properties are being used most frequently.Lexicon: Describe your events and data using a dictionary2. Raw Data Export: If you need a more comprehensive export of your data model, you can use Mixpanel's Raw Data Export API. This allows you to export raw event data, which includes the structure of your events and their properties. Here's an example of how to use the API:LBKScurl --request GET \ --url '[https://data.mixpanel.com/api/2.0/export?from_date=2024-07-23&amp;to_date=2024-07-24&amp;limit=100&amp;event=sample_event](https://data.mixpanel.com/api/2.0/export?from_date=2024-07-23&amp;to_date=2024-07-24&amp;limit=100&amp;event=sample_event)' \ --header 'accept: text/plain' \ --header 'authorization: Basic YOUR_TOKEN'LBKSThis will return your event data in JSONL format, where each line represents an event with its properties.Export Methods: Export raw data and reports from MixpanelBy using these methods, you can get a comprehensive view of your project's current data model, including events, properties, and their usage patterns.

    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.

  • Avatar of Yanisa S.
    Yanisa S.
    ·
    ·

    And how can I know the current join key of each table?