Setting Up Data View for Selective User Access in Kapa.ai
How to setup data view and give user only access to specific data such as events and filter by specific profile properties ? kapa.ai
To set up a Data View and give users access to specific data in Mixpanel, you can follow these steps: 1. Create a Data View: Navigate to Project Settings, then click on "+ Create Data View" in the Data Views settings. Add a name and description for your Data View and save it.2. Configure Data View filters: You can apply filters to determine what data is accessible within the Data View. This includes: - Events: Include or exclude specific event names - Event Properties: Filter by explicit property values across events - User Profile Properties: Filter users based on their property values3. Add users or teams to the Data View: Click "+ Add User" to add individual project members, or use the "Teams" tab to add entire teams to the Data View.4. Manage visibility and editing controls: You can set the Data View as "Public" or "Private" and control whether other Admins can edit the Data View settings.Here's an example of how you might set up a Data View filter:
LBKSCREATE VIEW `project.dataset.view` AS SELECT event_name, event_time, distinct_id, properties, mp_processing_time_ms, -- Add your transformations here FROM `project.dataset.table` WHERE condition; -- filter your view hereLBKSBy following these steps, you can create a Data View that gives users access only to specific events and filters by specific profile properties.For more detailed information on setting up and managing Data Views, you can refer to the Data Views & Classification documentation.Data Views Overview provides additional context on use cases and management of Data Views.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.