Create Materialized Segment

Learn how to create a materialized segment that loads units from BigQuery.

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.

Related Resources

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