> ## Documentation Index
> Fetch the complete documentation index at: https://confidence.spotify.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Create Materialized Segment

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

A [materialized segment](/docs/flags/materialized-segments) loads its list of units from your BigQuery instance using a SQL query.

## Create a Materialized Segment

<Steps>
  <Step title="Navigate to Segments">
    Navigate to the **Flags** page in the left menu, then click **Segments**.
  </Step>

  <Step title="Select the Materialized segments tab">
    Click the **Materialized segments** tab.
  </Step>

  <Step title="Click + Create">
    Click **+ Create** to create a new materialized segment.
  </Step>

  <Step title="Give the segment a name">
    Enter a descriptive name for your segment.
  </Step>

  <Step title="Define the SQL query">
    Click **+ Load Entities** and enter a SQL query that returns the entity IDs you want to include in the segment.
  </Step>

  <Step title="Run the query and select the column">
    Run the query and select the correct column from the response that contains your entity IDs.
  </Step>

  <Step title="Create the load job">
    Click **+ Create load job** to start loading units into the segment.
  </Step>
</Steps>

## Related Resources

<CardGroup cols={2}>
  <Card title="Materialized Segments Reference" href="/docs/flags/materialized-segments">
    Learn when and why to use materialized segments
  </Card>

  <Card title="Create Segments" href="/docs/how-to-guides/create-segments">
    Create standard attribute-based segments
  </Card>

  <Card title="BigQuery Setup" href="/docs/warehouse-setup/bigquery">
    Configure your BigQuery connection
  </Card>

  <Card title="Materialized Segments API" href="/docs/api/how-to-guides/flags/create-materialized-segment">
    API reference for materialized segments
  </Card>
</CardGroup>