---
title: disable_tiering() | Tiger Data Docs
description: Disable tiering on a hypertable and remove its object storage catalog entries
---

Disable tiering on a hypertable. The foreign table that represents tiered chunks is dropped and all object storage catalog entries for the hypertable are removed. After the call returns, the hypertable behaves as a regular Tiger Cloud hypertable with no tiered storage attached.

`disable_tiering` is only allowed when no tiered data exists for the hypertable. Before calling it you must:

1. Remove the tiering policy with [`remove_tiering_policy`](/reference/tiger-cloud/data-tiering/remove_tiering_policy/index.md).
2. Bring every tiered chunk back with [`untier_chunk`](/reference/tiger-cloud/data-tiering/untier_chunk/index.md).
3. Clear any chunks still waiting in the tiering queue with [`untier_chunk`](/reference/tiger-cloud/data-tiering/untier_chunk/index.md).

## Samples

- **Disable tiering on the `my_hypertable_name` hypertable**:

  ```
  SELECT disable_tiering('my_hypertable_name');
  ```

## Arguments

The syntax is:

```
SELECT disable_tiering(
    hypertable = '<hypertable_name>'
);
```

| Name         | Type       | Default | Required | Description                                   |
| ------------ | ---------- | ------- | -------- | --------------------------------------------- |
| `hypertable` | `REGCLASS` | -       | ✔        | Name of the hypertable to disable tiering on. |

## Returns

This function returns void.

## Errors

`disable_tiering` raises an exception when:

- The supplied relation is not a hypertable.
- A tiering policy is still attached to the hypertable. Remove it with [`remove_tiering_policy`](/reference/tiger-cloud/data-tiering/remove_tiering_policy/index.md) first.
- The hypertable has tiered chunks. Untier them with [`untier_chunk`](/reference/tiger-cloud/data-tiering/untier_chunk/index.md) first.
- The hypertable has chunks queued for tiering. Clear them with [`untier_chunk`](/reference/tiger-cloud/data-tiering/untier_chunk/index.md) first.