# External Table

> A table that reads files kept in some other place. The data is not copied in.

**Field:** Data Engineering  
**Category:** Storage & Warehousing  
**Also known as:** External Tables

## Think of it like

It is like a book in another library. You can read it there, so you do not bring it home.

## Definition

An external table is a table that reads data from files kept somewhere else. The system keeps only the table's shape: its columns, the file type and where the files are. When you query it, the engine reads the files right where they sit. Dropping the table removes the shape but leaves the files. Most warehouses and query engines can make one.

## Example

Emma's web logs land in object storage each hour. An external table lets her query them with SQL right away.

## Example code

```sql
CREATE EXTERNAL TABLE web_logs (
  ts     TIMESTAMP,
  status INT,
  url    STRING
)
STORED AS PARQUET
LOCATION 's3://shop-data/logs/';
```

The table only points at a folder. The files in that folder are the data.

## Why it matters

Data can be queried the moment it lands. There is no copy to pay for or keep in step.

## Common mistake

Expecting it to be as fast as a normal table. The engine reads raw files each time, so their format and layout matter a lot.

## Three principles

- **Data stays put.** The files are never moved.
- **Only the shape is stored.** The table is just a description.
- **Files decide speed.** Good formats make fast queries.

## Related terms

- [Object Storage](https://learn.benibix.com/term/data/object-storage)
- [Data Lake](https://learn.benibix.com/term/data/data-lake)
- [Amazon Athena](https://learn.benibix.com/term/data/amazon-athena)
- [Query Engine](https://learn.benibix.com/term/data/query-engine)
- [Apache Parquet](https://learn.benibix.com/term/data/apache-parquet)
- [Partition Pruning](https://learn.benibix.com/term/data/partition-pruning)
- [Federated Query](https://learn.benibix.com/term/data/federated-query)

![Left: a query engine or warehouse holds a highlighted table called web_logs, with its columns and a location in object storage. Only the description lives there. An arrow marked reads points right to three Parquet files in object storage, where the data stays and other tools can read it too. A note says dropping the table leaves the files, and a new file shows up in the next query.](https://learn.benibix.com/diagrams/dat-external-table.svg)

---

Source: https://learn.benibix.com/term/data/external-table
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
