# Retire tables and models that nothing queries

Warehouse objects nothing has queried in a quarter, removed on the evidence of the query log.

Category: Pipelines and warehouse
Source: https://letsship.ai/use-cases/retire-unqueried-tables-and-models
Published: 2026-08-25

## Goal

Remove warehouse tables and models that nothing has queried, backed by the query log.

## Acceptance criteria

- Query-log evidence covering at least a quarter is attached
- Downstream dependencies are checked, not just direct queries
- Objects are deprecated before deletion, with a stated window
- Storage and compute savings are recorded

## What lands as proof

Query-log evidence over a full quarter, which is the only defensible basis for dropping a table.

## Prompt

Copy this to an agent to open the ticket:

```text
Create a Linear issue in my team and assign it to the SHIP agent.

Title: Retire the unqueried {objects}

Description: Remove warehouse tables and models that nothing has queried, backed by the query log.

Acceptance criteria:
- Query-log evidence covering at least a quarter is attached
- Downstream dependencies are checked, not just direct queries
- Objects are deprecated before deletion, with a stated window
- Storage and compute savings are recorded

Before you create the issue, pull this repository's warehouse query log and list objects with no reads in the last quarter. Replace {objects}.
```

## Questions

### What does the agent actually change?

The ticket is scoped to one outcome: remove warehouse tables and models that nothing has queried, backed by the query log. Work that serves that outcome is in scope, and anything outside it is left for a separate ticket, so the pull request stays reviewable.

### How do I know the work is done?

The pull request carries the evidence, not only the diff. Here that means query-log evidence attached before anything is dropped, so a reviewer can confirm the result without reproducing the work locally.

### How much oversight does this need?

The run stops for the plan, and the review bar is raised afterwards so that smaller suggestions block the merge too, not only serious findings.