Data Studio is your central hub for exploring schemas in your Blueshift account. It provides a user-friendly interface to help you gain insights into your data structure and manage it efficiently.

Currently, Data Studio focuses on customer attributes, allowing you to:

• View and explore key details of your schema, including standard, custom, predictive, and derived attributes.
• Navigate nested attributes effortlessly for a deeper understanding of your data.
• Edit descriptions for custom attributes to ensure consistency and clarity.
• Download schema details in JSON format for offline analysis and integration with other tools.

Where to find Data Studio

• Navigate to the Customer Data section in the left-hand menu.
• Click on Data Studio to access the feature.

Customer Schema tab

Table view

The Customer Schema tab houses a table view containing customer attributes. It provides a structured overview of customer attributes with the following columns:

• Attribute name: The name of the attribute.
• Category: Indicates whether the attribute is Standard, Derived, Predictive, or Custom.
• Data type: Specifies the data format, such as String, Boolean, or Date.
• Description: Editable for Custom attributes to provide additional context.
• Created at: Shows when the attribute was created.

For an expanded, detailed view, click the row or select View Details from the three-dot menu at the right corner of the row.

On the expanded view, you can perform the following actions:

• Update the description for custom attributes.
• View sample values for all attributes. For nested or object data types, sample values are displayed within their nested structure.

• View nested attributes by clicking the expand icon for an object or nested data type.

Filters and sort options

To help you locate specific attributes quickly, Data Studio provides:

• Search: Find specific attributes using the "Search by Attribute Name" bar.
• Filters: Narrow down results by:
  • Category: Standard, Derived, Predictive, or Custom.
  • Data type: String, Integer, Date, Boolean, etc.
• Sorting: Click on column headers (e.g., Attribute name, Category) to sort attributes alphabetically or by type.

JSON view

The JSON view offers a detailed, developer-friendly representation of the schema. It includes:

• Attribute names as keys.
• Attribute details like labels, categories, data types, and sample values as values.

How to access JSON view

• Click the JSON toggle at the top of the screen.
• Use the search bar to locate specific attributes by key name. You can also change the theme and copy the JSON.
• Download the schema by clicking the download JSON icon at the top right of the screen.

Create a custom attribute

Follow these steps to create a new custom attribute in the Data Studio.

• Go to the Customer Data section in the left-hand menu.
• Click Data Studio to open the feature.
• Click the + CUSTOM ATTRIBUTE button in the top-right corner to open the Create Custom Attribute modal.
• Enter the following details:
• Name: Enter a name for the custom attribute.
• Type: Select from String, Integer, Decimal, Date, or Boolean.
• Description: Provide a brief description (max 150 characters).
• Click Save to create the attribute.
• Note: The new custom attribute may take 2–3 minutes to appear in the Data Studio grid.