---
title: Delta Lake
---

## Overview

This code block demonstrates how to query a Delta table.

```sql
CREATE FOREIGN DATA WRAPPER <wrapper_name>
HANDLER delta_fdw_handler
VALIDATOR delta_fdw_validator;

CREATE SERVER <server_name>
FOREIGN DATA WRAPPER <wrapper_name>;

CREATE FOREIGN TABLE <table_name> ()
SERVER <server_name>
OPTIONS (files '<files>');
```

<Accordion title="Example Usage">
```sql
CREATE FOREIGN DATA WRAPPER delta_wrapper
HANDLER delta_fdw_handler
VALIDATOR delta_fdw_validator;

CREATE SERVER delta_server
FOREIGN DATA WRAPPER delta_wrapper;

CREATE FOREIGN TABLE delta_table ()
SERVER delta_server
OPTIONS (files 's3://bucket/folder');

```
</Accordion>

<ParamField body="wrapper_name" required>
  Foreign data wrapper name. Can be any string.
</ParamField>
<ParamField body="server_name" required>
  Foreign server name. Can be any string.
</ParamField>
<ParamField body="table_name" required>
  Foreign table name. Can be any string.
</ParamField>
<ParamField body="files" required>
The path to the Delta table directory. For instance, `s3://bucket/folder` if the Delta table is in Amazon S3 or
`/path/to/folder` if the Delta table is on the local file system.
</ParamField>

## Cloud Object Stores

The [object stores](/integrations/object_stores) documentation explains how to provide secrets and other credentials for
Delta tables stored in object stores like S3.
```
