---
title: Materialized hypertables | Tiger Data Docs
description: Continuous aggregates store aggregated data in materialized hypertables. Learn how to manage them
---

Continuous aggregates take raw data from the original hypertable, aggregate it, and store the aggregated data in a materialization hypertable. You can modify this materialized hypertable in the same way as any other hypertable.

## Discover the name of a materialized hypertable

To change a materialized hypertable, you need to use its fully qualified name. To find the correct name, use the [`timescaledb_information.continuous_aggregates` view](/docs/reference/timescaledb/informational-views/continuous_aggregates/index.md). You can then use the name to modify it in the same way as any other hypertable.

1. **Query the `continuous_aggregates` view**

   ```
   SELECT view_name, format('%I.%I', materialization_hypertable_schema,
           materialization_hypertable_name) AS materialization_hypertable
       FROM timescaledb_information.continuous_aggregates;
   ```

2. **Locate the hypertable name**

   The results look like this:

   ```
            view_name         |            materialization_hypertable
   ---------------------------+---------------------------------------------------
   conditions_summary_hourly | _timescaledb_internal._materialized_hypertable_30
   conditions_summary_daily  | _timescaledb_internal._materialized_hypertable_31
   (2 rows)
   ```

## Learn more

- [Understand continuous aggregates](/docs/learn/continuous-aggregates/index.md): How continuous aggregates work, JOINs, and function support.
- [Hierarchical continuous aggregates](/docs/learn/continuous-aggregates/hierarchical-continuous-aggregates/index.md): Create continuous aggregates on top of other continuous aggregates.
- [Convert continuous aggregates to the columnstore](/docs/build/continuous-aggregates/compression-on-continuous-aggregates/index.md): Compress older aggregated data.
- [Drop data from continuous aggregates](/docs/build/continuous-aggregates/drop-data/index.md): Remove materialized data.
- [`ALTER MATERIALIZED VIEW` reference](/docs/reference/timescaledb/continuous-aggregates/alter_materialized_view/index.md): Modify continuous aggregate settings.