Skip to main content
A materialized segment loads its list of units from your BigQuery instance using a SQL query.

​
Create a Materialized Segment

1

Navigate to Segments

Navigate to the Flags page in the left menu, then click Segments.
2

Select the Materialized segments tab

Click the Materialized segments tab.
3

Click + Create

Click + Create to create a new materialized segment.
4

Give the segment a name

Enter a descriptive name for your segment.
5

Define the SQL query

Click + Load Entities and enter a SQL query that returns the entity IDs you want to include in the segment.
6

Run the query and select the column

Run the query and select the correct column from the response that contains your entity IDs.
7

Create the load job

Click + Create load job to start loading units into the segment.

Materialized Segments Reference

Learn when and why to use materialized segments

Create Segments

Create standard attribute-based segments

BigQuery Setup

Configure your BigQuery connection

Materialized Segments API

API reference for materialized segments